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

来源：互联网发布：淘宝卖家可以不发货吗编辑：程序博客网时间：2024/06/07 16:00

第一种基于标签：

文件名：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());
}
}

<?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

0 0