在src文件下建立c3p0.properties文件娃承，內(nèi)容如下圖
捕獲2.PNG
然后導(dǎo)入c3p0 jar包
連接代碼如下：
package c3p0;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.sql.DataSource;
import org.junit.Test;
import com.mchange.v2.c3p0.ComboPooledDataSource;
public class C3P0Test {
@Test
public void fun1() throws Exception {
// 獲取ComboPooledDataSource對(duì)象
// 它會(huì)自動(dòng)根據(jù)默認(rèn)的配置文件的名字去找對(duì)應(yīng)的配置文件
ComboPooledDataSource cpds = new ComboPooledDataSource();
// 獲取數(shù)據(jù)庫連接
Connection conn = cpds.getConnection();
// 準(zhǔn)備sql語句
String sql = "select *from student";
// 創(chuàng)建執(zhí)行者對(duì)象（預(yù)編譯）
PreparedStatement ptmt = conn.prepareStatement(sql);
// 執(zhí)行sql語句
ResultSet rs = ptmt.executeQuery();
// 處理數(shù)據(jù)
while (rs.next()) {
System.out.println(rs.getString("Sno") + "\t" + rs.getString("Sname") + "\t" + rs.getString("Ssex") + "\t"
+ rs.getInt("Sage") + "\t" + rs.getString("Sdept") + "\t" + rs.getString("S_entrance"));
}
// 釋放資源（rs - stmt - conn）
rs.close();
ptmt.close();
conn.close();
}
}
