关于c3p0连接池连接MySQL数据库（jsp项目）

1、依赖，数据库版本：MySQL 5.6

    <dependency>
      <groupId>com.mchange</groupId>
      <artifactId>c3p0</artifactId>
      <version>0.9.5.2</version>
    </dependency>
     <dependency>
      <groupId>com.mchange</groupId>
      <artifactId>mchange-commons-java</artifactId>
      <version>0.2.11</version>
    </dependency>
     <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.47</version>
    </dependency>

2、c3p0-config.xml

在配置文件中 ，需要注意的是< default-config>与 < named-config name=“mysql”>那这个问题先留到下面解释。

<?xml version="1.0" encoding="UTF-8"?>
<c3p0-config>
    <default-config>
	    <property name="driverClass">com.mysql.jdbc.Driver</property>
		<property name="jdbcUrl">
	    		jdbc:mysql://localhost:3306/testweb
	    </property>
		<property name="user">root</property>
		<property name="password">root</property>
		<property name="checkoutTimeout">30000</property>
		<property name="initialPoolSize">10</property>
		<property name="maxIdleTime">30</property>
		<property name="maxPoolSize">100</property>
		<property name="minPoolSize">10</property>
		<property name="maxStatements">200</property>
  </default-config> 
  <!-- This is my config for mysql-->
  <named-config name="mysql">
	    <property name="driverClass">com.mysql.jdbc.Driver</property>
	    <property name="jdbcUrl">jdbc:mysql://localhost:3306/aat?serverTimezone=UTC</property>
	    <property name="user">root</property>
	    <property name="password">19980130</property>
  </named-config>
</c3p0-config>

3、C3P0Util

还记得上面留的那个问题吗？
如若使用< named-config name=“mysql”>必须在初始化时必须
new ComboPooledDataSource ("mysql");
否则加载的是< default-config>。

package com.lcp.utils;

import com.mchange.v2.c3p0.ComboPooledDataSource;
import javax.sql.DataSource;
/**
 * description:
 * author: 沫凌
 * create: 2019-03-04 18:07
 */
public class C3P0Util {
    private static ComboPooledDataSource  dataSource = new ComboPooledDataSource ("mysql");
    public static DataSource getDataSource(){
        return dataSource;
    }

}