使用jdbc连接greenplum
- package aaaa;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.Statement;
- public class TestJDBC {
- public static void main(String[] args) throws Exception {
- Class.forName("com.pivotal.jdbc.GreenplumDriver");
- Connection db = DriverManager.getConnection("jdbc:pivotal:greenplum://10.10.10.10:5432;DatabaseName=mfg", "gpadmin", "gpadmin");
- Statement st = db.createStatement();
- ResultSet rs = st.executeQuery("SELECT mtm FROM aaaa limit 100");
- while (rs.next()) {
- System.out.println(rs.getString(1));
- }
- rs.close();
- st.close();
- }
- }