Java整合MongoDB分组查询
在网上看了很久的资料,最后在这个帖子里实现了功能,比起其他的帖子通俗易懂
链接:https://blog.csdn.net/qq_41012810/article/details/97260673
下面是我修改后的代码:
只需要指定要分组的字段,由于我是要取所有数据进行分组,就将所有条件都删除了,就留了个获取分组数量的条件
代码贴一下
private List<Map<String, Object>> getTypeCountAndData(){
List<Map<String, Object>> list = new ArrayList<>();
Map<String, Object> map = null;
String[] field = {"typeId","type"}; //分组的依据,根据那些参数进行分组
Aggregation aggregation1 = Aggregation.newAggregation(
Aggregation.group(field).count().as("count") //分组中的数量 ,as 起别名
);
//执行
AggregationResults<BasicDBObject> outputTypeCount1 = template.aggregate(aggregation1, "alarm", BasicDBObject.class);
//迭代器进行迭代
for (Iterator<BasicDBObject> iterator = outputTypeCount1.iterator(); iterator.hasNext(); ) {
map = new HashMap<>();
DBObject obj = iterator.next();
// 拿出自己所需要的值
String type = obj.get("type").toString();
String count = obj.get("count").toString();
String typeId = obj.get("typeId").toString();
map.put("type", type);
map.put("count", count);
map.put("typeId", typeId);
list.add(map);
}
return list;
}
又是有收获的一天