/**
* JDBC工具类
*/
public class JDBCUtils {
private static ComboPooledDataSource pool = null;
//1.私有化构造函数
private JDBCUtils(){}
/**
* 获取数据库连接对象(从连接池中获取)
* @return Connection对象
* @throws Exception
*/
public static Connection getConn() throws Exception{
if(pool == null){
pool = new ComboPooledDataSource();
}
return pool.getConnection();
}
/**
* 释放资源
*/
public static void close(Connection conn,
Statement stat, ResultSet rs){
if(rs != null){
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}finally{
rs = null;
}
}
if(stat != null){
try {
stat.close();
} catch (SQLException e) {
e.printStackTrace();
}finally{
stat = null;
}
}
if(conn != null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}finally{
conn = null;
}
}
}
}
JDBCUtils工具类的实现
最新推荐文章于 2022-11-03 11:26:48 发布