怎么把jsp文件连接Java文件_如何把jsp文件里的java代码写到java文件中封装起来，这两个文件要改成什么样？...

-//W3C//DTDHTML4.01Transitional//EN""http://www.w3...

String searchStr="";

if(request.getParameter("keyValue")!=null){

String keyField=request.getParameter("keyField");

String keyValue=new String(request.getParameter("keyValue").getBytes("iso8859-1"),"utf-8");

searchStr="where "+keyField+" like '%"+keyValue+"%'";

}

String driverClass = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

String url = "jdbc:sqlserver://localhost:1433;DatabaseName=Center_CB";

String user = "SqlConnect"; String password = "123456";Connection con =null;Statement st=null;

ResultSet rs=null;

try{ Class.forName(driverClass);

con=DriverManager.getConnection(url, user, password);

st=con.createStatement();

}catch(Exception e) { e.printStackTrace(System.err); out.println("网站出错，请与管理员联系"); return;}

%>

按户号电话号码

关键字

展开