Hbase通过SingleColumnValueFilter进行值查询

public class Demo5 {
	public static Configuration conf = HBaseConfiguration.create();
	static {
		Configuration HBASE_CONFIG = new Configuration();

		HBASE_CONFIG.set("hbase.zookeeper.quorum",
				"BJ-YZ-103R-63-38,BJ-YZ-103R-63-39,BJ-YZ-103R-63-40");
		HBASE_CONFIG.set("hbase.zookeeper.property.clientPort", "2181");
		conf = HBaseConfiguration.create(HBASE_CONFIG);
	}
	public static void QueryByCondition3(String tableName,String  v1,String v2) {  
		        try {  
		            HTablePool pool = new HTablePool(conf, 1000);  
		            HTableInterface table = pool.getTable(tableName);  
		           List<Filter> filters = new ArrayList<Filter>();  
		           Filter filter1 = new SingleColumnValueFilter(Bytes.toBytes("c1"), Bytes.toBytes("city"), CompareOp.EQUAL, Bytes.toBytes(v1));  
		           filters.add(filter1);  
		           Filter filter2 = new SingleColumnValueFilter(Bytes.toBytes("c1"), Bytes.toBytes("sex"), CompareOp.EQUAL, Bytes.toBytes(v2));  
		            filters.add(filter2);  
                FilterList filterList1 = new FilterList(filters);  
		            Scan scan = new Scan();  
		            scan.setFilter(filterList1);  
		            ResultScanner rs = table.getScanner(scan);  
		           for (Result r : rs) {  
	               System.out.println("获得到rowkey:" + new String(r.getRow()));  
		               for (KeyValue keyValue : r.raw()) {  
		                    System.out.println("列：" + new String(keyValue.getFamily())  
		                            + "====值:" + new String(keyValue.getValue()));  
		               }  
		            }  
		           rs.close();  
		 
		       } catch (Exception e) {  
		            e.printStackTrace();  
		        }  
		  
		    }  
	public static void main(String[] args) throws IOException {
		Demo5.QueryByCondition3("test1","hangzhou","nan");
	}

}