【www.bbyears.com--Access】
<%@ page contentType="text/html;charset=utf-8"%>
<%@ page import="java.sql.*"%>
<%
Connection conn;
Statement stmt;
ResultSet rs;
String k=request.getParameter("sel");
String sql;
String return_ZJname=null;
String return_id=null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection("jdbc:odbc:comu");//是数据源名
stmt=conn.createStatement();
sql="select count(*) as cut from ZJbiao where ZJname like "*"+k+"*"";
out.print(sql);
rs=stmt.executeQuery(sql);
if(rs.next())
{
int rec=rs.getInt("cut");//rec是所有结果
out.print("&rec="+rec+"&");
}
conn.close();
%>
我传递的参数是sel=air
在access里select count(*) as cut from ZJbiao where ZJname like "*air*"能获得结果
但在JSP中编译就不行 报错是:
org.apache.jasper.JasperException: An exception occurred processing JSP page /comu/selectZJ.jsp at line 16
13: stmt=conn.createStatement();
14: sql="select count(*) as cut from ZJbiao where ZJname like "*"+k+"*"";
15: out.print(sql);
16: rs=stmt.executeQuery(sql);
17: if(rs.next())
18: {