我正在try 创建一个函数，该函数判断数据库中有多少记录，并将数字发送给变量:
var records = -1;
async function howManyRecords() {
let myPromise = new Promise(function (resolve) {
DB.transaction(function (tx) {
tx.executeSql('SELECT count(*) AS mycount FROM DemoTable', [], function (tx, rs) {
records = rs.rows.item(0).mycount;
resolve();
},);
});
});
await myPromise;
console.log("records from promise function: " + records);
return myPromise;
}
然后我想在其他功能中使用该号码，例如当设备就绪时在控制台日志(log)中显示:
onDeviceReady.then(function () {
howManyRecords();
console.log("after calling function records are: " + records);
}
HowManyRecords函数正确地计算记录，但变量记录不正确:
IMG: after calling function records are: -1 // records from promise function: 5个
我真的需要一些帮助，我对这个话题是新手，被困在这里很长时间了，无法继续下go . 我用的是Cordova Sqlite.