java-mongodb查询笔记

一.模糊查询

1.只能是字符串

2.代码如下:

String tableName = "bidding_notice";

String dbName = "spider";

BasicDBObject qryParam = new BasicDBObject();

qryParam.put(SpiderMapKeyConst.KEY_TASK_ID, "82");

BasicDBObject regex = new BasicDBObject();

regex.put("$regex", ".*?暂无数据.*?");

qryParam.put(SpiderMapKeyConst.KEY_CONTENT, regex);

long count = mongoService.count(dbName, tableName, qryParam);

关键在于正则

regex.put("$regex", ".*?暂无数据.*?"

二.聚合查询

格式

{ $group : { _id : < expression > , < field1 >: { < accumulator1 > : < expression1 > }, ... } }

例子

db.getCollection('bidding_notice').aggregate([ { "$match" :{ "siteId" :"346"}},{ "$group" : { "_id" : "$siteId" , "count" : { "$sum" : 1}}}])

三.$ne详解

---

This will return all documents with a key called "IMAGE URL", but they may still have a null value.

db . mycollection . find ({ "IMAGE URL" :{