有助于性能的改善
package onlineshop;
import java.sql.*;
import java.lang.*;public class ConncetUser {
Connection con = null;
ResultSet rs = null; public ConncetUser()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(java.lang.ClassNotFoundException e) { }
} public ResultSet executeQuery(String sql)
{
rs = null;
try
{
con = DriverManager.getConnection("jdbc:odbc:manage","sa","");
Statement stmt = con.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {}
return rs;
}
}
jsp文件为:
<%@ page import="java.sql.*"contentType="text/html;charset=gb2312"%>
<%@ page import="java.lang.*" %>
<jsp:useBean id="workM" scope="page" class="onlineshop.ConncetUser" />
ResultSet rs=null;
rs=workM.executeQuery("SELECT * FROM user WHERE account="+"'"+account+"'");//查找
while(rs.next())
{
}
。
package onlineshop;
import java.sql.*;
import java.lang.*;public class ConncetUser {
Connection con = null;
ResultSet rs = null; public ConncetUser()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(java.lang.ClassNotFoundException e) { }
} public ResultSet executeQuery(String sql)
{
rs = null;
try
{
con = DriverManager.getConnection("jdbc:odbc:manage","sa","");
Statement stmt = con.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {}
return rs;
}
}
jsp文件为:
<%@ page import="java.sql.*"contentType="text/html;charset=gb2312"%>
<%@ page import="java.lang.*" %>
<jsp:useBean id="workM" scope="page" class="onlineshop.ConncetUser" />
ResultSet rs=null;
rs=workM.executeQuery("SELECT * FROM user WHERE account="+"'"+account+"'");//查找
while(rs.next())
{
}
。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货