c3p0 配置的方式连接postgres

1、写配置文件，注意配置的名字与属性

<?xml version="1.0" encoding="utf-8" ?>
<c3p0-config>
    <named-config name="testc3p0">
        <property name="user">postgres </property>
        <property name="password"> 123456</property>
        <property name="driverClass">org.postgresql.Driver </property>
        <property name="jdbcUrl"> jdbc:postgresql://127.0.0.1:5432/postgres</property>
        <property name="acquireIncrement"> 5</property>
        <property name="initialPoolSize"> 20</property>
        <property name="minPoolSize"> 2</property>
        <property name="maxPoolSize"> 40</property>
    </named-config>
</c3p0-config>

2、链接

ComboPooledDataSource datasource = new ComboPooledDataSource("testc3p0");
Connection connection= null;
try {
    connection = datasource.getConnection();
    String sql="select * from student";
    PreparedStatement preparedStatement=connection.prepareStatement(sql);
    ResultSet resultSet= preparedStatement.executeQuery();
    while (resultSet.next()){
        Integer id=resultSet.getInt("id");
        String  name=resultSet.getString("name");
        System.out.println(id+"--"+name);
    }

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

3、结果