我是个新手,用的是Java脚本. 我正在try 使用Promise和Async等待所有行及其父行
以下是我的代码
const e = require('express')
const mysql2 = require('mysql2')
const pool = mysql2.createPool({
host: '127.0.0.1',
user: 'root',
password: '',
database: 'dreamselling',
waitForConnections: false,
connectionLimit: 10,
queueLimit: 0
})
let levels=[];
const getLevel = (id,levels) => {
return new Promise((resolve, reject) => {
let sql = `select id,memberName,parent_id from member_table where id=${id}`;
pool.getConnection((error, connection) => {
connection.query(sql, (err, rows) => {
if (rows && rows[0].parent_id != null) {
// console.log(rows[0]);
levels.push((rows[0]))
getLevel(rows[0].parent_id,levels)
} else {
pool.end()
}
})
})
})
}
async function myfunc() {
let a = await getLevel(7)
console.log(levels);
// console.log('level',a);
}
myfunc()
我可以使用console.log查看行(ROWS[0]) 但无法从函数返回 关于这件事我需要帮助