三种常见的连接池

@Test public void testC3p0() throws Exception { // 创建连接池对象 ComboPooledDataSource dataSource = new ComboPooledDataSource(); // 设置连接数据库的参数 dataSource.setDriverClass("oracle.jdbc.OracleDriver"); dataSource.setJdbcUrl("jdbc:oracle:thin:@localhost:1521:xe"); dataSource.setUser("oliver"); dataSource.setPassword("0606"); // 获取连接 Connection connection = dataSource.getConnection(); System.out.println("C3p0连接池： "+connection); } @Test public void testDbcp() throws SQLException { // 创建连接池对象 BasicDataSource dataSource = new BasicDataSource(); // 设置连接数据库参数 dataSource.setDriverClassName("oracle.jdbc.OracleDriver"); dataSource.setUrl("jdbc:oracle:thin:@localhost:1521:xe"); dataSource.setUsername("oliver"); dataSource.setPassword("0606"); // 获取连接 Connection connection = dataSource.getConnection(); System.out.println("DBcp连接池： "+connection); } @Test public void testDruid() throws SQLException { // 创建连接池对象 DruidDataSource dataSource = new DruidDataSource(); // 设置连接数据库参数 dataSource.setDriverClassName("oracle.jdbc.OracleDriver"); dataSource.setUrl("jdbc:oracle:thin:@localhost:1521:xe"); dataSource.setUsername("oliver"); dataSource.setPassword("0606"); // 设置连接池优化配置的参数 dataSource.setInitialSize(3);// 设置初始化连接池创建的连接数 dataSource.setMaxActive(5); // 设置最大活跃连接数 dataSource.setMaxWait(2000); // 设置最大等待时间 dataSource.setMinIdle(3); // 设置最少空闲连接数 // 获取连接 Connection connection = dataSource.getConnection(); System.out.println("Druid连接池： "+connection); } Maven中导入的依赖 <!--c3p0连接池依赖--> <!-- https://mvnrepository.com/artifact/c3p0/c3p0 --> <dependency> <groupId>c3p0</groupId> <artifactId>c3p0</artifactId> <version>0.9.1.2</version> </dependency> <!--dbcp连接池--> <!-- https://mvnrepository.com/artifact/commons-dbcp/commons-dbcp --> <dependency> <groupId>commons-dbcp</groupId> <artifactId>commons-dbcp</artifactId> <version>1.4</version> </dependency> <!--aplibaba druid 连接池--> <!-- https://mvnrepository.com/artifact/com.alibaba/druid --> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> <version>1.1.10</version> </dependency>