java 中 mongodb的各种操作

来源：互联网发布：netflix prize 数据集编辑：程序博客网时间：2024/05/22 14:34

一. 常用查询:

1. 查询一条数据:(多用于保存时判断db中是否已有当前数据,这里 is 精确匹配,模糊匹配使用 regex...)

public PageUrl getByUrl(String url) {        return findOne(new Query(Criteria.where("url").is(url)),PageUrl.class);    }

2. 查询多条数据:linkUrl.id 属于分级查询

public List<PageUrl> getPageUrlsByUrl(int begin, int end,String linkUrlid) {                Query query = new Query();        query.addCriteria(Criteria.where("linkUrl.id").is(linkUrlid));        return find(query.limit(end - begin).skip(begin), PageUrl.class);            }

3. 模糊查询:

public long getProcessLandLogsCount(List<Condition> conditions)
    {
        Query query = new Query();
        if (conditions != null && conditions.size() > 0) {
            for (Condition condition : conditions) {
                query.addCriteria(Criteria.where(condition.getKey()).regex(".*?\\" +condition.getValue().toString()+ ".*"));
            }
        }
        return count(query, ProcessLandLog.class);
    }

模糊查询之二: 这里的查询会区分大小写

public List<PrivateWord> getKeywords(PrivateWord privateWord) {
Query query = new Query();
query.addCriteria(Criteria.where("createdBy").is(privateWord.getCreatedBy()));
if (StringUtils.isNotEmpty(privateWord.getKeyword())) {
query.addCriteria(new Criteria("keyword").regex(".*" + privateWord.getKeyword().trim() + ".*"));
}
if (StringUtils.isNotEmpty(privateWord.getSource())) {
query.addCriteria(new Criteria("source").is(privateWord.getSource()));
}
return super.queryList(query, privateWord);
}

如果忽略大小写的话：keywordArr为查询条件的字符串数组
List<PrivateWord> privateWords = privateWordService.getAll(user.getId(), groupName);
List<PrivateWord> tmpWords = new ArrayList<>();
for (PrivateWord pw : privateWords) {
String tmpKeyword = pw.getKeyword().trim();
boolean show = false;
if (keywordArr != null && keywordArr.length > 0) {
for (int i = 0; i < keywordArr.length; i++) {
if (tmpKeyword.toLowerCase().contains(keywordArr[i].toLowerCase())) {
show = true;
break;
}
}
if (!show){
continue;
}
}
tmpWords.add(pw);
}

4. gte: 大于等于,lte小于等于...注意查询的时候各个字段的类型要和mongodb中数据类型一致

public List<ProcessLandLog> getProcessLandLogs(int begin,int end,List<Condition> conditions,String orderField,Direction direction)
    {
        Query query = new Query();
        if (conditions != null && conditions.size() > 0) {
            for (Condition condition : conditions) {
                if(condition.getKey().equals("time")){
                    query.addCriteria(Criteria.where("time").gte(condition.getValue())); //gte: 大于等于
                }else if(condition.getKey().equals("insertTime")){
                    query.addCriteria(Criteria.where("insertTime").gte(condition.getValue()));
                }else{
                    query.addCriteria(Criteria.where(condition.getKey()).is(condition.getValue()));
                }
            }
        }
        return find(query.limit(end - begin).skip(begin).with(new Sort(new Sort.Order(direction, orderField))), ProcessLandLog.class);
    }

public List<DpsLand> getDpsLandsByTime(int begin, int end, Date beginDate,Date endDate) {
return find(new Query(Criteria.where("updateTime").gte(beginDate).lte(endDate)).limit(end - begin).skip(begin),
    DpsLand.class);
}

查询字段不存在的数据

public List<GoodsDetail> getGoodsDetails2(int begin, int end) {        Query query = new Query();        query.addCriteria(Criteria.where("goodsSummary").not());        return find(query.limit(end - begin).skip(begin),GoodsDetail.class);    }

5. 查询数量:

public long getPageInfosCount(List<Condition> conditions) {        Query query = new Query();        if (conditions != null && conditions.size() > 0) {            for (Condition condition : conditions) {                query.addCriteria(Criteria.where(condition.getKey()).is(condition.getValue()));            }        }        return count(query, PageInfo.class);    }

6. 更新一条数据的一个字段:

public WriteResult updateTime(PageUrl pageUrl) {        String id = pageUrl.getId();        return updateFirst(new Query(Criteria.where("id").is(id)),Update.update("updateTime", pageUrl.getUpdateTime()), PageUrl.class);    }

7. 更新一条数据的多个字段:

//调用更新private void updateProcessLandLog(ProcessLandLog processLandLog,            int crawlResult) {        List<String> fields = new ArrayList<String>();        List<Object> values = new ArrayList<Object>();        fields.add("state");        fields.add("result");        fields.add("time");        values.add("1");        values.add(crawlResult);        values.add(Calendar.getInstance().getTime());        processLandLogReposity.updateProcessLandLog(processLandLog, fields,                values);    }//更新public void updateProcessLandLog(ProcessLandLog land, List<String> fields,List<Object> values) {        Update update = new Update();        int size = fields.size();        for(int i = 0 ; i < size; i++){            String field = fields.get(i);            Object value = values.get(i);            update.set(field, value);        }        updateFirst(new Query(Criteria.where("id").is(land.getId())), update,ProcessLandLog.class);    }

7-1、根据条件更新数据：

public ResultObj updateWords(Word word) {        ResultObj resultObj = new ResultObj();        Query query = new Query();        query.addCriteria(new Criteria("createdBy").is(word.getCreatedBy()));        query.addCriteria(new Criteria("keyword").is(word.getKeyword()));        Update update = new Update();        update.set("updatedTime", new Date());        if (word.getSrhPv() != null) {            update.set("srhPv", word.getSrhPv());        }        if (word.getCompanyCnt() != null) {            update.set("companyCnt", word.getCompanyCnt());        }        if (word.getShowwinCnt() != null) {            update.set("showwinCnt", word.getShowwinCnt());        }        try {            mongoTemplate.updateMulti(query, update, Word.class);            resultObj.setResult(true);        } catch (Exception e) {            resultObj.setResult(false);            e.printStackTrace();            logger.error(e.getMessage(), e);        }        return resultObj;    }

8. 删除数据:

public void deleteObject(Class<T> clazz,String id) {        remove(new Query(Criteria.where("id").is(id)),clazz);    }

9.删除全部

public ResultObj deleteLastDays(Integer days) {
       Query query = new Query();
       query.addCriteria(Criteria.where("createdOn").gte(days)); //gte: 大于等于

       List<AliErrorLog> list = mongoTemplate.find(query, AliErrorLog.class);
        if(list != null){
            for(AliErrorLog aliErrorLog : list){
               mongoTemplate.remove(aliErrorLog);
            }
        }
       return null;
   }

10.保存数据:

//插入一条数据public void saveObject(Object obj) {        insert(obj);    }//插入多条数据    public void saveObjects(List<T> objects) {        for(T t:objects){            insert(t);        }    }

11、district（）去除重复的方法使用：

List result = mongoTemplate.getCollection("loginLog").distinct("userName");
for (Object o : result) {

log.info(o);
}
log.info("=============================1=====================================");

Query query = Query.query(Criteria.where("manId").is("123456"));

result = mongoTemplate.getCollection("loginLog").distinct("myFriends", query.getQueryObject());

for (Object o : result) {

log.info(o);

}

log.info("=============================2=====================================");

result = mongoTemplate.getCollection("loginLog").distinct("fruits.fruitId");

for (Object o : result) {
log.info(o);
}

0 0