java串連postgreSQL資料庫簡單使用

到
http://wwwmaster.postgresql.org/download/mirrors-ftp?file=binary%2Fv8.1.4%2Fwin32%2Fpostgresql-8.1.4-1.zip
選擇一個下載速度快的國家下載 postgresql資料庫

到

http://jdbc.postgresql.org/download.html 下載jdbc驅動

安裝 postgresql，建表 

--  Table: testtable

--  DROP TABLE testtable;

CREATE   TABLE  testtable
(
  id bigserial  NOT   NULL ,
  name  varchar ( 30 ),
   CONSTRAINT  testtable_pkey  PRIMARY   KEY  (id)
) 
WITHOUT OIDS;
ALTER   TABLE  testtable OWNER  TO  postgres;

 

CREATE  SEQUENCE testtable_id_seq
  INCREMENT  1
  MINVALUE  1
  MAXVALUE  9223372036854775807
  START  3
  CACHE  1 ;
ALTER   TABLE  testtable_id_seq OWNER  TO  postgres;

串連測試...

package  com.test;
import  org.postgresql. * ;
import  java.sql. * ;

public   class  TestDB  {
     public  TestDB()  {
    }
     public   static   void  main(String args[])
     {
        System.out.print( " this is a test " );
         try
         {
            Class.forName( " org.postgresql.Driver " ).newInstance();
            String url = " jdbc:postgresql://localhost:5432/postgres " ;
            Connection con = DriverManager.getConnection(url, " postgres " , " 1234 " );
            Statement st = con.createStatement();
            String sql = " select * from testtable " ;
            ResultSet rs = st.executeQuery(sql);
             while (rs.next())
             {
                System.out.print(rs.getInt( 1 ));
                System.out.println(rs.getString( 2 ));
            }
            rs.close();
            st.close();
            con.close();
            

        }
         catch (Exception ee)
         {
            System.out.print(ee.getMessage());
        }
    }
}