封装数据库

首先引入相应的表结构

npm i mysql

建一个db.js

let db = {}

const mysql = require("mysql");

const pool = mysql.createPool({
    host:"localhost",
    user:"root",
    password:"123456",
    database:"py",
    //可选
    queueLimit:3,
    connectionLimit:20
})

db.query = function(sql,callBack){
    pool.getConnection((err,conn)=>{
        if(err){
            console.log(err);
            return
        }
        conn.query(sql,(err,data)=>{
            if(err){
                console.log(err);
                return
            }
            callBack(data);
        })
    })
}

module.exports = db;

const db = require("./db");
//查询书籍的个数
db.query("select count(*) count from books",data=>{
    console.log(`共有${data[0].count}本书`);

})

运行index.js 查看结果即可

node index.js

对db.js的改进

let db = {};

const mysql = require("mysql");
const conn = mysql.createConnection({
    host:"localhost",
    user:"root",
    password:"123456",
    database:"py"
})

conn.connect();

db.query = function(sql,callBack){
    conn.query(sql,(err,data)=>{
        if(err){
            console.log(err);
            return;
        }
        callBack(data);
    })
}

module.exports = db;