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;
    }
}

• c3p0-0.9.5.2.jar (486.2 KB)
• 下载次数: 0

• mchange-commons-java-0.2.11.jar (592.3 KB)
• 下载次数: 0

• c3p0-oracle-thin-extras-0.9.5.2.jar (2.7 KB)
• 下载次数: 0