//1、导入c3p0的连个包，和mysql的驱动包//2、配置c3p0.xml的配置文件
<c3p0-config> <!-- 使用默认的配置读取连接池对象 --> <default-config> <!-- 连接参数 --> <property name="driverClass">com.mysql.jdbc.Driver</property> <property name="jdbcUrl">jdbc:mysql://localhost:3306/estore</property> <property name="user">root</property> <property name="password">123</property> <!-- 连接池参数 --> <property name="initialPoolSize">5</property> <property name="maxPoolSize">10</property> <property name="checkoutTimeout">3000</property> </default-config> <named-config name="otherc3p0"> <!-- 连接参数 --> <property name="driverClass">com.mysql.jdbc.Driver</property> <property name="jdbcUrl">jdbc:mysql://localhost:3306/estore</property> <property name="user">root</property> <property name="password">123</property> <!-- 连接池参数 --> <property name="initialPoolSize">5</property> <property name="maxPoolSize">8</property> <property name="checkoutTimeout">1000</property> </named-config></c3p0-config>//3、代码测试package cn.itcast.datasoure.c3p0;import com.mchange.v2.c3p0.ComboPooledDataSource;import javax.sql.DataSource;import java.sql.Connection;import java.sql.SQLException;/** * @author newcityman * @date 2019/8/16 - 21:45 */public class C3P0Demo01 {public static void main(String[] args) { Connection conn = null; try {// 1、创建数据库连接池对象 DataSource ds = new ComboPooledDataSource();// 2、获取连接对象 conn= ds.getConnection(); System.out.println(conn); } catch (SQLException e) { e.printStackTrace(); } }}
转载于:https://www.cnblogs.com/newcityboy/p/11366808.html
