Java數(shù)據(jù)庫(kù)連接池DBCP的介紹

第Java數(shù)據(jù)庫(kù)連接池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、單數(shù)據(jù)源

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、多數(shù)據(jù)源

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

數(shù)據(jù)源配置類：

packagecom.abc.demo.config;

importmons.dbcp2.BasicDataSource;

importperties.ConfigurationProperties;

importorg.springframework.boot.jdbc.DataSourceBuilder;

importorg.springfra