myeclipse6.5连接PostgreSQL数据库

接着上一篇文章，成功安装完PostgreSQL数据库服务器后，就是开始用myeclipse6.5连接PostgreSQL数据库的java程序了。

 

首先，需要jar包。

package com.test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import org.postgresql.*;

public class testdb {

    /**
     * @param args
     */
    public static void main(String[] args) {
        // TODO Auto-generated method stub

           System.out.println(  "  this is a test  "  );
             try
             {
                System.out.println(  "  try link db  "  );
                Class.forName( "org.postgresql.Driver" ).newInstance();
                //Class.forName("org.postgresql.Driver");
                String url = "jdbc:postgresql://localhost:5432/postgres" ;
                Connection con = DriverManager.getConnection(url, "postgres" , "step" );
                Statement st = con.createStatement();
                String sql = " select * from testtable " ;
                ResultSet rs = st.executeQuery(sql);
                System.out.println(  "  try link db  "  );
                while (rs.next())
                {
                    System.out.println(  "  try show db  "  );
                    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());
            }        
    }

}