c3p0配置文件（c3p0.properties.xml）解读

package cn.lijun.demo;

import com.mchange.v2.c3p0.ComboPooledDataSource;

import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.SQLException;

public class Demo2C3p0 {
    public static void main(String[] args) {

        try {
            //获得连接池的容器  DataSource
            DataSource ds=new ComboPooledDataSource();
            //打印所得的连接对象  配置文件中最大是10,关闭一个就能还回去一个，然后可以被立即调用
           for(int i=1;i<=11;i++){
               Connection conn = ds.getConnection();
               System.out.println(i+"  "+conn);
               if(i==5){
                   conn.close();
               }
           }

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

 

转载于:https://www.cnblogs.com/qurui1998/p/10649264.html