springboot配置C3P0数据库连接池

一、项目基础

参考&＃xff1a;Springboot&＃43;mybatis&＃43;mysql8.0

二、依赖引入

<dependency><groupId>com.mchangegroupId><artifactId>c3p0artifactId><version>0.9.5.2version>dependency>


三、配置文件修改

####################C3P0数据源配置#############################
#spring.datasource.c3p0.url &＃61; jdbc:mysql://192.168.0.12:3306/test?useSSL&＃61;false&useUnicode&＃61;true&characterEncoding&＃61;utf8&serverTimezone&＃61;Asia/Shanghai&rewriteBatchedStatements&＃61;true&allowPublicKeyRetrieval&＃61;true
spring.datasource.c3p0.jdbcUrl &＃61; jdbc:mysql://192.168.0.12:3306/test?useSSL&＃61;false&useUnicode&＃61;true&characterEncoding&＃61;utf8&serverTimezone&＃61;Asia/Shanghai&rewriteBatchedStatements&＃61;true&allowPublicKeyRetrieval&＃61;true
#spring.datasource.c3p0.driver-class-name&＃61;com.mysql.cj.jdbc.Driver
spring.datasource.c3p0.driverClass&＃61;com.mysql.cj.jdbc.Driver
#spring.datasource.c3p0.driver-class-name&＃61;com.mysql.jdbc.Driver
#spring.datasource.c3p0.username&＃61;riant
spring.datasource.c3p0.user&＃61;riant
##连接池大小管理
##初始化连接数
spring.datasource.c3p0.initialPoolSize&＃61;5
##连接池中保留的最小连接数
spring.datasource.c3p0.minPoolSize&＃61;3
##连接池中保留的最大连接数
spring.datasource.c3p0.maxPoolSize&＃61;10


注意&＃xff1a;与无连接池配置项存在几处差异
1、url地址配置项名修改&＃xff1a;spring.datasource.c3p0.jdbcUrl
2、驱动器配置项名称修改&＃xff1a;spring.datasource.c3p0.driverClass
3、数据库用户名修改&＃xff1a;spring.datasource.c3p0.user

四、数据源配置文件类

&＃64;Configuration
public class DataSourceConfig {&＃64;Bean(name &＃61; "dataSource") //配置属性,prefix : 前缀 spring.datasource固定&＃64;ConfigurationProperties(prefix &＃61; "spring.datasource.c3p0")public DataSource createDataSource(){return DataSourceBuilder.create() .type(ComboPooledDataSource.class) // 设置数据源类型.build(); }
}


五、测试结果