使用c3p0连接数据库的几种方式

第一种基于标签：

文件名：c3p0-config.xml

A：

<?xml version="1.0" encoding="UTF-8"?>
<c3p0-config>
<default-config>
<property name="jdbcUrl">jdbc:oracle:thin:@192.168.11.210:1521:orcl</property>
<property name="driverClass">oracle.jdbc.driver.OracleDriver</property>
<property name="user">root</property>
<property name="password">root</property>
<property name="checkoutTimeout">30000</property>
<property name="idleConnectionTestPeriod">30</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>
</c3p0-config>

测试类：

public class Main {
    @Test
  public void A() throws Exception{
        DataSource ds = new ComboPooledDataSource("c3p0-config.xml");
        System.out.println(ds.getConnection());
  }
}

B:

<?xml version="1.0" encoding="UTF-8"?>
<c3p0-config>
    <named-config name="helloc3p0">
        <property name="jdbcUrl">jdbc:oracle:thin:@192.168.11.210:1521:orcl</property>
        <property name="driverClass">oracle.jdbc.driver.OracleDriver</property>
        <property name="user">project</property>
        <property name="password">project</property>
        
        <property name="initialPoolSize">5</property>
        <property name="maxPoolSize">10</property>
        <property name="minPoolSize">5</property>
    </named-config>
</c3p0-config>
测试类：

public class Main {
    @Test
  public void A() throws Exception{
        DataSource ds = new ComboPooledDataSource("helloc3p0");
        System.out.println(ds.getConnection());
  }
}

第二种基于文件：

文件名：c3p0-config.properties

c3p0.jdbcUrl=jdbc:oracle:@thin:192.168.11.210:1521/orcl    
c3p0.driverClass=oracle.jdbc.driver.OracleDriver
c3p0.user=root  
c3p0.password=root        
c3p0.initialPoolSize=10     
c3p0.maxPoolSize=20       
c3p0.minPoolSize=5