1702-MySQL-C3P0连接池实例

---

1.配置

加载c3p0-0.9.1.2.jar包
设置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:///test</property>    <property name="user">root</property>    <property name="password">root</property>    <property name="initialPoolSize">5</property>    <property name="maxPoolSize">20</property>  </default-config>  <named-config name="oracle">     <property name="driverClass">com.mysql.jdbc.Driver</property>    <property name="jdbcUrl">jdbc:mysql:///test</property>    <property name="user">root</property>    <property name="password">root</property>  </named-config>   </c3p0-config>

2，Test

package com.it.jdbc.TestDataSoure;import java.sql.Connection;import java.sql.PreparedStatement;import org.junit.Test;import com.it.jdbc.DataSoure.MyDataSoure;import com.it.jdbc.utils.C3P0Utils;import com.it.jdbc.utils.JDBCUtils_V3;public class TestC3P0 {    @Test    public void testAdduser1() {    Connection conn = null;    PreparedStatement pstmt = null;    // 自定义连接池对象    try {        // 从连接池获得链接        conn = C3P0Utils.getConnection();        String sql = "insert into use1 value(null,?,?)";        pstmt =conn.prepareStatement(sql);        pstmt.setString(1, "何一");        pstmt.setString(2, "李二");        int rows = pstmt.executeUpdate();        if (rows > 0) {            System.out.println("添加成功");        } else {            System.out.println("添加失败");        }    } catch (Exception e) {        throw new RuntimeException(e);    } finally {        JDBCUtils_V3.release(conn, pstmt, null);    }}}

3.添加工具类C3P0Utils：

package com.it.jdbc.utils;import java.sql.Connection;import java.sql.SQLException;import javax.sql.DataSource;import com.mchange.v2.c3p0.ComboPooledDataSource;public class C3P0Utils {        private static ComboPooledDataSource dataSoure = new ComboPooledDataSource();//默认配置，classpath目录下        //ComboPooledDataSource pool = new ComboPooledDataSource("hh")        //或加载“c3p0-config.xml”的配置元素"hh"         for(int i=0;i<25;i++){        private static DataSource getDataSource(){            return dataSoure;        }        public static Connection getConnection(){            try {                return dataSoure.getConnection();            } catch (SQLException e) {                throw new RuntimeException();            }        }}

凌晨记