PostgreSQL示例demo

驱动下载地址：https://pan.baidu.com/s/1eBRESdntbnZQoN-yxJgFDA

功能：建立连接，数据读取

package com.epoint.HadoopAPIDemo;

import java.sql.Connection; 
import java.sql.DriverManager; 
import java.sql.ResultSet; 
import java.sql.Statement; 

public class PostgreSQLTest { 
    // JDBC连接串 
    static String url = "jdbc:postgresql://192.168.186.14:5432/hive"; 
    // PG用户名 
    static String usr = "hive"; 
    // PG密码 
    static String psd = "h3cDataEngine"; 

    public static void main(String args[]) { 
        Connection conn = null; 
        try { 
            Class.forName("org.postgresql.Driver"); 
            // 创建连接 
            conn = DriverManager.getConnection(url, usr, psd); 
            Statement st = conn.createStatement(); 
            // 查询TEST表内容 
            ResultSet rs = st.executeQuery("SELECT * FROM \"DBS\""); 
            while (rs.next()) { 
                System.out.print(rs.getString(1)); 
                System.out.print("  "); 
                System.out.println(rs.getString(2)); 
            } 
            rs.close(); 
            st.close(); 
        } catch (Exception e) { 
            e.printStackTrace(); 
        } finally { 
            // 关闭连接 
            if (conn != null) { 
                try { 
                    conn.close(); 
                    conn = null; 
                } catch (Exception e) { 
                    e.printStackTrace(); 
                } 
            } 
        } 
    } 
}