### 一.封装 建文件,名为:`mssql_async.js` ~~~ var sqlserver = require('mssql'); var dbConfig = { server: '192.168.1.21', port: 1433, user: 'sa', password: '123456', database: 'demo' }; var mssql_async= function (strsql) { return new Promise(function (resolve, reject) { sqlserver .connect(dbConfig) .then(function () { new sqlserver.Request() .query(strsql) .then(function (recordset) { resolve(recordset); }) .catch(function (err) { reject(err); }); }) .catch(function (err) { reject(err); }); }); }; module.exports = mssql_async; ~~~ ### 二.使用 ~~~ var mssql_async= require("./mssql_async"); function getCategoory() { mssql_async("SELECT item_clsno,item_clsname from category").then(res=>{ console.log(res); }).catch(err=>{ console.log(err) }); } getCategoory() ~~~