dbcp连接池
需要导入两个jar包
commons-dacp.jar
commons-pool.jar
(1).BasicDataSource方式
BasicDataSource basicDataSource = new BasicDataSource();
basicDataSource.setDriverClassName("com.mysql.jdbc.Driver");
basicDataSource.setUrl("jdbc:mysql://localhost:3306/firstdb?serverTimezone=GMT");
basicDataSource.setUsername("root");
basicDataSource.setPassword("mysqlpasw");
basicDataSource.setMaxActive(20);
basicDataSource.setInitialSize(20);
(2).BasicDataSourceFactroy方法
1.配置properties文件如下:
driverclassname=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/firstdb?serverTimezone=GMT
username=root
password=mysqlpasw
maxActive=20
2.创建初始化dbcp的类
Properties properties = new Properties();
//dbcpconfig.properties为properties文件名
//将properties以输入流的形式引入
FileInputStream load = new FileInputStream("src/dbcpconfig.properties");
properties.load(load);
DataSource dataSource = new BasicDataSourceFactory().createDataSource(properties);