C3PO链接池配置(顺带jar)

C3PO链接池配置(附带jar)

[C3P0
C3P0是一个开源的JDBC连接池，它实现了数据源和JNDI绑定，支持JDBC3和JDBC2的标准扩展

需要两个jar
c3p0-0.9.5.2.jar
mchange-commons-java-0.2.11.jar

建立一个配置文件c3p0.properties]

c3p0.driverClass=com.mysql.jdbc.Driver
c3p0.jdbcUrl=jdbc\:mysql\://192.168.1.11\:3306/anguea
c3p0.user=root
c3p0.password=root

代码操作

获取链接工具类


import java.sql.Connection;
import java.sql.SQLException;

import com.mchange.v2.c3p0.ComboPooledDataSource;

public class C3P0Util {
    private static ComboPooledDataSource ds = new ComboPooledDataSource();

    public static Connection getConnection(){
        try {
            return ds.getConnection();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return null;
    }
}


测试实现类



import java.sql.Connection;
import java.sql.SQLException;

import com.mchange.v2.c3p0.ComboPooledDataSource;

public class C3P0Util {
    private static ComboPooledDataSource ds = new ComboPooledDataSource();

    public static Connection getConnection(){
        try {
            return ds.getConnection();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return null;
    }
}