java连接pgsql demo

首先要添加jdbc driver依赖,下载地址。

如：

<dependency>
    <groupId>org.postgresql</groupId>
    <artifactId>postgresql</artifactId>
    <version>42.2.5.jre7</version>
</dependency>

 

代码示例：

import com.google.common.net.HostAndPort;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Properties;

public class PgConnTest {
    public static void main(String[] args) throws Exception {
        String host = "xxx.xxx.xxx.xx";
        Integer port = 3324;
        String user ="test_acc";
        String password = "xxxx";
        Connection conn = getConn(host,port,user,password,"postgres");
        String sql = "select rolname from pg_roles wh