mysql1702_1702-MySQL-C3P0连接池实例

1.配置

加载c3p0-0.9.1.2.jar包

设置c3p0-config.xml 配置文件：

com.mysql.jdbc.Driver

jdbc:mysql:///test

root

root

5

20

com.mysql.jdbc.Driver

jdbc:mysql:///test

root

root

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();

}

}

}

凌晨记