public class DBCPUtil {
private static DataSource dataSource;
static {
InputStream is = DBCPUtil.class.getClassLoader().getResourceAsStream("dbcp.properties");
Properties p = new Properties();
try {
p.load(is);
dataSource = BasicDataSourceFactory.createDataSource(p);
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* 用来通过连接池获取连接对象
* @return返回连接对象
*/
public static Connection getConnection() {
try {
return dataSource.getConnection();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}
/**
* 释放资源
* @param conn
* @param statement
* @param resultSet
*/
public static void close(Connection conn,Statement statement,ResultSet resultSet) {
try {
if(resultSet!=null) {
resultSet.close();
resultSet=null;
}
if(statement!=null) {
statement.close();
statement=null;
}
if(conn!=null) {
conn.close();
conn=null;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
private static DataSource dataSource;
static {
InputStream is = DBCPUtil.class.getClassLoader().getResourceAsStream("dbcp.properties");
Properties p = new Properties();
try {
p.load(is);
dataSource = BasicDataSourceFactory.createDataSource(p);
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* 用来通过连接池获取连接对象
* @return返回连接对象
*/
public static Connection getConnection() {
try {
return dataSource.getConnection();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}
/**
* 释放资源
* @param conn
* @param statement
* @param resultSet
*/
public static void close(Connection conn,Statement statement,ResultSet resultSet) {
try {
if(resultSet!=null) {
resultSet.close();
resultSet=null;
}
if(statement!=null) {
statement.close();
statement=null;
}
if(conn!=null) {
conn.close();
conn=null;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}