hbase 1.1.4增删查改demo

下面代码在hadoop 2.6.0 + hbase 1.1.4 + centos 7 + jdk 1.7上运行通过。

package cn.abc.hbase;

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

import org.apache.hadoop.conf.Configuration;
import org.apache.hadoop.hbase.Cell;
import org.apache.hadoop.hbase.CellUtil;
import org.apache.hadoop.hbase.HBaseConfiguration;
import org.apache.hadoop.hbase.HColumnDescriptor;
import org.apache.hadoop.hbase.HTableDescriptor;
import org.apache.hadoop.hbase.MasterNotRunningException;
import org.apache.hadoop.hbase.TableName;
import org.apache.hadoop.hbase.ZooKeeperConnectionException;
import org.apache.hadoop.hbase.client.Admin;
import org.apache.hadoop.hbase.client.Connection;
import org.apache.hadoop.hbase.client.ConnectionFactory;
import org.apache.hadoop.hbase.client.Delete;
import org.apache.hadoop.hbase.client.Get;
import org.apache.hadoop.hbase.client.Put;
import org.apache.hadoop.hbase.client.Result;
import org.apache.hadoop.hbase.client.ResultScanner;
import org.apache.hadoop.hbase.client.Scan;
import org.apache.hadoop.hbase.client.Table;
import org.apache.hadoop.hbase.util.Bytes;

public class HBaseDemo {

	public static Configuration conf;

	static {
		conf = HBaseConfiguration.create();
		conf.addResource("hbase-site.xml");
	}

	/**
	 * 创建表
	 * 
	 * @param tablename 表名
	 * @param columnFamily 列族
	 * @throws MasterNotRunningException
	 * @throws ZooKeeperConnectionException
	 * @throws IOException
	 */
	public static void createTable(String tablename, String columnFamily)
			throws MasterNotRunningException, IOException, ZooKeeperConnectionException {
		Connection conn = ConnectionFactory.createConnection(conf);
		Admin admin = conn.getAdmin();
		try {
			if (admin.tableExists(TableName.valueOf(tablename))) {
				System.out.println(tablename + " already exists");
			} else {
				TableName tableName = TableName.valueOf(tablename);
				HTableDescriptor tableDesc = new HTableDescriptor(tableName);
				tableDesc.addFamily(new HColumnDescriptor(columnFamily));
				admin.createTable(tableDesc);
				System.out.println(tablename + " created succeed");
			}
		} finally {
			admin.close();
			conn.close();
		}
	}
	
	/**
	 * 向表中插入一条新数据
	 * 
	 * @param tableName 表名
	 * @param row 行键key
	 * @param columnFamily 列族
	 * @param column 列名
	 * @param data 要插入的数据
	 * @throws IOException
	 */
	public static void putData(String tableName, String row, String columnFamily, String column, String data)
			throws IOException {
		Connection conn = ConnectionFactory.createConnection(conf);
		Table table = conn.getTable(TableName.valueOf(tableName));
		try {
			Put put = new Put(Bytes.toBytes(row));
			put.addColumn(Bytes.toBytes(columnFamily), Bytes.toBytes(column), Bytes.toBytes(data));
			table.put(put);
//			System.out.println("put '" + row + "','" + columnFamily + ":" + column + "','" + data + "'");
		} finally {
			table.close();
			conn.close();
		}
	}
	
	/**
	 * add a column family to an existing table
	 * 
	 * @param tableName table name 
	 * @param columnFamily column family
	 * @throws IOException
	 */
	public static void putFamily(String tableName, String columnFamily) throws IOException {
		Connection conn = ConnectionFactory.createConnection(conf);
		Admin admin = conn.getAdmin();
		try {
			if (!admin.tableExists(TableName.valueOf(tableName))) {
				System.out.println(tableName + " not exists");
			} else {
				admin.disableTable(TableName.valueOf(tableName));
				
				HColumnDescriptor cf1 = new HColumnDescriptor(columnFamily);
				admin.addColumn(TableName.valueOf(tableName), cf1);
				
				admin.enableTable(TableName.valueOf(tableName));
				System.out.println(TableName.valueOf(tableName) + ", " + columnFamily + " put succeed");
			}
		} finally {
			admin.close();
			conn.close();
		}
	}
	
	/**
	 * 根据key读取一条数据
	 * 
	 * @param tableName 表名
	 * @param row 行键key
	 * @param columnFamily 列族
	 * @param column 列名
	 * @throws IOException
	 */
	public static void getData(String tableName, String row, String columnFamily, String column) throws IOException{
		Connection conn = ConnectionFactory.createConnection(conf);
		Table table = conn.getTable(TableName.valueOf(tableName));
		try{
			Get get = new Get(Bytes.toBytes(row));
			Result result = table.get(get);
			byte[] rb = result.getValue(Bytes.toBytes(columnFamily), Bytes.toBytes(column));
			String value = new String(rb, "UTF-8");
			System.out.println(value);
		} finally {
			table.close();
			conn.close();
		}
	}

	/**
	 * get all data of a table
	 * 
	 * @param tableName table name
	 * @throws IOException
	 */
	public static void scanAll(String tableName) throws IOException {
		Connection conn = ConnectionFactory.createConnection(conf);
		Table table = conn.getTable(TableName.valueOf(tableName));
		try {
			Scan scan = new Scan();
			ResultScanner resultScanner = table.getScanner(scan);
			for(Result result : resultScanner){
				List<Cell> cells = result.listCells();
				for(Cell cell : cells){
					String row = new String(result.getRow(), "UTF-8");
					String family = new String(CellUtil.cloneFamily(cell), "UTF-8");
					String qualifier = new String(CellUtil.cloneQualifier(cell), "UTF-8");
					String value = new String(CellUtil.cloneValue(cell), "UTF-8");
					System.out.println("[row:"+row+"],[family:"+family+"],[qualifier:"+qualifier+"],[value:"+value+"]");
				}
			}
		} finally {
			table.close();
			conn.close();
		}
	}
	
	/**
	 * delete a data by row key
	 * 
	 * @param tableName table name
	 * @param rowKey row key
	 * @throws IOException
	 */
	public static void delData(String tableName, String rowKey) throws IOException {
		Connection conn = ConnectionFactory.createConnection(conf);
		Table table = conn.getTable(TableName.valueOf(tableName));
		try {
			List<Delete> list = new ArrayList<Delete>();
			Delete del = new Delete(rowKey.getBytes());
			list.add(del);
			table.delete(list);
			System.out.println("delete record " + rowKey + " ok");
		} finally {
			table.close();
			conn.close();
		}
	}
	
	/**
	 * delete a column's value of a row
	 * 
	 * @param tableName table name
	 * @param rowKey row key
	 * @param familyName family name
	 * @param columnName column name
	 * @throws IOException
	 */
	public static void deleteColumn(String tableName, String rowKey, String familyName, String columnName) throws IOException {
		Connection conn = ConnectionFactory.createConnection(conf);
		Table table = conn.getTable(TableName.valueOf(tableName));
		try{
			Delete del = new Delete(Bytes.toBytes(rowKey));
			del.addColumn(Bytes.toBytes(familyName), Bytes.toBytes(columnName));
			List<Delete> list = new ArrayList<Delete>(1);
			list.add(del);
			table.delete(list);
			System.out.println("[table:"+tableName+"],row:"+rowKey+"],[family:"+familyName+"],[qualifier:"+columnName+"]");
		} finally {
			table.close();
			conn.close();
		}
	}

	/**
	 * delete a columnFamily's all columns value of a row 
	 * 
	 * @param tableName table name
	 * @param rowKey row key
	 * @param familyName family name
	 * @throws IOException
	 */
	public static void deleteFamily(String tableName, String rowKey, String familyName) throws IOException {
		Connection conn = ConnectionFactory.createConnection(conf);
		Table table = conn.getTable(TableName.valueOf(tableName));
		try{
			Delete del = new Delete(Bytes.toBytes(rowKey));
			del.addFamily(Bytes.toBytes(familyName));
			List<Delete> list = new ArrayList<Delete>(1);
			list.add(del);
			table.delete(list);
			System.out.println("[table:"+tableName+"],row:"+rowKey+"],[family:"+familyName+"]");
		} finally {
			table.close();
			conn.close();
		}
	}

	/**
	 * delete a table
	 * 
	 * @param tableName table name
	 * @throws IOException
	 * @throws MasterNotRunningException
	 * @throws ZooKeeperConnectionException
	 */
	public static void deleteTable(String tableName) throws IOException, MasterNotRunningException, ZooKeeperConnectionException {
		Connection conn = ConnectionFactory.createConnection(conf);
		Admin admin = conn.getAdmin();
		try {
			admin.disableTable(TableName.valueOf(tableName));
			admin.deleteTable(TableName.valueOf(tableName));
			System.out.println("delete table " + tableName + " ok");
		} finally {
			admin.close();
			conn.close();
		}
	}
	
	public static void main(String[] args) {
		System.err.println("start...");
//		String tableName = "student";
		String tableName = "bus_load";
		try{
//			createTable(tableName, "stu");
//			createTable(tableName + "2", "stu");
			createTable(tableName, "load");
			putData(tableName, "row_1", "load", "no", "0001");
			putData(tableName, "row_1", "load", "rec_date", "2016-06-03");
			putData(tableName, "row_1", "load", "rec_time", "09:49:00");
			putData(tableName, "row_1", "load", "power", "154.24");
			
//			putData(tableName, "row_1", "stu", "stu_id", "001");
//			putData(tableName, "row_2", "stu", "stu_id", "002");
//			putData(tableName, "row_3", "stu", "stu_id", "003");
//			getData(tableName, "row_1", "stu", "stu_id");
//			delData(tableName, "row_3");
//			scanAll(tableName);
//			deleteTable(tableName + "2");
//			putFamily(tableName, "score");
//			putData(tableName, "row_4", "score", "chinese", "90");
//			putData(tableName, "row_5", "score", "math", "91");
//			scanAll(tableName);
//			deleteColumn(tableName, "row_4", "score", "chinese");
//			deleteFamily(tableName, "row_5", "score");
			scanAll(tableName);
		} catch(Exception ex){
			ex.printStackTrace();
		}
		System.err.println("end...");
	}

}