工具:mongobooster
1.工作中只用到了mongodb一次,所以总是忘记怎么查,下面一些示例,用来唤醒记忆。
db.col.find({likes : {$lt :200, $gt : 100}})
类似于SQL语句:Select * from col where likes>100 AND likes<200;
如果想获取 "col" 集合中 title 为 String 的数据,你可以使用以下命令:
db.col.find({"title" : {$type : 2}})
>db.COLLECTION_NAME.find().limit(NUMBER).skip(NUMBER)
>db.COLLECTION_NAME.find().sort({KEY:1})--排序
> db.mycol.aggregate([{$group : {_id : "$by_user", num_tutorial : {$sum : 1}}}])
以上实例类似sql语句: select by_user, count(*) from mycol group by by_user
2.在java中使用
DBCollection dbCollection = mongoFactory.getDBCollection();
BDObject match = new BasicDBObject("timestamp",new BasicDBObject("$gte",start).append("$lte",end));
BDObject files = new BasicDBObject();
files.put("id",1);
BDObject sort = new BDObject();
sort.put("timestamp",1);
DBCursor cursor = dbCollection.find(match,files).sort(sort);
while(cursor.hasNext){
BDObject dbObject = cursor.next();
dbObject.get("id").toString();
}
参考文档:
https://www.w3cschool.cn/mongodb/mongodb-java.html
https://docs.mongodb.com/manual/reference/method/db.collection.find/
http://api.mongodb.com/java/current/com/mongodb/DBCollection.html