const mssql = require("mssql");
const conf = require("./config");

const pool = new mssql.ConnectionPool(conf)
const poolConnect = pool.connect()
pool.on('error', err => {
    console.log('error: ', err)
})
const chaxun = async function (strsql, callBack) {
    try {
        const ps = new mssql.PreparedStatement(await poolConnect);
        const sql = strsql;
        ps.prepare(sql, function (err) {
            if (err)
                console.log(err);
            ps.execute("", function (err, recordset) {
                console.log(recordset)
                callBack(err, recordset);
                ps.unprepare(function (err) {
                    if (err)
                        console.log(err);
                });
            });
        });
    } catch (e) {
        console.log(e)
    }
}

代码格式好了，才会有人看的

const db = require('…/db/dbhelper')
exports.test = (req, res) => {
    console.log(33333333333333333);
    const strsql = "select * from ict_tab where bar_code ='709624970HM'";
    db.chaxun(strsql, (err, results) => {
        // 1. 执行 SQL 语句失败
        if (err) return res.cc(err)
        // 2. 执行 SQL 语句成功
        res.send({status: 0, message: '获取列表成功！', data: results,})
    })
}