Query query = new Query();
query.addCriteria(Criteria.where("status").ne(ZxqlConst.CONST_COMMON_QYY_STATUS_DEL));
query.addCriteria(Criteria.where("useType").is(ZxqlConst.CONST_ZX_SYS_INDUSTRY_USETYPE_INDUSTRY));
if (params.containsKey("industryNo")) {
String industryNo = (String)params.get("industryNo");
if(StringUtils.isNotBlank(industryNo)) {
Pattern pattern= Pattern.compile("^.*"+industryNo+".*$", Pattern.CASE_INSENSITIVE);
query.addCriteria(Criteria.where("industryNo").regex(pattern));
}
}
if (params.containsKey("industryName")) {
String industryName = (String)params.get("industryName");
if(StringUtils.isNotBlank(industryName)) {
Pattern pattern= Pattern.compile("^.*"+industryName+".*$", Pattern.CASE_INSENSITIVE);
query.addCriteria(Criteria.where("industryName").regex(pattern));
}
}
if (params.containsKey("sort")) {
String sort = (String)params.get("sort");
String order = (String)params.get("order");
if ("desc".equals(order)) {
query.with(Sort.by(Sort.Order.desc(sort)));
} else {
query.with(Sort.by(Sort.Order.asc(sort)));
}
} else {
query.with(Sort.by(Sort.Order.desc("lastTime")));
}
PageResult<ZxSysIndustry> pageResult = mongoPageHelper.pageQuery(query, ZxSysIndustry.class, pageSize, pageNum);
return pageResult;
mongodb分页
最新推荐文章于 2024-05-16 12:00:00 发布