JAVA Implementation Data import Phoenix

The jar packages that need to be imported are:

Implementation code:

 Packagecn.test;Importjava.sql.Connection;ImportJava.sql.DriverManager;Importjava.sql.SQLException;Importjava.sql.Statement;ImportJava.util.Random; Public classPhoenixtest { Public Static voidInsertdatas () {Statement stmt;        Connection con; String ItemID= Getitemid (10 ); String ItemName= Getitemname (10); floatPrice = (float) 0.1; Try{con= Drivermanager.getconnection ("jdbc:phoenix:node11:2181" ); stmt=con.createstatement (); System.out.println ("Content success ..."); //stmt.executeupdate ("CREATE TABLE Test (MyKey integer NOT null primary key, MyColumn varchar)");Stmt.executeupdate ("CREATE table items (ItemID varchar NOT NULL primary key,itemname varchar null,price FLOAT NULL");  for(inti = 0; i < 1000; i++)//How much data needs to be imported to modify itself, if the volume of data is larger requires 500 or 1000 to be submitted once, or a timed commit, the next time you modify the code {stmt.executeupdate ("Upsert into items values ('" + ItemID + "', '" + ItemName + "', '" + price++ + "')" );            } con.commit ();        Con.close (); }        Catch(SQLException e) {e.printstacktrace (); }    }    /*** Generate random numbers as Getitemid * *@return     */     Public StaticString Getitemid (intN) {String val= ""; Random Random=NewRandom ();  for(inti = 0; I < n; i++) {String str= Random.nextint (2)% 2 = = 0? "Num": "Char"; if("Char". Equalsignorecase (str)) { //Generate Letters                intNextint = Random.nextint (2)% 2 = = 0? 65:97; //System.out.println (nextint + "!!!!"); 1,0,1,1,1,0,0Val + = (Char) (Nextint + Random.nextint (26 ) ); }            Else if("Num". Equalsignorecase (str)) { //Generate numbersVal + = string.valueof (Random.nextint (10 ) ); }        }        returnVal; }    /*** Production of ItemName random functions *@paramlength *@return     */     Public StaticString Getitemname (intlength) {String base= "ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ"; Random Random=NewRandom (); StringBuffer SB=NewStringBuffer ();  for(inti = 0; i < length; i++ )        {            intNumber =Random.nextint (Base.length ());        Sb.append (Base.charat (number)); }        returnsb.tostring (); }     Public Static voidMain (string[] args) {insertdatas (); }}

JAVA Implementation Data import Phoenix