Node.js连接操作数据库

安装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})