java连接postgreSQL数据库实例（转）

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());            }        } }