public class druidsUtils {
private static DataSource ds;
//静态代码块
static{
try {
//加载配置文件
Properties pro = new Properties();
pro.load(test_druid.class.getClassLoader().getResourceAsStream("druid.properties"));
//初始化 数据库连接池对象
ds = DruidDataSourceFactory.createDataSource(pro);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
S
}
/**
* 获取连接方法
* @throws SQLException
*/
public static Connection getConnection() throws SQLException{
return ds.getConnection();
}
/**
* 释放资源方法
*/
public static void close(ResultSet rs ,Statement stmt,Connection conn){
if(rs!= null){
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(stmt!= null){
try {
stmt.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(conn!= null){
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
public static void close(Statement stmt,Connection conn){
close(null, stmt, conn);
}
/**
* 获取连接池方法
*/
public static DataSource getDataSource(){
return ds;
}