##连接数据库
新建model文件夹,然后db.js文件
const mongoose=require('mongoose')
mongoose.connect("mongodb://127.0.0.1:27017/h12_19")
const conn=mongoose.connection
conn.on("open",()=>{
console.log("数据库连接成功");
})
conn.on("error",err=>{
console.log("数据库连接失败,错误消息:",err.message);
})
module.exports=mongoose
##建表
model.js文件
const userSchema = new mongoose.Schema({
username: String,
password: String
})
const aSchema = new mongoose.Schema({
title: String,
})
const bSchema = new mongoose.Schema({
title1: String,
nei: String,
pid: {
type: mongoose.Types.ObjectId,
ref: 'a'
}
})
const userModel = mongoose.model("user", userSchema, "user")
const aModel = mongoose.model("a", aSchema, 'a')
const bModel = mongoose.model("b", bSchema, 'b')
module.exports = {
aModel,
bModel,
userModel,
}
##实现简单的增删改查的功能
####展示功能
router.get('/b_list', async (req, res) => {
let data = await bModel.find()
res.send({
data: data,
code: 200
})
})
####添加功能
router.post('/b_add', async (req, res) => {
let a = req.body
console.log(a)
await bModel.create(a)
console.log(a)
res.send({
code: 200,
msg: '添加成功'
})
})
####修改功能
router.post('/b_up/:id', async (req, res) => {
const id = req.params.id
let body = req.body
await bModel.updateOne({ _id: id }, body)
res.send({
code: 200,
msg: '修改成功'
})
})
####删除功能
router.delete('/b_del/:id', async (req, res) => {
const id = req.params.id
await bModel.deleteOne({ _id: id })
res.send({
code: 200,
msg: '删除成功'
})
})
#基本表结构
#在app.js做配置
const cors = require('cors')
app.use(cors())