node.js中的promise出现错误，希望将其作为承诺的连接并修复

Question

await conn.query("SELECT ID, idle_timer, action, combat FROM users WHERE idle_timer >= 1 ORDER BY ID ASC", async function(err, results) {
}

在等待连接处发生错误。query("SELECT ID，idle_timer，action，battle FROM users WHERE idle_time>=1 ORDER BY ID ASC"，异步函数(err，results(｛

想把它变成承诺吗？

Answer 1

您可以使用MySQL获取数据

在回叫模式

conn.query("SELECT ID, idle_timer, action, combat FROM users WHERE idle_timer >= 1 ORDER BY ID ASC", function(err, results) {...})

或在Promise模式中

conn.query("SELECT ID, idle_timer, action, combat FROM users WHERE idle_timer >= 1 ORDER BY ID ASC").then(results => { ... })

或者可能在Promise模式下使用Await/Async语法糖

const result = await conn.query("SELECT ID, idle_timer, action, combat FROM users WHERE idle_timer >= 1 ORDER BY ID ASC")

//...
const results = await conn.query("SELECT ID, idle_timer, action, combat FROM users WHERE idle_timer >= 1 ORDER BY ID ASC");
await conn.release();
for (let i = 0; i < results.length; i++) {
//... processing results
}

如果你是async/await的新手，请至少阅读promisehttps://developer.mozilla.org/ru/docs/Web/JavaScript/Reference/Statements/async_function