mongodb查询操作1

[
	{
	"_id":1,
	"name":"c语言程序设计",
	"category":["图书","计算机"],
	"price":{"进价":35,"零售价":35}
	},
	{
	"_id":2,
	"name":"小学六年级数学（上）",
	"category":["图书","教育"],
	"price":{"进价":25,"零售价":25}
	},
	
	{
	"_id":3,
	"name":"大闹天宫（连环画）",
	"category":["图书","神话","教育"],
	"price":{"进价":0.9,"零售价":2.5}
	
	},
	{
	"_id":4,
	"name":"辣条",
	"category":["食品","休闲"],
	"price":{"进价":0.6,"零售价":1}
	
	},
	{
	"_id":5,
	"name":"咪咪虾条",
	"category":["食品","休闲","膨化"],
	"price":{"进价":0.8,"零售价":2}
	
	},
	{
	"_id":6,
	"name":"大白兔奶糖",
	"category":["食品","糖果"],
	"price":{"进价":15,"零售价":22}
	
	}

]

把准备的数据插入到集合中

 db.class1.insertMany([
 {
 "_id":1,
"name":"c语言程序设计",
"category":["图书","计算机"],
"price":{"进价":35,"零售价":35}
 },
 {
 "_id":2,
 "name":"小学六年级数学（上）",
 "category":["图书","教育"],
 "price":{"进价":25,"零售价":25}
 },

{
 "_id":3,
 "name":"大闹天宫（连环画）",
"category":["图书","神话","教育"],
 "price":{"进价":0.9,"零售价":2.5}

 },
 {
 "_id":4,
 "name":"辣条",
"category":["食品","休闲"],
"price":{"进价":0.6,"零售价":1}

 },
 {
"_id":5,
"name":"咪咪虾条",
"category":["食品","休闲","膨化"],
 "price":{"进价":0.8,"零售价":2}

 },
 {
"_id":6,
 "name":"大白兔奶糖",
"category":["食品","糖果"],
 "price":{"进价":15,"零售价":22}
}
])

查询操作

db.集合名.find().pretty()    #查询集合中所有内容

> db.class1.find().pretty()
> db.class1.find()  #对比可以发现pretty()方法美化我们的查询结果的

分页

db.class1.find().limit(2)#此处的为x

db.class1.find().skip(2).limit(2)#跳过x条数据显示

sort排序

 db.class1.find().sort({_id:-1})#1升序，-1降序

db.集合名.find({查询条件}，{指定返回字段})  #带条件查询

 db.class1.find({name:"大白兔奶糖"},{_id:0})#0为不显示，1为显示，默认为显示

嵌套文档的查询

 db.class1.find({"price.进价":{$gt:20}},{_id:0,name:1})

操作符	用法
$gt	大于
$gte	大于等于
$lt	小于
$lte	小于等于

 db.class1.find({name:{$regex:/^大白兔/}},{_id:0})#使用正则进行查询

正则查询
/^固定前面部分/
/固定后面部分$/
/任意部分/
$or

 db.class1.find({$or:[{name:"大白兔奶糖"},{name:"c语言程序设计"}]},{_id:0})

 db.class1.find({$and:[{"price.进价":{$gt:20}},{"price.进价":{$lt:30}}]},{_id:0})#和条件