~~~ package cn.itcast.datasource.c3p0; /** * @author: hcf * @qq: 46914685 * @email: 46914685@qq.com */ import com.mchange.v2.c3p0.ComboPooledDataSource; import javax.sql.DataSource; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.SQLException; /** * c3p0的演示 */ public class C3P0Demo1 { public static void main(String[] args) throws SQLException { //1.創建數據庫連接池對象 DataSource ds = new ComboPooledDataSource(); //2.獲取連接對象 Connection conn = ds.getConnection(); //3.打印 System.out.println(conn); //2.定義sql String sql = "insert into account(name,balance) values('錢六',256.58)"; PreparedStatement pstmt = conn.prepareStatement(sql); int count = pstmt.executeUpdate(); System.out.println(count); } } ~~~ ***** ~~~ package cn.itcast.datasource.c3p0; /** * @author: hcf * @qq: 46914685 * @email: 46914685@qq.com */ import com.mchange.v2.c3p0.ComboPooledDataSource; import javax.sql.DataSource; import java.sql.Connection; import java.sql.SQLException; /** * c3p0演示 */ public class C3P0Demo2 { public static void main(String[] args) throws SQLException { testNamedConfig(); // //1.獲取DataSource 使用默認配置 // DataSource ds = new ComboPooledDataSource(); // //獲取連接 // for (int i = 1; i <=11 ; i++) { // Connection conn = ds.getConnection(); // System.out.println(i+":"+conn); // if(i==5){ // conn.close();//歸還連接到連接池中 // } // } } public static void testNamedConfig() throws SQLException { //1.獲取DataSource 使用默認配置 DataSource ds = new ComboPooledDataSource("otherc3p0"); //獲取連接 for (int i = 1; i <=11 ; i++) { Connection conn = ds.getConnection(); System.out.println(i+":"+conn); if(i==5){ conn.close();//歸還連接到連接池中 } } } } ~~~