c3p0 连接池

使用c3p0连接池来连接数据库，并且封装了一个连接的方法

import com.mchange.v2.c3p0.ComboPooledDataSource;


import java.beans.PropertyVetoException;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.ResourceBundle;

public class DBPoolUtils {
    private static ResourceBundle bundle =ResourceBundle.getBundle("com.jdbc_connection/jdbcDemo6/c3p0-config");
    //数据库的连接池
    private static ComboPooledDataSource dataSource = new ComboPooledDataSource();
    static {
        try {
            dataSource.setDriverClass(bundle.getString("jdbc.Driver"));
            dataSource.setJdbcUrl(bundle.getString("jdbc.url"));

            dataSource.setUser(bundle.getString("jdbc.user"));
            dataSource.setPassword(bundle.getString("jdbc.password"));
            dataSource.setAcquireIncrement(Integer.parseInt(bundle.getString("c3p0.acquireIncrement")));
            dataSource.setInitialPoolSize(Integer.parseInt(bundle.getString("c3p0.initialPoolSize")));
            dataSource.setMaxIdleTime(Integer.parseInt(bundle.getString("c3p0.maxIdleTime")));
            dataSource.setMaxPoolSize(Integer.parseInt(bundle.getString("c3p0.maxPoolSize")));
            dataSource.setMinPoolSize(Integer.parseInt(bundle.getString("c3p0.minPoolSize")));

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


    }
    public static Connection getConnection()throws SQLException {
        return dataSource.getConnection();
    }
}