首先,进行dbcp数据库连接池的配置dbcp.properties:
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/test
username=system
password=111222
initialSize=10
maxActive=100
maxIdle=50
minIdle=10
maxWait=10000
validationQuery=select * from dual
其次,下面要进行第一步读取dbcp.properties文件:
public class PropertiesUtil{
public static StringgetPropertiesValue(String key){
Properties p = new Properties();
try{
InputStream inputStream = new PropertiesUtil().getClass().getResourceAsStream("/dbcp.properties");
p.load(inputStream);
}catch(IOException e){
e.printStackTrace();
}
return p.getProperty(key);
}
}
然后,获取连接和断开连接:
public class ConnectionUtil{
public static Connection getConnection() throws SQLException {
BasicDataSource bds = new BasicDataSource();
bds.setDriverClassName(PropertiesUtil.getPropertiesValue("dbcp.driver"));
bds.setUrl(PropertiesUtil.getPropertiesValue("dbcp.url"));
bds.setUsername(PropertiesUtil.getPropertiesValue("dbcp.user"));
bds.setPassword(PropertiesUtil.getPropertiesValue("dbcp.password"));
return bds.getConnection();
}
public static void closeConnection(Connection con){
if(con != null){
try{
con.close();
}catch(SQLException e){
e.printStackTrace();
}
}
}
}