jsp 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: {
您可能感兴趣的文章:
jsp access 模糊查询
sql模糊查询实例详解
mysql 模糊查询
mysql 多字段关键词模糊查询方法
mysql模糊查询
JDBC 示例(转)
建立JSP操作以提高数据库访问的效率
有关mysql单表多关键字模糊查询的方法介绍
Mysql查找字段中是否包含指定字符或字符串
mysql语句带参数模糊查询匹配问题