MongoTemplate实现分页查询，模糊匹配

public Paging<HelpDocCategoryDto> queryHelpDocList(HelpDocListQuery query) {
    try {
        logger.error("查询帮助文档列表入参 ：【{}】",JSONObject.toJSONString(query));
        Paging<HelpDocCategoryDto> paging = new Paging<>();
        if (null != query.getPage() && null != query.getPageSize()) {
            paging.setPage(query.getPage());
            paging.setPageSize(query.getPageSize());
        }
        Integer page = query.getPage();
        Integer pageSize = query.getPageSize();
        List<AggregationOperation> operations = new ArrayList<>();
        if (null != query.getKeyword()) {
            Pattern pattern = Pattern.compile("^.*" + query.getKeyword() + ".*$", Pattern.CASE_INSENSITIVE);
            Criteria criteria = Criteria.where("title").regex(pattern);
            operations.add(Aggregation.match(criteria));
        }
        if (null != query.getApp()) {
            operations.add(Aggregation.match(Criteria.where("app").is(query.getApp())));
        }
        if (null != query.getCategoryCode()) {
            operations.add(Aggregation.match(Criteria.where("categoryCode").is(query.getCategoryCode())));
        }
        long totalCount = 0;
        //获取满足添加的总页数
        if (null != operations && operations.size() > 0) {
            Aggregation aggregationCount = Aggregation.newAggregation(operations);
            AggregationResults<HelpDocCategoryDto> resultsCount = template.aggregate(aggregationCount, "help_doc", HelpDocCategoryDto.class);
            totalCount = resultsCount.getMappedResults().size();
        } else {
            List<HelpDoc> list = template.findAll(HelpDoc.class);
            totalCount = list.size();
        }
        operations.add(Aggregation.skip((long) (page - 1) * pageSize));
        operations.add(Aggregation.limit(pageSize));
        operations.add(Aggregation.lookup("doc_category", "categoryCode", "code", "category"));
        operations.add(Aggregation.sort(Sort.Direction.DESC, "solveCount"));
        Aggregation aggregation = Aggregation.newAggregation(operations);
        AggregationResults<HelpDocCategoryDto> results = template.aggregate(aggregation, "help_doc", HelpDocCategoryDto.class);

        paging.setData(results.getMappedResults());
        paging.setTotalCount(totalCount);
        return paging;
    } catch (HelpException e) {
        logger.error("查询帮助文档列表异常 --  ErrCode：[{}]，ErrMessage：[{}]", e.getErrCode(), e.getErrMessage());
        throw e;
    } catch (Exception e) {
        throw e;
    }
}

@Getter
@Setter
public class Paging<T> implements Serializable {

    /**
     * 当前页数
     */
    private int page = 1;

    /**
     * 每页条数
     * 此参数为0时，不分页
     */
    private int pageSize = 20;

    /**
     * 总条数
     */
    private long totalCount;

    /**
     * 数据
     */
    private List<T> data;

    public void setPageSize(int pageSize) {
        if (0 < pageSize) {
            this.pageSize = pageSize;
        } else {
            this.pageSize = 20;
        }
    }

    /**
     * 指定 page 页数据的起始条目数
     *
     * @return
     */
    public int calculateSkip() {
        return (page - 1) * pageSize;
    }

}

@Getter
@Setter
public class HelpDocCategoryDto {

    boolean isTop;

    boolean isCategoryTop;

    String code;

    int app;

    int solveCount;

    int unSolveCount;

    String categoryCode;

    DocCategory category;

    String title;

    String staticHtmlPath;

    String content;

    Date createTime;

    Date updateTime;

}

@Getter
@Setter
public class HelpDocListQuery implements Serializable {

    private Integer page = 1;

    private Integer pageSize = 20;

    /**
     * 匹配标题
     */
    private String keyword;

    /**
     * 客户端：1 医生端 2 患者端
     */
    private Integer app;

    /**
     * 分类code
     */
    private String categoryCode;
}

转载于:https://www.cnblogs.com/sunjianhong-java/p/8087336.html