我想在查詢之外使用 for 回圈，但它列印為空。
sql = 'SELECT * FROM people';
let currMarker = [];
db.all(sql, [], (err,rows) => {
if (err) return console.error(err.message);
currMarker = rows;
for (let i = 0; i < currMarker.length; i ) {
console.log(currMarker[i].name);
console.log(currMarker[i].username);
}
});
我想像這樣使用它：
sql = 'SELECT * FROM people';
let currMarker = [];
db.all(sql, [], (err,rows) => {
if (err) return console.error(err.message);
currMarker = rows;
});
for (let i = 0; i < currMarker.length; i ) {
console.log(currMarker[i].name);
console.log(currMarker[i].username);
}
uj5u.com熱心網友回復：
這是一個解決方案。
sql = 'SELECT * FROM people';
let currMarker = [];
const queryFunc = () =>{
return new Promise((resolve, reject)=>{
db.all(sql, [], (err,rows) => {
if (err) return console.error(err.message);
currMarker = rows;
resolve();
});
});
};
queryFunc().then((val)=>{
for (let i = 0; i < currMarker.length; i ) {
console.log(currMarker[i].name);
console.log(currMarker[i].username);
}
});
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/536624.html