node 数据库 如何搭建服务器

新建app.js

const myExpress = require('express');
const logger = require('morgan');
const bodyParser = require('body-parser');
const cookieParser = require('cookie-parser');
const myEjs = require('ejs');
const mySession = require('express-session');
//引用路由
const userRouter = require('./Router/Router');//用户相关路由
const viewRouter = require('./Router/viewRouter');//试图相关路由
const product = require('./Router/tbRouter');//表格
const app = myExpress();


app.use(logger('dev'));
//定义数据解析
app.use(bodyParser.json());
app.use(bodyParser.urlencoded({extended:false}));
//定义cookie解析器
app.use(cookieParser());
app.use(mySession({
    secret:'xxx',
    name:'dyj',
    cookie:{maxAge:1000000}, //过期时间
    rolling:true,
    resave:true
}));
app.set('views',__dirname+'/view');//设置视图路径
app.engine('html',myEjs.__express);//创建HTML引擎
app.set('view engine','html');
app.use(viewRouter);//视图相关路由
app.use(userRouter);//用户相关路由
app.use(product);//产品相关路由
//跨域
app.all('*',function (req,res,next) {
    res.header("Access-Control-Allow-Origin","*");
    res.header("Access-Control-Allow-Headers","X-Requested-With,X_Requested_With,Content-Type");
    // res.header("Content-Type" , "application/json;charset=utf-8");
    res.header("Access-Control-Allow-Methods", "PUT,POST,GET,DELETE,OPTIONS");
    next();
    //解决跨域问题
});
// app.use(myExpress.static(__dirname+'/public'));//静态文件夹目录
console.log('服务启动');+
app.listen('8888');

然后cmd在命令行打开到对应目录下npm init初始化
然后多了个文件
如下

{
  "name": "order",
  "version": "0.1.0",
  "private": true,
  "scripts": {
    "serve": "vue-cli-service serve",
    "build": "vue-cli-service build"
  },
  "dependencies": {
    "core-js": "^3.6.5",
    "body-parser": "^1.19.0",
    "cookie-parser": "^1.4.5",
    "element-ui": "^2.13.2",
    "express": "^4.17.1",
    "vue": "^2.6.11",
    "ejs": "^3.1.2",
    "morgan": "^1.10.0",
    "vue-router": "^3.2.0",
    "vuex": "^3.4.0"
  },
  "devDependencies": {
    "@vue/cli-plugin-babel": "^4.4.0",
    "@vue/cli-plugin-router": "^4.4.0",
    "@vue/cli-plugin-vuex": "^4.4.0",
    "@vue/cli-service": "^4.4.0",
    "axios": "^0.19.2",
    "mysql": "^2.18.1",
    "vue-template-compiler": "^2.6.11"
  }
}

最后cmd在命令行打开到对应目录下npm i
让他自己安装相应的插件以及依赖
新建DBConfig.js文件 //这是数据库相关的

const mysql = require('mysql');
function DBoper(sql,param,callback) {
    let myConnect = mysql.createConnection({
        host:'localhost',
        user:'root',
        paw:'',//密码
        port:'3306',//端口号
        database:'restaurant'//数据库名称
    });
    myConnect.connect();
    myConnect.query(sql,param,callback);
    myConnect.end();
}
module.exports={
  query:DBoper
};

再新建router.js文件 //这是路由相关的

const myexpress = require('express');
const db = require('./DBCconfig');
const router = myexpress.Router();
//大概用法如下
router.post('/reception/querytype',function (req,res) {
    let sql =`SELECT * FROM dishes_classify`;  //这儿写sql语句，
    db.query(sql,[],function (err,data) {
        if (err){
            res.end('失败')
        }else {
            res.json(data)
        }
    })
});
module.exports = router;