SpringData mongodb指定查询字段、分页查询、模糊查询及排序

话不多说，直接上代码：

Query query = new Query();
query.fields().include("_id").include("typeCode").include("nameDesc").include("ipVal").include("enblFlag");//指定查询字段
query.skip((pageNo - 1) * pageSize);//便宜记录数
query.limit(pageSize);//每页记录数
query.with(Sort.by("nameDesc"));//指定排序字段，默认升序
if (!StringUtils.isEmpty(equipmentInfo.getNameDesc())) {
    Pattern pattern = Pattern.compile("^.*" + escapeExprSpecialWord(equipmentInfo.getNameDesc().trim()) + ".*$", Pattern.CASE_INSENSITIVE);
    query.addCriteria(Criteria.where("nameDesc").regex(pattern));//模糊查询
}

/**
  * 转义字符串中与正则表达式相关的特殊字符
  */
public String escapeExprSpecialWord(String keyword) {
        String[] fbsArr = { "\\", "$", "(", ")", "*", "+", ".", "[", "]", "?", "^", "{", "}", "|" };
        for (String key : fbsArr) {
            if (keyword.contains(key)) {
                keyword = keyword.replace(key, "\\" + key);
            }
        }
        return keyword;
    }

也可以使用一下代码设置排序方式：

query.with(Sort.by(Sort.Direction.ASC, "nameDesc"));
//或
query.with(Sort.by(Sort.Direction.DESC, "nameDesc"));