安装mongoose
yarn add mongoose
连接数据库
db.config.js
const mongoose = require("mongoose")
mongoose.connect("mongodb://127.0.0.1:27017/company-system").then(() => {
console.log("成功连接到MongoDB")
}).catch((err) => {
console.error("无法连接到MongoDB", err);
});
app.js
var createError = require('http-errors');
var express = require('express');
var path = require('path');
var logger = require('morgan');
var indexRouter = require('./routes/index');
// 引入数据库
require('./config/db.config')
var app = express();
// view engine setup
app.set('views', path.join(__dirname, 'views'));
app.set('view engine', 'jade');
app.use(logger('dev'));
app.use(express.json());
app.use(express.urlencoded({ extended: false }));
app.use(cookieParser());
app.use(express.static(path.join(__dirname, 'public')));
创建模型
const mongoose = require("mongoose")
const Schema = mongoose.Schema
const UserType = {
username:String,
password:String,
gender:Number,
introduction:String,
avatar:String,
role:Number
}
const UserModel = mongoose.model("user",new Schema(UserType))
module.exports = UserModel
增加数据
UserModel.create({
introduction,username,gender,avatar,password,role
})
查询数据
UserModel.find({username:"kerwin"},["username","role","introduction","password"]).sort({createTime:-1}).skip(10).limit(10)
更新数据
UserModel.updateOne({_id},{introduction,username,gender,avatar})
删除数据
UserModel.deleteOne({_id})