jsp调用数据库的问题 ^_^,偶在bean里面用一个close方法(我的ResultSet是在jsp上的)在jsp中调用close后,继续在Resultset关闭她 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 调用bean 比如:public class DBconn { String DBdriver = "org.gjt.mm.mysql.Driver"; String DBurl = "jdbc:mysql://localhost:3306/struts?user=root&password="; Statement state = null; ResultSet rs = null; Connection conn = null; public DBconn() { try { Class.forName(DBdriver); } catch (java.lang.ClassNotFoundException ee) { System.err.print("DBconn:" + ee.getMessage()); } } public ResultSet ExeQuery(String s) { try { conn = DriverManager.getConnection(DBurl); state = conn.createStatement(); rs = state.executeQuery(s); } catch (SQLException ex) { System.err.print("SQLException:" + ex.getMessage()); } return rs; } public void ExeUpdate(String s) throws SQLException { conn = DriverManager.getConnection(DBurl); state = conn.createStatement(); state.executeUpdate(s); } public void CloseDB() throws SQLException { if (conn != null) conn.close(); if (state != null) state.close(); if (rs != null) rs.close(); }} 问下有没有谁有邮件编辑器的html代码呀~ myBatis 动态生成排序问题。 setString参数都可以怎么写。 新手求教 吐血看不懂-纯javascript作的左右列表内容互换 怎么用JSP编写程序 页面上实现html打印 问一个struts的错误 使用jstl中的sql标签库能否自动关闭数据库连接? 有没有一个比较好点的编辑器啊 系统时间问题 关于 sun 的petshop!大家谈谈感受 我的下载页面的问题?
String DBdriver = "org.gjt.mm.mysql.Driver";
String DBurl = "jdbc:mysql://localhost:3306/struts?user=root&password=";
Statement state = null;
ResultSet rs = null;
Connection conn = null;
public DBconn() {
try {
Class.forName(DBdriver);
}
catch (java.lang.ClassNotFoundException ee) {
System.err.print("DBconn:" + ee.getMessage());
}
} public ResultSet ExeQuery(String s) {
try {
conn = DriverManager.getConnection(DBurl);
state = conn.createStatement();
rs = state.executeQuery(s);
}
catch (SQLException ex) {
System.err.print("SQLException:" + ex.getMessage());
}
return rs;
} public void ExeUpdate(String s) throws SQLException {
conn = DriverManager.getConnection(DBurl);
state = conn.createStatement();
state.executeUpdate(s);
} public void CloseDB() throws SQLException {
if (conn != null)
conn.close();
if (state != null)
state.close();
if (rs != null)
rs.close();
}
}