3、MongoDB实战使用记录

1、创建数据库

--创建数据库school
use school_che;
-- 查看所有数据库
show dbs;
-- 插入数据
db.school_che.insert({"name":"小明"});

– 创建名称为t_role的集合,并且插入数据

db.t_role.insert({"name":"小明"});
db.t_role.save({"name":"小明"});

2、删除数据库

use school_che;
--删除数据库
db.dropDatabase();

3、创建集合

use school_che;
-- 创建名称为t_user的集合
db.createCollection("t_user");

4、删除集合

--删除名称为school_cheche的集合
db.school_cheche.drop();

5、展示所有集合

use school_cheche;
show collections;

6、插入数据（文档）

-- 其一
db.getCollection("t_user").insertMany([
    {
        "areaIds" : [440300],
        "insuranceCompanyIds" : [2005,2011],
        "suitePackageIds" : [18],
        "manufacturerIds" : [92],
        "username" : "小明"
    },
    {
        "areaIds" : [440300],
        "insuranceCompanyIds" : [2005,2011],
        "suitePackageIds" : [19],
        "manufacturerIds" : [92],
        "username" : "小红"
    },
    {
        "areaIds" : [440300],
        "insuranceCompanyIds" : [2005,2011],
        "suitePackageIds" : [20],
        "manufacturerIds" : [92],
        "username" : "小黄"
    },
]);

-- 其二
db.t_user.insertMany([
    {
        "areaIds" : [440300],
        "insuranceCompanyIds" : [2005,2011],
        "suitePackageIds" : [18],
        "manufacturerIds" : [92],
        "username" : "小花"
    },
    {
        "areaIds" : [440300],
        "insuranceCompanyIds" : [2005,2011],
        "suitePackageIds" : [19],
        "manufacturerIds" : [92],
        "username" : "小李 "
    }
]);
-- 其三
db.t_user.insertOne({
        "areaIds" : [440300],
        "insuranceCompanyIds" : [2005,2011],
        "suitePackageIds" : [18],
        "manufacturerIds" : [92],
        "username" : "哈哈1"
});
-- 其四
db.getCollection("t_user").insertOne({
    "areaIds" : [440300],
    "insuranceCompanyIds" : [2005,2011],
    "suitePackageIds" : [18],
    "manufacturerIds" : [92],
    "username" : "哈哈2"
});

7、更新数据

– 更新多条满足条件的数据

db.t_user.updateOne({username:'zhangsan'},{$set:{age:25}},false,true);

db.getCollection('edi_config').update(
    {insuranceCompany: NumberLong('1111'), env : "test"},
    {$set:{
        "config.publicKey": "aaaa",
        "config.wapPayUrl":"aaaa",
        "config.payUrl":"aaaa"
        }
    }
);

8、查询数据

db.getCollection("t_user").find({username:"小明"}).count();
db.getCollection("t_user").find({username:/小/});
db.getCollection("t_user").find({username:/^小/});
db.getCollection("t_user").find({username:/小^/});
db.getCollection("t_user").find({username:{$regex:"小"}});
db.getCollection("t_user").find({manufacturerIds:[92]}).sort({suitePackageIds:-1});
db.getCollection("t_user").find({manufacturerIds:[92]}).sort({suitePackageIds:1});
db.getCollection("t_user").find({manufacturerIds:[92]}).skip(1).limit(2);
db.getCollection("t_user").find({username:"小明"}, {id:true, username:true});

9、创建索引

#说明：1表示升序，-1表示降序。
db.t_user.createIndex({'username':1});
db.t_user.createIndex({'class':-1});
db.getCollection('ar_a_record').ensureIndex({"aaId":1},{"name":"index_aaId"});
db.getCollection('ar_a_record').ensureIndex({"aaId":1},{"name":"index_aaId"});

/*唯一索引*/
db.getCollection('aa_aaaa_record').ensureIndex({"aaaId":1},{"unique":true});

/*查看索引*/
db.t_user.getIndexes()

/*删除索引根据名称*/
db.t_user.dropIndex("index_aaaaId");

/*删除所有索引*/
db.t_user.dropIndex();