怎么提高网页打开速度 改驱动,用jdbc的第四个驱动,适合互联网 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.io.InputStream;import java.util.Properties;public class DBConn { // -----声明连接变量名称------// private String url = ""; // private String url = // "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=guanyuanw2"; // private String url = // "jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.17.1.16)(PORT=1521)))(CONNECT_DATA=(SID=LINUXOAL)(SERVER=DEDICATED)))"; private String user = ""; private String password = ""; private String sDBDriver = ""; // private boolean bAutoCommit = false; public ResultSet rs = null; public PreparedStatement ps = null; public int iTotalRow = 0; public Connection conn = null; public Statement stmt = null; Properties prop = null; // ---------数据库初始化---------// public DBConn() { try { // sDBDriver = "oracle.jdbc.driver.OracleDriver"; // sDBDriver = "org.gjt.mm.mysql.Driver"; prop = new Properties(); InputStream is = getClass().getResourceAsStream( "/config/db.properties"); prop.load(is); url = prop.getProperty("dburl"); user = prop.getProperty("dbuser"); password = prop.getProperty("dbpassword"); sDBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; Class.forName(sDBDriver); if (is != null) { is.close(); } } catch (Exception e) { e.printStackTrace(); } } // ------------根据SQL查询,返回ResultSet---------// public ResultSet executeQuery(String sql) { try { conn = DriverManager.getConnection(url, user, password); stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); rs = stmt.executeQuery(sql); return rs; } catch (Exception e) { e.printStackTrace(); } return rs; } public boolean executeUpdate(String sql) { try { conn = DriverManager.getConnection(url, user, password); stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); stmt.executeUpdate(sql); conn.close(); return true; } catch (Exception e) { e.printStackTrace(); } return false; } public PreparedStatement preparedStatement(String sql) { try { conn = DriverManager.getConnection(url, user, password); ps = conn.prepareStatement(sql); return (ps); } catch (SQLException ex) { ex.printStackTrace(); } return ps; } // ---------数据库其他操作-----------// public int getCount(String sTable) { try { conn = DriverManager.getConnection(url, user, password); stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); sTable = "select count(*) as cnt from " + sTable; rs = stmt.executeQuery(sTable); if (rs.next()) { iTotalRow = rs.getInt("cnt"); } rs.close(); return iTotalRow; } catch (Exception e) { e.printStackTrace(); } return 0; } // -------------自动提交关闭-----------// public boolean isAutoCommit(boolean flag) { try { conn = DriverManager.getConnection(url, user, password); conn.setAutoCommit(flag); return true; } catch (Exception e) { e.printStackTrace(); } return false; } public void setCommit() { try { conn = DriverManager.getConnection(url, user, password); conn.commit(); } catch (Exception e) { e.printStackTrace(); } } // ------------数据库关闭---------// public void closeRs(ResultSet rs) { try { rs.close(); conn.close(); } catch (Exception e) { e.printStackTrace(); } } public void closePs(PreparedStatement ps) { try { ps.close(); conn.close(); } catch (Exception e) { e.printStackTrace(); } } public void closeConn() { try { // stmt.close(); conn.close(); } catch (Exception e) { e.printStackTrace(); } }}这是连接数据库的代码,有可能改动,以便加快在互联网的浏览速度吗 系统设计中的进程视图 HIERBNATE无法插入数据 请高手进来 指点一二 小弟先谢过看到帖子的人了 有个问题很让我恼火,字符问题(如能解决,不胜感激) jsp导入自定义类 这段代码没看懂,,help~~~~~~~~~~~~~ 编译的问题,要我的命啊! executeUpdate成功后返回什么值?怎么知道它执行成功?在线等! 看看这段代码,高手们! 有没有比较成熟,好用的CSDN的客户端工具呀 一个数据库的问题(答者有分) 昨天晚上jsp程序,经过多用户,长时间测试,tomcat返回日志如下:请大家帮忙解答(送45分) nutch 分布式采集该怎么弄啊?
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.io.InputStream;
import java.util.Properties;public class DBConn { // -----声明连接变量名称------// private String url = "";
// private String url =
// "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=guanyuanw2";
// private String url =
// "jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.17.1.16)(PORT=1521)))(CONNECT_DATA=(SID=LINUXOAL)(SERVER=DEDICATED)))";
private String user = "";
private String password = "";
private String sDBDriver = ""; // private boolean bAutoCommit = false;
public ResultSet rs = null;
public PreparedStatement ps = null;
public int iTotalRow = 0;
public Connection conn = null;
public Statement stmt = null;
Properties prop = null; // ---------数据库初始化---------//
public DBConn() {
try {
// sDBDriver = "oracle.jdbc.driver.OracleDriver";
// sDBDriver = "org.gjt.mm.mysql.Driver";
prop = new Properties();
InputStream is = getClass().getResourceAsStream(
"/config/db.properties");
prop.load(is);
url = prop.getProperty("dburl");
user = prop.getProperty("dbuser");
password = prop.getProperty("dbpassword");
sDBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
Class.forName(sDBDriver);
if (is != null) {
is.close();
}
} catch (Exception e) {
e.printStackTrace();
}
} // ------------根据SQL查询,返回ResultSet---------//
public ResultSet executeQuery(String sql) {
try {
conn = DriverManager.getConnection(url, user, password);
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
rs = stmt.executeQuery(sql);
return rs;
} catch (Exception e) {
e.printStackTrace();
}
return rs;
} public boolean executeUpdate(String sql) {
try {
conn = DriverManager.getConnection(url, user, password);
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
stmt.executeUpdate(sql);
conn.close();
return true;
} catch (Exception e) {
e.printStackTrace();
}
return false;
} public PreparedStatement preparedStatement(String sql) {
try {
conn = DriverManager.getConnection(url, user, password);
ps = conn.prepareStatement(sql);
return (ps);
} catch (SQLException ex) {
ex.printStackTrace();
}
return ps;
} // ---------数据库其他操作-----------//
public int getCount(String sTable) {
try {
conn = DriverManager.getConnection(url, user, password);
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
sTable = "select count(*) as cnt from " + sTable;
rs = stmt.executeQuery(sTable);
if (rs.next()) {
iTotalRow = rs.getInt("cnt");
}
rs.close();
return iTotalRow;
} catch (Exception e) {
e.printStackTrace();
}
return 0;
} // -------------自动提交关闭-----------//
public boolean isAutoCommit(boolean flag) {
try {
conn = DriverManager.getConnection(url, user, password);
conn.setAutoCommit(flag);
return true;
} catch (Exception e) {
e.printStackTrace();
}
return false;
} public void setCommit() {
try {
conn = DriverManager.getConnection(url, user, password);
conn.commit();
} catch (Exception e) {
e.printStackTrace();
}
} // ------------数据库关闭---------//
public void closeRs(ResultSet rs) {
try {
rs.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
} public void closePs(PreparedStatement ps) {
try {
ps.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
} public void closeConn() {
try {
// stmt.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
这是连接数据库的代码,有可能改动,以便加快在互联网的浏览速度吗