java数据库连接池dbcp初学

dbcp不像tomcat-dbcp，dbcp需要下载俩个jar包：
commons-dbcp-1.4.jar:
https://mvnrepository.com/artifact/commons-dbcp/commons-dbcp/1.4
commons-pool-1.6.jar:
https://mvnrepository.com/artifact/commons-pool/commons-pool/1.6
下载后将jar包导入项目
由于前面说过tomcat-dbcp方式，因此dbcp我不啰嗦，上代码
新建.java类文件

import org.apache.commons.dbcp.BasicDataSource;
import org.apache.commons.dbcp.BasicDataSourceFactory;
import javax.sql.DataSource;
import java.io.InputStream;
import java.util.Properties;
public class Dbcp {
    //方式一硬配置
    public static DataSource getDataSourceDbcp(){
        BasicDataSource basicDataSource = new BasicDataSource();
        basicDataSource.setDriverClassName("oracle.jdbc.OracleDriver");
        basicDataSource.setUrl("jdbc:oracle:thin:@127.0.0.1:1521:orcl");
        basicDataSource.setUsername("scott");
        basicDataSource.setPassword("tiger");
        basicDataSource.setInitialSize(20);
        basicDataSource.setMaxActive(10);
        return basicDataSource;
    }

    //方式二 文件配置
    public static DataSource getDataSourceDbcpFactory() throws Exception {
        DataSource dataSource = null;
        Properties properties = new Properties();
        InputStream inputStream = new Dbcp().getClass().getClassLoader().getResourceAsStream("dbcpcinfig.propereties");
        properties.load(inputStream);
        dataSource = BasicDataSourceFactory.createDataSource(properties);
        return dataSource;
    }

    public static void main(String[] args) throws Exception {
        System.out.println("一：" + getDataSourceDbcp().getConnection());
        System.out.println("二：" + getDataSourceDbcp().getConnection());
    }
}

"dbcpcinfig.propereties"文件：

driverClassName=oracle.jdbc.OracleDriver
url=jdbc:oracle:thin:@127.0.0.1:1521:orcl
username=scott
password=tiger
initialSize=20
MaxActive=10

运行结果：

这两个就是jdbc中的conn对象。
最后___________________________________________

愿你心如花木，向阳而开