我試圖與執行一個簡單的查詢Sqlite中React-Native使用的反應，本機的SQLite存盤插件。根據檔案，我應該在成功回呼 1)SQLite.Transaction和 2) 中獲得兩個引數，SQLlite.ResultSet 但我只SQLite.Transaction在我的示例中獲得了。
let sql = "SELECT * FROM table_a;"
let params = [];
db.executeSql(sql, params,
(trans, results) => {
console.log("execute success results: " JSON.stringify(results))
console.log("execute success transaction: " JSON.stringify(trans))
//resolve(results);
resolve(trans);
},
(error) => {
console.log("execute error: " error);
reject(error);
});
控制臺輸出
execute success results: undefined
execute success transaction: {"rows":{"length":1},"rowsAffected":0}
uj5u.com熱心網友回復：
我忘了把我的包裹executeSql在一個transaction. 這按預期作業：
db.transaction((txn) => {
txn.executeSql(sql, params, (trans, results) => {
console.log("execute success results: " JSON.stringify(results))
console.log("execute success transaction: " JSON.stringify(trans))
//resolve(results);
resolve(trans);
},
(error) => {
console.log("execute error: " JSON.stringify(error))
reject(error);
});
});
轉載請註明出處，本文鏈接：https://www.uj5u.com/ruanti/325082.html