package cn.itcast.test;
import java.beans.PropertyVetoException;
import java.sql.Connection;
import java.sql.SQLException;
import org.junit.Test;
import com.mchange.v2.c3p0.ComboPooledDataSource;
/**
* 演示c3p0连接池
* @author 国真
* 1. 需要两个jar包:c3p0-0.9.2-pre1.jar 和 mchange-commons-0.2.jar
* 2. fun1()使用代码来创建连接池对象
* fun2()使用默认配置,
* fun3()使用命名配置,
*/
public class Demo {
@Test
public void fun1() throws PropertyVetoException, SQLException{
//创建连接池对象
ComboPooledDataSource ds = new ComboPooledDataSource();
//连接参数配置(四大参数)
ds.setDriverClass("com.mysql.jdbc.Driver");
ds.setJdbcUrl("jdbc:mysql://localhost:3306/test");
ds.setUser("root");
ds.setPassword("admin");
//池配置省略
//获取连接
Connection connection = ds.getConnection();
System.out.println(connection.getClass().getName()); //返回connection对象所代表的具体对象的名称
connection.close();
}
@Test
public void fun2() throws PropertyVetoException, SQLException{
//创建连接池对象
ComboPooledDataSource ds = new ComboPooledDataSource();
Connection connection = ds.getConnection();
System.out.println(connection.getClass().getName());
connection.close();
//关闭池连接
ds.close();
}
@Test
public void fun3() throws PropertyVetoException, SQLException{
//创建连接池对象
ComboPooledDataSource ds = new ComboPooledDataSource("mysqlConfig"); //若给出了参数,则该参数就是的名称
Connection connection = ds.getConnection();
System.out.println(connection.getClass().getName());
connection.close();
//关闭池连接
ds.close();
}
}
jdbc:mysql://localhost:3306/test
com.mysql.jdbc.Driver
root
admin
3
10
2
10
jdbc:mysql://localhost:3306/test
com.mysql.jdbc.Driver
root
admin
3
10
2
10