postgreSQL 的jdbc驱动下载地址:
http://jdbc.postgresql.org/download.html
jdbc名称如下:postgresql-9.1-901.jdbc4.jar
java 连接postgreSQL的jdbc 实例如下:
工具类:ConnUtil
内容:
- package com.hw.postgres.jdbc;
-
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.SQLException;
-
- public class ConnUtil
- {
- public static Connection getConn()
- {
- Connection conn = null;
- try
- {
- Class.forName("org.postgresql.Driver");
- String url = "jdbc:postgresql://192.168.2.150:5432/postgres";
- try
- {
- conn = DriverManager.getConnection(url, "postgres", "postgres");
- }
- catch (SQLException e)
- {
- e.printStackTrace();
- }
- }
- catch (ClassNotFoundException e)
- {
- e.printStackTrace();
- }
-
- return conn;
- }
-
- }
测试类:TestMain
- package com.hw.postgres.jdbc;
-
- import java.sql.Connection;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
-
- public class TestMain
- {
-
-
-
-
- public static void main(String[] args)
- {
- Connection conn=ConnUtil.getConn();
- String sql="select * from student";
- Statement stmt=null;
- ResultSet rs=null;
- try
- {
- stmt=conn.createStatement();
- rs=stmt.executeQuery(sql);
- while(rs.next()){
- System.out.println(rs.getInt(1));
- }
- }
- catch (SQLException e)
- {
- e.printStackTrace();
- }
- }
-
- }
最后运行测试类TestMain ,即可。
和Mysql差不多。。。只不过驱动不一样而已,语法也有细微的差别