Promise

定义:

var mssql = require('mssql')
var mssqlConfig = require('../config.js').msdb
const pool = new mssql.ConnectionPool(mssqlConfig)
var userInfo = module.exports

userInfo.get = new Promise(

    function (resolve, reject) {

        pool.connect().then(pool => {
            return pool.query`select top 1 * from ba_cpinfo`

        }).then(result => {
            pool.close();
            // console.dir(result.recordset)
            resolve(result)
            //  return result
        }).catch(err => {
            pool.close();
            console.dir(err)
            reject(err)
            // return err
        })
      

    }
)

 

调用：

var express = require('express');
var router = express.Router();
var userInfo=require('../service/userinfo.js')
var login=require('../service/login')
/* GET home page. */
router.get('/', function(req, res, next) {
 
  userInfo.get.then((success,err)=>{
    if(!err)
    {
      console.dir(success)
  
      res.send(JSON.stringify(success,null,2) );
    }else 
    {
      console.dir(err)
      res.send(JSON.stringify(err,null,2) );
    }

  login.logon("123").then((success,err)=>{
    if(!err)
    {
      console.dir(success)
  
      res.send(JSON.stringify(success,null,2) );
    }else 
    {
      console.dir(err)
      res.send(JSON.stringify(err,null,2) );
    }
    
  })
  


});

module.exports = router;