Spring 整合数据库连接池

1. 整合Druid

1.1. 依赖

<!-- druid -->
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>1.1.15</version>
</dependency>
<!-- mysql -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.38</version>
</dependency>

1.2. Bean配置

<bean id="dataSource"
    class="com.alibaba.druid.pool.DruidDataSource" init-method="init"
    destroy-method="close">
    <property name="url" value="jdbc:mysql://localhost:3306/test" />
    <property name="username" value="root" />
    <property name="password" value="123456" />
    <property name="driverClassName" value="com.mysql.jdbc.Driver" />
    <property name="maxActive" value="10" />
    <property name="minIdle" value="5" />
</bean>

1.3. 测试

@Test
public void test() throws Exception {
    ApplicationContext ioc = new ClassPathXmlApplicationContext("applicationContext.xml");
    DataSource dataSource = ioc.getBean(DataSource.class);
    Connection conn = dataSource.getConnection();
    System.out.println(conn);
}

2. 整合C3P0

2.1. 依赖

<!-- c3p0 -->
<dependency>
    <groupId>com.mchange</groupId>
    <artifactId>c3p0</artifactId>
    <version>0.9.5.2</version>
</dependency>
<!-- mysql -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.38</version>
</dependency>

2.2. Bean配置

<bean id="dataSource"
    class="com.mchange.v2.c3p0.ComboPooledDataSource">
    <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/test" />
    <property name="user" value="root" />
    <property name="password" value="123456" />
    <property name="driverClass" value="com.mysql.jdbc.Driver" />
    <property name="minPoolSize" value="3"/>
    <property name="maxPoolSize" value="15" />
</bean>