通过最基础的jdbc形式来连接postgresql,相关代码如下:
package com;
import java.sql.*;
public class DbTest {
private static String url = "jdbc:postgresql://127.0.0.1:5432/test";
private static String driver = "org.postgresql.Driver";
private static String user = "postgres";
private static String password = "postgres";
public static void main(String[] args) {
String sql = "select * from biz_account";
DbTest dbHelper = new DbTest(sql);
try {
ResultSet resultSet = dbHelper.getStatement().executeQuery();
System.out.println("Id username password");
while (resultSet.next()) {
System.out.println(resultSet.getString(1) + " " + resultSet.getString(2) + " " + resultSet.getString(3));
}