前提:将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(); } }