java与pgsql_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);

}

}

运行主函数：输出

这样就可以连接成功了