最后
码字不易,觉得有帮助的可以帮忙点个赞,让更多有需要的人看到
又是一年求职季,在这里,我为各位准备了一套Java程序员精选高频面试笔试真题,来帮助大家攻下BAT的offer,题目范围从初级的Java基础到高级的分布式架构等等一系列的面试题和答案,用于给大家作为参考
以下是部分内容截图
}
/**
* 关闭所有连接
*
* @throws IOException 可能出现的异常
*/
public static void close() throws IOException {
if (admin != null)
admin.close();
if (conn != null)
conn.close();
}
/**
* 创建表
* @param myTableName 表名
* @param colFamily 列族名的数组
* @throws IOException 可能出现的异常
*/
public static void createTable(String myTableName, String[] colFamily) throws IOException {
TableName tableName = TableName.valueOf(myTableName);
if (admin.tableExists(tableName)) {
logger.info(myTableName + "表已经存在");
} else {
//HTableDescriptor hTableDescriptor = new HTableDescriptor(tableName);
//for (String str : colFamily) {
// HColumnDescriptor hColumnDescriptor = new HColumnDescriptor(str);
// hTableDescriptor.addFamily(hColumnDescriptor);
//}
//admin.createTable(hTableDescriptor);
TableDescriptorBuilder tableDescriptor = TableDescriptorBuilder.newBuilder(tableName);
for (String str : colFamily) {
ColumnFamilyDescriptor columnFamily = ColumnFamilyDescriptorBuilder.newBuilder(Bytes.toBytes(str)).build();// 构建列族对象
tableDescriptor.setColumnFamily(columnFamily); // 设置列族
}
admin.createTable(tableDescriptor.build()); // 创建表
}
}
/**
* 添加数据
* @param tableName 表名
* @param rowkey 行键
* @param colFamily 列族
* @param col 列
* @param value 值
* @throws IOException 可能出现的异常
*/
public static void insertData(String tableName,String rowkey,String colFamily,String col,String value) throws IOException {
Table table = conn.getTable(TableName.valueOf(tableName));
Put put = new Put(rowkey.getBytes());
put.addColumn(colFamily.getBytes(),col.getBytes(),value.getBytes());
table.put(put);
table.close();
}
/**
* 根据行键删除数据
* @param tableName 表名
* @param rowkey 行键
* @throws IOException 可能出现的异常
*/
public static void deleteData(String tableName,String rowkey) throws IOException {
Table table = conn.getTable(TableName.valueOf(tableName));
Delete delete = new Delete(rowkey.getBytes());
table.delete(delete);
table.close();
}
/**
* 获取数据
* @param tableName 表名
* @param rowkey 行键
* @param colFamily 列族
* @param col 列
* @throws IOException 可能出现的异常
*/
public static void getData(String tableName,String rowkey,String colFamily,String col) throws IOException {
Table table = conn.getTable(TableName.valueOf(tableName));
Get get = new Get(rowkey.getBytes());
get.addColumn(colFamily.getBytes(),col.getBytes());
Result result = table.get(get);
System.out.println(new String(result.getValue(colFamily.getBytes(),col.getBytes())));
table.close();
}
public static void main(String[] args) throws IOException {
init();
createTable("student",new String[]{"score"});
insertData("student","zhangsan","score","English","69");
insertData("student","zhangsan","score","Math","86");
insertData("student","zhangsan","score","Computer","77");
getData("student","zhangsan","score","Computer");
close();
}
}
### 3、Hbase过滤器查询
>
> 过滤器可以分为两种:比较过滤器和专用过滤器
>
>
>
**比较过滤器**
>
> **LESS** —— 小于
>
>
> **LESS\_OR\_EQUAL** —— 小于等于
>
>
> **EQUAL** —— 等于
>
>
> **NOT\_EQUAL** —— 不等于
>
>
> **GREATER\_OR\_EQUAL** —— 大于等于
>
>
> **GREATER** —— 大于
>
>
> **NO\_OP** —— 排除所有
>
>
>
**专用过滤器**
>
> **BinaryComparator** —— 匹配完整字节数组,Bytes.compareTo(byte[])
>
>
> **BinaryPrefixComparator** —— 匹配字节数组前缀
> **NullComparator** —— 判断给定的是否为空
> **BitComparator** —— 按位比较
> **RegexStringComparator** —— 提供一个正则的比较器,仅支持 EQUAL 和非EQUAL
> **SubstringComparator** —— 判断提供的子串是否出现在value中
>
>
>
* #### 3.1、ResultScanner结果处理handleResultScanner
/**
- ResultScanner结果解析
*/
public void handleResultScanner(ResultScanner scanner) throws IOException {
//因为ResultScanner类继承了迭代器
//使用增强for循环遍历
for (Result rs : scanner) {
String id = Bytes.toString(rs.getRow());
System.out.println(“当前行的rowkey为:” + id);
//继续增强for循环得到每一行中的每一个单元格(列)
//获取一行中的所有单元格
for (Cell cell : rs.listCells()) {
//获取该单元格属于的列簇
String family = Bytes.toString(CellUtil.cloneFamily(cell));
//获取该单元格的列名
String colName = Bytes.toString(CellUtil.cloneQualifier(cell));
//获取该单元格的列值
String value = Bytes.toString(CellUtil.cloneValue(cell));
System.out.println(family + “:” + colName + “的值为:” + value);
}
String name = Bytes.toString(rs.getValue(“info”.getBytes(), “name”.getBytes()));
String age = Bytes.toString(rs.getValue(“info”.getBytes(), “age”.getBytes()));
String gender = Bytes.toString(rs.getValue(“info”.getBytes(), “gender”.getBytes()));
String clazz = Bytes.toString(rs.getValue(“info”.getBytes(), “clazz”.getBytes()));
System.out.println(“学号:” + id + “,姓名:” + name + “,年龄:” + age + “,性别:” + gender + “,班级:” + clazz);
}
#### 3.2、rowKey过滤器RowFilter
/**
- 行键过滤器
- 通过RowFilter与BinaryComparator过滤比rowKey 1500100010小的所有值出来
*/
@Test
public void RowFilter1(){
try {
//获取表的实例
TableName students = TableName.valueOf(“students”);
Table studentTable = conn.getTable(students);
BinaryComparator binaryComparator = new BinaryComparator(“1500100010”.getBytes());
//创建一个行键过滤器的对象
RowFilter rowFilter = new RowFilter(CompareOperator.LESS, binaryComparator);
Scan scan = new Scan();
scan.setFilter(rowFilter);
ResultScanner scanner = studentTable.getScanner(scan);
handleResultScanner(scanner);
} catch (IOException e) {
e.printStackTrace();
}
}
#### 3.3、列族过滤器FamilyFilter
/**
- 通过FamilyFilter与SubstringComparator查询列簇名包含in的所有列簇下面的数据
*/
@Test
public void FamilyFilter1(){
try {
//获取表的实例
TableName students = TableName.valueOf(“students”);
Table studentTable = conn.getTable(students);
//创建一个比较器对象
//只要列簇名中包含了in,就把该列簇下的所有列查询出来
SubstringComparator substringComparator = new SubstringComparator(“in”);
//创建列簇过滤器
FamilyFilter familyFilter = new FamilyFilter(CompareOperator.EQUAL, substringComparator);
Scan scan = new Scan();
scan.setFilter(familyFilter);
//获取数据
ResultScanner scanner = studentTable.getScanner(scan);
handleResultScanner(scanner);
} catch (IOException e) {
e.printStackTrace();
}
}
/**
- 通过FamilyFilter与 BinaryPrefixComparator 过滤出列簇以i开头的列簇下的所有数据
*/
@Test
public void FamilyFilter2(){
try {
//获取表的实例
TableName students = TableName.valueOf(“students”);
Table studentTable = conn.getTable(students);
//创建前缀比较器
BinaryPrefixComparator binaryPrefixComparator = new BinaryPrefixComparator(“i”.getBytes());
//创建列簇过滤器
FamilyFilter familyFilter = new FamilyFilter(CompareOperator.EQUAL, binaryPrefixComparator);
Scan scan = new Scan();
scan.setFilter(familyFilter);
ResultScanner scanner = studentTable.getScanner(scan);
handleResultScanner(scanner);
} catch (IOException e) {
e.printStackTrace();
}
}
#### 3.4、列过滤器QualifierFilter
/**
- 通过QualifierFilter与SubstringComparator查询列名包含ge的列的值
*/
@Test
public void QualifierFilter1(){
try {
//获取表的实例
TableName students = TableName.valueOf(“students”);
Table studentTable = conn.getTable(students);
//创建包含比较器
//age
//gender
SubstringComparator substringComparator = new SubstringComparator(“ge”);
//创建一个列过滤器
QualifierFilter qualifierFilter = new QualifierFilter(CompareOperator.EQUAL, substringComparator);
Scan scan = new Scan();
scan.setFilter(qualifierFilter);
ResultScanner scanner = studentTable.getScanner(scan);
handleResultScanner(scanner);
} catch (IOException e) {
e.printStackTrace();
}
}
/**
*
- 通过QualifierFilter与SubstringComparator查询列名包含ge的列的值
*/
@Test
public void QualifierFilter2(){
try {
//获取表的实例
TableName students = TableName.valueOf(“students”);
Table studentTable = conn.getTable(students);
SubstringComparator substringComparator = new SubstringComparator(“am”);
//创建列过滤器
QualifierFilter qualifierFilter = new QualifierFilter(CompareOperator.EQUAL, substringComparator);
Scan scan = new Scan();
scan.setFilter(qualifierFilter);
ResultScanner scanner = studentTable.getScanner(scan);
handleResultScanner(scanner);
} catch (IOException e) {
e.printStackTrace();
}
}
#### 3.5、列值过滤器ValueFilter
/**
- 通过ValueFilter与BinaryPrefixComparator过滤出所有的cell中值以 “张” 开头的学生
*/
@Test
public void ValueFilter1() {
try {
//获取表的实例
TableName students = TableName.valueOf(“students”);
Table studentTable = conn.getTable(students);
//创建前缀比较器
BinaryPrefixComparator binaryPrefixComparator = new BinaryPrefixComparator(“张”.getBytes());
//创建列值过滤器的对象
ValueFilter valueFilter = new ValueFilter(CompareOperator.EQUAL, binaryPrefixComparator);
Scan scan = new Scan();
scan.setFilter(valueFilter);
ResultScanner scanner = studentTable.getScanner(scan);
//因为ResultScanner类继承了迭代器
//使用增强for循环遍历
// for (Result rs : scanner) {
// String id = Bytes.toString(rs.getRow());
// System.out.println(“当前行的rowkey为:” + id);
// //继续增强for循环得到每一行中的每一个单元格(列)
// //获取一行中的所有单元格
// for (Cell cell : rs.listCells()) {
// //获取该单元格属于的列簇
// String family = Bytes.toString(CellUtil.cloneFamily(cell));
// //获取该单元格的列名
// String colName = Bytes.toString(CellUtil.cloneQualifier(cell));
// //获取该单元格的列值
// String value = Bytes.toString(CellUtil.cloneValue(cell));
// System.out.println(family + “:” + colName + “的值为:” + value);
// }
// }
handleResultScanner(scanner);
} catch (IOException e) {
e.printStackTrace();
}
}
/**
- 过滤出文科的学生,只会返回以文科开头的数据列,其他列的数据不符合条件,不会返回
/
@Test
public void ValueFilter12(){
try {
//获取表的实例
HTableInterface students = conn.getTable(“students”);
//创建正则比较器
RegexStringComparator regexStringComparator = new RegexStringComparator("^文科.");
//创建列值过滤器
ValueFilter valueFilter = new ValueFilter(CompareFilter.CompareOp.EQUAL, regexStringComparator);
Scan scan = new Scan();
scan.setFilter(valueFilter);
ResultScanner scanner = students.getScanner(scan);
handleResultScanner(scanner);
} catch (IOException e) {
e.printStackTrace();
}
}
#### 3.6、单列值过滤器 SingleColumnValueFilter
/**
- 单列值过滤器
- SingleColumnValueFilter会返回满足条件的cell所在行的所有cell的值(即会返回一行数据)
- 通过SingleColumnValueFilter与查询文科班所有学生信息
/
@Test
public void SingleColumnValueFilter(){
try {
//获取表的实例
TableName students = TableName.valueOf(“students”);
Table studentTable = conn.getTable(students);
//创建一个正则比较器
RegexStringComparator regexStringComparator = new RegexStringComparator("^文科.");
//创建单列值过滤器对象
SingleColumnValueFilter singleColumnValueFilter = new SingleColumnValueFilter(
“info”.getBytes(),
“clazz”.getBytes(),
CompareOperator.EQUAL,
regexStringComparator
);
Scan scan = new Scan();
scan.setFilter(singleColumnValueFilter);
ResultScanner scanner = studentTable.getScanner(scan);
handleResultScanner(scanner);
} catch (IOException e) {
e.printStackTrace();
}
}
#### 3.7、列值排除过滤器SingleColumnValueExcludeFilter
/**
- 列值排除过滤器
- 与SingleColumnValueFilter相反,会排除掉指定的列,其他的列全部返回
- 通过SingleColumnValueExcludeFilter与BinaryComparator查询文科一班所有学生信息,最终不返回clazz列
*/
@Test
public void SingleColumnValueExcludeFilter(){
try {
//获取表的实例
TableName students = TableName.valueOf(“students”);
Table studentTable = conn.getTable(students);
//创建一个二进制比较器
BinaryComparator binaryComparator = new BinaryComparator(“文科一班”.getBytes());
//创建一个列值排除过滤器
SingleColumnValueExcludeFilter singleColumnValueExcludeFilter = new SingleColumnValueExcludeFilter(
“info”.getBytes(),
“clazz”.getBytes(),
CompareOperator.EQUAL,
binaryComparator
);
Scan scan = new Scan();
scan.setFilter(singleColumnValueExcludeFilter);
ResultScanner scanner = studentTable.getScanner(scan);
handleResultScanner(scanner);
分享
首先分享一份学习大纲,内容较多,涵盖了互联网行业所有的流行以及核心技术,以截图形式分享:
(亿级流量性能调优实战+一线大厂分布式实战+架构师筑基必备技能+设计思想开源框架解读+性能直线提升架构技术+高效存储让项目性能起飞+分布式扩展到微服务架构…实在是太多了)
其次分享一些技术知识,以截图形式分享一部分:
Tomcat架构解析:
算法训练+高分宝典:
Spring Cloud+Docker微服务实战:
最后分享一波面试资料:
切莫死记硬背,小心面试官直接让你出门右拐
1000道互联网Java面试题:
Java高级架构面试知识整理:
…(img-4D9ZNcND-1715637856128)]
算法训练+高分宝典:
[外链图片转存中…(img-8sdP8hAo-1715637856128)]
Spring Cloud+Docker微服务实战:
[外链图片转存中…(img-c67bLH4F-1715637856128)]
最后分享一波面试资料:
切莫死记硬背,小心面试官直接让你出门右拐
1000道互联网Java面试题:
[外链图片转存中…(img-y0KZgMpP-1715637856129)]
Java高级架构面试知识整理:
[外链图片转存中…(img-rwIAEoNl-1715637856129)]