利用c3p0获取连接的简单举例

说明：

1、需要导入的包：c3p0-0.9.2.1.jar、mchange-commons-java-0.2.3.4.jar、mysql-connector-java-5.0.8-bin .jar

2、在src下创建c3p0-config.xml文件。参考代码如下：

<?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/p</property>
        <property name="user">root</property>
        <property name="password">root</property>

        <property name="acquireIncrement">50</property>
        <property name="initialPoolSize">10</property>
        <property name="minPoolSize">5</property>
        <property name="maxPoolSize">20</property>
    </default-config>
    
	<named-config name="mysql">
		<property name="driverClass">com.mysql.jdbc.Driver</property>
		<property name="jdbcUrl">jdbc:mysql://localhost:3306/p</property>
		<property name="user">root</property>
		<property name="password"></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>
	</named-config>
	
	<named-config name="oracle">
		<property name="driverClass">oracle.jdbc.driver.OracleDriver</property>
		<property name="jdbcUrl">jdbc:oracle:thin:@localhost:1521:orcl</property>
		<property name="user">scott</property>
		<property name="password">liang</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>
	</named-config>
	
    <named-config name="h">
        <property name="user">root</property>
        <property name="password">root</property>
        <property name="driverClass">com.mysql.jdbc.Driver</property>
        <property name="jdbcUrl">jdbc:mysql://localhost:3306/p</property>

        <property name="acquireIncrement">5</property>
        <property name="initialPoolSize">5</property>
        <property name="minPoolSize">5</property>
        <property name="maxPoolSize">10</property>

        <!-- C3P0 数据库连接池可以维护的 Statement 的个数 -->
        <property name="maxStatements">20</property>
        <!-- 每个连接同时可以使用的 Statement 对象的个数 -->
        <property name="maxStatementsPerConnection">5</property>

    </named-config>
</c3p0-config>

3、创建获取连接与释放连接的工具类Utils.class，参考代码如下：

package c3p0;

import java.sql.Connection;
import com.mchange.v2.c3p0.ComboPooledDataSource;

/**
 * 数据库工具类
 */
public class Utils {
	static ComboPooledDataSource cpds = null;
	static {
		cpds = new ComboPooledDataSource("h");
	}

	/**
	 * 获得连接
	 */
	public static Connection getConnection() {
		try {
			return cpds.getConnection();
		} catch (Exception e) {
			e.printStackTrace();
			return null;
		}
	}

	/**
	 * 释放连接
	 */
	public static void close(Connection conn) {
		if (conn != null) {
			try {
				conn.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
	}

	/**
	 * 测试连接
	 */
	public static void main(String[] args) {
		Connection conn = getConnection();
		System.out.println(conn.getClass().getName());
		close(conn);
	}
}