const mysql = require(‘…/mysql/mysql’)let connection = null;connection = mysql.createConnection();/**
- 错误消息
*/let bad_msg = {
code: 500,
msg: '内部错误!'}/**
- 成功消息
*/let success_msg = {
code: 200,
msg: '操作成功'}const connections = {
/**
* 查询方法
* @param {*} table 表名
* @param {*} condition 条件
* @param {*} params 参数
* @param {*} search 查询条件
* @returns
*/
find(table, condition, params, search = '*') {
return new Promise((resolve, reject) => {
let sql = `SELECT ${search} FROM ${table} WHERE ${condition}`
connection.query(sql, params, (err, result) => {
if (err) {
reject(bad_msg)
} else {
let _ = JSON.parse(JSON.stringify(success_msg))
_.data = result