C3P0简单配置:
public class C3p0Test {
@Test
public void test1(){
ComboPooledDataSource cpds = new ComboPooledDataSource("robbin");
Connection conn = null;
PreparedStatement stmt = null;
ResultSet rs = null;
try {
conn= cpds.getConnection();
stmt = conn.prepareStatement("select * from user");
rs = stmt.executeQuery();
while(rs.next()){
String name = rs.getString("name");
String money = rs.getString("money");
System.out.println( " name : " + name +", money : " + money);
}
} catch (Exception e) {
e.printStackTrace();
}finally{
JdbcUtils.release(rs, stmt, conn);
}
}
@Test
public void test2(){
ComboPooledDataSource cpds = new ComboPooledDataSource();
Connection conn = null;
PreparedStatement stmt = null;
ResultSet rs = null;
try {
// 设置 连接数据库的 基本信息
cpds.setDriverClass("com.mysql.jdbc.Driver");
cpds.setJdbcUrl("jdbc:mysql://localhost:3309/bank");
cpds.setUser("root");
cpds.setPassword("root");
conn= cpds.getConnection();
stmt = conn.prepareStatement("select * from account");
rs = stmt.executeQuery();
while(rs.next()){
String name = rs.getString("name");
String money = rs.getString("money");
System.out.println( " name : " + name +", money : " + money);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
JdbcUtils.release(rs, stmt, conn);
}
}
}
XML配置c3p0-config.xml
<c3p0-config>
<default-config>
<property name="driverClass">com.mysql.jdbc.Driver</property>
<property name="jdbcUrl">jdbc:mysql://localhost:3309/bank</property>
<property name="user">root</property>
<property name="password">root</property>
</default-config>
</c3p0-config>