java连接pgsql线程池

private String driver = "org.postgresql.Driver";
private String url = "jdbc:postgresql://****:1921/datebase?serverTimezone=GMT";
private String username = "";
private String password = "";
private static BasicDataSource basicDataSource = new BasicDataSource();

public DBCPUtils() {
    basicDataSource.setUrl(url);
    basicDataSource.setDriverClassName(driver);
    basicDataSource.setUsername(username);
    basicDataSource.setPassword(password);

    basicDataSource.setInitialSize(100);// 初始化时创建10个链接
    basicDataSource.setMaxTotal(1000);// 设置最大连接数
    basicDataSource.setMaxIdle(5);// 这只最大的空闲连接数
    basicDataSource.setMinIdle(1);// 设置最小空闲连接数字
}

/**
 * 返回一个数据源DataSource应该是在javax.sql.DataSource包下
 *
 * @return
 */
public static DataSource getDataSource() {
    return basicDataSource;
}

调用：

public static void main(String[] args){
    DBCPUtils util = new DBCPUtils();
    DataSource ds = util.getDataSource();
    Connection conn;
    try {
        conn = ds.getConnection();
        String sql = "select * from gd_poi_new_6citys limit 10";
        PreparedStatement st = conn.prepareStatement(sql);
        ResultSet res = st.executeQuery();
        while (res.next()){
            System.out.println(res.getString("poi_id"));
        }
    } catch (Exception e) {
        e.printStackTrace();
    }
}