总结一下最近参与项目学到的知识,不知道自己会不会坚持写Blog(;´д`)
总之先从ES基本操作开始了!
目录
AND查询
List<StudentVO> searchMustStudent(StudentQO studentQO) throws IOException;
public List<StudentVO> searchMustStudent(StudentQO studentQO) throws IOException {
//设置返回参数
SearchSourceBuilder sourceBuilder = new SearchSourceBuilder();
//SELECT name, gender, age
sourceBuilder.fetchSource(new String[]{"name", "gender", "age"}, null);
//FROM student
SearchRequest searchRequest = new SearchRequest("student");
//设置查询条件
BoolQueryBuilder mustQueryBuilder = QueryBuilders.boolQuery();
//精确查询 WHERE id = studentQO.getId()
mustQueryBuilder.must(QueryBuilders.termQuery("id", studentQO.getId()));
/*
//模糊查询 WHERE id like '123%'
mustQueryBuilder.must(QueryBuilders.wildcardQuery("id", "123*"));
*/
//AND name != ""
mustQueryBuilder.mustNot(QueryBuilders.termQuery("name", ""));
/*
另一种方法:mustQueryBuilder.must(QueryBuilders.existsQuery("name&