MongoDB的聚合查询

Java代码

1. MongoClient mongoClient = null;
2. try {
3. mongoClient = new MongoClient("102.198.119.29", 27017);
4. DB db = mongoClient.getDB("syslog");
5. //设置Where条件
6. DBObject match = new BasicDBObject("$match", new BasicDBObject(
7. "DATE",
8. (new BasicDBObject("$gt", "2012-11-28 00:19:00")).append(
9. "$lt", "2012-11-29 09:19:00")));
10. //设置分组字段
11. BasicDBObject groupFilters = new BasicDBObject("_id", "$PRIORITY");
12. //对分组字段统计行数
13. groupFilters.put("count", new BasicDBObject("$sum", 1));
14. BasicDBObject group = new BasicDBObject("$group", groupFilters);
15. //设置显示的字段集合
16. DBObject fields = new BasicDBObject("PRIORITY", 1);
17. fields.put("_id", "$PRIORITY");
18. DBObject project = new BasicDBObject("$project", fields);
19. AggregationOutput output = db.getCollection("messages").aggregate(
20. match, project, group);
21. System.out.println(output.getCommandResult());
22. } catch (UnknownHostException e) {
23. e.printStackTrace();
24. }