HBase 0.98增删改查java代码实现

HBase0.98代码

增删改查工具用例

package HBase;

import org.apache.hadoop.conf.Configuration;
import org.apache.hadoop.hbase.*;
import org.apache.hadoop.hbase.client.*;
import org.apache.hadoop.hbase.filter.Filter;
import org.apache.hadoop.hbase.util.Bytes;

import java.io.IOException;
import java.util.ArrayList;
import java.util.List;


/**
 * Created by LiuWenSheng on 2017/8/7.
 */
public class HBaseUtils {
    /**
     * 创建一个表并制定列族，同一个表只能创建一次，下次如果创建相同的表则会报出异常
     * @param admin
     * @param tableName 表名
     * @param columns 列族的字符串数组
     * @throws IOException
     */
    public void createTable(HBaseAdmin admin,String tableName,String[] columns) throws IOException {
        HTableDescriptor descriptor = new HTableDescriptor(TableName.valueOf(Bytes.toBytes(tableName)));
        for (String column :columns){
            descriptor.addFamily(new HColumnDescriptor(column));
        }
        admin.createTable(descriptor);
    }

    /**
     * 插入数据
     * @param conf 配置信息
     * @param tableName 表名
     * @param rowKey rowkey
     * @param colFamily 列族名
     * @param column 列名
     * @param value 插入的值
     * @throws IOException
     */
    public void insertData(Configuration conf,String tableName,String rowKey,String colFamily,String column,String value) throws IOException {
        HTable table = new HTable(conf, tableName);
        Put put = new Put(Bytes.toBytes(rowKey));
        put.add(Bytes.toBytes(colFamily),Bytes.toBytes(column),Bytes.toBytes(value));
        table.put(put);
    }

    /**
     * 删除表
     * @param admin
     * @param talbeName
     * @throws IOException
     */
    public void deleteTable(HBaseAdmin admin,String talbeName)throws  IOException{
        admin.disableTable(Bytes.toBytes(talbeName));
        admin.deleteTable(Bytes.toBytes(talbeName));
    }
    public void deleteRow(Configuration conf,String tableName ,String row) throws IOException {
        HTable table = new HTable(conf,tableName);
        Delete del = new Delete(Bytes.toBytes(row));
        table.delete(del);
    }
    public List<Cell[]> findByFilter(Configuration conf, String tableName, Filter filter) throws IOException, IllegalAccessException, InstantiationException {
        HTable table = new HTable(conf,tableName);
        List<Cell[]> list = new ArrayList<Cell[]>();
        Scan scaner = new Scan();
        scaner.setFilter(filter);
        ResultScanner results = table.getScanner(scaner);
        for (Result result:results){
            list.add(result.rawCells());
        }
        return list;
    }

    public  List<Cell[]>findByScan(Configuration conf,String tableName)throws IOException {
        HTable table = new HTable(conf,tableName);
        List<Cell[]> list = new ArrayList<Cell[]>();
        Scan scaner = new Scan();
        ResultScanner results = table.getScanner(scaner);
        for (Result result:results){
            list.add(result.rawCells());
        }
        return list;
    }
}

Hbase中只能说对用户的每一个操作都进行了封装，put是一个类，delete是一个类、等我们可以创建这些类，然后给这些累添加属性。最后使用这些类就可以完成增删改查操作。

测试用例

package test;

import HBase.HBaseUtils;
import org.apache.hadoop.conf.Configuration;


import org.apache.hadoop.hbase.Cell;
import org.apache.hadoop.hbase.HBaseConfiguration;
import org.apache.hadoop.hbase.client.HBaseAdmin;
import org.apache.hadoop.hbase.filter.ColumnPrefixFilter;
import org.apache.hadoop.hbase.util.Bytes;
import org.junit.Before;
import org.junit.Test;

import java.io.IOException;
import java.util.List;

/**
 * Created by Administrator on 2017/8/7.
 */
public class MyHBaseTest {
    private HBaseUtils hBaseUtils = new HBaseUtils();
    private Configuration  conf = HBaseConfiguration.create();
    private HBaseAdmin admin = null;
    @Before
    public void beforeTest() throws IOException {
        conf.set("hbase.zookeeper.quorum", "127.0.0.1");//此处应填你的IP地址，如果在windows下运行必须要填写
        conf.set("hbase.zookeeper.property.clientPort", "2181");
        admin = new HBaseAdmin(conf);
    }
    @Test
    public void test_createTable() throws IOException {
        String[] strs = new String[]{"one","two"};
        hBaseUtils.createTable(admin,"test",strs);
    }
    @Test
    public void test_insertData()throws IOException{
        hBaseUtils.insertData(conf,"test","rowkey","one","name","xingming");
    }
    @Test
    public void test_findbyFilter()throws Exception{
        ColumnPrefixFilter filter = new ColumnPrefixFilter(Bytes.toBytes("rowkey"));
        List<Cell[]> test = hBaseUtils.findByFilter(conf, "test", filter);
        if (test.isEmpty()){
            System.out.print("EMPOTY");
        }
        for (Cell[] cell:test){
            for (Cell c:cell){
                System.out.print(c.getRow());
            }
        }
    }
    @Test
    public void test_findByScan()throws Exception{
        List<Cell[]> test = hBaseUtils.findByScan(conf, "test");
        if (test.isEmpty()){
            System.out.print("EMPOTY");
        }
        for (Cell[] cell:test){
            for (Cell c:cell){
                System.out.println(new String(c.getRowArray(),c.getRowOffset(),c.getRowLength()));
                System.out.println(new String(c.getValueArray(),c.getValueOffset(),c.getValueLength()));
                System.out.println(new String(c.getQualifierArray(),c.getQualifierOffset(),c.getQualifierLength()));
            }
        }
    }
}