java access模糊查询_jsp access 模糊查询

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: {