在网上搜了好多,但都不是我想要得那种,不是直接传参就可以
Criteria cr = Criteria.where("prizeWinDay").gte(startDay).lte(endDay).and("orgCode").in(SonOrgCode);
这块是添加 where 条件 ,某个值大于并且小于多少则直接点,不要再加and;如果想增加条件则一直加and
GroupBy groupBy = GroupBy.key("prizeoptionId","userName").initialDocument("{count:0}").reduceFunction("function(doc, out){out.count++}") .finalizeFunction("function(out){return out;}");
这个方法是进行分组,key里面得字符串可以多个字段名;后面得值得意义可以参考:https://www.cnblogs.com/liangblog/p/5872243.html
GroupByResults<IntegrationPrizewinrecordDB> res = mongoTemplate.group(cr,"integrationPrizewinrecordDB", groupBy, IntegrationPrizewinrecordDB.class);
执行sql;第一个参数为where 条件,第二个参数为表明,第三个为需要分组得值,第四个条件为表对应得实体类;
DBObject obj = res.getRawResults();
BasicDBList dbList = (BasicDBList) obj.get("retval");
for(int i=0;i<dbList.size();i++) {
IntegrationPrizewinrecord integ = new IntegrationPrizewinrecord();
DBObject objc = (DBObject) dbList.get(i);
System.out.println(dbList.get(i));
Object age = objc.get("prizeoptionId");
Object count = objc.get("count");
}
这个是遍历返回得条件,里面可以get到对应得key得值