packagetop.mtain.hive;importjava.sql.*;publicclassHiveJDBC{publicstaticvoidmain(String[]args){Connectioncon;Stringdriver="org.apache.hive.jdbc.HiveDriver";Stringurl="jdbc:hive2://xxx.xxx.xxx.xxx:10000/testdb";字符串用户=“根”；字符串密码=“xxxxxxxxxxxx”；尝试{Class.forName(driver);con=DriverManager.getConnection（网址，用户，密码）；if(!con.isClosed())System.out.println("连接数据库成功！");Statementstatement=con.createStatement();//要执行的SQL语句Stringsql="select*fromt_user";//3。ResultSet类，用来存放得到的结果集！！结果集rs=statement.executeQuery(sql);System.out.println("----------------");System.out.println("执行结果如下：");系统。out.println("-----------------");System.out.println("编号"+"\t"+"姓名");System.out.println("----------------");字符串ID=空；字符串名称=空；while(rs.next()){id=rs.getString("ID");name=rs.getString("姓名");System.out.println(id+"\t"+名称);}rs.close();con.close();}catch(ClassNotFoundExceptione){System.out.println("抱歉，找不到驱动程序！");e.printStackTrace();}catch(SQLExceptione){//数据库连接失败异常处理e.printStackTrace();}catch(Exceptione){e.printStackTrace();}finally{System.out.println("数据库数据获取成功！！");}}}
