devbox
笔触狂放9
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

Vue+Node.js+Msyql实现一个简单的毕业设计《体检预约管理系统》_大学前端vue项目

作者：笔触狂放9 | 2024-02-29 16:05:13

赞

踩

大学前端vue项目

最近接了一个小姐姐的毕业设计，她是要我做一个纯前端的《体检预约管理系统》，我一想前端咋去用node.js访问数据库呀？于是乎去面向百度了一波，终究还是找到了案例代码，然后日夜冥思苦想把这个项目做出来给交付了，废话不多说，开始正题！

话不多说咱们直接开整吧，冲啊！！！冲啊！！！冲啊！！！

开发技术及开发工具

开发工具采用vsCode【前后端代码的编写】、Navicat Premium 15【Mysql数据库的连接】

前端采用Vue、ElementUI

后端采用node.js

数据库采用Mysql

轮播图文件存储是用到了阿里云的OSS对象存储，想了解的直接去看官网的SDK就行，免费可以使用的

阿里云官网地址：

云上特卖会场

《体检预约管理系统》视频展示，视频前几十秒可能会有些许的模糊，不过也就几十秒

体检预约管理系统演示视频

项目整体架构图

前端架构图

后端架构图

Vue.js+ElementUi前端核心页面功能截图

这里就不贴代码了，内容太多了，兄弟们需要源码自行到文尾链接下载

1.首页

2.系统管理（用户管理）

3.系统管理（角色管理）

4.系统管理（菜单管理）

5.项目管理（项目详情）

6.套餐管理（套餐详情）

7.记录管理（预约记录）

8.日志管理（登录日志）

9.轮播图管理（轮播图详情）

10.个人管理（个人信息）

11.登录

 

Node.js后端核心代码（以下为部分代码，整个项目请点击文尾连接下载）

1.设置跨域请求

  1. const express = require('express')
  2. const bodyParser = require('body-parser')
  3. const router = require('./router/router.js')
  4. const app = express()
  5.  
  6. // 跨域请求处理
  7. app.all('*', (req, res, next) => {
  8.   res.header('Access-Control-Allow-Origin', '*')
  9.   res.header('Access-Control-Allow-Headers', 'X-Requested-With')
  10.   res.header('Access-Control-Allow-Headers', 'Content-Type, Content-Length, Authorization, Accept, X-Requested-With, X_Requested_With')
  11.   res.header('Access-Control-Allow-Methods', 'PUT, POST, GET, DELETE, OPTIONS')
  12.   res.header('X-Powered-By', '3.2.1')
  13.   if (req.method == 'OPTIONS') res.send(200)
  14.   /*让options请求快速返回*/ else next()
  15. })
  16.  
  17.  
  18.  
  19. app.use(bodyParser.urlencoded({ extended: false }))
  20. app.use(bodyParser.json())
  21.  
  22.  
  23. app.use(router)
  24.  
  25. app.listen('3000', () => {
  26.   console.log('Server is running');
  27. })

2.数据库连接信息设置

host：连接地址

user：数据库用户名

password：数据库密码

database：数据库名称

创建数据连接的js工具类（以下为部分代码，整个项目请点击文尾连接下载）

  1. var mysql = require('mysql')
  2.  
  3. var mysql_config = {
  4.  
  5.   host: 'localhost',
  6.  
  7.   user: 'root',
  8.  
  9.   password: '123456',
  10.  
  11.   database: 'healthcheck'
  12.  
  13. }
  14.  
  15. function handleDisconnection() {
  16.  
  17.   var dbServer = mysql.createConnection(mysql_config)
  18.  
  19.   dbServer.connect(function (err) {
  20.     console.log('数据库链接成功')
  21.     if (err) {
  22.  
  23.       setTimeout(handleDisconnection, 2000)
  24.  
  25.     }
  26.  
  27.   })
  28.  
  29.   dbServer.on('error', function (err) {
  30.  
  31.     console.log('db error', err)
  32.  
  33.     if (err.code === 'PROTOCOL_CONNECTION_LOST') {
  34.  
  35.       console.log('db error执行重连:' + err.message)
  36.  
  37.       handleDisconnection()
  38.  
  39.     } else {
  40.  
  41.       throw err
  42.  
  43.     }
  44.  
  45.   })
  46.  
  47.   return dbServer //返回一个connection对象，用于调用它的其他方法
  48.  
  49.   exports.dbServer = dbServer
  50.  
  51. }
  52.  
  53. exports.handleDisconnection = handleDisconnection

3.功能接口

感觉跟java的jdbc差不多也是创建连接对象然后再去执行sql语句，最后再获取返回结果（以下为部分代码，整个项目请点击文尾连接下载）

  1. const express = require('express')
  2. const con = require('../modul/db.js')
  3.  
  4. const router = express.Router()
  5.  
  6. let db= con.handleDisconnection()
  7.  
  8. //====================================================================
  9. //====================================================================
  10. //首页当天查询
  11. router.get('/getToay', (req, res) => {
  12.   let sql = "select (select count(*) from record as r where r.cid = c.cid and date(r.time) = curdate()) as count,c.* from combo as c  ";
  13.   db.query({
  14.     sql: sql
  15.   }, (err, results, fields) => {
  16.     res.send(results)
  17.   })
  18. })
  19. //近7天查询
  20. router.get('/getWeek', (req, res) => {
  21.   let sql = "select (select count(*) from record as r where r.cid = c.cid and DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= date(r.time)) as count,c.* from combo as c  ";
  22.   db.query({
  23.     sql: sql
  24.   }, (err, results, fields) => {
  25.     res.send(results)
  26.   })
  27. })
  28. //近30天查询
  29. router.get('/getMonth', (req, res) => {
  30.   let sql = "select (select count(*) from record as r where r.cid = c.cid and DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= date(r.time)) as count,c.* from combo as c   ";
  31.   db.query({
  32.     sql: sql
  33.   }, (err, results, fields) => {
  34.     res.send(results)
  35.   })
  36. })
  37. //今年查询
  38. router.get('/getYear', (req, res) => {
  39.   let sql = "select (select count(*) from record as r where r.cid = c.cid and YEAR(r.time)=YEAR(NOW())) as count,c.* from combo as c  ";
  40.   db.query({
  41.     sql: sql
  42.   }, (err, results, fields) => {
  43.     res.send(results)
  44.   })
  45. })
  46. //====================================================================
  47. //====================================================================
  48.  
  49. //登录
  50. router.get('/login', (req, res) => {
  51.   let account = req.query.account //账号
  52.   let password = req.query.password //密码
  53.   let sql = "select * from `user` where account = '"+account+"' and `password` = '"+password+"';";
  54.   db.query({
  55.     sql: sql
  56.   }, (err, results, fields) => {
  57.     res.send(results)
  58.   })
  59. })
  60.  
  61. //注册用户
  62. router.post('/register', (req, res) => {
  63.   // let dat = new Date
  64.   let sql = "INSERT INTO `user`(account,`password`,`time`,`status`) "+ 
  65.   "VALUES ('"+req.body.account+"', '"+req.body.password+"', '"+req.body.time+"','1')";
  66.  
  67.   db.query(sql, (err, result) => {
  68.     if (err) {
  69.       console.log("错误信息",err)
  70.     } else {
  71.       //获取用户编号
  72.       var uid = result.insertId;
  73.       //新增用户角色表
  74.       let sql = "INSERT INTO `userrole`(rid,uid) VALUES ('3', '"+uid+"')";
  75.       db.query(sql, (err, result) => {
  76.         if (err) {
  77.           console.log("错误信息",err)
  78.         } else {
  79.           res.json({
  80.             code: 200
  81.           })
  82.         }
  83.       })
  84.     }
  85.   })
  86. })
  87.  
  88. //====================================================================
  89. //====================================================================
  90.  
  91. //根据用户编号查询root节点
  92. router.get('/rootMeun', (req, res) => {
  93.   let uid = req.query.uid //用户编号
  94.   let sql = "select * from `user` as u "+
  95.   "inner join userrole as ur on ur.uid = u.uid "+
  96.   "inner join role as r on ur.rid=r.rid "+
  97.   "inner join menurole as mr on mr.rid=r.rid "+
  98.   "inner join menu as m on mr.mid=m.mid "+
  99.   "where u.uid = '"+uid+"' and m.pid = '0'";
  100.   db.query({
  101.     sql: sql,
  102.     nestTables:'_'
  103.   },function(err,result){
  104.     res.send(result)
  105.   })
  106. })
  107. //根据root节点查询子节点
  108. router.get('/childrenMeun', (req, res) => {
  109.   let mid = req.query.mid //root菜单编号
  110.   let sql = "select * from `menu` where pid = '"+mid+"';";
  111.   db.query({
  112.     sql: sql
  113.   }, (err, results, fields) => {
  114.     res.send(results)
  115.   })
  116. })
  117.  
  118. //====================================================================
  119. //====================================================================
  120. //新增用户
  121. router.post('/addUser', (req, res) => {
  122.   let sql = "INSERT INTO `user`(account,`password`,`name`,`number`,`gender`,`phone`,`address`,`age`,`time`,`status`) "+ 
  123.   "VALUES ('"+req.body.account+"', '"+req.body.password+"','"+req.body.name+"','"+req.body.number+"','"+req.body.gender+"','"+req.body.phone+"','"+req.body.address+"','"+req.body.age+"', '"+req.body.time+"','"+req.body.status+"')";
  124.  
  125.   db.query(sql, (err, result) => {
  126.     if (err) {
  127.       console.log("错误信息",err)
  128.     } else {
  129.       //获取用户编号
  130.       var uid = result.insertId;
  131.       //获取角色编号
  132.       var rid = req.body.backup;
  133.       //新增用户角色表
  134.       let sql = "INSERT INTO `userrole`(rid,uid) VALUES ('"+rid+"', '"+uid+"')";
  135.       db.query(sql, (err, result) => {
  136.         if (err) {
  137.           console.log("错误信息",err)
  138.         } else {
  139.           res.json({
  140.             code: 200
  141.           })
  142.         }
  143.       })
  144.     }
  145.   })
  146. })
  147.  
  148. // 删除用户
  149. router.get('/delUser', (req, res) => {
  150.   let uid = req.query.uid;
  151.   let sql = "DELETE FROM `user` WHERE uid = '"+uid+"'";
  152.   db.query(sql, (err, result) => {
  153.     if (err) {
  154.       console.log(err)
  155.     } else {
  156.       res.json({
  157.         code: 200
  158.       })
  159.     }
  160.   })
  161. })
  162. //修改用户
  163. router.post('/updateUser', (req, res) => {
  164.   //获取用户编号
  165.   let uid = req.body.uid;
  166.   //获取角色编号
  167.   let rid = req.body.rid;
  168.   let sql = "UPDATE `user` SET "+
  169.             "account = '"+req.body.account+"',"+
  170.             "password = '"+req.body.password+"',"+
  171.             "name = '"+req.body.name+"',"+
  172.             "number = '"+req.body.number+"',"+
  173.             "gender = '"+req.body.gender+"',"+
  174.             "phone = '"+req.body.phone+"',"+
  175.             "address = '"+req.body.address+"',"+
  176.             "age = '"+req.body.age+"',"+
  177.             "status = '"+req.body.status+"'"+
  178.             "WHERE uid = '"+uid+"'";
  179.   db.query(sql, (err, result) => {
  180.     if (err) {
  181.       console.log("错误信息1",err)
  182.     } else {
  183.       if(''!=rid){
  184.         //修改用户角色表
  185.         let sql = "UPDATE `userrole` SET "+
  186.                   "rid = '"+rid+"'"+
  187.                   "WHERE uid = '"+uid+"'";
  188.         db.query(sql, (err, result) => {
  189.           if (err) {
  190.             console.log("错误信息2",err)
  191.           } else {
  192.             res.json({
  193.               code: 200
  194.             })
  195.           }
  196.         })
  197.       }else{
  198.         res.json({
  199.           code: 200
  200.         })
  201.       }
  202.       
  203.     }
  204.   })
  205. })
  206. //查询所有用户
  207. router.get('/queryUser', (req, res) => {
  208.   let sql = "select r.rname as rname,u.* from `user` as u "+
  209.             "inner join userrole as ur on ur.uid = u.uid "+
  210.             "inner join role as r on ur.rid=r.rid;"
  211.   db.query({
  212.     sql: sql
  213.   }, (err, results, fields) => {
  214.     res.send(results)
  215.   })
  216. })
  217. //分页查询所有用户
  218. router.get('/queryUserPage', (req, res) => {
  219.     //模糊查询用户名称
  220.     let input = req.query.input;
  221.       //模糊查询用户地址
  222.     let address = req.query.address;
  223.     //模糊查询用户角色
  224.     let option = req.query.option;
  225.       //模糊查询用户状态
  226.     let status = req.query.status;
  227.  
  228.   //默认页码
  229.   let currentPage = 1;
  230.   //默认显示数据条数
  231.   let pageSize = 8;
  232.   if(req.query.currentPage){
  233.     currentPage = req.query.currentPage;
  234.   }
  235.   if(req.query.pageSize){
  236.     pageSize = req.query.pageSize;
  237.   }
  238.   //最后一页页码
  239.   let last_page = currentPage-1;
  240.   if(currentPage<=1){
  241.     last_page = 1;
  242.   }
  243.   console.log("当前页",currentPage);
  244.  
  245.   let total = 0;
  246.   //查询总条数
  247.   let sql = "select r.rname as rname,u.* from `user` as u "+
  248.             "inner join userrole as ur on ur.uid = u.uid "+
  249.             "inner join role as r on ur.rid=r.rid where 1=1 "
  250.             if(input!='' && input!=undefined){
  251.               sql += "and u.name like '%"+input+"%' ";
  252.             }
  253.             if(address!='' && address!=undefined){
  254.               sql += "and u.address like '%"+address+"%' ";
  255.             }
  256.             if(option!='' && option!=undefined){
  257.               sql += "and r.rid = '"+option+"' ";
  258.             }
  259.             if(status!='' && status!=undefined){
  260.               sql += "and u.status = '"+status+"' ";
  261.             }
  262.   console.log(sql);
  263.   db.query({
  264.     sql: sql
  265.   }, (err, results, fields) => {
  266.  
  267.     console.log(results.length)
  268.     total = results.length;
  269.     currentPage = (currentPage - 1 ) * pageSize;
  270.     let sql2 = sql+"limit "+currentPage+","+pageSize+"";
  271.     db.query({
  272.       sql: sql2
  273.     }, (err, results, fields) => {
  274.       console.log(results)
  275.       if(results!=''){
  276.         results[0].backup3 = total;
  277.       }
  278.       res.send(results)
  279.     })
  280.   })
  281. })
  282. //根据ID查询用户
  283. router.get('/queryUserById', (req, res) => {
  284.   let uid = req.query.uid;
  285.   let sql = "select r.rname as rname,r.rid as rid,u.* from `user` as u "+
  286.   "inner join userrole as ur on ur.uid = u.uid "+
  287.   "inner join role as r on ur.rid=r.rid where u.uid = '"+uid+"'";
  288.   db.query({
  289.     sql: sql
  290.   }, (err, results, fields) => {
  291.     console.log(results);
  292.     res.send(results)
  293.   })
  294. })
  295. //====================================================================
  296. //====================================================================
  297. //新增角色
  298. router.post('/addRole', (req, res) => {
  299.   let backup = req.body.pid;
  300.   let sql = "INSERT INTO `role`(rname,`desc`) "+ 
  301.   "VALUES ('"+req.body.rname+"', '"+req.body.desc+"')";
  302.  
  303.   db.query(sql, (err, result) => {
  304.     if (err) {
  305.       console.log("错误信息",err)
  306.     } else {
  307.       //判断新增是不是父节点
  308.         res.json({
  309.           code: 200
  310.         })
  311.     }
  312.   })
  313. })
  314. //查询所有角色
  315. router.get('/queryRole', (req, res) => {
  316.   let sql = "select * from `role`;";
  317.   db.query({
  318.     sql: sql
  319.   }, (err, results, fields) => {
  320.     res.send(results)
  321.   })
  322. })
  323. //分页查询所有角色
  324. router.get('/queryRolePage', (req, res) => {
  325.   //默认页码
  326.   let currentPage = 1;
  327.   //默认显示数据条数
  328.   let pageSize = 9;
  329.   if(req.query.currentPage){
  330.     currentPage = req.query.currentPage;
  331.   }
  332.   if(req.query.pageSize){
  333.     pageSize = req.query.pageSize;
  334.   }
  335.   //最后一页页码
  336.   let last_page = currentPage-1;
  337.   if(currentPage<=1){
  338.     last_page = 1;
  339.   }
  340.   console.log("当前页",currentPage);
  341.  
  342.   let total = 0;
  343.   //查询总条数
  344.   let sql = "select * from role";
  345.   console.log(sql);
  346.   db.query({
  347.     sql: sql
  348.   }, (err, results, fields) => {
  349.  
  350.     console.log(results.length)
  351.     total = results.length;
  352.     currentPage = (currentPage - 1 ) * pageSize;
  353.     let sql2 = "select * from role "+
  354.                "limit "+currentPage+","+pageSize+" ";
  355.     db.query({
  356.       sql: sql2
  357.     }, (err, results, fields) => {
  358.       console.log(err);
  359.       console.log("这是sql2",sql2)
  360.       if(results!=''){
  361.         results[0].backup3 = total;
  362.       }
  363.       res.send(results)
  364.     })
  365.   })
  366. })
  367. // 删除角色
  368. router.get('/delRole', (req, res) => {
  369.   let rid = req.query.rid;
  370.   let sql = "DELETE FROM `role` WHERE rid = '"+rid+"'";
  371.   db.query(sql, (err, result) => {
  372.     if (err) {
  373.       console.log(err)
  374.     } else {
  375.       res.json({
  376.         code: 200
  377.       })
  378.     }
  379.   })
  380. })
  381. //修改角色
  382. router.post('/updateRole', (req, res) => {
  383.   //获取角色编号
  384.   let rid = req.body.rid;
  385.   let sql = "UPDATE `role` SET "+
  386.             "rname = '"+req.body.rname+"',"+
  387.             "`desc` = '"+req.body.desc+"' "+
  388.             "WHERE rid = '"+rid+"'";
  389.   db.query(sql, (err, result) => {
  390.     if (err) {
  391.       console.log("错误信息1",err)
  392.     } else {
  393.       res.json({
  394.         code: 200
  395.       })
  396.     }
  397.   })
  398. })
  399. //根据ID查询角色
  400. router.get('/queryRoleById', (req, res) => {
  401.   let rid = req.query.rid;
  402.   let sql = "select * from role "+
  403.   "where rid = '"+rid+"'";
  404.   db.query({
  405.     sql: sql
  406.   }, (err, results, fields) => {
  407.     console.log(results);
  408.     res.send(results)
  409.   })
  410. })
  411. //根据角色编号查询出他所有的父菜单
  412. router.get('/queryMenuByRid', (req, res) => {
  413.   let rid = req.query.rid;
  414.   let sql = "select m.mid as mid from menu as m "+
  415.   "inner join menurole as mr on m.mid=mr.mid  "+
  416.   "where mr.rid = '"+rid+"' and  m.pid = '0' ";
  417.   db.query({
  418.     sql: sql
  419.   }, (err, results, fields) => {
  420.     console.log(results);
  421.     res.send(results)
  422.   })
  423. })
  424. //新增角色对应菜单
  425. router.get('/addRoleMenu', (req, res) => {
  426.   let sql = "INSERT INTO `menurole`(rid,mid) "+ 
  427.   "VALUES ('"+req.query.rid+"', '"+req.query.mid+"' )";
  428.  
  429.   db.query(sql, (err, result) => {
  430.     if (err) {
  431.       console.log("错误信息",err)
  432.     } else {
  433.         res.json({
  434.           code: 200
  435.         })
  436.     }
  437.   })
  438. })
  439. // 删除角色对应菜单
  440. router.get('/delRoleMenu', (req, res) => {
  441.   let rid = req.query.rid;
  442.   let sql = "DELETE FROM `menurole` WHERE rid = '"+rid+"'";
  443.   db.query(sql, (err, result) => {
  444.     if (err) {
  445.       console.log(err)
  446.     } else {
  447.       res.json({
  448.         code: 200
  449.       })
  450.     }
  451.   })
  452. })
  453. //====================================================================
  454. //====================================================================
  455. //新增菜单
  456. router.post('/addMenu', (req, res) => {
  457.   let backup = req.body.pid;
  458.   let sql = "INSERT INTO `menu`(mname,pid,url) "+ 
  459.   "VALUES ('"+req.body.mname+"', '"+req.body.pid+"','"+req.body.url+"' )";
  460.  
  461.   db.query(sql, (err, result) => {
  462.     if (err) {
  463.       console.log("错误信息",err)
  464.     } else {
  465.       //判断新增是不是父节点
  466.         res.json({
  467.           code: 200
  468.         })
  469.     }
  470.   })
  471. })
  472. // 删除菜单
  473. router.get('/delMenu', (req, res) => {
  474.   let mid = req.query.mid;
  475.   let sql = "DELETE FROM `menu` WHERE mid = '"+mid+"'";
  476.   db.query(sql, (err, result) => {
  477.     if (err) {
  478.       console.log(err)
  479.     } else {
  480.       res.json({
  481.         code: 200
  482.       })
  483.     }
  484.   })
  485. })
  486. //修改菜单
  487. router.post('/updateMenu', (req, res) => {
  488.   //获取菜单编号
  489.   let mid = req.body.mid;
  490.   let sql = "UPDATE `menu` SET "+
  491.             "mname = '"+req.body.mname+"',"+
  492.             "url = '"+req.body.url+"' "+
  493.             "WHERE mid = '"+mid+"'";
  494.   db.query(sql, (err, result) => {
  495.     if (err) {
  496.       console.log("错误信息1",err)
  497.     } else {
  498.       res.json({
  499.         code: 200
  500.       })
  501.     }
  502.   })
  503. })
  504. //查询所有父级菜单
  505. router.get('/queryMenu', (req, res) => {
  506.   let sql = "select * from `menu` where pid ='0'";
  507.   db.query({
  508.     sql: sql
  509.   }, (err, results, fields) => {
  510.     res.send(results)
  511.   })
  512. })
  513. //根据ID查询菜单
  514. router.get('/queryMenuById', (req, res) => {
  515.   let mid = req.query.mid;
  516.   let sql = "select * from menu "+
  517.   "where mid = '"+mid+"'";
  518.   db.query({
  519.     sql: sql
  520.   }, (err, results, fields) => {
  521.     console.log(results);
  522.     res.send(results)
  523.   })
  524. })
  525. //分页查询所有菜单
  526. router.get('/queryMenuPage', (req, res) => {
  527.   //默认页码
  528.   let currentPage = 1;
  529.   //默认显示数据条数
  530.   let pageSize = 9;
  531.   if(req.query.currentPage){
  532.     currentPage = req.query.currentPage;
  533.   }
  534.   if(req.query.pageSize){
  535.     pageSize = req.query.pageSize;
  536.   }
  537.   //最后一页页码
  538.   let last_page = currentPage-1;
  539.   if(currentPage<=1){
  540.     last_page = 1;
  541.   }
  542.   console.log("当前页",currentPage);
  543.  
  544.   let total = 0;
  545.   //查询总条数
  546.   let sql = "select * from menu";
  547.   console.log(sql);
  548.   db.query({
  549.     sql: sql
  550.   }, (err, results, fields) => {
  551.  
  552.     console.log(results.length)
  553.     total = results.length;
  554.     currentPage = (currentPage - 1 ) * pageSize;
  555.     let sql2 = "select * from menu "+
  556.                "limit "+currentPage+","+pageSize+" ";
  557.     db.query({
  558.       sql: sql2
  559.     }, (err, results, fields) => {
  560.       console.log(err);
  561.       console.log("这是sql2",sql2)
  562.       if(results!=''){
  563.         results[0].backup3 = total;
  564.       }
  565.       res.send(results)
  566.     })
  567.   })
  568. })
  569. //====================================================================
  570. //====================================================================
  571. //新增项目
  572. router.post('/addProject', (req, res) => {
  573.   let sql = "INSERT INTO `project`(pname,`sage`,`sgender`,`type`,`department`) "+ 
  574.   "VALUES ('"+req.body.pname+"', '"+req.body.sage+"','"+req.body.sgender+"','"+req.body.type+"','"+req.body.department+"')";
  575.  
  576.   db.query(sql, (err, result) => {
  577.     if (err) {
  578.       console.log("错误信息",err)
  579.     } else {
  580.       res.json({
  581.         code: 200
  582.       })
  583.     }
  584.   })
  585. })
  586. // 删除项目
  587. router.get('/delProject', (req, res) => {
  588.   let pid = req.query.pid;
  589.   let sql = "DELETE FROM `project` WHERE pid = '"+pid+"'";
  590.   db.query(sql, (err, result) => {
  591.     if (err) {
  592.       console.log(err)
  593.     } else {
  594.       res.json({
  595.         code: 200
  596.       })
  597.     }
  598.   })
  599. })
  600. //修改项目
  601. router.post('/updateProject', (req, res) => {
  602.   //获取项目编号
  603.   let pid = req.body.pid;
  604.   let sql = "UPDATE `project` SET "+
  605.             "pname = '"+req.body.pname+"',"+
  606.             "sage = '"+req.body.sage+"',"+
  607.             "type = '"+req.body.type+"',"+
  608.             "department = '"+req.body.department+"',"+
  609.             "sgender = '"+req.body.sgender+"' "+
  610.             "WHERE pid = '"+pid+"'";
  611.   db.query(sql, (err, result) => {
  612.     if (err) {
  613.       console.log("错误信息1",err)
  614.     } else {
  615.       res.json({
  616.         code: 200
  617.       })
  618.     }
  619.   })
  620. })
  621. //查询所有项目
  622. router.get('/queryProject', (req, res) => {
  623.   let sql = "select * from project";
  624.   db.query({
  625.     sql: sql
  626.   }, (err, results, fields) => {
  627.     res.send(results)
  628.   })
  629. })
  630. //根据ID查询项目
  631. router.get('/queryProjectById', (req, res) => {
  632.   let pid = req.query.pid;
  633.   let sql = "select * from project "+
  634.   "where pid = '"+pid+"'";
  635.   db.query({
  636.     sql: sql
  637.   }, (err, results, fields) => {
  638.     console.log(results);
  639.     res.send(results)
  640.   })
  641. })
  642. //分页查询所有项目
  643. router.get('/queryProjectPage', (req, res) => {
  644.   //模糊查询项目名称
  645.   let pname = req.query.pname;
  646.   //默认页码
  647.   let currentPage = 1;
  648.   //默认显示数据条数
  649.   let pageSize = 9;
  650.   if(req.query.currentPage){
  651.     currentPage = req.query.currentPage;
  652.   }
  653.   if(req.query.pageSize){
  654.     pageSize = req.query.pageSize;
  655.   }
  656.   //最后一页页码
  657.   let last_page = currentPage-1;
  658.   if(currentPage<=1){
  659.     last_page = 1;
  660.   }
  661.   console.log("当前页",currentPage);
  662.  
  663.   let total = 0;
  664.   //查询总条数
  665.   let sql = "select * from project where 1=1 ";
  666.   if(pname!="" && pname!=undefined){
  667.     sql += "and pname like '%"+pname+"%' ";
  668.   }
  669.   console.log(sql);
  670.   db.query({
  671.     sql: sql
  672.   }, (err, results, fields) => {
  673.  
  674.     console.log(results.length)
  675.     total = results.length;
  676.     currentPage = (currentPage - 1 ) * pageSize;
  677.     let sql2 = "select * from project where 1=1 ";
  678.     if(pname!="" || pname!=undefined || pname!="undefined"){
  679.       sql2 += "and pname like '%"+pname+"%'";
  680.     }
  681.     sql2 += "limit "+currentPage+","+pageSize+" ";
  682.     db.query({
  683.       sql: sql2
  684.     }, (err, results, fields) => {
  685.       console.log(err);
  686.       console.log("这是sql2",sql2)
  687.       if(results!=''){
  688.         results[0].backup3 = total;
  689.       }
  690.       res.send(results)
  691.     })
  692.   })
  693. })
  694.  
  695. //====================================================================
  696. //====================================================================
  697. //新增套餐
  698. router.post('/addCombo', (req, res) => {
  699.   let sql = "INSERT INTO `combo`(`cname`,`sage`,`sgender`,`meaning`,`start`,`stop`)  "+ 
  700.   "VALUES ('"+req.body.cname+"', '"+req.body.sage+"', '"+req.body.sgender+"', '"+req.body.meaning+"', '"+req.body.start+"', '"+req.body.stop+"')";
  701.  
  702.   db.query(sql, (err, result) => {
  703.     if (err) {
  704.       console.log("错误信息",err)
  705.     } else {
  706.         res.json({
  707.           code: 200
  708.         })
  709.     }
  710.   })
  711. })
  712. //查询所有套餐
  713. router.get('/queryCombo', (req, res) => {
  714.   let sql = "select * from `combo`;";
  715.   db.query({
  716.     sql: sql
  717.   }, (err, results, fields) => {
  718.     res.send(results)
  719.   })
  720. })
  721. //分页查询所有套餐
  722. router.get('/queryComboPage', (req, res) => {
  723.   //模糊查询套餐名称
  724.   let input = req.query.input;
  725.     //模糊查询起始结束时间
  726.   let start = req.query.start;
  727.   let stops = req.query.stop;
  728.   //默认页码
  729.   let currentPage = 1;
  730.   //默认显示数据条数
  731.   let pageSize = 9;
  732.   if(req.query.currentPage){
  733.     currentPage = req.query.currentPage;
  734.   }
  735.   if(req.query.pageSize){
  736.     pageSize = req.query.pageSize;
  737.   }
  738.   //最后一页页码
  739.   let last_page = currentPage-1;
  740.   if(currentPage<=1){
  741.     last_page = 1;
  742.   }
  743.   console.log("当前页",currentPage);
  744.  
  745.   let total = 0;
  746.   //查询总条数
  747.   let sql = "select * from combo where 1=1 ";
  748.             if(input!='' && input!=undefined){
  749.               sql += "and cname like '%"+input+"%' ";
  750.             }
  751.             if(start!='' && start!=undefined || stops!='' && stops!=undefined){
  752.               sql += "and `start` Between '"+start+"' AND '"+stops+"' and `stop` Between '"+start+"' AND '"+stops+"' ";
  753.             }
  754.   console.log(sql);
  755.   db.query({
  756.     sql: sql
  757.   }, (err, results, fields) => {
  758.  
  759.     console.log(results.length)
  760.     total = results.length;
  761.     currentPage = (currentPage - 1 ) * pageSize;
  762.     let sql2 = sql+"limit "+currentPage+","+pageSize+" ";
  763.     db.query({
  764.       sql: sql2
  765.     }, (err, results, fields) => {
  766.       console.log(err);
  767.       console.log("这是sql2",sql2)
  768.       if(results!=''){
  769.         results[0].backup3 = total;
  770.       }
  771.       // res.send(results)
  772.       var haha = results;
  773.       for(var i =0;i<results.length;i++){
  774.         var a =0;
  775.           //根据套餐ID查询对应的项目
  776.         var sqlp = "select * from project as p inner join cp on p.pid=cp.pid "+
  777.         "where cp.cid = '"+results[i].cid+"'";
  778.         db.query({
  779.           sql: sqlp
  780.         }, (err, resul, fields) => {
  781.           // haha[i].backup = resul;
  782.           for(var j =0;j<resul.length;j++){
  783.             results[a].backup = resul;
  784.           }
  785.           a++;
  786.         })
  787.       }
  788.       console.log(results);
  789.       res.send(results)
  790.  
  791.       
  792.     })
  793.   })
  794. })
  795. // 删除套餐
  796. router.get('/delCombo', (req, res) => {
  797.   let cid = req.query.cid;
  798.   let sql = "DELETE FROM `combo` WHERE cid = '"+cid+"'";
  799.   db.query(sql, (err, result) => {
  800.     if (err) {
  801.       console.log(err)
  802.     } else {
  803.       res.json({
  804.         code: 200
  805.       })
  806.     }
  807.   })
  808. })
  809. //修改套餐
  810. router.post('/updateCombo', (req, res) => {
  811.   //获取套餐编号
  812.   let cid = req.body.cid;
  813.   let sql = "UPDATE `combo` SET "+
  814.             "cname = '"+req.body.cname+"',"+
  815.             "sage = '"+req.body.sage+"',"+
  816.             "sgender = '"+req.body.sgender+"',"+
  817.             "meaning = '"+req.body.meaning+"',"+
  818.             "start = '"+req.body.start+"',"+
  819.             "`stop` = '"+req.body.stop+"' "+
  820.             "WHERE cid = '"+cid+"'";
  821.   db.query(sql, (err, result) => {
  822.     if (err) {
  823.       console.log("错误信息1",err)
  824.     } else {
  825.       res.json({
  826.         code: 200
  827.       })
  828.     }
  829.   })
  830. })
  831. //根据ID查询套餐
  832. router.get('/queryComboById', (req, res) => {
  833.   let cid = req.query.cid;
  834.   let sql = "select * from combo "+
  835.   "where cid = '"+cid+"'";
  836.   db.query({
  837.     sql: sql
  838.   }, (err, results, fields) => {
  839.     console.log(results);
  840.     res.send(results)
  841.   })
  842. })
  843. //根据套餐编号查询出他所有的项目
  844. router.get('/queryProjectByCid', (req, res) => {
  845.   let cid = req.query.cid;
  846.   let sql = "select p.pid as pid,p.pname as pname from project as p "+
  847.   "inner join cp on cp.pid=p.pid  "+
  848.   "where cp.cid = '"+cid+"' ";
  849.   console.log(sql);
  850.   db.query({
  851.     sql: sql
  852.   }, (err, results, fields) => {
  853.     console.log(results);
  854.     res.send(results)
  855.   })
  856. })
  857. //新增套餐对应项目
  858. router.get('/addcp', (req, res) => {
  859.   let sql = "INSERT INTO `cp`(cid,pid) "+ 
  860.   "VALUES ('"+req.query.cid+"', '"+req.query.pid+"' )";
  861.  
  862.   db.query(sql, (err, result) => {
  863.     if (err) {
  864.       console.log("错误信息",err)
  865.     } else {
  866.         res.json({
  867.           code: 200
  868.         })
  869.     }
  870.   })
  871. })
  872. // 删除套餐对应项目
  873. router.get('/delcp', (req, res) => {
  874.   let cid = req.query.cid;
  875.   let sql = "DELETE FROM `cp` WHERE cid = '"+cid+"'";
  876.   db.query(sql, (err, result) => {
  877.     if (err) {
  878.       console.log(err)
  879.     } else {
  880.       res.json({
  881.         code: 200
  882.       })
  883.     }
  884.   })
  885. })
  886. //====================================================================
  887. //====================================================================
  888. //分页查询所有记录
  889. router.get('/queryRecordPage', (req, res) => {
  890.   //查询记录状态
  891.   let status = req.query.status;
  892.     //模糊查询起始结束时间
  893.   let start = req.query.start;
  894.   let stops = req.query.stop;
  895.   //默认页码
  896.   let currentPage = 1;
  897.   //默认显示数据条数
  898.   let pageSize = 10;
  899.   if(req.query.currentPage){
  900.     currentPage = req.query.currentPage;
  901.   }
  902.   if(req.query.pageSize){
  903.     pageSize = req.query.pageSize;
  904.   }
  905.   //最后一页页码
  906.   let last_page = currentPage-1;
  907.   if(currentPage<=1){
  908.     last_page = 1;
  909.   }
  910.   console.log("当前页",currentPage);
  911.  
  912.   let total = 0;
  913.   //查询总条数
  914.   let sql = "select r.reid as reid,u.uid as uid,u.`name` as uname,u.phone as phone,u.gender as gender,c.cname as cname,c.`start`,c.`stop`,r.`status` as `status`,r.time as time from record as r "+
  915.             "inner join `user` as u on r.uid=u.uid "+
  916.             "inner join combo as c on r.cid=c.cid where 1=1 ";
  917.  
  918.             
  919.             if(status!='' && status!=undefined){
  920.               sql += "and r.status = '"+status+"' ";
  921.             }
  922.             if(start!='' && start!=undefined || stops!='' && stops!=undefined){
  923.               sql += "and r.time Between '"+start+"' AND '"+stops+"' ";
  924.             }
  925.   console.log(sql);
  926.   db.query({
  927.     sql: sql
  928.   }, (err, results, fields) => {
  929.  
  930.     console.log(results.length)
  931.     total = results.length;
  932.     currentPage = (currentPage - 1 ) * pageSize;
  933.     let sql2 = sql +="limit "+currentPage+","+pageSize+" ";
  934.     db.query({
  935.       sql: sql2
  936.     }, (err, results, fields) => {
  937.       console.log(err);
  938.       console.log("这是sql2",sql2)
  939.       if(results!=''){
  940.         results[0].backup3 = total;
  941.       }
  942.       res.send(results)
  943.     })
  944.   })
  945. })
  946. //根据ID查询记录
  947. router.get('/queryRecordById', (req, res) => {
  948.   let reid = req.query.reid;
  949.   let sql = "select r.reid as reid,u.uid as uid,u.`name` as uname,u.phone as phone,u.gender as gender,c.cname as cname,c.`start`,c.`stop`,r.`status` as `status`,r.time as time from record as r "+
  950.             "inner join `user` as u on r.uid=u.uid "+
  951.             "inner join combo as c on r.cid=c.cid "+
  952.             "where r.reid = '"+reid+"'";
  953.   db.query({
  954.     sql: sql
  955.   }, (err, results, fields) => {
  956.     console.log(results);
  957.     res.send(results)
  958.   })
  959. })
  960.  
  961. //根据用户ID查询记录
  962. router.get('/queryRecordById', (req, res) => {
  963.   let uid = req.query.uid;
  964.   let sql = "select r.reid as reid,u.uid as uid,u.`name` as uname,u.phone as phone,u.gender as gender,c.cname as cname,c.`start`,c.`stop`,r.`status` as `status`,r.time as time from record as r "+
  965.             "inner join `user` as u on r.uid=u.uid "+
  966.             "inner join combo as c on r.cid=c.cid "+
  967.             "where u.uid = '"+uid+"'";
  968.   db.query({
  969.     sql: sql
  970.   }, (err, results, fields) => {
  971.     console.log(results);
  972.     res.send(results)
  973.   })
  974. })
  975.  
  976. //修改记录
  977. router.post('/updateRecord', (req, res) => {
  978.   //获取记录编号
  979.   let reid = req.body.reid;
  980.   let sql = "UPDATE `record` SET "+
  981.             "time = '"+req.body.time+"',"+
  982.             "status = '"+req.body.status+"' "+
  983.             "WHERE reid = '"+reid+"'";
  984.   db.query(sql, (err, result) => {
  985.     if (err) {
  986.       console.log("错误信息1",err)
  987.     } else {
  988.       res.json({
  989.         code: 200
  990.       })
  991.     }
  992.   })
  993. })
  994.  
  995. //新增预约记录
  996. router.post('/addRecords', (req, res) => {
  997.   //获取用户编号
  998.   let uid = req.body.uid;
  999.   console.log(uid);
  1000.   let usql = "select * from `user` where uid = '"+uid+"' and `name` <> ''  and `number` <> ''  and `gender` <> ''  and `phone` <> ''  and `address` <> ''  and `age` <> ''";
  1001.  
  1002.  
  1003.   let sql = "INSERT INTO `rotation`(`roname`,`rourl`,`describe`,`status`) "+ 
  1004.   "VALUES ('"+req.body.roname+"', '"+req.body.rourl+"','"+req.body.describe+"','"+req.body.status+"' )";
  1005.  
  1006.  
  1007.   db.query({
  1008.     usql: usql
  1009.   }, (err, results, fields) => {
  1010.     console.log(results);
  1011.     res.send(results)
  1012.   })
  1013.   // db.query(sql, (err, result) => {
  1014.   //   if (err) {
  1015.   //     console.log("错误信息",err)
  1016.   //   } else {
  1017.   //       res.json({
  1018.   //         code: 200
  1019.   //       })
  1020.   //   }
  1021.   // })
  1022. })
  1023. //新增预约记录
  1024. router.get('/addRecord', (req, res) => {
  1025.   //获取用户编号
  1026.   let uid = req.body.uid;
  1027.   //获取套餐编号
  1028.   let cid = req.body.cid;
  1029.   //获取时间
  1030.   let time = req.body.time;
  1031.   let sql = "select * from `user` where uid = '"+uid+"' and `name` <> ''  and `number` <> ''  and `gender` <> ''  and `phone` <> ''  and `address` <> ''  and `age` <> ''";
  1032.   db.query({
  1033.     sql: sql
  1034.   }, (err, results, fields) => {
  1035.     console.log(results);
  1036.     if(results.length<=0){
  1037.       res.send("请先去完善个人信息")
  1038.     }else{
  1039.       let sqls = "INSERT INTO `record`(`uid`,`cid`,`status`,`time`) "+ 
  1040.       "VALUES ('"+uid+"', '"+cid+"', '2', '"+time+"' )";
  1041.     
  1042.       db.query(sqls, (err, result) => {
  1043.         if (err) {
  1044.           console.log("错误信息",err)
  1045.         } else {
  1046.             res.json({
  1047.               code: 200
  1048.             })
  1049.         }
  1050.       })
  1051.     }
  1052.   })
  1053. })
  1054.  
  1055. // 删除记录
  1056. router.get('/delRecord', (req, res) => {
  1057.   let reid = req.query.reid;
  1058.   let sql = "DELETE FROM `record` WHERE reid = '"+reid+"'";
  1059.   db.query(sql, (err, result) => {
  1060.     if (err) {
  1061.       console.log(err)
  1062.     } else {
  1063.       res.json({
  1064.         code: 200
  1065.       })
  1066.     }
  1067.   })
  1068. })
  1069. //====================================================================
  1070. //====================================================================
  1071. //分页查询所有日志
  1072. router.get('/queryLoginLogsPage', (req, res) => {
  1073.   //默认页码
  1074.   let currentPage = 1;
  1075.   //默认显示数据条数
  1076.   let pageSize = 13;
  1077.   if(req.query.currentPage){
  1078.     currentPage = req.query.currentPage;
  1079.   }
  1080.   if(req.query.pageSize){
  1081.     pageSize = req.query.pageSize;
  1082.   }
  1083.   //最后一页页码
  1084.   let last_page = currentPage-1;
  1085.   if(currentPage<=1){
  1086.     last_page = 1;
  1087.   }
  1088.   console.log("当前页",currentPage);
  1089.  
  1090.   let total = 0;
  1091.   //查询总条数
  1092.   let sql = "select u.uid as uid,u.account as account,l.* from `logs` as l "+
  1093.             "inner join `user` as u on l.uid=u.uid"
  1094.   console.log(sql);
  1095.   db.query({
  1096.     sql: sql
  1097.   }, (err, results, fields) => {
  1098.  
  1099.     console.log(results.length)
  1100.     total = results.length;
  1101.     currentPage = (currentPage - 1 ) * pageSize;
  1102.     let sql2 = "select u.uid as uid,u.account as account,l.* from `logs` as l "+
  1103.                "inner join `user` as u on l.uid=u.uid "+
  1104.                "order by l.time desc "+
  1105.                "limit "+currentPage+","+pageSize+" ";
  1106.     db.query({
  1107.       sql: sql2
  1108.     }, (err, results, fields) => {
  1109.       console.log(err);
  1110.       console.log("这是sql2",sql2)
  1111.       if(results!=''){
  1112.         results[0].backup3 = total;
  1113.       }
  1114.       res.send(results)
  1115.     })
  1116.   })
  1117. })
  1118. //新增登入登出登录日志
  1119. router.post('/addLoginLogs', (req, res) => {
  1120.   //获取操作详情(0:登入,1:登出)
  1121.   let details = req.body.details;
  1122.   console.log("草拟吗",details)
  1123.   if(details=="0"){
  1124.     details='登入了系统';
  1125.   }else if(details=="1"){
  1126.     details='登出了系统';
  1127.   }
  1128.   let sql = "INSERT INTO `logs`(`uid`,`ip`,`details`,`time`) "+ 
  1129.   "VALUES ('"+req.body.uid+"', '"+req.body.ip+"','"+details+"','"+req.body.time+"')";
  1130.  
  1131.   db.query(sql, (err, result) => {
  1132.     if (err) {
  1133.       console.log("错误信息",err)
  1134.     } else {
  1135.       res.json({
  1136.         code: 200
  1137.       })
  1138.     }
  1139.   })
  1140. })
  1141.  
  1142. //====================================================================
  1143. //====================================================================
  1144. //新增轮播图
  1145. router.post('/addRotation', (req, res) => {
  1146.   let sql = "INSERT INTO `rotation`(`roname`,`rourl`,`describe`,`status`) "+ 
  1147.   "VALUES ('"+req.body.roname+"', '"+req.body.rourl+"','"+req.body.describe+"','"+req.body.status+"' )";
  1148.  
  1149.   db.query(sql, (err, result) => {
  1150.     if (err) {
  1151.       console.log("错误信息",err)
  1152.     } else {
  1153.         res.json({
  1154.           code: 200
  1155.         })
  1156.     }
  1157.   })
  1158. })
  1159. // 删除轮播图
  1160. router.get('/delRotation', (req, res) => {
  1161.   let roid = req.query.roid;
  1162.   let sql = "DELETE FROM `rotation` WHERE roid = '"+roid+"'";
  1163.   db.query(sql, (err, result) => {
  1164.     if (err) {
  1165.       console.log(err)
  1166.     } else {
  1167.       res.json({
  1168.         code: 200
  1169.       })
  1170.     }
  1171.   })
  1172. })
  1173. //修改轮播图
  1174. router.post('/updateRotation', (req, res) => {
  1175.   //获取轮播图编号
  1176.   let roid = req.body.roid;
  1177.   let sql = "UPDATE `rotation` SET "+
  1178.             "roname = '"+req.body.roname+"',"+
  1179.             "rourl = '"+req.body.rourl+"',"+
  1180.             "`describe` = '"+req.body.describe+"',"+
  1181.             "status = '"+req.body.status+"' "+
  1182.             "WHERE roid = "+roid+" ";
  1183.   db.query(sql, (err, result) => {
  1184.     if (err) {
  1185.       console.log("错误信息1",err)
  1186.     } else {
  1187.       res.json({
  1188.         code: 200
  1189.       })
  1190.     }
  1191.   })
  1192. })
  1193. //根据ID查询轮播图
  1194. router.get('/queryRotationById', (req, res) => {
  1195.   let roid = req.query.roid;
  1196.   let sql = "select * from rotation "+
  1197.   "where roid = '"+roid+"'";
  1198.   db.query({
  1199.     sql: sql
  1200.   }, (err, results, fields) => {
  1201.     console.log(results);
  1202.     res.send(results)
  1203.   })
  1204. })
  1205. //查询所有轮播图
  1206. router.get('/queryRotation', (req, res) => {
  1207.   let sql = "select * from `rotation`;";
  1208.   db.query({
  1209.     sql: sql
  1210.   }, (err, results, fields) => {
  1211.     res.send(results)
  1212.   })
  1213. })
  1214. //分页查询所有轮播图
  1215. router.get('/queryRotationPage', (req, res) => {
  1216.   //默认页码
  1217.   let currentPage = 1;
  1218.   //默认显示数据条数
  1219.   let pageSize = 9;
  1220.   if(req.query.currentPage){
  1221.     currentPage = req.query.currentPage;
  1222.   }
  1223.   if(req.query.pageSize){
  1224.     pageSize = req.query.pageSize;
  1225.   }
  1226.   //最后一页页码
  1227.   let last_page = currentPage-1;
  1228.   if(currentPage<=1){
  1229.     last_page = 1;
  1230.   }
  1231.   console.log("当前页",currentPage);
  1232.  
  1233.   let total = 0;
  1234.   //查询总条数
  1235.   let sql = "select * from menu";
  1236.   console.log(sql);
  1237.   db.query({
  1238.     sql: sql
  1239.   }, (err, results, fields) => {
  1240.  
  1241.     console.log(results.length)
  1242.     total = results.length;
  1243.     currentPage = (currentPage - 1 ) * pageSize;
  1244.     let sql2 = "select * from menu "+
  1245.                "limit "+currentPage+","+pageSize+" ";
  1246.     db.query({
  1247.       sql: sql2
  1248.     }, (err, results, fields) => {
  1249.       console.log(err);
  1250.       console.log("这是sql2",sql2)
  1251.       if(results!=''){
  1252.         results[0].backup3 = total;
  1253.       }
  1254.       res.send(results)
  1255.     })
  1256.   })
  1257. })
  1258. //====================================================================
  1259.  
  1260.  
  1261. module.exports = router

  数据库表详解

combo：套餐表
cp：套餐项目中间表
logs：日志表
project：项目表
menu：菜单表
menurole：菜单角色中间表
role：角色表
record：预约记录表
rotation：轮播图表
user：用户表
userrole：用户角色表

源码+项目部署

数据库还有源码一起都打包再下边的地址里了，下载开箱即用，跟springboot一样，嘻嘻嘻！

 源码地址：

链接：https://pan.baidu.com/s/16_taBlWe-xpsx1GvPqEcRA 
提取码：7sn7

嗯嗯嗯......终于到了激动人心的时候了，我来帮你搞定一切，帝王般的服务你值得拥有，免费的哟，记得备注下：曹家的小仙女 / 小哥哥，微信：BitPlanet

最后附上

一寸光阴一寸金，寸金难买寸光阴。请珍惜现在美好的青春，咱们一起努力奋斗，创造美好未来

拜托拜托！！！拜托拜托！！！拜托拜托！！！

​

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/笔触狂放9/article/detail/166573
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号