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