The return problem of ES6 Asynchronous function

A member function in the

class
function queries the data and returns the result set

class DB.
async Query (strSql)

{
    await this._conpool.request()
    .query(strSql, (err, result) => {
        console.dir(result.recordset);    //
        return result.recordset;
    });
}

call
let db = new DB ();

db.Query2 ("select * from sc_Product"). Then (ret = > {

)

    console.dir(ret);
    res.json(ret);
});

has not been able to get the correct data, the previous print shows that the Query function query is correct.
ask for advice!

Node.js javascript es6

Apr.09,2021

encapsulated in promise, your way of writing is a bit awkward, (by the way, async is ES7)

async function(){
    let db = new DB();
    try{
        let ret =await db.Query('select * from sc_Product');
        console.dir(ret);
        res.json(ret);
    }catch(e){
        //error
    }
}

await what is used for wait is a promise (if it is not promise, the result will be returned directly), and the return value of an async function is actually an promise, so they form a set of syntax for writing asynchronous code in Synchronize way.
any asynchronous operation must be encapsulated in promise before the syntax sugar async/await can be used.

from your first function, you can see that you don't quite understand the syntax of promise. It is suggested to find a relevant blog to study

Previous: How does django judge where the search engine comes from and where the user comes from?

Next: How to assign the data obtained by vue request to data

How to transfer parameters asynchronously by js?
I have several asynchronous function operations, but I want these asynchronous operations to be performed sequentially, I want to use queues, and each function needs to pass parameters. I think of the middleware of koa2, but how do I implement it? Or is ...

Node.js javascript es6 async await-async

Mar.17,2021