有关数据库连接关闭的问题请教大手
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try(
String sql="";
sql="select * from XXX";
conn = InitAction.getConnection();
pstmt = conn.prepareStatement(sql);
rs = pstmt.executeQuery(sql);
sql="update XXX where id=1";
conn = InitAction.getConnection();
pstmt = conn.prepareStatement(sql);
pstmt.executeUpdate();
)
catch (SQLException ex) {
log.error(ex.getMessage());
} finally {
CloseResource.closeRs(rs);
CloseResource.closeStatement(pstmt);
CloseResource.closeConn(conn);
}
