Nodejs连接Mysql实现增删改查接口demo

Demo目录

query ./dbconfig.js

const mysql = require('mysql')
const dbconfig = require('./dbconfig')
const pool = mysql.createPool(dbconfig);


//数据库连接池
function query(sql,params) {
   
    return new Promise((resolve, reject) => {
   
    	  pool.getConnection((err, conn) => {
   
            if (err) {
   
            	reject(err)
            	return
            }
            // let sql = 'select *from user where id=? and name=?'
            //执行sql语句
            conn.query(sql, params, (err, result) => {
   
                conn.release()
                if (err) {
   
                    throw err
                }
               resolve(result)
        })
    });
    });
}

module.exports=query

query配置 ./router/index.js

let dbconfig

dbconfig={
   
	//配置mysql数据库
	connectionLimit: 10,
    host: "localhost",
    user