JDBC 连接 PostgreSQL

驱动依赖

org.postgresql postgresql 42.2.19

JDBC操作

Class.forName("org.postgresql.Driver");
String url = "jdbc:postgresql://172.18.9.114:5432/postgres";
String username = "pgdba";
String password = "pgdba";
//在表spatial_ref_sys中，从第1开始，回去10条数据
String sql = "select * from spatial_ref_sys limit 10 offset 0";
//获取连接
Connection connection = DriverManager.getConnection(url, username, password);
//执行SQL
PreparedStatement statement = connection.prepareStatement(sql);
ResultSet resultSet = statement.executeQuery();
//遍历结果
while (resultSet.next()) {
    String col1 = resultSet.getString(1);
    String col2 = resultSet.getString(2);
    String col3 = resultSet.getString(3);
    System.out.println(col1 + "\t" + col2 + "\t" + col3 + "\t");
}