mongo 条件查询实例

最新推荐文章于 2024-07-25 11:44:23 发布

killppyou

最新推荐文章于 2024-07-25 11:44:23 发布

阅读量166

点赞数

本文链接：https://blog.csdn.net/killppyou/article/details/85795731

版权

public JSONObject getAgeDistribution(Map<String, Object> paramMap) {
    try{
        //查询到的数据必须是执行成功的status的值取0和1
        BasicDBList condList = new BasicDBList();
        condList.add(new BasicDBObject("status", "1"));
        condList.add(new BasicDBObject("status", "0"));
        BasicDBObject dbObject = new BasicDBObject();
        dbObject.put("$or", condList);


        //按时间段取值
        if(paramMap.get("start") !=null && paramMap.get("end") !=null){
            dbObject.append("createTime",
                    new BasicDBObject().append(QueryOperators.GTE, paramMap.get("start")).append(QueryOperators.LTE, paramMap.get("end")));
        }

        //指定返回的字段
        BasicDBObject fieldsObject = new BasicDBObject();
        fieldsObject.put("quota", true);
        fieldsObject.put("status", true);
        fieldsObject.put("requestParams", true);

        Query query = new BasicQuery(dbObject, fieldsObject);
        List<RiskModelRecord> riskModelRecordList = mongoTemplate.find(query, RiskModelRecord.class);