代码如下:
//1. 引入模块
let mongoose = require('mongoose');
mongoose.connect('mongodb://localhost/m_data');
let db = mongoose.connection;
db.once('open', () => {
console.log('数据库连接成功')
})
//2.Schema(模板对象)
let Schema = mongoose.Schema;
let personSchema = new Schema({
name: String,
age: Number,
chat: String,
sex: {
type: String,
default: '男'
}
})
//3.创建MOdel集合对象
let personModel = mongoose.model('person',personSchema);
//4. 增删改查
// 4.1 增加
/*
personModel.create([
{name: '刘华华',age: 58,chat: '华667'},
{name: '陈英',age: 50,chat: 'naying1990', sex: '女'},
{name: '周杰',age: 38,chat: 'jaychou'},
{name: '胡可可',age: 18,chat: 'hkk1990', sex: '女'}
],(err) => {
if(!err) {
console.log('插入成功')
}else {
throw err
}
})
*/
//4.2 查
/*
personModel.find({},(err,doc) => {
if(!err) {
console.log(doc)
console.log(typeof doc)
}
})
*/
// personModel.find({name: '周杰'}, (err,doc) => {
// if(!err) {
// console.log(doc)
// }
// })
// personModel.find({},{ name: 1, _id: 0, sex: 1, chat: 1},(err,doc) => {
// if(!err) {
// console.log(doc)
// }else {
// throw err
// }
// })
// personModel.find({},"-_id name",{skip: 1, limit: 2} ,(err,doc) => {
// if(!err) {
// console.log(doc)
// }else {
// throw err
// }
// })
// 4.3 修改 {multi: true} =》 修改多个
/*
personModel.update({name: '王菲'},{$set: {name: '王阿丹',age:10,chat: '我要学习'}}, {multi: true},(err) => {
if(!err) {
console.log('修改成功')
}else{
throw err
}
})
*/
// 4.4 删除
/*
personModel.remove({name: '谢霆锋'}, { }, (err)=>{
if(!err){
console.log('删除成功!');
}else {
throw err;
}
});
*/
// 4.5 统计个数
personModel.count({}, (err, count)=>{
if(!err){
console.log(count);
}else {
throw err;
}
});