Spring配置三大数据库连接池

Spring配置三大数据库连接池c3p0/dbcp/druid

1. spring-dao.xml中的配置

    <context:property-override location="classpath:***.properties"/>
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" />
    <bean id="dataSource_c3p0" class="com.mchange.v2.c3p0.ComboPooledDataSource" />
    <bean id="dataSource_dbcp" class="org.apache.commons.dbcp.BasicDataSource" />
    <bean id="dataSource_druid" class="com.alibaba.druid.pool.DruidDataSource" />

注：dataSource中设置对应的class

2. *.properties的配置

c3p0.properties

dataSource.driverClass=com.mysql.jdbc.Driver
dataSource.jdbcUrl=jdbc:mysql://127.0.0.1:3306/seckill?useUnicode=true&characterEncoding=utf8
dataSource.user=root
dataSource.password=123456
dataSource.maxPoolSize=20
dataSource.minPoolSize=5
dataSource.autoCommitOnClose=false
dataSource.checkoutTimeout=1000
dataSource.acquireRetryAttempts=2

dbcp.properties

dataSource.driverClassName=com.mysql.jdbc.Driver
dataSource.url=jdbc:mysql://127.0.0.1:3306/seckill?useUnicode=true&characterEncoding=utf8
dataSource.username=root
dataSource.password=123456
dataSource.initialSize=3
dataSource.maxActive=20
dataSource.maxIdle=10
dataSource.minIdle=3
dataSource.maxWait=1000

druid.properties

dataSource.driverClassName=com.mysql.jdbc.Driver
dataSource.url=jdbc:mysql://127.0.0.1:3306/seckill?useUnicode=true&characterEncoding=utf8
dataSource.username=root
dataSource.password=123456
dataSource.initialSize=3
dataSource.maxActive=20
dataSource.maxIdle=10
dataSource.minIdle=3
dataSource.maxWait=1000