当前位置: 首页 > 后端技术 > Node.js

使用vue+node+koa+sequlize实现后台管理系统(二)

时间:2023-04-04 00:13:29 Node.js

mkdirAceNode&&cdAceNodevipackage.json在packabe.json中添加如下内容{"name":"ace-node","version":"1.0.0","description":"backendforace","main":"./src/app.js","scripts":{"start":"nodemonnode./src/app.js","build":"babel./src/app.js-ddist"},"keywords":["koa","async"],"author":"爱谁","license":"1.0","dependencies":{"@types/async":"^3.0.3","@types/koa":"^2.0.51","@types/koa-bodyparser":"^4.3.0","@types/koa-json":"^2.0.18","@types/koa-logger":"^3.1.1","@types/koa-router":"^7.0.42","@types/koa2-cors":"^2.0.1","@types/mysql":"^2.15.7","async":"^3.1.0","http-proxy-middleware":"^0.20.0","koa":"^2.11.0","koa-bodyparser":"^4.2.1","koa-error":"^3.2.0","koa-json":"^2.0.2","koa-logger":"^3.2.1","koa-router":"^7.4.0","koa-service":"^1.0.1","koa-static":"^5.0.0","koa2-cors":"^2.0.6","mysql":"^2.17.1","mysql2":"^2.0.0","nodemon":"^1.19.4","sequelize":"^5.21.2"},"devDependencies":{"@babel/cli":"^7.2.3","@babel/core":"^7.4.0","@babel/preset-env":"^7.4.2","@babel/register":"^7.4.0","typescript":"^3.6.4","mocha":"^5.2.0"}}粘贴目录结构。├──app.js├──controller│└──userController.js├──middleware├──modle│└──user.js├──mysql.js├──routes│└──index.js├──sequelize.js└──service├────index.js└──userService.js5.后台代码就不一一贴了,有兴趣的同学可以去我的git看看6.差点忘了,说说数据库的配置connection.sequelize.js文件是用来连接数据库的,本项目所有的增删改查都要经过这个文件,贴出来给大家看看constSequlice=require('sequelize');constsequelize=newSequlice('你的数据库名','用户名','密码',{host:'数据库主机',dialect:'mysql',pool:{max:5,min:0,acquire:30000,idle:10000,},});module.exports=续集;注意:使用sequelize时,不需要去mysql中手动创建数据表。你只需要一个映射文件,也就是我代码中的module/user.js文件。具体使用方法参考sequelize使用方法。你绝对可以理解。7、如果要增删改查,可能需要一点SQL基础。可以先熟悉一下,再去sequelize官网看文档,不然可能有点压力。8、至此,后台基本就结束了。下一篇分享会将前后端项目打包成docker镜像运行。