myeclipse6.5连接PostgreSQL数据库

来源：互联网发布：淘宝网怎么推广编辑：程序博客网时间：2024/06/07 02:34

接着上一篇文章，成功安装完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());            }            }}