数据库连接池的使用（二）——c3p0

close归还连接对象

package sqlpool;

import com.mchange.v2.c3p0.ComboPooledDataSource;

import java.sql.Connection;
import java.sql.SQLException;

public class C3p0_1 {
    public static void main(String[] args) {
        //创建核心对象，，数据库连接池对象,不传参则使用默认的配置读取连接池对象
        ComboPooledDataSource cpds = new ComboPooledDataSource();
        //获取连接
        try {

            //System.out.println(con);
            //xml文件配置的最大连接数量为10
            for (int i = 1; i <= 10; i++) {
                Connection con = cpds.getConnection();
                System.out.println(i + ":" + con);
            }

            //若要循环更多次而不报错，用close归还连接对象
            /*for (int i = 1; i <= 11; i++) {
            Connection con = cpds.getConnection();
                System.out.println(i + ":" + con);
                if (i == 5) {
                    con.close();
                }
            }

             */
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}