<%@ 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");/is the data source name
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 is all the results
Out.print ("&rec=" +rec+ "&");
}
Conn.close ();
%>
The parameters I pass are Sel=air
In Access select COUNT (*) as cut from Zjbiao where zjname like ' *air* ' can get results
But compiles in the JSP does not have the error is:
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: {