Express 中使用mysql

npm i mysql -S

common.js

//引入
const mysql =require('mysql');
//创建连接池
exports.dbPool = mysql.createPool({host: "localhost", database: "数据库名", user: '用户名', password: '密码'});

products.js

const express = require('express');
const router = module.exports = express.Router();
const dbPool = require('../common').dbPool;
router.get('/:id(\\d+)', function (req, res) {//正则表示只接受数字
    dbPool.getConnection(function (err, conn) {
        if (err) {
                   throw err;
        }
        conn.query("select products.productname,products.introduce,products.imgsrc,products_category.category_name from products join products_category on products.category_id=products_category.id where category_id=? ;", [req.params.id],//params表示路径参数
         function (err, result) {
            res.json(result);
            //释放连接
            conn.release();
        });
    })
});