### 一.封裝 建文件,名為:`mysql_async.js` ~~~ const mysql = require("mysql"); const pool = mysql.createPool({ host: "localhost", user: "root", password: "root", database: "demo" }); let mysql_async= function(sql, values) { // 返回一個 Promise return new Promise((resolve, reject) => { pool.getConnection(function(err, connection) { if (err) { reject(err); } else { connection.query(sql, values, (err, rows) => { if (err) { reject(err); } else { resolve(rows); } // 結束會話 connection.release(); }); } }); }); }; module.exports = mysql_async; ~~~ ### 使用 ~~~ const mysql_async= require('./mysql_async'); async function update(){ lat data=[1,2] await query("update product set category=? where id=?",data).then(res=>{ console.log(res); }).catch(err=>{ console.log(err); }) } update() ~~~