Query query = new Query();
//精确查询
Criteria criteriaAdvert = Criteria.where(“body.advertName”).is(advertName);
Criteria criteriaProductCompany = Criteria.where(“body.productCompanyName”).is(productCompanyName);
//模糊查询
Criteria criteriaCompany = Criteria.where(“companyName”).regex(this.pattern(companyName));
query.addCriteria(criteriaAdvert);
query.addCriteria(criteriaProductCompany);
query.addCriteria(criteriaCompany);
//根据创建时间倒序排列
query.with(Sort.by(new Sort.Order(Sort.Direction.DESC, “createdDate”)))
//先按照点击次数倒序排,然后再按照浏览时长倒序排
SortOperation sortOperation = Aggregation.sort(Sort.by(new Sort.Order(Sort.Direction.DESC, “clickCount”),new Sort.Order(Sort.Direction.DESC, “stopTime”)));
//从第几条数据开始分页
query.skip((pointQuery.getPage() - 1) * pointQuery.getPageSize());
//每页多少条数据
query.limit(pointQuery.getPageSize());
//根据条件查询数据,返回list
List poLists = mongoTemplate.find(query, TestPointPo.class);
//模糊查询
public Pattern pattern(String info){
String regex = String.format("%s%s","^.", info, ".$");
Pattern pattern = Pattern.compile(regex, Pattern.CASE_INSENSITIVE);
return pattern;
}
projectionOperation = Aggregation.project(“currentPageName”,“clickCount”, “stopTime”, “body”);
groupOperation = Aggregation.group(“body.name1”, “body.name2”, “name3”, “body.name4”) .sum(“stopTime”).as(“stopTime”).sum(“clickCount”).as(“clickCount”)
.first(“body.name1”).as(“realName”)
.first(“body.name2”).as(“companyName”)
.first(“name3”).as(“currentPageName”)
.first(“body.name4”).as(“eventId”);
//这两个是当代码中的数据类型与数据库中存储的数据类型不一样的时候可以通过这个方法进行数据类型的转换
ConvertOperators.ToDate
Convert.toInt()//MongoDB代码中是字符串与数据库中int类型对比