JDBC学习（六）：使用c3p0数据库连接池连接数据库

package demo03;
import org.junit.jupiter.api.Test;
import com.mchange.v2.c3p0.ComboPooledDataSource;
public class testGetConnection {
  //方法一
  @Test
  public void test() throws Exception{
    ComboPooledDataSource cpds = new ComboPooledDataSource();
    cpds.setDriverClass( "com.mysql.jdbc.Driver" ); //loads the jdbc driver            
    cpds.setJdbcUrl( "jdbc:mysql://localhost:3306/test" );
    cpds.setUser("root");                                  
    cpds.setPassword("root");
    cpds.setInitialPoolSize(10);
    java.sql.Connection con = cpds.getConnection();
    System.out.println(con);
  }
}

package demo03;
import org.junit.jupiter.api.Test;
import com.mchange.v2.c3p0.ComboPooledDataSource;
public class testGetConnection {
  //方法二：获取XML配置文件
  @Test
  public void test_() throws Exception {
    ComboPooledDataSource cpds = new ComboPooledDataSource("intergalactoApp"); 
    java.sql.Connection coon = cpds.getConnection();
    System.out.println(coon);
  }
}

<?xml version="1.0" coding="UTF-8"?>
<c3p0-config>
  <!-- This app is massive! -->
  <named-config name="intergalactoApp"> 
    <property name="driverClass">com.mysql.jdbc.Driver</property>
    <property name="jdbcUrl">jdbc:nysql://localhost:3306/testdb</property>
    <property name="user">root</property>
    <property name="password">root</property>
    <property name="acquireIncrement">5</property>
    <property name="initialPoolSize">10</property>
    <property name="minPoolSize">5</property>
    <property name="maxPoolSize">100</property>
    <!-- intergalactoApp adopts a different approach to configuring statement caching -->
    <property name="maxStatements">0</property> 
    <property name="maxStatementsPerConnection">5</property>
  </named-config>
</c3p0-config>