正文
JAVA-JDBC-c3p0连接池配置
提示：扫一扫查出行【扫一扫了解最新限行尾号】
复制提示
配置c3p0数据源的方式有三种，分别是手动配置，xml文件配置和properties文件配置，这三种配置方式存在一种即可。
通常来讲，用文件配置更方便书写和阅读
配置如下：
注：*号部分写自己的配置
1.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://localhost:****/********</property>
<property name ="user">*********</property>
<property name ="password">***********</property>
</default-config>
</c3p0-config>
2.c3p0.properties配置
c3p0.driverClass=com.mysql.jdbc.Driver
c3p0.jdbcUrl=jdbc:mysql://localhost:*****/*****
c3p0.user=******
c3p0.password=******
3.手动配置及连接测试
package JDBC; import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement; import com.mchange.v2.c3p0.ComboPooledDataSource; /**
* c3p0连接池
* @author Administrator
*
*/
public class C3P0 {
public static void main(String[] args) {
Connection conn = null;
Statement stat = null;
ResultSet rs = null;
//创建一个c3p0数据源对象
ComboPooledDataSource scoure = new ComboPooledDataSource();
//利用对象读取配置信息
//注释掉这段代码后会去找配置文件，存在任意一个都可以成功
/*try {
scoure.setDriverClass("com.mysql.jdbc.Driver");
scoure.setJdbcUrl("jdbc:mysql://localhost:****/******");
scoure.setUser("********");
scoure.setPassword("*****");
} catch (Exception e) {
// TODO: handle exception
}*/ try {
conn = scoure.getConnection();
stat = conn.createStatement();
rs = stat.executeQuery("select * from student");
while(rs.next()){
int sno =rs.getInt("sno");
String sname = rs.getString("sname");
System.out.println("id:"+sno);
System.out.println("sname:"+sname);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
if(rs != null){
try {
rs.close();
} catch (Exception e2) {
e2.printStackTrace();
}finally{
rs = null;
}
}
if(stat != null){
try {
stat.close();
} catch (Exception e2) {
e2.printStackTrace();
}finally{
stat = null;
}
}
if(conn != null){
try {
conn.close();
} catch (Exception e2) {
e2.printStackTrace();
}finally{
conn = null;
}
}
} }
}
测试结果：
