public class JdbcUtils {
private static ComboPooledDataSource cpds= new ComboPooledDataSource();
public static DataSource getDataSource(){
return cpds;
}
public static Connection getConnection(){
try {
return cpds.getConnection();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
throw new RuntimeException("建立连接失败");
}
}
public static void close(Connection conn){
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
public static void close(Connection conn ,Statement stm){
if (stm != null) {
try {
stm.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
close(conn);
}
}
public static void close(Connection conn ,Statement stm ,ResultSet rs){
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
close(conn, stm);
}
public static void close(PreparedStatement pstm){
if (pstm !=null) {
try {
pstm.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}