JDBC连接PostgreSQL

shuaiwei588

官方的PostgreSQL JDBC驱动程序，驱动类名：org.postgresql.Driver，URL格式：
jdbc:postgresql:database
jdbc:postgresql://host/database
jdbc:postgresql://host:port/database

public class TestPg {
private static Driver driver = null;// 驱动变量
static{
loadDrivers("org.postgresql.Driver");
}
// 装载和注册所有JDBC驱动程序
public static void loadDrivers(String dri) {
String driverClassName = dri;
try {
driver = (Driver) Class.forName(driverClassName).newInstance();
DriverManager.registerDriver(driver);
System.out.println("成功注册JDBC驱动程序" + driverClassName);
} catch (Exception e) {
System.out.println("无法注册JDBC驱动程序:" + driverClassName + ",错误:" + e);
}
}
public static void main(String[] args) {
TestPg tp;
try {
Connection conn = DriverManager.getConnection("jdbc:postgresql://10.1.141.12:5432/expertdb", "postgres", "root");
Statement sttmt = conn.createStatement();
ResultSet rs = sttmt.executeQuery("select * from pub_user");
while(rs!=null && rs.next()){
String name = rs.getString(2);
System.out.println(name);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}