HBase学习

HBase与java程序交互

1.判断表是否存在
2.创建表
3.创建命名空间
4.删除表
5.插入代码块
6.查数据(get)
7.查数据(scan)
8.删除数据
删除数据的总结：

整合上面8个步骤

package com.wxit.utils;

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

import java.io.IOException;

/**
 * @Author wj
 **/
public class Utils {

    private static Connection connection = null;
    private static Admin admin = null;

    static {
        try {
            //1.获取配置文件信息
            Configuration configuration = HBaseConfiguration.create();

            configuration.set("hbase.zookeeper.quorum", "192.168.56.102");
            configuration.set("hbase.zookeeper.property.clientPort", "2181");
            configuration.set("hbase.master", "192.168.56.102:16000");
            configuration.set("zookeeper.znode.parent", "/hbase");

            connection = ConnectionFactory.createConnection(configuration);

            admin = connection.getAdmin();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    public static boolean isTableExist(String tableName) throws IOException {

        boolean exists = admin.tableExists(TableName.valueOf(tableName));

        return exists;
    }

    //关闭资源
    public static void close(){
        if (admin != null){
            try {
                admin.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
        if (connection != null){
            try {
                connection.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    }

    //创建表
    public static void createTable(String tableName,String ... cfs) throws IOException {

        //1.判断是否存在列族信息
        if (cfs.length <= 0){
            System.out.println("请设置列族信息");
            return;
        }

        //2判断表是否存在
        if (isTableExist(tableName)){
            System.out.println(tableName + "表已存在！");
            return;
        }

        //3.创建表描述器
        HTableDescriptor hTableDescriptor = new HTableDescriptor(TableName.valueOf(tableName));

        //4.循环添加列表信息
        for (String cf : cfs){

            //5.创建列族描述器
            HColumnDescriptor hColumnDescriptor = new HColumnDescriptor(cf);

            //添加具体的列族信息
            hTableDescriptor.addFamily(hColumnDescriptor);
        }

        //4.创建表
        admin.createTable(hTableDescriptor);
    }

    //删除表
    public static void dropTable(String tableName) throws IOException {

        //1.判断表是否存在
        if(!isTableExist(tableName)){
            System.out.println(tableName + "表不存在！");
            return;
        }

        //2.使表下线
        admin.disableTable(TableName.valueOf(tableName));

        //3.删除表
        admin.deleteTable(TableName.valueOf(tableName));
    }

    //创建命名空间
    public static void createNameSpace(String ns){

        //1.创建命名空间描述器
        NamespaceDescriptor namespaceDescriptor = NamespaceDescriptor.create(ns).build();

        //2.创建命令空间
        try {
            admin.createNamespace(namespaceDescriptor);
        } catch (NamespaceExistException e){
            System.out.println(ns + "命名空间已存在！");
        } catch (IOException e) {
            e.printStackTrace();
        }

        System.out.println("可以");
    }

    //5.向表中插入数据
    public static void putData(String tableName,String rowKey,String cf,String cn,String value) throws IOException {

        //1.获取连接表对象
        Table table = connection.getTable(TableName.valueOf(tableName));

        //2.创建Put对象
        Put put = new Put(Bytes.toBytes(rowKey));

        //3.给put对象赋值
        put.addColumn(Bytes.toBytes(cf),Bytes.toBytes(cn),Bytes.toBytes(value));

        //4.插入数据
        table.put(put);

        //5.关闭连接
        table.close();

    }

    //6.获取数据
    public static void getData(String tableName,String rowKey,String cf,String cn) throws IOException {

        //1.获取表对象
        Table table = connection.getTable(TableName.valueOf(tableName));

        //2.创建Get对象
        Get get = new Get(Bytes.toBytes(rowKey));

        //2.1指定获取的列族
//        get.addFamily(Bytes.toBytes(cf));

        //2.2指定列族和列
        get.addColumn(Bytes.toBytes(cf),Bytes.toBytes(cn));

        //2.3设置获取数据的版本数
        get.setMaxVersions();

        //3.获取数据
        Result result = table.get(get);

        //4.解析result，并打印
        for (Cell cell : result.rawCells()) {

            //5.打印数据
            System.out.println("CF:" + Bytes.toString(CellUtil.cloneFamily(cell))
            + "CN:" + Bytes.toString(CellUtil.cloneQualifier(cell))
            + "Value:" + Bytes.toString(CellUtil.cloneValue(cell)) );
        }

        //6.关闭表连接
        table.close();
    }

    //7.获取数据(Scan)
    public static void scanTable(String tableName) throws IOException {

        //1.获取表对象
        Table table = connection.getTable(TableName.valueOf(tableName));

        //2.构建Scan对象
        Scan scan = new Scan();

        //3.扫描表
        ResultScanner resultScanner = table.getScanner(scan);

        //4.解析resultScanner
        for (Result result : resultScanner) {

            //5.解析result并打印
            for (Cell cell : result.rawCells()) {
                //6.打印数据
                System.out.println("CF:" + Bytes.toString(CellUtil.cloneFamily(cell))
                        + "CN:" + Bytes.toString(CellUtil.cloneQualifier(cell))
                        + "Value:" + Bytes.toString(CellUtil.cloneValue(cell)) );
            }
        }

        //7.关闭表连接
        table.close();
    }

    //8.
    public static void deleteData(String tableName,String rowKey,String cf,String cn) throws IOException {

        //1.获取表对象
        Table table = connection.getTable(TableName.valueOf(tableName));

        //2.构建删除对象
        Delete delete = new Delete(Bytes.toBytes(rowKey));

        //2.1设置删除的列
//        delete.addColumn(Bytes.toBytes(cf),Bytes.toBytes(cn));

        //2.2删除指定的列族
        delete.addFamily(Bytes.toBytes(cf));

        //3.执行删除操作
        table.delete(delete);

        //4.关闭连接
        table.close();
    }


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

//        System.out.println(isTableExist("stu5"));
//
//        createTable("0408:stu5","info1","info2");

//        dropTable("stu5");

//        createNameSpace("0408");

//        System.out.println(isTableExist("stu5"));
//        putData("stu","1001","info2","name","wujie");

//        getData("stu2","1001","info","name");
//        scanTable("stu");

        deleteData("stu","1010","info1","name");
        close();
    }

}