public class DBUtils {
private static String url = null;
private static String username = null;
private static String pwd = null;
private static DataSource ds_pooled;
/**
* 加载数据库连接的配置文件和驱动
*/
static{
FileInputStream fis = null;
Properties env = new Properties();
try {
fis = new FileInputStream("dbconfig.properties");
//加载属性文件中的数据库配置信息
//以=左边作为key值,右边作为value值
env.load(fis);
//1. 加载驱动类
Class.forName(env.getProperty("jdbc.driver"));
url = env.getProperty("jdbc.url");
username = env.getProperty("jdbc.username");
pwd = env.getProperty("jdbc.pwd");
//设置连接数据库的配置信息
DataSource ds_unpooled = DataSources
.unpooledDataSource(url, username, pwd);
Map pool_conf = new HashMap();
//设置最大连接数
pool_conf.put("maxPoolSize", 10);
ds_pooled = DataSources.pooledDataSource(ds_unpooled,
pool_conf);
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
/**
* 获取连接对象
*/
public static Connection getConnection() throws SQLException {
// 2. 设置连接的url,username,pwd
// return DriverManager.getConnection(url, username, pwd);
return ds_pooled.getConnection();
}
/**
* 释放连接池资源
*/
public static void clearup(){
if(ds_pooled != null){
try {
DataSources.destroy(ds_pooled);
} catch (SQLException e) {
e.printStackTrace();
}
}
}
/**
* 资源关闭
*
* @param rs
* @param stmt
* @param conn
*/
public static void close(ResultSet rs, Statement stmt
, Connection conn) {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (stmt != null) {
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}