如何在 Nodejs 中使用参数化查询

参数化查询"/>

如何在 Nodejs 中使用参数化查询

我正在使用 Nodejs 和 expressjs，现在我正在尝试执行选择查询，查询工作成功但我想要两件事

1) How to convert this query to "paramerized query" ?
2) Whenever i am trying to get "total rows" then i am getting "[object object] "

这是我当前的代码

static async addServiceDetail(shopId,serviceId,genderTypeId,price,serviceName)
    {
        const sql = `SELECT id from hc_servicesdetail WHERE shopId='${shopId}' AND  serviceId='${serviceId}' AND genderTypeId='${genderTypeId}'`;
        const [rows, fields] = await pool.execute(sql);
         console.log('total rows are'+ rows); // getting [object object]
        if(rows<1)
            {
                  //further code  
            }
    }

您可以将参数作为数组传递给

execute

let shopId = 'B';
let serviceId = 'k';
let genderTypeId = 'F';
let sql = 'SELECT id from hc_servicesdetail WHERE shopId=? AND serviceId=? AND genderTypeId=?';
const [rows, fields] = await pool.execute(sql, [shopId, serviceId, genderTypeId]);
console.log('Rows:', rows)

输出看起来像这样：

Rows: [ { id: 1 } ]