[HBase 基础]-- 增删改查表(包含过滤)

最新推荐文章于 2024-12-02 16:43:54 发布
原创 最新推荐文章于 2024-12-02 16:43:54 发布 · 651 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#hbase

一、简单模式的实现的代码如下

import java.io.IOException;

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.Get;
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.mapreduce.TableInputFormat;
import org.apache.hadoop.hbase.util.Bytes;
import org.apache.hadoop.security.UserGroupInformation;

/**
 * Document:本类作用---->使用Hbase传统api创建hbase表、查询数据等（测试环境）
 * User: yangjf
 * Date: 2016/8/18  18:31
 * 本地模式
 * 测试通过
 */

public class SimpleHBase {

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

  System.setProperty("java.security.krb5.conf","F:/krb5.conf");//windows下 ,本地执行需要
  String tableName="greatgas:student";

  Configuration configuration = HBaseConfiguration.create();//创建Hbase连接配置
  configuration.set("hbase.zookeeper.quorum", "slave-31.dev.cluster.enn.cn:2181");
  configuration.set("hbase.rootdir", "hdfs://mycluster/hbase");
  configuration.set("hadoop.security.authentication", "kerberos");
  configuration.set("hbase.security.authentication", "kerberos");
  configuration.set("hbase.security.authorization", "true");
  configuration.set("hbase.master.kerberos.principal", "hbase/_HOST@ENN.CN");
  configuration.set("hbase.thrift.kerberos.principal", "hbase/_HOST@ENN.CN");
  configuration.set("hbase.regionserver.kerberos.principal", "hbase/_HOST@ENN.CN");
  configuration.set("hbase.zookeeper.property.clientPort", "2181");
  configuration.set(TableInputFormat.INPUT_TABLE, tableName);
  configuration.set("hbase.rpc.timeout", "10000");
  configuration.set("hbase.client.retries.number", "5");
  configuration.set("hbase.client.pause", "5000");
  configuration.set("hbase.client.scanner.timeout.period", "50000");
  String user = "e_heyutao@ENN.CN";
  String keyPath = "F:/e_heyutao.keytab";                 //本地测试需要的文件
  UserGroupInformation.setConfiguration(configuration);
  UserGroupInformation.loginUserFromKeytab(user, keyPath);

  //测试创建、添加、获取和删除数据
  System.out.println("建表.......");
  createTable(configuration, tableName);
  System.out.println("添加数据.......");
  addData(configuration, tableName);
  System.out.println("获取数据.......");
  getData(configuration, tableName);
  System.out.println("获取所有数据.......");
  getAllData(configuration, tableName);
  System.out.println("删除数据.......");
  deleteDate(configuration, tableName);
  System.out.println("删除表.......");
  dropTable(configuration, tableName);
  
 }
 
 /**
  * create a new Table
  * @param configuration Configuration
  * @param tableName String,the new Table's name
  * */
 public static void createTable(Configuration configuration,String tableName){
  HBaseAdmin admin;
  try {
   admin = new HBaseAdmin(configuration);
   if(admin.tableExists(tableName)){
    admin.disableTable(tableName);
    admin.deleteTable(tableName);
    System.out.println(tableName+"is exist ,delete ......");
   }
   
   
   HTableDescriptor tableDescriptor=new HTableDescriptor(TableName.valueOf(tableName));
   tableDescriptor.addFamily(new HColumnDescriptor("info"));
   tableDescriptor.addFamily(new HColumnDescriptor("address"));
   admin.createTable(tableDescriptor);
   System.out.println("end create table");
  } catch (MasterNotRunningException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (ZooKeeperConnectionException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (IOException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  
 }
 
 /**
  * Delete the existing table
  * @param configuration Configuration
  * @param tableName String,Table's name
  * */
 public static void dropTable(Configuration configuration,String tableName){
  HBaseAdmin admin;
  try {
   admin = new HBaseAdmin(configuration);
   if(admin.tableExists(tableName)){
    admin.disableTable(tableName);
    admin.deleteTable(tableName);
    System.out.println(tableName+"delete success!");
   }else{
    System.out.println(tableName+"Table does not exist!");
   }
  } catch (MasterNotRunningException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (ZooKeeperConnectionException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (IOException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
 }
 
 /**
  * insert a data
  * @param configuration Configuration
  * @param tableName String,Table's name
  * */
 public static void addData(Configuration configuration,String tableName){
  HBaseAdmin admin;
  try {
   admin = new HBaseAdmin(configuration);
   if(admin.tableExists(tableName)){
    HTable table=new HTable(configuration, tableName);
    Put put=new Put(Bytes.toBytes("zhangsan"));
    put.add(Bytes.toBytes("info"), Bytes.toBytes("age"), Bytes.toBytes("28"));
    table.put(put);
    System.out.println("add success!");
   }else{
    System.out.println(tableName+"Table does not exist!");
   }
  } catch (MasterNotRunningException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (ZooKeeperConnectionException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (IOException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
 }
 
 /**
  * Delete a data
  * @param configuration Configuration
  * @param tableName String,Table's name
  * */
 public static void deleteDate(Configuration configuration,String tableName){
  HBaseAdmin admin;
  try {
   admin=new HBaseAdmin(configuration);
   if(admin.tableExists(tableName)){
    HTable table=new HTable(configuration, tableName);
    Delete delete=new Delete(Bytes.toBytes("zhangsan"));
    table.delete(delete);
    System.out.println("delete success!");
   }else{
    System.out.println("Table does not exist!");
   }
  } catch (MasterNotRunningException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (ZooKeeperConnectionException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (IOException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
 }
 

 /**
  * get a data
  * @param configuration Configuration
  * @param tableName String,Table's name
  * */
 public static void getData(Configuration configuration,String tableName){
  HTable table;
  try {
   table = new HTable(configuration, tableName);
   Get get=new Get(Bytes.toBytes("zhangsan"));
   Result result=table.get(get);
 
   for(Cell cell:result.rawCells()){   
    System.out.println("RowName:"+new String(CellUtil.cloneRow(cell))+" ");
    System.out.println("Timetamp:"+cell.getTimestamp()+" ");
    System.out.println("column Family:"+new String(CellUtil.cloneFamily(cell))+" ");
    System.out.println("row Name:"+new String(CellUtil.cloneQualifier(cell))+" ");
    System.out.println("value:"+new String(CellUtil.cloneValue(cell))+" ");
   }
  } catch (IOException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
 }
 
 /**
  * insert all data
  * @param configuration Configuration
  * @param tableName String,Table's name
  * */
 public static void getAllData(Configuration configuration,String tableName){
  HTable table;
  try {
   table=new HTable(configuration, tableName);
   Scan scan=new Scan();
   ResultScanner results=table.getScanner(scan);
   for(Result result:results){
    for(Cell cell:result.rawCells()){   
     System.out.println("RowName:"+new String(CellUtil.cloneRow(cell))+" ");
     System.out.println("Timetamp:"+cell.getTimestamp()+" ");
     System.out.println("column Family:"+new String(CellUtil.cloneFamily(cell))+" ");
     System.out.println("row Name:"+new String(CellUtil.cloneQualifier(cell))+" ");
     System.out.println("value:"+new String(CellUtil.cloneValue(cell))+" ");
    }
   }
  } catch (IOException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
    
 }
}

 

二、有接口类和实现类的实现代码如下

 

1、接口类

package local.interfaces;

import java.util.List;

import org.apache.hadoop.hbase.client.Put;
import org.apache.hadoop.hbase.client.Result;

public interface HBaseDAO {

	public void save(Put put, String tableName) ;
	public void insert(String tableName, String rowKey, String family, String quailifer, String value) ;
	public void insert(String tableName, String rowKey, String family, String quailifer[], String value[]) ;
	
	public void save(List Put, String tableName) ;
	
	public Result getOneRow(String tableName, String rowKey) ;
	
	public List getRows(String tableName, String rowKey_like) ;
	
	public List getRows(String tableName, String rowKeyLike, String cols[]) ;
	
	public List getRows(String tableName, String startRow, String stopRow) ;
	
	public void deleteRecords(String tableName, String rowKeyLike);
	public   void deleteTable(String tableName);
	public   void createTable(String tableName, String[] columnFamilys);
}
 Put, String tableName) ;
	
	public Result getOneRow(String tableName, String rowKey) ;
	
	public List getRows(String tableName, String rowKey_like) ;
	
	public List getRows(String tableName, String rowKeyLike, String cols[]) ;
	
	public List getRows(String tableName, String startRow, String stopRow) ;
	
	public void deleteRecords(String tableName, String rowKeyLike);
	public   void deleteTable(String tableName);
	public   void createTable(String tableName, String[] columnFamilys);
}

 

2、实现类

 

package local.impl;

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

import local.interfaces.HBaseDAO;
import org.apache.hadoop.conf.Configuration;
import org.apache.hadoop.hbase.Cell;
import org.apache.hadoop.hbase.CellUtil;
import org.apache.hadoop.hbase.HColumnDescriptor;
import org.apache.hadoop.hbase.HTableDescriptor;
import org.apache.hadoop.hbase.KeyValue;
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.Get;
import org.apache.hadoop.hbase.client.HBaseAdmin;
import org.apache.hadoop.hbase.client.HConnection;
import org.apache.hadoop.hbase.client.HConnectionManager;
import org.apache.hadoop.hbase.client.HTable;
import org.apache.hadoop.hbase.client.HTableInterface;
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.filter.PrefixFilter;
import org.apache.hadoop.hbase.mapreduce.TableInputFormat;
import org.apache.hadoop.security.UserGroupInformation;

/**
 * Document:本类作用---->接口实现类，增删改查
 * User: yangjf
 * Date: 2016/9/18  18:31
 * 本地模式
 * 测试通过
 */

public class HBaseDAOImp implements HBaseDAO {

	HConnection hTablePool = null;

	static Configuration conf =null;
	public HBaseDAOImp()
	{
		System.setProperty("java.security.krb5.conf","F:/krb5.conf");//windows下 ,本地执行需要
		conf = new Configuration();
		String zk_list = "slave-31.dev.cluster.enn.cn:2181";
		conf.set("hbase.zookeeper.quorum", zk_list);

//		conf.set("hbase.zookeeper.quorum", "slave-31.dev.cluster.enn.cn:2181");
		conf.set("hbase.rootdir", "hdfs://mycluster/hbase");
		conf.set("hadoop.security.authentication", "kerberos");
		conf.set("hbase.security.authentication", "kerberos");
		conf.set("hbase.security.authorization", "true");
		conf.set("hbase.master.kerberos.principal", "hbase/_HOST@ENN.CN");
		conf.set("hbase.thrift.kerberos.principal", "hbase/_HOST@ENN.CN");
		conf.set("hbase.regionserver.kerberos.principal", "hbase/_HOST@ENN.CN");
		conf.set("hbase.zookeeper.property.clientPort", "2181");
//		conf.set(TableInputFormat.INPUT_TABLE, tableName);
		conf.set("hbase.rpc.timeout", "10000");
		conf.set("hbase.client.retries.number", "5");
		conf.set("hbase.client.pause", "5000");
		conf.set("hbase.client.scanner.timeout.period", "50000");
		String user = "e_heyutao@ENN.CN";
		String keyPath = "F:/e_heyutao.keytab";                 //本地测试需要的文件
		UserGroupInformation.setConfiguration(conf);

		try {
			UserGroupInformation.loginUserFromKeytab(user, keyPath);

			hTablePool = HConnectionManager.createConnection(conf) ;
		} catch (IOException e) {
			e.printStackTrace();
		}
	}

	//main方法测试
	public static void main(String[] args) {
		HBaseDAO dao = new HBaseDAOImp();

//		创建表
		String tableName="greatgas:test";
		String cfs[] = {"cf"};
		dao.createTable(tableName,cfs);

//		存入一条数据
		Put put = new Put("mytest".getBytes());
		put.add("cf".getBytes(), "name".getBytes(), "cai10".getBytes()) ;
		dao.save(put, "greatgas:test") ;

//		插入多列数据
		Put puts = new Put("mytest".getBytes());
		List list = new ArrayList();
		put.add("cf".getBytes(), "addr".getBytes(), "shanghai1".getBytes()) ;
		put.add("cf".getBytes(), "age".getBytes(), "30".getBytes()) ;
		put.add("cf".getBytes(), "tel".getBytes(), "13889891818".getBytes()) ;
		list.add(puts) ;
		dao.save(list, "greatgas:test");

//		插入单行数据
		dao.insert("greatgas:test", "testrow", "cf", "age", "35") ;
		dao.insert("greatgas:test", "testrow", "cf", "cardid", "12312312335") ;
		dao.insert("greatgas:test", "testrow", "cf", "tel", "13512312345") ;

		List list2 = dao.getRows("greatgas:test", "testrow",new String[]{"age"}) ;
		for(Result rs : list2)
		{
			for(Cell cell:rs.rawCells()){
				System.out.println("RowName:"+new String(CellUtil.cloneRow(cell))+" ");
				System.out.println("Timetamp:"+cell.getTimestamp()+" ");
				System.out.println("column Family:"+new String(CellUtil.cloneFamily(cell))+" ");
				System.out.println("row Name:"+new String(CellUtil.cloneQualifier(cell))+" ");
				System.out.println("value:"+new String(CellUtil.cloneValue(cell))+" ");
			}
		}

		Result rs = dao.getOneRow("greatgas:test", "testrow");
		System.out.println(new String(rs.getValue("cf".getBytes(), "age".getBytes())));


	}
	@Override
	public void save(Put put, String tableName) {
		// TODO Auto-generated method stub
		HTableInterface table = null;
		try {
			table = hTablePool.getTable(tableName) ;
			table.put(put) ;

		} catch (Exception e) {
			e.printStackTrace() ;
		}finally{
			try {
				table.close() ;
			} catch (IOException e) {
				e.printStackTrace();
			}
		}
	}
	@Override
	public void insert(String tableName, String rowKey, String family,
					   String quailifer, String value) {
		// TODO Auto-generated method stub
		HTableInterface table = null;
		try {
			table = hTablePool.getTable(tableName) ;
			Put put = new Put(rowKey.getBytes());
			put.add(family.getBytes(), quailifer.getBytes(), value.getBytes()) ;
			table.put(put);
		} catch (Exception e) {
			e.printStackTrace();
		}finally
		{
			try {
				table.close() ;
			} catch (IOException e) {
				e.printStackTrace();
			}
		}
	}
	@Override
	public void insert(String tableName,String rowKey,String family,String quailifer[],String value[])
	{
		HTableInterface table = null;
		try {
			table = hTablePool.getTable(tableName) ;
			Put put = new Put(rowKey.getBytes());
			// 批量添加
			for (int i = 0; i < quailifer.length; i++) {
				String col = quailifer[i];
				String val = value[i];
				put.add(family.getBytes(), col.getBytes(), val.getBytes());
			}
			table.put(put);
		} catch (Exception e) {
			e.printStackTrace();
		}finally
		{
			try {
				table.close() ;
			} catch (IOException e) {
				e.printStackTrace();
			}
		}
	}
	@Override
	public void save(List Put, String tableName) {
		// TODO Auto-generated method stub
		HTableInterface table = null;
		try {
			table = hTablePool.getTable(tableName) ;
			table.put(Put) ;
		}
		catch (Exception e) {
			// TODO: handle exception
		}finally
		{
			try {
				table.close() ;
			} catch (IOException e) {
				e.printStackTrace();
			}
		}

	}


	@Override
	public Result getOneRow(String tableName, String rowKey) {
		// TODO Auto-generated method stub
		HTableInterface table = null;
		Result rsResult = null;
		try {
			table = hTablePool.getTable(tableName) ;
			Get get = new Get(rowKey.getBytes()) ;
			rsResult = table.get(get) ;
		} catch (Exception e) {
			e.printStackTrace() ;
		}
		finally
		{
			try {
				table.close() ;
			} catch (IOException e) {
				e.printStackTrace();
			}
		}
		return rsResult;
	}

	@Override
	public List getRows(String tableName, String rowKeyLike) {
		// TODO Auto-generated method stub
		HTableInterface table = null;
		List list = null;
		try {
			table = hTablePool.getTable(tableName) ;
			PrefixFilter filter = new PrefixFilter(rowKeyLike.getBytes());
			Scan scan = new Scan();
			scan.setFilter(filter);
			ResultScanner scanner = table.getScanner(scan) ;
			list = new ArrayList() ;
			for (Result rs : scanner) {
				list.add(rs) ;
			}
		} catch (Exception e) {
			e.printStackTrace() ;
		}
		finally
		{
			try {
				table.close() ;
			} catch (IOException e) {
				e.printStackTrace();
			}
		}
		return list;
	}

	@Override
	public List getRows(String tableName, String rowKeyLike ,String cols[]) {
		// TODO Auto-generated method stub
		HTableInterface table = null;
		List list = null;
		try {
			table = hTablePool.getTable(tableName) ;
			PrefixFilter filter = new PrefixFilter(rowKeyLike.getBytes());
			Scan scan = new Scan();
			for (int i = 0; i < cols.length; i++) {
				scan.addColumn("cf".getBytes(), cols[i].getBytes()) ;
			}
			scan.setFilter(filter);
			ResultScanner scanner = table.getScanner(scan) ;
			list = new ArrayList() ;
			for (Result rs : scanner) {
				list.add(rs) ;
			}
		} catch (Exception e) {
			e.printStackTrace() ;
		}
		finally
		{
			try {
				table.close() ;
			} catch (IOException e) {
				e.printStackTrace();
			}
		}
		return list;
	}
	@Override
	public List getRows(String tableName,String startRow,String stopRow)
	{
		HTableInterface table = null;
		List list = null;
		try {
			table = hTablePool.getTable(tableName) ;
			Scan scan = new Scan() ;
			scan.setStartRow(startRow.getBytes()) ;
			scan.setStopRow(stopRow.getBytes()) ;
			ResultScanner scanner = table.getScanner(scan) ;
			list = new ArrayList() ;
			for (Result rsResult : scanner) {
				list.add(rsResult) ;
			}

		}catch (Exception e) {
			e.printStackTrace() ;
		}
		finally
		{
			try {
				table.close() ;
			} catch (IOException e) {
				e.printStackTrace();
			}
		}
		return list;
	}

	@Override
	public void deleteRecords(String tableName, String rowKeyLike){
		HTableInterface table = null;
		try {
			table = hTablePool.getTable(tableName) ;
			PrefixFilter filter = new PrefixFilter(rowKeyLike.getBytes());
			Scan scan = new Scan();
			scan.setFilter(filter);
			ResultScanner scanner = table.getScanner(scan) ;
			List list = new ArrayList() ;
			for (Result rs : scanner) {
				Delete del = new Delete(rs.getRow());
				list.add(del) ;
			}
			table.delete(list);
		}
		catch (Exception e) {
			e.printStackTrace() ;
		}
		finally
		{
			try {
				table.close() ;
			} catch (IOException e) {
				e.printStackTrace();
			}
		}

	}

	public   void createTable(String tableName, String[] columnFamilys){
		try {
			// admin 对象
			HBaseAdmin admin = new HBaseAdmin(conf);
			if (admin.tableExists(tableName)) {
				System.err.println("此表，已存在！");
			} else {
				HTableDescriptor tableDesc = new HTableDescriptor(
						TableName.valueOf(tableName));

				for (String columnFamily : columnFamilys) {
					tableDesc.addFamily(new HColumnDescriptor(columnFamily));
				}

				admin.createTable(tableDesc);
				System.err.println("建表成功!");

			}
			admin.close();// 关闭释放资源
		} catch (MasterNotRunningException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (ZooKeeperConnectionException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

	}

	/**
	 * 删除一个表
	 *
	 * @param tableName
	 *            删除的表名
	 * */
	public   void deleteTable(String tableName)   {
		try {
			HBaseAdmin admin = new HBaseAdmin(conf);
			if (admin.tableExists(tableName)) {
				admin.disableTable(tableName);// 禁用表
				admin.deleteTable(tableName);// 删除表
				System.err.println("删除表成功!");
			} else {
				System.err.println("删除的表不存在！");
			}
			admin.close();
		} catch (MasterNotRunningException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (ZooKeeperConnectionException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	/**
	 * 查询表中所有行
	 * @param tablename
	 */
	public void scaner(String tablename) {
		try {
			HTable table =new HTable(conf, tablename);
			Scan s =new Scan();
			ResultScanner rs = table.getScanner(s);
			for (Result r : rs) {
				KeyValue[] kv = r.raw();
				for (int i =0; i < kv.length; i++) {
					System.out.print(new String(kv[i].getRow()) +"");
					System.out.print(new String(kv[i].getFamily()) +":");
					System.out.print(new String(kv[i].getQualifier()) +"");
					System.out.print(kv[i].getTimestamp() +"");
					System.out.println(new String(kv[i].getValue()));
				}
			}
		} catch (IOException e) {
			e.printStackTrace();
		}
	}


}

 list = new ArrayList();
		put.add("cf".getBytes(), "addr".getBytes(), "shanghai1".getBytes()) ;
		put.add("cf".getBytes(), "age".getBytes(), "30".getBytes()) ;
		put.add("cf".getBytes(), "tel".getBytes(), "13889891818".getBytes()) ;
		list.add(puts) ;
		dao.save(list, "greatgas:test");

//		插入单行数据
		dao.insert("greatgas:test", "testrow", "cf", "age", "35") ;
		dao.insert("greatgas:test", "testrow", "cf", "cardid", "12312312335") ;
		dao.insert("greatgas:test", "testrow", "cf", "tel", "13512312345") ;

		List list2 = dao.getRows("greatgas:test", "testrow",new String[]{"age"}) ;
		for(Result rs : list2)
		{
			for(Cell cell:rs.rawCells()){
				System.out.println("RowName:"+new String(CellUtil.cloneRow(cell))+" ");
				System.out.println("Timetamp:"+cell.getTimestamp()+" ");
				System.out.println("column Family:"+new String(CellUtil.cloneFamily(cell))+" ");
				System.out.println("row Name:"+new String(CellUtil.cloneQualifier(cell))+" ");
				System.out.println("value:"+new String(CellUtil.cloneValue(cell))+" ");
			}
		}

		Result rs = dao.getOneRow("greatgas:test", "testrow");
		System.out.println(new String(rs.getValue("cf".getBytes(), "age".getBytes())));


	}
	@Override
	public void save(Put put, String tableName) {
		// TODO Auto-generated method stub
		HTableInterface table = null;
		try {
			table = hTablePool.getTable(tableName) ;
			table.put(put) ;

		} catch (Exception e) {
			e.printStackTrace() ;
		}finally{
			try {
				table.close() ;
			} catch (IOException e) {
				e.printStackTrace();
			}
		}
	}
	@Override
	public void insert(String tableName, String rowKey, String family,
					   String quailifer, String value) {
		// TODO Auto-generated method stub
		HTableInterface table = null;
		try {
			table = hTablePool.getTable(tableName) ;
			Put put = new Put(rowKey.getBytes());
			put.add(family.getBytes(), quailifer.getBytes(), value.getBytes()) ;
			table.put(put);
		} catch (Exception e) {
			e.printStackTrace();
		}finally
		{
			try {
				table.close() ;
			} catch (IOException e) {
				e.printStackTrace();
			}
		}
	}
	@Override
	public void insert(String tableName,String rowKey,String family,String quailifer[],String value[])
	{
		HTableInterface table = null;
		try {
			table = hTablePool.getTable(tableName) ;
			Put put = new Put(rowKey.getBytes());
			// 批量添加
			for (int i = 0; i < quailifer.length; i++) {
				String col = quailifer[i];
				String val = value[i];
				put.add(family.getBytes(), col.getBytes(), val.getBytes());
			}
			table.put(put);
		} catch (Exception e) {
			e.printStackTrace();
		}finally
		{
			try {
				table.close() ;
			} catch (IOException e) {
				e.printStackTrace();
			}
		}
	}
	@Override
	public void save(List Put, String tableName) {
		// TODO Auto-generated method stub
		HTableInterface table = null;
		try {
			table = hTablePool.getTable(tableName) ;
			table.put(Put) ;
		}
		catch (Exception e) {
			// TODO: handle exception
		}finally
		{
			try {
				table.close() ;
			} catch (IOException e) {
				e.printStackTrace();
			}
		}

	}


	@Override
	public Result getOneRow(String tableName, String rowKey) {
		// TODO Auto-generated method stub
		HTableInterface table = null;
		Result rsResult = null;
		try {
			table = hTablePool.getTable(tableName) ;
			Get get = new Get(rowKey.getBytes()) ;
			rsResult = table.get(get) ;
		} catch (Exception e) {
			e.printStackTrace() ;
		}
		finally
		{
			try {
				table.close() ;
			} catch (IOException e) {
				e.printStackTrace();
			}
		}
		return rsResult;
	}

	@Override
	public List getRows(String tableName, String rowKeyLike) {
		// TODO Auto-generated method stub
		HTableInterface table = null;
		List list = null;
		try {
			table = hTablePool.getTable(tableName) ;
			PrefixFilter filter = new PrefixFilter(rowKeyLike.getBytes());
			Scan scan = new Scan();
			scan.setFilter(filter);
			ResultScanner scanner = table.getScanner(scan) ;
			list = new ArrayList() ;
			for (Result rs : scanner) {
				list.add(rs) ;
			}
		} catch (Exception e) {
			e.printStackTrace() ;
		}
		finally
		{
			try {
				table.close() ;
			} catch (IOException e) {
				e.printStackTrace();
			}
		}
		return list;
	}

	@Override
	public List getRows(String tableName, String rowKeyLike ,String cols[]) {
		// TODO Auto-generated method stub
		HTableInterface table = null;
		List list = null;
		try {
			table = hTablePool.getTable(tableName) ;
			PrefixFilter filter = new PrefixFilter(rowKeyLike.getBytes());
			Scan scan = new Scan();
			for (int i = 0; i < cols.length; i++) {
				scan.addColumn("cf".getBytes(), cols[i].getBytes()) ;
			}
			scan.setFilter(filter);
			ResultScanner scanner = table.getScanner(scan) ;
			list = new ArrayList() ;
			for (Result rs : scanner) {
				list.add(rs) ;
			}
		} catch (Exception e) {
			e.printStackTrace() ;
		}
		finally
		{
			try {
				table.close() ;
			} catch (IOException e) {
				e.printStackTrace();
			}
		}
		return list;
	}
	@Override
	public List getRows(String tableName,String startRow,String stopRow)
	{
		HTableInterface table = null;
		List list = null;
		try {
			table = hTablePool.getTable(tableName) ;
			Scan scan = new Scan() ;
			scan.setStartRow(startRow.getBytes()) ;
			scan.setStopRow(stopRow.getBytes()) ;
			ResultScanner scanner = table.getScanner(scan) ;
			list = new ArrayList() ;
			for (Result rsResult : scanner) {
				list.add(rsResult) ;
			}

		}catch (Exception e) {
			e.printStackTrace() ;
		}
		finally
		{
			try {
				table.close() ;
			} catch (IOException e) {
				e.printStackTrace();
			}
		}
		return list;
	}

	@Override
	public void deleteRecords(String tableName, String rowKeyLike){
		HTableInterface table = null;
		try {
			table = hTablePool.getTable(tableName) ;
			PrefixFilter filter = new PrefixFilter(rowKeyLike.getBytes());
			Scan scan = new Scan();
			scan.setFilter(filter);
			ResultScanner scanner = table.getScanner(scan) ;
			List list = new ArrayList() ;
			for (Result rs : scanner) {
				Delete del = new Delete(rs.getRow());
				list.add(del) ;
			}
			table.delete(list);
		}
		catch (Exception e) {
			e.printStackTrace() ;
		}
		finally
		{
			try {
				table.close() ;
			} catch (IOException e) {
				e.printStackTrace();
			}
		}

	}

	public   void createTable(String tableName, String[] columnFamilys){
		try {
			// admin 对象
			HBaseAdmin admin = new HBaseAdmin(conf);
			if (admin.tableExists(tableName)) {
				System.err.println("此表，已存在！");
			} else {
				HTableDescriptor tableDesc = new HTableDescriptor(
						TableName.valueOf(tableName));

				for (String columnFamily : columnFamilys) {
					tableDesc.addFamily(new HColumnDescriptor(columnFamily));
				}

				admin.createTable(tableDesc);
				System.err.println("建表成功!");

			}
			admin.close();// 关闭释放资源
		} catch (MasterNotRunningException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (ZooKeeperConnectionException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

	}

	/**
	 * 删除一个表
	 *
	 * @param tableName
	 *            删除的表名
	 * */
	public   void deleteTable(String tableName)   {
		try {
			HBaseAdmin admin = new HBaseAdmin(conf);
			if (admin.tableExists(tableName)) {
				admin.disableTable(tableName);// 禁用表
				admin.deleteTable(tableName);// 删除表
				System.err.println("删除表成功!");
			} else {
				System.err.println("删除的表不存在！");
			}
			admin.close();
		} catch (MasterNotRunningException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (ZooKeeperConnectionException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	/**
	 * 查询表中所有行
	 * @param tablename
	 */
	public void scaner(String tablename) {
		try {
			HTable table =new HTable(conf, tablename);
			Scan s =new Scan();
			ResultScanner rs = table.getScanner(s);
			for (Result r : rs) {
				KeyValue[] kv = r.raw();
				for (int i =0; i < kv.length; i++) {
					System.out.print(new String(kv[i].getRow()) +"");
					System.out.print(new String(kv[i].getFamily()) +":");
					System.out.print(new String(kv[i].getQualifier()) +"");
					System.out.print(kv[i].getTimestamp() +"");
					System.out.println(new String(kv[i].getValue()));
				}
			}
		} catch (IOException e) {
			e.printStackTrace();
		}
	}


}

以上代码测试通过，可根据需要修改！

 

手把手玩转HBase的增删改查
Discovery的专栏
08-07 2898
目录 1.进入命令行 2.表的操作 2.1创建表 2.2修改表 2.3删除表 3.数据的操作 3.1插入数据 3.2修改数据 3.3删除数据 3.4查询数据 上一篇文章教会了大家在最小的环境中搭建HBase，能快速体验HBase数据库。今天教会大家所有的增删改查命令，期待通过数据的操纵更好的体验列式存储数据库的魅力。 1.进入命令行 在安装目录的bin目录下输入下面的命令进入命令行： hbase shell 成功进入shell环境会显示下面的信息： HBase Shell
hbase一些小总结（增删改查）
水金的博客
08-13 2381
HBase概述 1）构建在HDFS之上 2) 分布式： 分而治之 3）面向列： HBase特点 1）大 2）面向列：数据构成，列族（多个列） 3）稀疏：null 4）数据类型单一：string 5）无模式: 每行数据所对应的列是可以不同     user: id  name password age info....  在创建表的时候就需要指定的 6）数据多版本     Cell HBase...
hbase的增删改查
zwmonk的博客
11-03 356
package hbase.com.cn.hbase; import java.io.BufferedReader; import java.io.FileReader; import java.util.ArrayList; import java.util.Iterator; import java.util.List; import org.apache.hadoop.conf.Config...
HBase的增删改查
qq_50904598的博客
06-08 1572
一种分布式、可扩展、支持海量数据存储的Nosql数据库。
HBase基础 --- 增删查改
qq_57151931的博客
03-07 1381
HBase增删查改
HBase的shell操作（增删改查）
m0_46657040的博客
10-11 1732
启动HBase [atguigu@hadoop102 hbase]$ bin/start-hbase.sh 关闭HBase [atguigu@hadoop102 hbase]$ bin/stop-hbase.sh 进入 HBase 客户端命令行 [atguigu@hadoop102 hbase]$ bin/hbase shell 查看帮助命令 hbase(main):001:0> help DDL(操作表和命名空间本身的增删改查) DML(操作表内部的增删改查) DDL 表 创..
HBaseHelper Hbase增删改查帮助类
09-02
个人封装的一个Hbase操作帮助类，主要有表的创建、删除、插入、删除、查询（单条件、组合条件查询）等等。写的一般有什么需要改正的地方可留言共同参考
HBASE 常用shell命令，增删改查
热门推荐
csdn问鼎
04-09 2万+
首先给出本次操作的数据 create 'student','info','address' put 'student','1','info:age','20' put 'student','1','info:name','wang' put 'student','1','info:class','1' put 'student','1','address:city','zhengzhou' put
HBase数据库的基本操作增删改查
彭世瑜的博客
12-14 3191
# 进入hbase命令行,hbase需要在环境变量路径中 &gt;hbase shell 表操作 # 显示hbase中的表 &gt; list # 创建user表，包含info、data两个列族 &gt; create 'user', 'info', 'data' # 查看表结构（省略部分信息） &gt; describe 'user' {NAME =&gt; 'data'} {N...
【NoSQL数据库】Hbase基本操作——数据库表的增删改查
最新发布
2201_75539359的博客
12-02 1868
HBase数据库表操作，包括创建和删除表，对表数据进行增加、查询、更新和删除，其中涉及到HBase Shell的操作命令create、count、put、get、scan、delete等。
java调用hbase实现数据库的增删改查
03-20
java调用hbase数据库，完成对hbase常用api的封装和对hbase数据库的增删改查等操作，经测试绝对可用。
Java操作Hbase进行建表、删表以及对数据进行增删改查
05-14
Java操作Hbase进行建表、删表以及对数据进行增删改查，条件查询
hbase 增删改查基本操作
tterminator的专栏
07-04 1378
一、hbase增删改查基本操作package hbasetest;import java.io.IOException; import java.io.InterruptedIOException; import java.util.HashSet; import java.util.Set;import org.apache.hadoop.conf.Configuration; import or
java操作HBase增删改查基础
login_sonata的博客
11-28 1441
完整代码在最后部分，有注释，可以直接跳过去看代码。环境是我之前搭的Hadoop和hbase，详见：分布式HBase安装配置和基础学习，但是他们在虚拟机里，eclipse在win10，所以要在win下添加虚拟机的ip映射（这一步或许不需要，看实际情况），修改C:\Windows\System32\drivers\etc\hosts文件，添加： 10.4.20.49 Master 10.4.20.
Hbase常用操作(增删改查)
weixin_33753003的博客
12-31 231
2019独角兽企业重金招聘Python工程师标准>>> ...
HBase数据库增删改查常用命令操作
weixin_30547797的博客
12-28 320
最近测试用到了Hbase数据库，新建一个学生表，对表进行增删改查操作，把常用命令贴出来分享给大家~ 官方API：https://hbase.apache.org/book.html#quickstart 转载于:https://www.cnblogs.com/xjx767361314/p/10191055.html...
对hbase进行增删改查的操作实例
dsh的博客
12-11 1552
对hbase进行操作
《Hadoop核心技术》Hbase集群部署，创建表，删除表，插入数据，查询数据
litr666的博客
06-25 2114
可以进行随机访问的存取和检索数据的存储平台HBase 是一个开源的、分布式的、版本化的 NoSQL 数据库（也即非关系型数据库），它利用 Hadoop 分布式文件系统（Hadoop Distributed File System，HDFS）提供分布式数据存储。与传统的关系型数据库类似，HBase 也以表的形式组织数据，表也由行和列组成；不同的是，HBase 有列族的概念，它将一列或者多列组织在一起，HBase 的每一个列都必须属于某个列族。
hbase java 实例
seedcup的专栏
12-25 788
发现一HBase实例文章：http://archive.cnblogs.com/a/2178069/ HBase提供了java api来对HBase进行一系列的管理涉及到对表的管理、数据的操作等。常用的API操作有： 1. 对表的创建、删除、显示以及修改等，可以用HBaseAdmin，一旦创建了表，那么可以通过HTable的实例来访问表，每次可以往表里增加数据。 2. 插入数据 创建一个P
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

oo寻梦in记

你的鼓励将是我创作的最大动力!

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值