DBCollection lists = MongoDBUtil.getCollection(MONGODB_TABLE_SHARE_ORDER_COMMENT);// 查询所有记录
//分组字段
DBObject key = new BasicDBObject();
key.put("shareOrderId", true);
//查询条件
QueryBuilder queryBuilder = new QueryBuilder();
queryBuilder.and("shareOrderId").in(commentIdList);
queryBuilder.and("commentStatus").is(status);
DBObject condition = queryBuilder.get();
//分组统计初始变量,为空时自动为每列提供初始变量
DBObject initial = new BasicDBObject();
DBObject index = new BasicDBObject();
/*index.put("commentNum", 0);
index.put("shareOrderId", "");
initial.put("commentGroup", index);*/
initial.put("count", 0);
//记录处理function
String reduce = "function (doc, out) { "
+ " out.count = out.count += 1; "
+ "}";
BasicDBList resultList = (BasicDBList) lists.group(key, condition, initial, reduce);
if (resultList != null) {
for (int i = 0; i < resultList.size(); i++) {
DBObject obj = (DBObject) resultList.get(i);
Object commentId = obj.get("shareOrderId");
Object commentNum = obj.get("count");
}
}
转载于:https://my.oschina.net/u/2616867/blog/916227