java 1.4 api_JAVA API操作hbase1.4.2

package com.quyf;

import org.apache.hadoop.conf.Configuration;

import org.apache.hadoop.fs.Path;

import org.apache.hadoop.hbase.*;

import org.apache.hadoop.hbase.client.*;

import org.apache.hadoop.hbase.util.Bytes;

import org.junit.After;

import org.junit.Before;

import org.junit.Test;

import java.io.IOException;

import java.util.ArrayList;

import java.util.Iterator;

import java.util.List;

/**

* Created by Administrator on 2018/4/8.

*/

public class HbaseDemo {

private static Connection conn;

private static Configuration configuration;

private static Admin admin;

public static void main(String[] args) throws Exception{

//System.out.println("hello world");

}

@Before

public void setup() throws Exception{

configuration = new Configuration();

configuration.set("hbase.zookeeper.quorum", "bg1:2181,bg2:2181,bg3:2181");

// configuration.addResource(new Path("I:\\gitproject\\hbase_demo\\src\\main\\resources\\hbase-site.xml"));

conn = ConnectionFactory.createConnection(configuration);

admin = conn.getAdmin();

}

/**

* 结束之后 关闭对象

*/

@After

public void End_up() throws Exception {

if (conn != null) conn.close();

}

@Test

public void create() throws IOException {

String[] cols = {"phone","addr","age"};

createTable("helloworld", cols);

}

/**

* @param tableName

* @param columns

* @throws IOException

*/

private void createTable(String tableName, String[] columns) throws IOException {

TableName tb = TableName.valueOf( tableName );

if( admin.tableExists( tb )){

System.out.println("已经存在");

}else{

System.out.println("not存在");

HTableDescriptor desc = new HTableDescriptor( tb );

for (String column:columns) {

desc.addFamily( new HColumnDescriptor(column));

}

admin.createTable(desc);

System.out.println("create "+tableName+" success");

}

}

@Test

public void showTable() throws IOException {

TableName[] tables = admin.listTableNames();

for(TableName tab:tables){

System.out.println("表名："+tab.getNameAsString());

HTableDescriptor desc = admin.getTableDescriptor( tab );

for(HColumnDescriptor column: desc.getColumnFamilies()){

System.out.println(column.getNameAsString()+"==="+column.toString());

}

}

}

@Test

public void getByRowKey() throws IOException {

//admin.getTableDescriptor(TableName.valueOf("test"));

Table table = conn.getTable(TableName.valueOf("test"));

Get get = new Get("0004".getBytes());

Result rt = table.get(get);

System.out.println( rt.toString());

for(Cell cell:rt.rawCells()){

System.out.println(

Bytes.toString(CellUtil.cloneRow(cell))+"\t"+

Bytes.toString( CellUtil.cloneFamily(cell))+"\t"+

Bytes.toString(CellUtil.cloneQualifier(cell))+"\t"+

Bytes.toString( CellUtil.cloneValue(cell))

);

}

}

@Test

public void put() throws IOException {

Table tab = conn.getTable(TableName.valueOf("test"));

Put put1 = new Put("0004".getBytes());

put1.addColumn("info".getBytes(),"age".getBytes(),Bytes.toBytes("4"));

//put1.addColumn("info".getBytes(),"username".getBytes(),Bytes.toBytes("hellooww"));

Put put2 = new Put("0005".getBytes());

put2.addColumn("info".getBytes(),"age".getBytes(),Bytes.toBytes("45"));

// put2.addColumn("info".getBytes(),"username".getBytes(),Bytes.toBytes("alibaba"));

List list = new ArrayList();

list.add(put1);

list.add(put2);

tab.put(list);

}

@Test

public void deletByRowKey() throws IOException {

Table table = conn.getTable(TableName.valueOf("test"));

Delete delete = new Delete(Bytes.toBytes("0004"));

//如果age列有多个版本的话，这里只删除了最新的一个版本，其他版本的数据还在的，

//　addColumn是删除某一个列簇里的最新时间戳版本。

// delete.addColumns是删除某个列簇里的所有时间戳版本。

//delete.addColumn("info".getBytes(),"age".getBytes());

//测试下删除不存在的列

// delete.addColumn("info".getBytes(),"hh".getBytes());

//测试下删除不存在的列簇 会报错 column family info22 does not exist in region test

delete.addColumn("info22".getBytes(),"hh".getBytes());

table.delete(delete);

table.close();

}

@Test

public void scanTable() throws IOException {

Table table = conn.getTable(TableName.valueOf("test"));

Scan scan = new Scan();

//scan可以加很多条件和范围

scan.withStartRow("0002".getBytes());

//scan.withStopRow("0004".getBytes());//不包含末尾行

scan.withStopRow("0004".getBytes(),true);//包含末尾行

ResultScanner rtScan = table.getScanner( scan );

// Iterator itor = rtScan.iterator();

// while(itor.hasNext()){

// System.out.println( itor.next().toString());

// }

for (org.apache.hadoop.hbase.client.Result next = rtScan.next();next !=null;next = rtScan.next() ){

System.out.println(next.toString());

}

}

}