Java数据库连接池DBCP的介绍

第Java数据库连接池DBCP的介绍2.2、在SpringBoot中使用

2.2.1、引入依赖

parent

groupIdorg.springframework.boot/groupId

artifactIdspring-boot-starter-parent/artifactId

version2.3.12.RELEASE/version

relativePath/

/parent

dependencies

dependency

groupIdorg.springframework.boot/groupId

artifactIdspring-boot-starter-web/artifactId

/dependency

dependency

groupIdorg.springframework/groupId

artifactIdspring-jdbc/artifactId

/dependency

dependency

groupIdmons/groupId

artifactIdcommons-dbcp2/artifactId

version2.9.0/version

/dependency

dependency

groupIdmysql/groupId

artifactIdmysql-connector-java/artifactId

/dependency

/dependencies

2.2.2、单数据源

application.yml配置：

spring:

datasource:

driver-class-name:com.mysql.cj.jdbc.Driver

url:jdbc:mysql://1:3306/myDbuseUnicode=truecharacterEncoding=UTF-8

username:root

password:123456

type:mons.dbcp2.BasicDataSource

dbcp2:

max-total:20

max-idle:5

使用：

@Autowired

privateDataSourcedataSource;

2.2.3、多数据源

application.yml配置：

spring:

datasource:

dbcp2:

db1:

driver-class-name:com.mysql.cj.jdbc.Driver

url:jdbc:mysql://1:3306/myDbuseUnicode=truecharacterEncoding=UTF-8

username:root

password:123456

max-total:20

max-idle:5

db2:

driver-class-name:com.mysql.cj.jdbc.Driver

url:jdbc:mysql://2:3306/myDbuseUnicode=truecharacterEncoding=UTF-8

username:root

password:123456

max-total:20

max-idle:5

数据源配置类：

packagecom.abc.demo.config;

importmons.dbcp2.BasicDataSource;

importperties.ConfigurationProperties;

importorg.springframework.boot.jdbc.DataSourceBuilder;

importorg.springfra