node.js 连接sqlserver封装mssql

npm i mssql

mssql版本8.1.1
db.js封装

var sql = require('mssql'); 
var dbConfig = {
    user: 'sa',
    password: '1111',
    server: '111.111.111.111',
    database: 'db_text',
    port: 1433,
    pool: {
        max: 10,
        min: 0,
        idleTimeoutMillis: 30000
    },
    options:{
        encrypt: false
    }
  };
function getAllUsers(sqls) {
    return new Promise((resolve,reject)=>{
        var conn = new sql.ConnectionPool(dbConfig);
        var req = new sql.Request(conn);
        conn.connect(function (err) {
            if (err) {
                console.log(err);
                resolve([err])
                // return;
            }
            req.query(sqls, function (err, recordset) {
                // if (err) {
                //     console.log(err);
                //     return;
                // }
                // else {
                //     console.log(recordset);
                // }
                conn.close();
                resolve([err,recordset])
            });
        });
    })
}
   module.exports=getAllUsers;

index.js引用

var db = require('./db');
async function asa(){
    let sql = `select * from tb_userinfo`;
    let [err,recordset]=await db(sql)
    console.log(recordset,'aaa');
}
asa()

var express=require('express')
var app=express()
app.listen(3000,()=>{console.log('服务已开启')});
var db = require('./db');
app.get('/index',async (req,res)=>{
    let sql = `select * from tb_userinfo`;
    let [err,recordset]=await db(sql)
    console.log(recordset,'aaa');
    res.send('asas')
})