java 使用jdbc连接Greenplum数据库

try {
    // URL
    String url = "jdbc:pivotal:greenplum://host:port;DatabaseName=<name>";
    
    // 数据库用户名
    String username = "gpadmin ";
    
    // 数据库密码
    String password = "gpadmin";
    
    // 加载驱动
    Class.forName("com.pivotal.jdbc.GreenplumDriver");
    
    // 获取连接
    Connection conn = DriverManager.getConnection(url, username, password);
    
    String sql = "select * from testTable";
    PreparedStatement pre = conn.prepareStatement(sql);
    ResultSet rs = pre.executeQuery();
    
    while(rs.next())
    {
        System.out.println(rs.getString(1));
    }
} catch (Exception e) {
    e.printStackTrace();
}

在此附上Greenplum驱动jar包下载地址: http://download.csdn.net/download/enterings/10039723
希望大家少走弯路!