JDBC 连接 PostgreSQL
驱动依赖org.postgresqlpostgresql42.2.19JDBC操作Class.forName("org.postgresql.Driver");String url = "jdbc:postgresql://172.18.9.114:5432/postgres";String username = "pgdba";String password = "pgdba";//在表spat
·
驱动依赖
org.postgresql postgresql 42.2.19JDBC操作
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");
}
更多推荐
已为社区贡献4条内容
所有评论(0)