![[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-1yD53vmu-1689156226437)(C:\Users\tanhao\AppData\Roaming\Typora\typora-user-images\image-20230711151250519.png)]](https://img-blog.csdnimg.cn/25802b24fbc445b5baaf8f8afa5442c6.png)
![[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-GbGrCpv0-1689156226447)(C:\Users\tanhao\AppData\Roaming\Typora\typora-user-images\image-20230711151419856.png)]](https://img-blog.csdnimg.cn/245a227ebf7046d1832e645dddab0ba1.png)
{
"accounts": [
{
"id": "3-YLju5f3",
"title": "买电脑",
"time": "2023-02-08",
"type": "-1",
"account": "5500",
"remarks": "为了上网课"
},
{
"id": "3-YLju5f4",
"title": "请女朋友吃饭",
"time": "2023-02-08",
"type": "-1",
"account": "214",
"remarks": "情人节聚餐"
},
{
"id": "mRQiD4s3K",
"title": "发工资",
"time": "2023-02-19",
"type": "1",
"account": "4396",
"remarks": "终于发工资啦!~~"
}
],
"users":[
{
"id": 1,
"name": "zhangsan",
"age": 18
},
{
"id": 2,
"name": "lisi",
"age": 20
},
{
"id": 3,
"name": "wangwu",
"age": 22
}
]
}
![[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-XDxj6OyX-1689156226464)(C:\Users\tanhao\AppData\Roaming\Typora\typora-user-images\image-20230711151746467.png)]](https://img-blog.csdnimg.cn/1ee81baec3a8414abd31bdc9248c8dd6.png)
show dbs
use 数据库名
db
use 库名
db.dropDatabase()
db.createCollection('集合名称')
show collections
db.集合名.drop()
db.集合名.renameCollection('newName')
db.集合名.insert(文档对象);
db.集合名.find(查询条件)
db.集合名.update(查询条件,新的文档)
db.集合名.update({name:'张三'},{$set:{age:19}})
db.集合名.remove(查询条件)
//1. 安装 mongoose
//2. 导入 mongoose
const mongoose = require('mongoose');
//3. 连接数据库
mongoose.connect('mongodb://127.0.0.1:27017/bilibili');
//4. 设置连接回调
//连接成功
mongoose.connection.on('open', () => {
console.log('连接成功');
//5. 创建文档结构对象
let BookSchema = new mongoose.Schema({
title: String,
author: String,
price: Number
});
//6. 创建文档模型对象
let BookModel = mongoose.model('book', BookSchema);
//7. 插入文档
BookModel.create({
title: '西游记',
author: '吴承恩',
price: 19.
}, (err, data) => {
if (err) throw err;
//输出 data 对象
console.log(data);
//8. 断开连接
mongoose.disconnect();
});
});
//连接出错 mongoose.connection.on('error', () => {
console.log('连接出错~~');
})
//连接关闭 mongoose.connection.on('close', () => {
console.log('连接关闭');
})
| 类型 | 描述 |
|---|---|
| String | 字符串 |
| Number | 数字 |
| Boolean | 布尔值 |
| Array | 数组，也可以使用 [] 来标识 |
| Date | 日期 |
| Buffer | Buffer 对象 |
| Mixed | 任意类型，需要使用 mongoose.Schema.Types.Mixed 指定 |
| ObjectId | 对象 ID，需要使用 mongoose.Schema.Types.ObjectId 指定 |
| Decimal128 | 高精度数字，需要使用 mongoose.Schema.Types.Decimal128 指定 |
title: {
type: String,
required: true // 设置必填项
},
author: {
type: String,
default: '匿名' //默认值
},
gender: {
type: String,
enum: ['男','女'] //设置的值必须是数组中的
},
username: {
type: String,
unique: true
},
SongModel.create({
title:'给我一首歌的时间',
author: 'Jay'
}, function(err, data){
//错误
console.log(err);
//插入后的数据对象
console.log(data);
});
//1.引入mongoose
const mongoose = require('mongoose');
//2.链接mongodb数据库 connect 连接 mongoose.connect('mongodb://127.0.0.1:27017/project');
//3.设置连接的回调 mongoose.connection.on('open',()=>{
//4.声明文档结构
const PhoneSchema = new mongoose.Schema({
brand:String,
color:String,
price:Number,
tags:Array
})
//5.创建模型对象
const PhoneModel = mongoose.model('phone',PhoneSchema);
PhoneModel.insertMany([
{
brand:'华为',
color:'灰色',
price:2399,
tags:['电量大','屏幕大','信号好']
},
{
brand:'小米',
color:'白色',
price:2099,
tags:['电量大','屏幕大','信号好']
}
],(err,data)=>{
if(err) throw err;
console.log('写入成功');
mongoose.connection.close();
})
})
SongModel.deleteOne({_id:'5dd65f32be6401035cb5b1ed'}, function(err){
if(err) throw err;
console.log('删除成功');
mongoose.connection.close();
});
SongModel.deleteMany({author:'Jay'}, function(err){
if(err) throw err;
console.log('删除成功');
mongoose.connection.close();
});
SongModel.updateOne({author: 'JJ Lin'}, {author: '林俊杰'}, function (err) {
if(err) throw err;
mongoose.connection.close();
});
SongModel.updateMany({author: 'Leehom Wang'}, {author: '王力宏'}, function (err) {
if(err) throw err;
mongoose.connection.close();
});
SongModel.findOne({author: '王力宏'}, function(err, data){
if(err) throw err;
console.log(data);
mongoose.connection.close();
});
//根据 id 查询数据 SongModel.findById('5dd662b5381fc316b44ce167',function(err, data){
if(err) throw err;
console.log(data);
mongoose.connection.close();
});
//不加条件查询
SongModel.find(function(err, data){
if(err) throw err;
console.log(data);
mongoose.connection.close();
});
//加条件查询
SongModel.find({author: '王力宏'}, function(err, data){
if(err) throw err;
console.log(data);
mongoose.connection.close();
});
> 使用 $gt
< 使用 $lt
>= 使用 $gte
<= 使用 $lte
!== 使用 $ne
例:
db.students.find({id:{$gt:3}}); id号比3大的所有的记录
db.students.find({$or:[{age:18},{age:24}]});
db.students.find({$and: [{age: {$lt:20}}, {age: {$gt: 15}}]});
db.students.find({name:/imissyou/});
//0:不要的字段
//1:要的字段 SongModel.find().select({_id:0,title:1}).exec(function(err,data){
if(err) throw err;
console.log(data);
mongoose.connection.close();
});
//sort 排序
//1:升序
//-1:倒序 SongModel.find().sort({hot:1}).exec(function(err,data){
if(err) throw err;
console.log(data);
mongoose.connection.close();
});
//skip 跳过 limit 限定 SongModel.find().skip(10).limit(10).exec(function(err,data){
if(err) throw err;
console.log(data);
mongoose.connection.close();
});
row err;
console.log(data);
mongoose.connection.close();
});
#### 5.8.2 数据排序
```js
//sort 排序
//1:升序
//-1:倒序 SongModel.find().sort({hot:1}).exec(function(err,data){
if(err) throw err;
console.log(data);
mongoose.connection.close();
});
//skip 跳过 limit 限定 SongModel.find().skip(10).limit(10).exec(function(err,data){
if(err) throw err;
console.log(data);
mongoose.connection.close();
});