public void testFindUserByIds(){
List<String> arrayList = new ArrayList<>();
arrayList.add(1+"");
arrayList.add(3+"");
arrayList.add(4+"");
arrayList.add(5+"");
arrayList.add(6+"");
arrayList.add(7+"");
arrayList.add(8+"");
arrayList.add(9+"");
Criteria criteria = Criteria.where("_id").in(arrayList);
GroupOperation group1 = Aggregation.group("name").count().as("count");
Aggregation aggregation1 = Aggregation.newAggregation(
Aggregation.match(criteria), // 只选择年龄大于18的文档
Aggregation.group("age").count().as("count")
);
AggregationResults<Document> result = mongoTemplate.aggregate(aggregation1, "user", Document.class);
List<Document> ageCounts = result.getMappedResults();
Aggregation aggregation2 = Aggregation.newAggregation(
Aggregation.match(criteria), // 只选择年龄大于18的文档
Aggregation.group("name").count().as("count")
);
AggregationResults<Document> result1 = mongoTemplate.aggregate(aggregation2, "user", Document.class);
List<Document> ageCounts2 = result1.getMappedResults();
System.out.println(ageCounts);
System.out.println(ageCounts2);
}
mongo聚合
最新推荐文章于 2024-07-20 23:55:03 发布