jdbc连接postgresqls

1。到官网根据JDBC的版本下载对应的驱动

http://jdbc.postgresql.org/

2。数据库连接

public static void main(String[] args) {
		Connection conn = null;
		try {
			Class.forName("org.postgresql.Driver");
			conn = DriverManager.getConnection("jdbc:postgresql://127.0.0.1:5432/lubby", "admin", "admin");
			String sql = "select * from stu";
			PreparedStatement ps = conn.prepareStatement(sql);
			ResultSet rs = ps.executeQuery();
			while(rs.next()){
				System.out.println(rs.getString(1)+rs.getString(2));
			}
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}

3。执行结果

002王丽丽
003王远远
004四提问
005asdasd