一:下载:postgresql-9.1-901.jdbc4.jar 驱动
二:
package postpresql;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
/**
* postpresqlJdbc java jdbc 测试类
*
* @author Administrator
*
*/
public class postpresqlJdbc {
static String url = "jdbc:postgresql://localhost:5432/postgres";
static String usr = "testuser";
static String psd = "testuser";
public static void main(String args[]) {
Connection conn = null;
try {
Class.forName("org.postgresql.Driver");
conn = DriverManager.getConnection(url, usr, psd);
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery("SELECT * FROM tds_user");
while (rs.next()) {
System.out.print(rs.getString(1));
System.out.print(" ");
}
rs.close();
st.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}