JDBC phoenix

1、首先确保引入以下两个包：

2、通过phoenix连接

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package com.phkj.phoenixtest2;


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

import org.antlr.grammar.v3.TreeToNFAConverter.set_return;
import org.apache.phoenix.jdbc.PhoenixDriver;
import org.omg.CORBA.INTERNAL;
import org.python.antlr.ast.boolopType;

public class Orecal2Phoniex {
    
    public static void main(String[] args) throws ClassNotFoundException, SQLException {

        //1、加载驱动
        Class.forName("org.apache.phoenix.jdbc.PhoenixDriver");
      //  Class.forName("oracle.jdbc.driver.OracleDriver");
        System.out.println("加载phoneix、oracle驱动");
        //2、建立连接
        Connection connPhoenix = null;
        Connection conn = null;
       try {
            System.out.println("123");
            connPhoenix =DriverManager.getConnection("jdbc:phoenix:ip号:端口号","","");
            //conn =DriverManager.getConnection("jdbc:oracle:thin:@oracle ip地址:orcl", "账号", "密码");
            System.out.println("Phoenix、oracle 连接成功！");
        } catch (SQLException e) {
            System.out.println("Phoenix、oracle 连接失败！");
        }
      
       //3、操作句柄    
       Statement stmt=null,stmt1=null,stmt2=null;
       try {
           stmt=connPhoenix.createStatement();
           System.out.println("获取句柄成功");
       } catch (SQLException e) {    
           System.out.println("获取句柄失败");
       }
       
       //4、sql操作
       String sql=null,
               sql1="select * from CS_T_cust_contact_info";
       
       ResultSet rs=stmt.executeQuery(sql1); 
       Integer n=0,m=0;
     /*  while (rs.next()){
           n++;
           Integer ID=rs.getInt("ID");
           String CUST_NAME = rs.getString("CUST_NAME");
           String REG_PROV = rs.getString("REG_PROV");
           Integer LOAN_MONEY=rs.getInt("LOAN_MONEY");
           sql="upsert into CS_T1_CUST_BASE_INFO(ID,CUST_NAME,REG_PROV,LOAN_MONEY) values"
                   + "("+ID+",'"+CUST_NAME+"','"+REG_PROV+"',"+LOAN_MONEY+")";
           stmt.executeUpdate(sql);
           if (n%10000==0){
               m++;
               connPhoenix.commit();
               System.out.println("提交"+m+"次");
           }
           
                       
       }*/
       while (rs.next()){
           n++;
           Integer ID=rs.getInt("ID");
           String CUST_NO = rs.getString("CUST_NO");
           sql="upsert into CS_T1_cust_contact_info(ID,CUST_NO) values"
                   + "("+ID+",'"+CUST_NO+"')";
           stmt.executeUpdate(sql);
           if (n%10000==0){
               m++;
               connPhoenix.commit();
               System.out.println("提交"+m+"次");
           }
       }
           
              
       /* for (int id = 1 ; id<=1640000 ;id++){
           if( id%4 ==1){
               sql="upsert into CS_T_CUST_BASE_INFO(id,LOAN_MONEY) values("+id+","+2500+")";
           }else if (id%4 == 2){
               sql="upsert into CS_T_CUST_BASE_INFO(id,LOAN_MONEY) values("+id+","+3000+")";
           }
           else if (id%4 == 3){
               sql="upsert into CS_T_CUST_BASE_INFO(id,LOAN_MONEY) values("+id+","+3500+")";
           }
           stmt.executeUpdate(sql);
           
           if (id%5000==0){
               connPhoenix.commit();
               System.out.println("提交");
           }
           
        } */
       
       //5、关闭连接
       stmt.close();
       connPhoenix.close();
    }
}