MongoDB常用文法

標籤：style   strong   ar   時間   new   ef   on   app   

1 MongoVUE用法1.1 模糊查詢

頭匹配：

　　{"title":new RegExp("^各地發起紀念周總理")}

任意位置匹配：

　　{"published":{$gte: "2013-05-01", $lt: "2013-06-10"}, "title":new RegExp(".*北京.*")}

1.2 時間段查詢

{"published":{$gte: "2013-05-01", $lt: "2013-06-10"}}

1.3 聯集查詢

{"published":{$gte: "2013-05-01", $lt: "2013-06-10"}, "title":new RegExp("^北京")}

2 mongo.jar用法2.1 聯集查詢

BasicDBObject query = new BasicDBObject();

query.put("published", new BasicDBObject("$gte", "2013-05-01").append("$lt", "2013-06-11"));

query.put("title", new BasicDBObject("$regex", ".*北京.*"));