网站内非数据库的页面速度很快,测试文件下载速度也到100K以上,但访问数据库的页面就是很忙,换了别的mysql也是如此.是不是javabean连接操作数据库出的问题.程序代码都是jsp写的,插入,更新,删除数据都是用ResultSet.用bean文件中的方法执行的.大虾们帮忙看看.javabean文件为:import java.sql.*;
public class DBConnect
{ //数据库链接
Connection conn;
Statement stmt;
ResultSet rs;
String user="rrr";
String password="www";
String mysqlDriver="com.mysql.jdbc.Driver";
String url="jdbc:mysql://*****:3306/s133599";
//对sql执行executeQuery
public ResultSet executeQuerySQL(String sql) throws Exception
{
try{
Class.forName(mysqlDriver).newInstance();
conn=DriverManager.getConnection(url,user,password);
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs=stmt.executeQuery(sql);
return rs;
}catch(SQLException e){
System.out.print(e.getMessage());
return null;
}
}
public class DBConnect
{ //数据库链接
Connection conn;
Statement stmt;
ResultSet rs;
String user="rrr";
String password="www";
String mysqlDriver="com.mysql.jdbc.Driver";
String url="jdbc:mysql://*****:3306/s133599";
//对sql执行executeQuery
public ResultSet executeQuerySQL(String sql) throws Exception
{
try{
Class.forName(mysqlDriver).newInstance();
conn=DriverManager.getConnection(url,user,password);
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs=stmt.executeQuery(sql);
return rs;
}catch(SQLException e){
System.out.print(e.getMessage());
return null;
}
}
你用连接池吧