Node.js express

express.js

	const express = require('express')
	const app = express()
	const SQL = require('./MysqL')  // 链接Mysql数据库
	const connector = require('./connector')
	app.all('*', function (req, res, next) {
		res.header('Access-Control-Allow-Origin', '*')
		res.header("Access-Control-Allow-Credentials", "true")
		res.header('Access-Control-Allow-Headers', 'Content-Type,Content-Length, Authorization, Accept,X-Requested-With')
		res.header('Access-Control-Allow-Methods', 'PUT,POST,GET,DELETE,OPTIONS')
		if( req.method == "OPTIONS" ) res.send(200);/*让options请求快速返回*/
		else  next();
	})

	app.use(express.urlencoded({ extended: true }));
	app.use(express.json());
	app.use(connector)
	app.listen(8082,()=>{
		console.log('Server connection completed',8082)
		SQL
	})

Mysql.js

var mysql = require('mysql');
var connection = mysql.createConnection({
    host: 'localhost',
    user: 'root',
    password: 'root',
    database:'admin',
    port: 3306
});
connection.connect((err, result) => {
    if (err) {
      console.log("连接失败");
      return;
    }
    console.log("Database connection completed",3306);
  });
  module.exports = connection
//   connection.end(); // 结束连接

connector.js

    const router = require('express').Router()
    const connection = require('./MysqL')
    var Inquire = 'SELECT * FROM user';
    router.post('/Inquire',(req,res)=>{
        connection.query(Inquire,function (err, result) {
            if(err){
              console.log('[SELECT ERROR] - ',err.message);
              res.json({  
                code:200,  
                msg:'暂无数据'
            }) 
              return;
            }else{
                res.json({  
                    code:200,  
                    msg:'查询成功',
                    result:result
                }) 
            }
    });
    })

    router.post('/ADD',(req,res)=>{
        let arr = []
        let array = []
        req.body.id = "2022"+RndNum(5)+""
        for(let val in req.body){
            arr.push(val)
            array.push(req.body[val])
        }

        var addsql = "INSERT INTO user("+arr.toString()+") VALUES(?,?,?,?,?,?,?,?,?,?)";
        var addsqlparams = array;
        connection.query(addsql,addsqlparams,function (err, result) {
            if(err){
              res.json({  
                code:200,  
                msg:'添加错误',
            }) 
              return;
            }else{
                res.json({  
                    code:200,  
                    msg:'添加成功',
                }) 
            }
    });
    function RndNum(n){
         var rnd="";
         for(var i=0;i<n;i++)
             rnd+=Math.floor(Math.random()*10);
         return rnd;
     }
    })
    module.exports = router