express+ mysql搭建服务器

express框架

var express = require("express");
var app = express();
 
var bodyParser = require("body-parser");
app.use(bodyParser.json())
app.use(bodyParser.urlencoded({
  extended: false
}));
 
app.get("/searchTab", function (req, res) {
  const {name,date1,date2} = req.query;
···逻辑  需要拿到数据库res.send("写回去的内容")
}
 
app.post("/postTab", function (req, res) {
  const {name,date1,date2} = req.body;
···逻辑  需要拿到数据库res.send("写回去的内容")
}

连接数据库

服务器是node程序，前端是另一个程序，所以

const mysql = require('mysql');
 
//数据库
var pool = mysql.createPool({
  host: 'localhost',
  user: 'root',
  password: '123456',
  database: 'test',
  port: 3306,
  multipleStatements: true,
  charset: "UTF8_GENERAL_CI"
});
//跨域
var cors = require("cors");
app.use(cors())
 
 pool.query(str, function (err, rows) {
    if (err) {
      res.send("0")
      return
    } else {}}）；　　

上传文件

var multer = require("multer");
var path = require("path");
 
app.use(express.static(path.join(__dirname, 'public/img')))
//保存在的位置
var storage = multer.diskStorage({
  destination: function (req, file, cb) {
    cb(null, 'public/img');
  },
  filename: function (req, file, cb) {
    cb(null, Date.now() + "-" + file.originalname);
  }
})
 
var upload = multer({
  storage: storage
})
app.post('/postImage', upload.single("file"), function (req, res, next) {
  //res.json(req.file.originalname);
  // 服务器IP
  const url = "http://localhost:8089/" + req.file.filename
  res.send(url);
  next()
});