JAVA高级查询是怎么实现的_关于mongoDB使用java实现高级查询query参数的组装

import org.springframework.data.mongodb.core.query.Criteria;

import org.springframework.data.mongodb.core.query.Query;

模糊查询：regex or：orOperator

$gt:大于

$lt:小于

$gte:大于或等于

$lte:小于或等于

Sort：排序Query query = new Query();

query.addCriteria(Criteria.where("orgId").is(queryShopActionLogReqVO.getOrgId()));

query.addCriteria(Criteria.where("logType").is(queryShopActionLogReqVO.getLogType()));

Criteria criteriaDay = null;

if(!StringUtils.isEmpty(queryShopActionLogReqVO.getStartTime())) {

criteriaDay = Criteria.where("loginTime").gte(queryShopActionLogReqVO.getStartTime());

}

if(!StringUtils.isEmpty(queryShopActionLogReqVO.getEndTime())) {

if(criteriaDay == null){

criteriaDay = Criteria.where("loginTime").lte(queryShopActionLogReqVO.getEndTime());

}else{

criteriaDay.lte(queryShopActionLogReqVO.getEndTime());

}

}

if(criteriaDay != null){

query.addCriteria(criteriaDay);

}

if(!StringUtils.isEmpty(queryShopActionLogReqVO.getKeyWord())) {

query.addCriteria(new Criteria ().orOperator(Criteria.where("userCode").regex(queryShopActionLogReqVO.getKeyWord())

,Criteria.where("userName").regex(queryShopActionLogReqVO.getKeyWord())

,Criteria.where("account").regex(queryShopActionLogReqVO.getKeyWord())));

}

query.with(new Sort(Sort.Direction.DESC, "loginTime"));

return query;