问Await是唯一的异步函数: API节点

EN

**SyntaxError: await is only valid in async function**


var express = require('express');
var router = express.Router();
var sql = require('mssql');

async function connectDB(){

 const pool = new sql.ConnectionPool(global.config.sqlConfig);
     try {
         await pool.connect();
         console.log('Connected to DATABASE');
         return pool;
     }
     catch(err){
         console.log('conn failure');
         return err;
     }
};

async function executeQuery(req, res){    
 const DB = await connectDB(); 
 try{
     var result = await DB.request()
     .query(req).then(function () {
        console.log("QUERY PASSED");
        console.log(result.recordset);
        return result.recordset;
     });

 }
 catch(err){
     console.log("ERROR QUERYing DATABASE");
     return err;
 }
 finally{
      DB.close();
 }

 };

router.get('/login', function (req, res) {   
   var strquery = "select fUserPwd from tblUser where fUserID ='ADMIN'";
    console.log(strquery);
   const result = await executeQuery(strquery, res); 
   res.send(result);     

});

module.exports = router;