jdbc连接hive，vertica进行数据同步

1.jdbc连接Hive

public class testJdbConnect {
   
    private static String dirvername = "org.apache.hive.jdbc.HiveDriver";
    private static String Url = "jdbc:hive2://10.0.11.90:10000/dde";
    private static Connection connection;
    public static  Connection getConnection(){
   
        try {
   
            Class.forName(dirvername);
           connection = DriverManager.getConnection(Url,"","");
        } catch (ClassNotFoundException e) {
   
            e.printStackTrace();
            System.exit(1);
        } catch (SQLException e) {
   
            e.printStackTrace();
        }
        return connection;
    }
    public static PreparedStatement preparedStatement(Connection connection,String sql){
   
        PreparedStatement ps = null;
        try {
   
            ps = connection.prepareStatement(sql);
        } catch (SQLException e) {
   
            e.printStackTrace();
        }
        return ps;
    }
}

2.将查询到的数据保存进对象中并返回

public class JdbcConnectHive {
   
    private static Connection connection = testJdbConnect.getConnection();
    private static PreparedStatement ps;
    private static ResultSet resultSet;

    public static  List<javabean> getDataSouece(String tables) {
   
        String sql = "select app_id,member_id,app_name,advertiser_id,insertion_orders_id,line_item_id,profile_id,parent_interval_id,publisher_id,site_id,app_official_name,create_date,last_modified from " +tables;
        System.out.println(sql);
        List<String> data=new ArrayList<String>();
        List<