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