文档操作.docx
《文档操作.docx》由会员分享,可在线阅读,更多相关《文档操作.docx(24页珍藏版)》请在冰豆网上搜索。
文档操作
1.查询学生的所有信息
数据准备
varpersons=[{
name:
"jim",
age:
25,
email:
"75431457@",
c:
89,m:
96,e:
87,
country:
"USA",
books:
["JS","C++","EXTJS","MONGODB"],
address:
{city:
"beijing",street:
"861ParkStreet"}
},
{
name:
"tom",
age:
null,
email:
"214557457@",
c:
75,m:
66,e:
97,
country:
"USA",
books:
["PHP","JAVA","EXTJS","C++"],
address:
{city:
"beijing",province:
"hebei"}
},
{
name:
"lili",
age:
null,
email:
"344521457@",
c:
75,m:
63,e:
97,
country:
"USA",
books:
["JS","JAVA","C#","MONGODB"]
},
{
name:
"zhangsan",
age:
27,
email:
"2145567457@",
c:
89,m:
86,e:
67,
country:
"China",
books:
["JS","JAVA","EXTJS","MONGODB"]
},
{
name:
"lisi",
age:
26,
email:
"274521457@",
c:
53,m:
96,e:
83,
country:
"China",
books:
["JS","C#","PHP","MONGODB"]
},
{
name:
"wangwu",
age:
27,
email:
"65621457@",
c:
45,m:
65,e:
99,
country:
"China",
books:
["JS","JAVA","C++","MONGODB"]
},
{
name:
"zhaoliu",
age:
27,
email:
"214521457@",
c:
99,m:
96,e:
97,
country:
"China",
books:
["JS","JAVA","EXTJS","PHP"]
},
{
name:
"piaoyingjun",
age:
26,
email:
"piaoyingjun@",
c:
39,m:
54,e:
53,
country:
"Korea",
books:
["JS","C#","EXTJS","MONGODB"]
},
{
name:
"lizhenxian",
age:
27,
email:
"lizhenxian@",
c:
35,m:
56,e:
47,
country:
"Korea",
books:
["JS","JAVA","EXTJS","MONGODB"]
},
{
name:
"lixiaoli",
age:
21,
email:
"lixiaoli@",
c:
36,m:
86,e:
32,
country:
"Korea",
books:
["JS","JAVA","PHP","MONGODB"]
},
{
name:
"Limiao",
age:
21,
email:
"lixiaoli@",
c:
36,m:
86,e:
32,
country:
"Korea",
books:
["JS","JAVA","PHP","MONGODB"]
},
{
name:
"zhangsuying",
age:
22,
email:
"zhangsuying@",
c:
45,m:
63,e:
77,
country:
"Korea",
books:
["JS","JAVA","C#","MONGODB"]
}]
先执行
db.studend.find()
若存在测删除student
db.student.drop()
再执行插入
db.student.insert(persons)
>db.student.insert(persons)
BulkWriteResult({
"writeErrors":
[],
"writeConcernErrors":
[],
"nInserted":
12,
"nUpserted":
0,
"nMatched":
0,
"nModified":
0,
"nRemoved":
0,
"upserted":
[]
})
然后查询所有student记录
>db.student.find()
{"_id":
ObjectId("57554f9cf7b6c25c4d573c73"),"name":
"jim","age":
25,"email":
"75431457@","c":
89,"m":
96,"e":
87,"country":
"USA","books":
["JS","C++","EXTJS","MONGODB"],"address":
{"city":
"beijing","street":
"861ParkStreet"}}
{"_id":
ObjectId("57554f9cf7b6c25c4d573c74"),"name":
"tom","age":
null,"email":
"214557457@","c":
75,"m":
66,"e":
97,"country":
"USA","books":
["PHP","JAVA","EXTJS","C++"],"address":
{"city":
"beijing","province":
"hebei"}}
{"_id":
ObjectId("57554f9cf7b6c25c4d573c75"),"name":
"lili","age":
null,"email":
"344521457@","c":
75,"m":
63,"e":
97,"country":
"USA","books":
["JS","JAVA","C#","MONGODB"]}
{"_id":
ObjectId("57554f9cf7b6c25c4d573c76"),"name":
"zhangsan","age":
27,"email":
"2145567457@","c":
89,"m":
86,"e":
67,"country":
"China","books":
["JS","JAVA","EXTJS","MONGODB"]}
{"_id":
ObjectId("57554f9cf7b6c25c4d573c77"),"name":
"lisi","age":
26,"email":
"274521457@","c":
53,"m":
96,"e":
83,"country":
"China","books":
["JS","C#","PHP","MONGODB"]}
{"_id":
ObjectId("57554f9cf7b6c25c4d573c78"),"name":
"wangwu","age":
27,"email":
"65621457@","c":
45,"m":
65,"e":
99,"country":
"China","books":
["JS","JAVA","C++","MONGODB"]}
{"_id":
ObjectId("57554f9cf7b6c25c4d573c79"),"name":
"zhaoliu","age":
27,"email":
"214521457@","c":
99,"m":
96,"e":
97,"country":
"China","books":
["JS","JAVA","EXTJS","PHP"]}
{"_id":
ObjectId("57554f9cf7b6c25c4d573c7a"),"name":
"piaoyingjun","age":
26,"email":
"piaoyingjun@","c":
39,"m":
54,"e":
53,"country":
"Korea","books":
["JS","C#","EXTJS","MONGODB"]}
{"_id":
ObjectId("57554f9cf7b6c25c4d573c7b"),"name":
"lizhenxian","age":
27,"email":
"lizhenxian@","c":
35,"m":
56,"e":
47,"country":
"Korea","books":
["JS","JAVA","EXTJS","MONGODB"]}
{"_id":
ObjectId("57554f9cf7b6c25c4d573c7c"),"name":
"lixiaoli","age":
21,"email":
"lixiaoli@","c":
36,"m":
86,"e":
32,"country":
"Korea","books":
["JS","JAVA","PHP","MONGODB"]}
{"_id":
ObjectId("57554f9cf7b6c25c4d573c7d"),"name":
"Limiao","age":
21,"email":
"lixiaoli@","c":
36,"m":
86,"e":
32,"country":
"Korea","books":
["JS","JAVA","PHP","MONGODB"]}
{"_id":
ObjectId("57554f9cf7b6c25c4d573c7e"),"name":
"zhangsuying","age":
22,"email":
"zhangsuying@","c":
45,"m":
63,"e":
77,"country":
"Korea","books":
["JS","JAVA","C#","MONGODB"]}
也可以使用这个命令
>db.student.find({})
2.查询所有学生的姓名
>db.student.find({},{_id:
0,name:
1})
{"name":
"jim"}
{"name":
"tom"}
{"name":
"lili"}
{"name":
"zhangsan"}
{"name":
"lisi"}
{"name":
"wangwu"}
{"name":
"zhaoliu"}
{"name":
"piaoyingjun"}
{"name":
"lizhenxian"}
{"name":
"lixiaoli"}
{"name":
"Limiao"}
{"name":
"zhangsuying"}
3.查询出年龄在25到27岁之间的学生
>db.student.find({age:
{$gte:
25,$lte:
27}})
{"_id":
ObjectId("57554f9cf7b6c25c4d573c73"),"name":
"jim","age":
25,"email":
"75431457@","c":
89,"m":
96,"e":
87,"country":
"USA","books":
["JS","C++","EXTJS","MONGODB"],"address":
{"city":
"beijing","street":
"861ParkStreet"}}
{"_id":
ObjectId("57554f9cf7b6c25c4d573c76"),"name":
"zhangsan","age":
27,"email":
"2145567457@","c":
89,"m":
86,"e":
67,"country":
"China","books":
["JS","JAVA","EXTJS","MONGODB"]}
{"_id":
ObjectId("57554f9cf7b6c25c4d573c77"),"name":
"lisi","age":
26,"email":
"274521457@","c":
53,"m":
96,"e":
83,"country":
"China","books":
["JS","C#","PHP","MONGODB"]}
{"_id":
ObjectId("57554f9cf7b6c25c4d573c78"),"name":
"wangwu","age":
27,"email":
"65621457@","c":
45,"m":
65,"e":
99,"country":
"China","books":
["JS","JAVA","C++","MONGODB"]}
{"_id":
ObjectId("57554f9cf7b6c25c4d573c79"),"name":
"zhaoliu","age":
27,"email":
"214521457@","c":
99,"m":
96,"e":
97,"country":
"China","books":
["JS","JAVA","EXTJS","PHP"]}
{"_id":
ObjectId("57554f9cf7b6c25c4d573c7a"),"name":
"piaoyingjun","age":
26,"email":
"piaoyingjun@","c":
39,"m":
54,"e":
53,"country":
"Korea","books":
["JS","C#","EXTJS","MONGODB"]}
{"_id":
ObjectId("57554f9cf7b6c25c4d573c7b"),"name":
"lizhenxian","age":
27,"email":
"lizhenxian@","c":
35,"m":
56,"e":
47,"country":
"Korea","books":
["JS","JAVA","EXTJS","MONGODB"]}
下面这种方式更直观
db.student.find({age:
{$gte:
25,$lte:
27}},{_id:
0,name:
1,age:
1})
{"name":
"jim","age":
25}
{"name":
"zhangsan","age":
27}
{"name":
"lisi","age":
26}
{"name":
"wangwu","age":
27}
{"name":
"zhaoliu","age":
27}
{"name":
"piaoyingjun","age":
26}
{"name":
"lizhenxian","age":
27}
4.查询出所有不是韩国籍的学生
db.student.find({country:
{$ne:
"Korea"}},{_id:
0,name:
1,country:
1})
{"name":
"jim","country":
"USA"}
{"name":
"tom","country":
"USA"}
{"name":
"lili","country":
"USA"}
{"name":
"zhangsan","country":
"China"}
{"name":
"lisi","country":
"China"}
{"name":
"wangwu","country":
"China"}
{"name":
"zhaoliu","country":
"China"}
5.查询国籍是中国或美国的学生信息
>db.student.find({country:
{$in:
["USA","China"]}})
{"_id":
ObjectId("57554f9cf7b6c25c4d573c73"),"name":
"jim","age":
25,"email":
"75431457@","c":
89,"m":
96,"e":
87,"country":
"USA","books":
["JS","C++","EXTJS","MONGODB"],"address":
{"city":
"beijing","street":
"861ParkStreet"}}
{"_id":
ObjectId("57554f9cf7b6c25c4d573c74"),"name":
"tom","age":
null,"email":
"214557457@","c":
75,"m":
66,"e":
97,"country":
"USA","books":
["PHP","JAVA","EXTJS","C++"],"address":
{"city":
"beijing","province":
"hebei"}}
{"_id":
ObjectId("57554f9cf7b6c25c4d573c75"),"name":
"lili","age":
null,"email":
"344521457@","c":
75,"m":
63,"e":
97,"country":
"USA","books":
["JS","JAVA","C#","MONGODB"]}
{"_id":
ObjectId("57554f9cf7b6c25c4d573c76"),"name":
"zhangsan","age":
27,"email":
"2145567457@","c":
89,"m":
86,"e":
67,"country":
"China","books":
["JS","JAVA","EXTJS","MONGODB"]}
{"_id":
ObjectId("57554f9cf7b6c25c4d573c77"),"name":
"lisi","age":
26,"email":
"274521457@","c":
53,"m":
96,"e":
83,"country":
"China","books":
["JS","C#","PHP","MONGODB"]}
{"_id":
ObjectId("57554f9cf7b6c25c4d573c78"),"name":
"wangwu","age":
27,"email":
"65621457@","c":
45,"m":
65,"e":
99,"country":
"China","books":
["JS","JAVA","C++","MONGODB"]}
{"_id":
ObjectId("57554f9cf7b6c25c4d573c79"),"name":
"zhaoliu","age":
27,"email":
"214521457@","c":
99,"m":
96,"e":
97,"country":
"China","books":
["JS","JAVA","EXTJS","PHP"]}
6.查询国籍不是中国或美国的学生信息
>db.student.find({country:
{$nin:
["USA","China"]}})
{"_id":
ObjectId("57554f9cf7b6c25c4d573c7a"),"name":
"piaoyingjun","age":
26,"email":
"piaoyingjun@","c":
39,"m":
54,"e":
53,"country":
"Korea","books":
["JS","C#","EXTJS","MONGODB"]}
{"_id":
ObjectId("57554f9cf7b6c25c4d573c7b"),"name":
"lizhenxian","age":
27,"email":
"lizhenxian@","c":
35,"m":
56,"e":
47,"country":
"Korea","books":
["JS","JAVA","EXTJS","MONGODB"]}
{"_id":
ObjectId("57554f9cf7b6c25c4d573c7c"),"name":
"lixiaoli","age":
21,"email":
"lixiaoli@","c":
36,"m":
86,"e":
32,"country":
"Korea","books":
["JS","JAVA","PHP","MONGODB"]}
{"_id":
ObjectId("57554f9cf7b6c25c4d573c7d"),"name":
"Limiao","age":
21,"email":
"lixiaoli@","c":
36,"m":
86,"e":
32,"country":
"K