HBase学习笔记API（1）

配置maven中的settings.xml,设置镜像源。

		<mirror>  
			<id>nexus-aliyun</id>  
			<mirrorOf>central</mirrorOf>    
			<name>Nexus aliyun</name>  
			<url>http://maven.aliyun.com/nexus/content/groups/public</url>  
		</mirror>
			
		<mirror>  
			<id>nexus-osc</id>  
			<mirrorOf>*</mirrorOf>  
			<name>Nexus osc</name>  
			<url>http://maven.oschina.net/content/groups/public/</url>  
		</mirror>

配置pom.xml

    <dependency>
      <groupId>org.apache.hbase</groupId>
      <artifactId>hbase-server</artifactId>
      <version>0.98.6-hadoop2</version>
    </dependency>
    
    <dependency>
      <groupId>org.apache.hbase</groupId>
      <artifactId>hbase-client</artifactId>
      <version>0.98.6-hadoop2</version>
    </dependency>

package com.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.Delete;
import org.apache.hadoop.hbase.client.HBaseAdmin;
import org.apache.hadoop.hbase.client.HTable;
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.util.Bytes;

public class HBaseDemo {
	//创建Hadoop以及HBase管理配置对象
	public static Configuration conf;
	
	static {
		//使用HBaseConfiguration的单例方法实例化
		conf = HBaseConfiguration.create();
		conf.set("hbase.zookeeper.quorum","192.168.159.33");  //hbase 服务地址
		conf.set("hbase.zookeeper.property.clientPort","2181"); //端口号
	}
	
	/*
	 * 判断表是否存在
	 */
	public static boolean isTableExist(String tableName) throws MasterNotRunningException, ZooKeeperConnectionException, IOException {
		//在HBase中管理，访问表需要先创建HBaseAdmin对象
		HBaseAdmin admin = new HBaseAdmin(conf);
		return admin.tableExists(tableName);
	}
	
	/**
	 * 创建表
	 * @param tableName
	 * @param columnFamily
	 * @throws MasterNotRunningException
	 * @throws ZooKeeperConnectionException
	 * @throws IOException
	 */
	public static void createTable(String tableName, String... columnFamily) throws MasterNotRunningException, ZooKeeperConnectionException, IOException {
		HBaseAdmin admin = new HBaseAdmin(conf);
		//判断表是否存在
		if(isTableExist(tableName)) {
			System.out.println("表" + tableName + "已存在");
		}else {
			//创建表属性对象,表名需要转字节，valueOf() 方法用于返回给定参数的原生 Number 对象值，参数可以是原生数据类型, String等。
			HTableDescriptor descriptor = new HTableDescriptor(TableName.valueOf(tableName));
			
			//创建多个列族
			for(String cf : columnFamily) {
				descriptor.addFamily(new HColumnDescriptor(cf));
			}
			
			//根据对表的配置，创建表
			admin.createTable(descriptor);
			System.out.println("表" + tableName + "创建成功！");
		}
	}
	
	
	
	/**
	 * 删除表
	 * @param tableName
	 * @throws MasterNotRunningException
	 * @throws ZooKeeperConnectionException
	 * @throws IOException
	 */
	public static void dropTable(String tableName) throws MasterNotRunningException, ZooKeeperConnectionException, IOException {
		HBaseAdmin admin = new HBaseAdmin(conf);
		if(isTableExist(tableName)) {
			admin.disableTable(tableName);
			admin.deleteTable(tableName);
			System.out.println("表" + tableName + "删除成功！");
		}else {
			System.out.println("表" + tableName + "不存在！");
		}
	}
	
	/**
	 * 向HBase表中插入数据
	 * @param tableName
	 * @param rowKey
	 * @param columnFamily
	 * @param column
	 * @param value
	 * @throws IOException 
	 */
	public static void addRowData(String tableName, String rowKey, String columnFamily, String column, String value) throws IOException {
		//创建HTable对象
		HTable hTable = new HTable(conf, tableName);
		//向表中插入数据,转化字节
		Put put = new Put(Bytes.toBytes(rowKey));
		//向Put对象中组装数据
		put.add(Bytes.toBytes(columnFamily),Bytes.toBytes(column), Bytes.toBytes(value));
		hTable.put(put);
		hTable.close();
		System.out.println("插入成功！");
	}
	
	/**
	 * 删除多行数据
	 * @param tableName
	 * @param rows
	 * @throws IOException 
	 */
	public static void deleteMultiRow(String tableName, String... rows) throws IOException {
		HTable hTable = new HTable(conf, tableName);
		List<Delete> deleteList = new ArrayList<Delete>();
		for(String row : rows) {
			Delete delete = new Delete(Bytes.toBytes(row));
			deleteList.add(delete);
		}
		hTable.delete(deleteList);
		hTable.close();
		System.out.println("表" + tableName + "数据删除成功！");
	}
	
	
	/**
	 * 获取表中所有的数据
	 * @param tableName
	 * @throws IOException 
	 */
	public static void getAllRows(String tableName) throws IOException {
		HTable hTable = new HTable(conf, tableName);
		//得到用于扫描region的对象
		Scan scan = new Scan();
		//使用HTable得到resultscanner实现类的对象
		ResultScanner resultScanner = hTable.getScanner(scan);
		for(Result result : resultScanner) {
			Cell[] cells = result.rawCells();
			for(Cell cell : cells) {
				//得到rowkey
				System.out.print(Bytes.toString(CellUtil.cloneRow(cell)) + "\t");
				//得到列族
				System.out.print(Bytes.toString(CellUtil.cloneFamily(cell)) + "\t");
				System.out.print(Bytes.toString(CellUtil.cloneQualifier(cell)) + "\t");
				System.out.println(Bytes.toString(CellUtil.cloneValue(cell)));				
			}
		}
	}
	
	
	
	public static void main(String[] args)  {
		try {
//			System.out.println(isTableExist("student"));
//			createTable("person","basic_info","job","heathy");
//			dropTable("person");
//			addRowData("person", "1001", "basic_info", "name", "Jim");
//			addRowData("person", "1001", "basic_info", "sex", "Male");
//			addRowData("person", "1001", "basic_info", "age", "18");
//			addRowData("person", "1001", "job", "dept_no", "10");
//			deleteMultiRow("person", "1001");
			getAllRows("person");
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}