TIPS：本文實現(xiàn)類似數(shù)據(jù)庫后臺管理系統(tǒng)的多條件分頁查詢。文章來源地址http://www.zghlxwxcb.cn/news/detail-509677.html

package com.test.impl;

/**
 * TestIndex實現(xiàn)類impl，實現(xiàn)多條件分頁查詢
 */
@Service
public class TestIndexServiceImpl implements TestIndexService {

    private static final Logger LOGGER = LoggerFactory.getLogger(TestIndexServiceImpl.class);

    @Autowired
    private ElasticsearchRestTemplate elasticsearchRestTemplate;

	//TestIndexListQuery query為條件查詢對象，封裝了一些需要查詢的字段
    @Override
    public Page<TestIndex> list(TestIndexListQuery query) {
        Integer pageNum = query.getPageNum();
        Integer pageSize = query.getPageSize();

        //組裝查詢條件 must類似and匹配到所有字段后進(jìn)行組合查詢
        BoolQueryBuilder queryBuilder = QueryBuilders.boolQuery();
        if(StringUtils.isNotBlank(query.getItem_id())){
            queryBuilder.must(termQuery("item_id", query.getItem_id()));
        }
        if(StringUtils.isNotBlank(query.getItem_name())){
            //類似like的操作，針對不能分詞的字段進(jìn)行模糊查詢，數(shù)據(jù)量大不推薦，性能不友好
            queryBuilder.must(wildcardQuery("item_name", "*"+query.getItem_name()+"*"));
        }
        if(StringUtils.isNotBlank(query.getArea_code())){
            queryBuilder.must(termQuery("area_code", query.getArea_code()));
        }
        if(StringUtils.isNotBlank(query.getUser_name())){
            queryBuilder.must(QueryBuilders.wildcardQuery("user_name", "*"+query.getUser_name()+"*"));
        }
        if(StringUtils.isNotBlank(query.getPhone())){
            queryBuilder.must(termQuery("phone", query.getPhone()));
        }
        if (Objects.nonNull(query.getStartTime())) {
            queryBuilder.must(QueryBuilders.rangeQuery("createdatetime").gte(query.getStartTime()));
        }
        if (Objects.nonNull(query.getEndTime())) {
            queryBuilder.must(QueryBuilders.rangeQuery("createdatetime").lte(query.getEndTime()));
        }

        NativeSearchQuery build = new NativeSearchQueryBuilder()
                .withQuery(queryBuilder)
                .withPageable(PageRequest.of(pageNum, pageSize))
                .withHighlightFields(//字段高亮設(shè)值
                        new HighlightBuilder.Field("seek_title").preTags("<em>").postTags("</em>")
//                        new HighlightBuilder.Field("seek_title").preTags("<span style='color:blue'>").postTags("</span>")
                )
                .build();
        LOGGER.info("列表查詢的語句：{}", build.getQuery().toString());

        SearchHits<Seek> search = elasticsearchRestTemplate.search(build, Seek.class);
        SearchPage<Seek> page = SearchHitSupport.searchPageFor(search, build.getPageable());

        //高亮結(jié)果集，也可以用page.getHighlightFields()獲取
        List<Seek> list = new ArrayList<>();
        for (SearchHit<Seek> each : page) {
            Seek vo = each.getContent();
            //高亮設(shè)值
            if (each.getHighlightFields().get("seek_title") != null) {
                vo.setSeek_title(each.getHighlightFields().get("seek_title").get(0));
            }
            list.add(vo);
        }
        //組裝分頁對象
        Page<Seek> pageInfo = new PageImpl<>(list, build.getPageable(), search.getTotalHits());
//        PageImpl<Seek> pageInfo = new PageImpl<Seek>(list, build.getPageable(), search.getTotalHits());
        return pageInfo;
    }

}

到了這里，關(guān)于ES簡單教程（四）使用ElasticsearchRestTemplate多條件分頁查詢（復(fù)雜版）的文章就介紹完了。如果您還想了解更多內(nèi)容，請在右上角搜索TOY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！