NodeExpress连接MySql

 const mysql = require('mysql2/promise');
 const pool = mysql.createPool({
     host: 'localhost',
     user: 'root',//数据库用户名
     database: 'blog',//数据库
     password: '',//数据库密码
     waitForConnections: true,//是否允许排队等待
     connectionLimit: 10,//最大连接数
     dateStrings: true //时间转字符串（转化格式）
 });
 module.exports = pool;

const express = require('express')
const app = express()
const router = express.Router()//创建路由
let pool = require('../../modules/pool')//引入配置好的数据库
router.get('/type', (req, res) => {
//创建路由使用： http://localhost:端口号/type
    (async () => {
//query中使用sql语句，rows是查询
        const [rows] = await pool.query(`select * from articletype ORDER BY time DESC;`);
        res.json({
//返回出去一段json
        })
    })()
})
module.exports = router;

app.use('/',require('./route/type/read-type'))
app.listen(3000, () => console.log(`博客接口运行`))