MongoDB(二)CRUD

插入

db.demouser.insertOne({"uid" : 10, "name" : "Sky", "address" : "芳村大道东", "creator" : "admin", "status" : 1, "createTime" : "2016-11-07 18:08:29", "updateTime" : "2016-11-07 18:08:29" });

{
    "acknowledged" : true,
    "insertedId" : ObjectId("5835434fcf9d757761af5d02")
}

查询

db.demouser.find({"name":"Sky"});
{ "_id" : ObjectId("5835434fcf9d757761af5d02"), "uid" : 10, "name" : "Sky", "address" : "芳村大道东", "creator" : "admin", "status" : 1, "createTime" : "2016-11-07 18:08:29", "updateTime" : "2016-11-07 18:08:29" }

db.user.count({"id":4});

db.demouser.find({"name":"Sky"}).pretty();
{
    "_id" : ObjectId("5835434fcf9d757761af5d02"),
    "uid" : 10,
    "name" : "Sky",
    "address" : "芳村大道东",
    "creator" : "admin",
    "status" : 1,
    "createTime" : "2016-11-07 18:08:29",
    "updateTime" : "2016-11-07 18:08:29"
}

#查询指定的字段
#其中_id是默认返回的，如果不需要返回，则设置_id:0
>db.demouser.find({"name":"Sky"},{"_id":0,"uid":1}).pretty();
{
"uid":10
}

db.user.find({"gender":{"$exists":true}});
{ "_id" : ObjectId("5835468f1fab7204b0cd4ed2"), "id" : 3, "username" : "lin3", "fullname" : "超级3", "gender" : 3, "classmate" : [ { "name" : "angel" } ] }
> db.user.find({"gender":{"$exists":false}});
{ "_id" : ObjectId("5835481c1fab7208a4424d4c"), "id" : 4, "username" : "lin", "fullname" : "超级", "classmate" : [ { "name" : "cool" } ] }

需要查询排序分页的操作，可以类似以下：
根据字段"id"倒序排序，跳过1条记录，返回前2条记录

> db.user.find().sort({"id":-1}).skip(1).limit(2);
{ "_id" : ObjectId("583566521fab7215ec038034"), "id" : 5, "username" : "li", "fullname" : "超级", "gender" : 1 }
{ "_id" : ObjectId("5835481c1fab7208a4424d4c"), "id" : 4, "username" : "lin", "fullname" : "超级", "classmate" : [ { "name" : "cool" } ], "gender" : 3 }

更新

db.demouser.update({"name" : "Sky"},{ "_id" : ObjectId("5835434fcf9d757761af5d02"), "uid" : 10, "name" : "Sky New", "address" : "芳村大道东", "creator" : "admin", "status" : 1, "createTime" : "2016-11-07 18:08:29", "updateTime" : "2016-11-07 18:08:29" });
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })

db.demouser.update({"_id" : ObjectId("5835434fcf9d757761af5d02")},{"$set":{"status":2}});
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })

db.user.update({"_id" : ObjectId("5835481c1fab7208a4424d4c")},{"$unset":{"gender" : 1}});
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })

db.user.update({"_id" : ObjectId("5835468f1fab7204b0cd4ed2")},{"$inc":{"gender" : 1}});
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })

db.user.updateOne({"_id" : ObjectId("5835481c1fab7208a4424d4c")},{"$push":{"classmate":{"name":"cool"}}});
{ "acknowledged" : true, "matchedCount" : 1, "modifiedCount" : 1 }

{
    "_id" : ObjectId("5835481c1fab7208a4424d4c"),
    "id" : 4,
    "username" : "lin",
    "fullname" : "超级",
    "classmate" : [
        {
            "name" : "cool"
        }
    ]
}

删除文档

db.demouser.remove({"_id":ObjectId("5835434fcf9d757761af5d02")});
WriteResult({ "nRemoved" : 1 })

删除集合

db.demouser.drop();
true

..