c3p0 JDBC连接池 xml配置文件的书写

需要创建  c3p0-config.xml 配置文件

  * c3p0配置文件
  * 1.配置文件名称:c3p0-config.xml
  * 2.配置文件的位置一定要在类路径下

复制

修改文件

首字母的大写改成小写

配置文件设置完成

记得导入数据库连接jar包

              c3p0  jar包

 

 

代码

package test03;

import java.beans.PropertyVetoException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.mchange.v2.c3p0.ComboPooledDataSource;

/**
 * C3p0连接数据源
 * @author star
 *
 */
public class C3p0Test {
    public static void main(String[] args) throws Exception {
        //test1();
        test2();
    }
    
    private static void test1() throws SQLException, PropertyVetoException {
        // TODO Auto-generated method stub
        //创建连接池
        ComboPooledDataSource pool = new ComboPooledDataSource();
        
        //设置的连接的四大参数
        //
        pool.setDriverClass("com.mysql.jdbc.Driver");
        pool.setJdbcUrl("jdbc:mysql:///day01");
        pool.setUser("root");
        pool.setPassword("root");
        //
        //获取连接
        Connection conn = pool.getConnection();
        String sql = "select * from stu";
        ResultSet rs = conn.createStatement().executeQuery(sql);
        while(rs.next()) {
            System.out.println(rs.getInt(1)+"   "+rs.getString(2));
        }
        rs.close();
        conn.close();
    }
    //使用配置文件
    /*
     * c3p0配置文件
     * 1.配置文件名称:c3p0-config.xml 
     * 2.配置文件的位置一定要在类路径下
     */
    private static void test2() throws Exception {
        // TODO Auto-generated method stub
        //c3p0 创建连接池对象
        ComboPooledDataSource pool = new ComboPooledDataSource();
        //获取连接
        Connection conn = pool.getConnection();
        String sql = "select * from stu";
        ResultSet rs = conn.createStatement().executeQuery(sql);
        while(rs.next()){
            System.out.println(rs.getInt(1)+"    "+rs.getString(2));
        }
        rs.close();
        conn.close();
        
    }
    
}

 

<c3p0-config>
  <default-config>
    <property name="driverClass">com.mysql.jdbc.Driver</property>
    <property name="jdbcUrl">jdbc:mysql:///day01</property>
    <property name="user">root</property>
    <property name="password">root</property>
    

  </default-config>
</c3p0-config>

 

//c3p0 创建连接池对象
  ComboPooledDataSource pool = new ComboPooledDataSource();