62,614
社区成员
发帖
与我相关
我的任务
分享
public java.sql.ResultSet executeQuery(String sexesql) throws SQLException {
java.sql.ResultSet rs = null;
Statement stmtDb = conn.createStatement();
try {
rs = stmtDb.executeQuery(sexesql);
} catch (SQLException e) {
System.err.println("ERROR IN Execute :" + sexesql + " : " + e);
} catch (NullPointerException e) {
}
return (rs);
while (rs.next()) {
long id = rs.getLong(1);
if (!isDeleted(id)) {
PathwayBean pb = new PathwayBean();
pb.selectDataFromDBByID(id);
list.add(pb);
}
}
rs.getStatement().close();//这两行关闭行吗?
rs.close();//这行应该可以省略吧?
public static PathwayDBUtil getInstance(String name){
if (dBUtilInstace == null){//用Singleton模式,只有一个实例
dBUtilInstace = new PathwayDBUtil();
url="jdbc:sqlserver://192.168.2.5:1433;DatabaseName="+name;
dBUtilInstace.openConn();
}
return dBUtilInstace;
}
private void openConn() {//打开数据库连接
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
conn = DriverManager.getConnection(url, user, pwd);
} catch (Exception e) {
e.printStackTrace();
}
}
public void closeConn() {//在所有批次查询都查完后最后关闭数据库连接
try {
if (conn == null) {
return;
}
conn.close();
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
conn.close();
} catch (Exception e) {
}
}
}
catch (SQLException e)
{
System.err.println("ERROR IN Execute :" + sexesql + " : " + e);
} catch (NullPointerException e)
{}
finally
{
try
{
rs.close();
} catch (Exception e)
{}
}
/**
*
* @param rs ResultSet
* @param st Statement
* @param conn Connection
*/
public void closeConnections(ResultSet rs, Statement st, Connection conn)
{
if (rs != null)
{
try
{
rs.close();
}
catch (SQLException e)
{
}
}
if (st != null)
{
try
{
st.close();
}
catch (SQLException e)
{
}
}
if (conn != null)
{
try
{
conn.close();
}
catch (SQLException e)
{
}
}
}
最简单的
if(!conn.isClosed)
{
conn.closed();
}
public static void closeConnection(DBConnection dbc) {
if (dbc != null) {
try {
DBHT.remove(dbc.globeID);
useCnt--;
if (dbc.connection != null) {
dbc.connection.close();
String[] msg = { "DBFactory", "closeConnection",
dbc + " 关闭成功" };
TLoger.logDebug("2003", msg);
} else {
String[] msg = { "DBFactory", "closeConnection",
dbc + " 不存在联接" };
TLoger.logDebug("2003", msg);
}
} catch (SQLException ex) {
String[] err = { "DBFactory", "closeConnection", dbc + " 关闭失败" };
TLoger.logErr("3300", err, ex);
}
}
}