添加依赖包
pom.xml --------------------------------------------------------------- <dependency> <groupId>org.apache.commons</groupId> <artifactId>commons-dbcp2</artifactId> <version>2.0.1</version> </dependency> <dependency> <groupId>commons-io</groupId> <artifactId>commons-io</artifactId> <version>2.6</version> </dependency>配置文件
application.properties --------------------------------------------------------------- # 连接池配置参数 spring.datasource.type=org.apache.commons.dbcp2.BasicDataSource # <!--init connection num--> spring.datasource.dbcp2.initial-size=10 # maxTotal spring.datasource.dbcp2.max-total=300 # <!--max idle connection num--> spring.datasource.dbcp2.max-idle=20 # <!--min idle connection num--> spring.datasource.dbcp2.min-idle=10 # <!--timeout num--> spring.datasource.dbcp2.max-wait-millis=10000 # auto commit spring.datasource.dbcp2.default-auto-commit=true连接池测试
DataSourceTests.java --------------------------------------------------------------- package com.hrjlk.controller; import javax.sql.DataSource; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.boot.autoconfigure.jdbc.DataSourceProperties; import org.springframework.context.ApplicationContext; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.RestController; @RestController public class DataSourceTests { @Autowired ApplicationContext applicationContext; @Autowired DataSourceProperties dataSourceProperties; @GetMapping("/getdata") public void testDataSource() throws Exception { // 获取配置的数据源 DataSource dataSource = applicationContext.getBean(DataSource.class); // 查看配置数据源信息 System.out.println(dataSource); System.out.println(dataSource.getClass().getName()); System.out.println(dataSourceProperties); } }访问测试
# 页面返回空白，终端打印输出连接池对象内容 http://localhost:8080/getdata # 不访问时不会建立连接池 http://localhost:8080/jdbc # 查看数据库建立了10个初始化PostgreSQL JDBC Driver链接 select datname,pid,usename,application_name,query from pg_catalog.pg_stat_activity;