nodejs mysql 操作

const db = require('../config/db')

let show = (table) => {
    return new Promise((resolve, reject) => {
        db.query(`select * from ${table}`, (err, rows) => {
            if (err) {
                reject(err);
            }
            resolve(rows);
        })
    })
}

let select = (table, param) => {
    return new Promise((resolve, reject) => {
        for (x in param) {
            db.query(`select * from ${table} where ${x} = '${param[x]}'`, (err, rows) => {
                if (err) {
                    reject(err);
                }
                resolve(rows);
            })
        }
    })
}

let update = (table, data, param) => {
    return new Promise((resolve, reject) => {
        let condition = ""
        for (d in data) {
            condition += d + "='" + data[d] + "',"
        }
        condition = condition.substr(0, condition.length - 1)
        for (x in param) {
            db.query(`update ${table} set ${condition} where ${x} = '${param[x]}'`, (err, rows) => {
                if (err) {
                    reject(err);
                }
                resolve(rows);
            })
        }

    })
}

let insert = (table, param) => {
    return new Promise((resolve, reject) => {
        let filed = ""
        let value = ""
        for (x in param) {
            filed += x + ","
            value += "'" + param[x] + "'" + ","
        }
        filed = filed.substr(0, filed.length - 1)
        value = value.substr(0, value.length - 1)
        console.log(filed)
        console.log(value)
        console.log(`insert into (${filed}) values (${value})`)
        db.query(`insert into ${table} (${filed}) values (${value})`, (err, rows) => {
            if (err) {
                reject(err);
            }
            resolve(rows);
        })
    })
}
exports.show = show
exports.select = select
exports.update = update
exports.insert = insert