2021-08-07 C3P0的相关配置文件和代码测试

C3P0连接池配置文件.xml

<?xml version="1.0" encoding="UTF-8"?>

<!-- c3p0的缺省（默认）配置
如果在代码中 CombolPooledDataSource ds =new CombolPooledDataSource();
这就表示使用的是C3P0默认配置-->
<c3p0-config>
    <default-config>
        <property name="driverClass">com.mysql.cj.jdbc.Driver</property>
        <property name="jdbcUrl">jdbc:mysql://localhost:3306/jdbcstudy?useUnicode=true&amp;characterEncoding=utf8&amp;useSSL=true&amp;</property>
        <property name="user">root</property>
        <property name="password">root</property>

        <property name="acquireIncrement">5</property>
        <property name="initialPoolSize">10</property>
        <property name="minPoolSize">5</property>
        <property name="maxPoolSize">20</property>
    </default-config>
    <!-- c3p0的缺省（默认）配置
    如果在代码中 CombolPooledDataSource ds =new ComCombolPooledDataSource("MySQL);
   这就是表示name是MySQL-->
    <named-config name="MySQL">
        <property name="driverClass">com.mysql.cj.jdbc.Driver</property>
        <property name="jdbcUlr">jdbc:mysql://localhost:3306/jdbcstudy?useUnicode=true&amp;characterEncoding=utf8&amp;useSSL=true&amp;</property>
        <property name="user">root</property>
        <property name="password">root</property>

        <property name="acquireIncrement">5</property>
        <property name="initialPoolSize">10</property>
        <property name="minPoolSize">5</property>
        <property name="maxPoolSize">20</property>
    </named-config>
</c3p0-config>

C3P0测试文件以及工具库：（打注释的地方忽略）

package com.kuang.lesson05;

import com.kuang.lesson05.utils.jdbcUtils_C3P0;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.Date;

public class TestC3P0 {
    public static void main(String[] args) {
        Connection con = null;
        PreparedStatement st = null;
        try {
            con = jdbcUtils_C3P0.getConnection ();
            String sql = "insert into users (id,`NAME`,`PASSWORD`,`email`,`birthday`)"+"values(?,?,?,?,?)";
            st = con.prepareStatement (sql);
            st.setInt (1, 9);
            st.setString (2, "小狗");
            st.setString (3, "1123456");
            st.setString (4, "23434234@qq.com");
            st.setDate (5, new java.sql.Date (new Date ().getTime ()));
            int n = st.executeUpdate ();
            if (n > 0) {
                System.out.println ("插入成功");
            }
        } catch (SQLException e) {
            e.printStackTrace ();
        } finally {
            jdbcUtils_C3P0.release (con, st, null);
        }
    }
    }

package com.kuang.lesson05.utils;

import com.mchange.v2.c3p0.ComboPooledDataSource;
import org.apache.commons.dbcp.BasicDataSourceFactory;

import javax.sql.DataSource;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

public class jdbcUtils_C3P0 {
    private  static ComboPooledDataSource dataSource1=null;
    static {
        try {
       //代码版配置
         /*  dataSource1=  new ComboPooledDataSource ();
           dataSource1.setDriverClass ();
            dataSource1.setUser ();
            dataSource1.setPassword (;);
            dataSource1.setJdbcUrl ();
         dataSource1.setMaxIdleTime ();
              dataSource1.setMinPoolSize ();*/
            dataSource1=new ComboPooledDataSource ("MySQL");   //配置文件写法
        } catch (Exception e) {
            e.printStackTrace ();
        }
    }
        //  获取连接
       public static Connection getConnection() throws SQLException {
            return dataSource1.getConnection ();    //接口的方法
        }



        //  释放资源
        public static void release(Connection con, Statement st, ResultSet rs){
        if(rs!=null) {
            try {
                rs.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace ();
            }
        }
            if(st!=null) {
                try {
                    st.close();
                } catch (SQLException throwables) {
                    throwables.printStackTrace ();
                }
                if(con!=null) {
                    try {
                        con.close();
                    } catch (SQLException throwables) {
                        throwables.printStackTrace ();
                    }
                }

            }
        }
        }