最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
jsp+access 模糊查询
时间:2008-06-12 编辑:简简单单 来源:一聚教程网
<%@ 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 读取地址栏参数
相关文章
- js 查询表格内容并加亮相应内容单元格 07-19
- jsp 关键字模糊查询代码 07-06
- jsp 关键字:查询,事务,粒度 09-04
- JSP代码(添加,查询) 01-12
- SpringBoot测试配置属性与web启动环境解析 10-24
- vue中将el-switch值true、false改为number类型的1和0解析 10-24