使用scala，java实现使用phenix读取hbase中数据

来源：互联网发布：java 连接sqlserver 编辑：程序博客网时间：2024/06/02 01:03

前提：将phenix与hbase已经成功映射

直接上代码:scala

object testperson {  def main(args: Array[String]) {    var cc: Connection = null    val driver: String = "org.apache.phoenix.jdbc.PhoenixDriver"    val url: String = "jdbc:phoenix:10.248.27.42:2181"      Class.forName(driver)      cc = DriverManager.getConnection(url)      val conn: Connection = DriverManager.getConnection(url)      val statement: Statement = conn.createStatement      val time: Long = System.currentTimeMillis      val sql: String = "select * from ORDER_COST_TOTAL order by END_TIME desc limit 1"      val rs: ResultSet = statement.executeQuery(sql)      while (rs.next) {        val time:Timestamp = rs.getTimestamp("END_TIME")        val money:Double=rs.getDouble("ORDER_COST")     println("time:"+time+"   money:"+money)      }      val timeUsed: Long = System.currentTimeMillis - time      System.out.println("所花费的时间" + timeUsed)    }}

java版

import java.sql.*;import java.util.List;public class ReadMoney {    public static void main( String[] args ) throws Throwable    {        GetConnection();}    public static void GetConnection(){        Connection cc = null;        String driver = "org.apache.phoenix.jdbc.PhoenixDriver";         String url = "jdbc:phoenix:10.248.27.42:2181";        try {            Class.forName(driver);        } catch (ClassNotFoundException e) {            e.printStackTrace();        }            try {                cc = DriverManager.getConnection(url);                Connection conn = DriverManager.getConnection(url);                Statement statement = conn.createStatement();                long time = System.currentTimeMillis();                String sql = "select *  from test.Person";                ResultSet rs = statement.executeQuery(sql);                while (rs.next()) {                    //获取时间戳和总金额                    Integer incardNum=rs.getInt("IDCARDNUM");                    Timestamp ss;                    String name=rs.getString("NAME");                    Integer age=rs.getInt("AGE");//                    Timestamp time=rs.getTimestamp(0);//                    Double money=rs.getDouble(1);            System.out.println("incardNum: "+incardNum+"  name:"+name+ "  money:" + age);        }                long timeUsed = System.currentTimeMillis() - time;                System.out.println("所花费的时间"+timeUsed);            } catch (SQLException e) {                e.printStackTrace();            }    }

0 0