java 连接 pgsql

首先在jdbc的配置中新增pgsql的配置属性:

pgsql.driverClassName=org.postgresql.Driver
pgsql.url=jdbc:postgresql://12.1.16.211:5432/fskp
pgsql.username=admin
pgsql.password=123456

java连接pgsql

package com.wdg.util;

import java.io.InputStream;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Properties;

public class PGSQLUtil {

  public static PGSQLUtil pgsqlUtil = null;

  private static Connection conn = null;

  public static PGSQLUtil getInstance() {
    if (pgsqlUtil == null) {
      return new PGSQLUtil();
    }
    return pgsqlUtil;
  }

  public Connection getConnection() {
    if (conn == null) {
      try {
        InputStream is = null;
        is = PGSQLUtil.class.getClassLoader().getResourceAsStream("jdbc.properties");
        Properties props = new Properties();
        props.load(new InputStreamReader(is, "utf-8"));
        Class.forName(props.getProperty("pgsql.driverClassName"));
        String url = props.getProperty("pgsql.url");
        String username = props.getProperty("pgsql.username");
        String password = props.getProperty("pgsql.password");
        conn = DriverManager.getConnection(url, username, password);
      } catch (Exception e) {
        e.printStackTrace();
      }
    }
    return conn;
  }

  public static void main(String[] args) {

    Connection conns = PGSQLUtil.getInstance().getConnection();
    System.out.println(conns);
  }

}

 运行主函数：输出

这样就可以连接成功了