数据库连接池-C3P0

1、Java使用C3P0简单实例

ComboPooledDataSource ds = new ComboPooledDataSource();
ds.setDriverClass("com.mysql.jdbc.Driver");
ds.setJdbcUrl("jdbc:mysql://localhost:3306/test");
ds.setUser("test");
ds.setPassword("test");
		
Connection conn = ds.getConnection();
System.out.println(conn);
		
conn.close();
		
ds.close();

2、使用C3P0 配置文件实例

配置文件：

<?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/test</property>
		<property name="user">test</property>
		<property name="password">test</property>
		
		<!-- 连接池配置 -->
		<property name="acquireIncrement">5</property>
		<property name="initialPoolSize">10</property>
		<property name="minPoolSize">2</property>
		<property name="maxPoolSize">10</property>
	</default-config>
</c3p0-config>

Java 代码：

ComboPooledDataSource ds = new ComboPooledDataSource();
		
Connection conn = ds.getConnection();
System.out.println(conn);
		
conn.close();
		
ds.close();

3、使用C3P0配置文件的named-config配置实例

配置文件：

<?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/test</property>
		<property name="user">test</property>
		<property name="password">test</property>
		
		<!-- 连接池配置 -->
		<property name="acquireIncrement">5</property>
		<property name="initialPoolSize">10</property>
		<property name="minPoolSize">2</property>
		<property name="maxPoolSize">10</property>
	</default-config>
	
	<named-config name="mysqlR">
		<!-- 数据库连接配置 -->
		<property name="driverClass">com.mysql.jdbc.Driver</property>
		<property name="jdbcUrl">jdbc:mysql://localhost:3306/test</property>
		<property name="user">root</property>
		<property name="password">root</property>
		
		<!-- 连接池配置 -->
		<property name="acquireIncrement">5</property>
		<property name="initialPoolSize">10</property>
		<property name="minPoolSize">2</property>
		<property name="maxPoolSize">10</property>
	</named-config>
	
</c3p0-config>

Java代码：

ComboPooledDataSource ds = new ComboPooledDataSource("mysqlR");
		
Connection conn = ds.getConnection();
System.out.println(conn);
		
conn.close();
		
ds.close();