node.js连接数据库写接口

//初始化
npm init
//安装依赖
npm install body-parser express mysql cors -S 

引入路由，把页面拆分开：

connect.js

const mysql = require('mysql')
const express = require('express')
const app = express()
const router = express.Router();

// 解析参数
const bodyParser = require('body-parser')
let login = true;
// json请求
app.use(bodyParser.json())
// 表单请求
app.use(bodyParser.urlencoded({
   extended: false}))

const option = {
   
    host: 'localhost',
    user: 'root',
    password