mongo与Java之aggregate

最新推荐文章于 2024-07-13 02:22:52 发布

打不死的IT小强

最新推荐文章于 2024-07-13 02:22:52 发布

阅读量1.4k

点赞数

分类专栏： mongodb 文章标签： aggregate java mongodb

本文链接：https://blog.csdn.net/hubeilihao/article/details/46489485

版权

mongodb 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

使用aggregate实现分组功能：
–脚本

db.wx_local_group_count_day.aggregate(
{"$match":{"_id.name":{$in:["坂田", "南湾", "平湖", "龙岗", "横岗", "龙城", "坪地", "布吉"]},
            "_id.updateTime":{$gte:"2015-06-01",$lte:"2015-06-10 23:59:59"}
          }
    },
{"$group":{
    "_id":"$_id.updateTime",
    "fssum":{"$sum":"$value.fssum"},
    "xzsum":{"$sum":"$value.xzsum"},
    "bdfssum":{"$sum":"$value.bindsum"}
    }
},
{"$sort":{"_id":-1}}
    );

$match—是查询条件
$group—分组内容其中的Key “_id”是必须的.

Java实现上述脚本

/**
     *  拼接日期查询格式
     * */
    public DBObject  searchTime(String startTime,String endTime){
        DBObject timeC = new BasicDBObject();
        if (StringHelper.isNotNull(startTime)) {
            startTime = startTime;
            timeC.put("$gte", startTime);
        }
        if (StringHelper.isNotNull(endTime)) {
            endTime = endTime + " " + "23:59:59";
            timeC.put("$lte", endTime);
        }
        return timeC;
    }

    DBObject  timeC = searchTime("2015-06-01","2015-06-10");
    List<String> zxs = Arrays.asList(new String[]{"坂田","南湾"...});

    String gsmc = "";


    //aggregate实现分组加排序 
    public List<Map> dayGroup(DBObject timeC,List zxs,String gsmc){
        List list = new ArrayList();
        BasicDBObject in = new BasicDBObject();  //查询条件
        in.append("_id.name", new BasicDBObject("$in", zxs));
        in.append("_id.updateTime", timeC);
        BasicDBObject math = new BasicDBObject();
        math.append("$match",in);

        BasicDBObject groupby = new BasicDBObject();//分组统计
        groupby.append("_id", "$_id.updateTime");
        groupby.append("fssum", new BasicDBObject("$sum", "$value.fssum"));
        groupby.append("xzsum", new BasicDBObject("$sum", "$value.xzsum"));
        groupby.append("bdfssum", new BasicDBObject("$sum", "$value.bindsum"));

        BasicDBObject group = new BasicDBObject();
        group.append("$group", groupby);


        BasicDBObject sort = new BasicDBObject();
        sort.append("$sort", new BasicDBObject("_id", -1));  //按updateTime倒序排
        DBObject obj = (DBObject) groupCountDayDao.groupByAggregate(math, group, sort);

        JSONArray jsonarr = JSONArray.fromObject(obj);//  必须转成JSONArray, 转JSONObject会报错.
        for(int i = 0;i<jsonarr.size();i++){
            JSONObject json = (JSONObject) jsonarr.get(i);
            Map map = new HashMap();
            map.put("updateTime", json.getString("_id"));
            map.put("fssum", json.getInt("fssum"));
            map.put("xzsum", json.getInt("xzsum"));
            map.put("bdfssum", json.getInt("bdfssum"));
            map.put("gsmc",gsmc);
            list.add(map);  
        }

        return list;
    }