gpt4 book ai didi

cordova - 如何使用window.openDatabase访问phonegap中的旧数据库?

转载 作者:行者123 更新时间:2023-12-01 18:43:19 25 4
gpt4 key购买 nike

我在PhoneGap开发页面阅读了存储教程。在示例中,它使用了 window.openDatabase 两次。但文档说 openDatabase 返回一个新的数据库对象,我猜该示例的目标是生成一个新的数据库,然后访问它以取回数据。但是为什么它创建了两次新的数据库对象?

<!DOCTYPE html>
<html>
<head>
<title>Storage Example</title>

<script type="text/javascript" charset="utf-8" src="cordova-1.8.1.js"></script>
<script type="text/javascript" charset="utf-8">

// Wait for Cordova to load
//
document.addEventListener("deviceready", onDeviceReady, false);

// Populate the database
//
function populateDB(tx) {
tx.executeSql('DROP TABLE IF EXISTS DEMO');
tx.executeSql('CREATE TABLE IF NOT EXISTS DEMO (id unique, data)');
tx.executeSql('INSERT INTO DEMO (id, data) VALUES (1, "First row")');
tx.executeSql('INSERT INTO DEMO (id, data) VALUES (2, "Second row")');
}

// Query the database
//
function queryDB(tx) {
tx.executeSql('SELECT * FROM DEMO', [], querySuccess, errorCB);
}

// Query the success callback
//
function querySuccess(tx, results) {
console.log("Returned rows = " + results.rows.length);
// this will be true since it was a select statement and so rowsAffected was 0
if (!results.rowsAffected) {
console.log('No rows affected!');
return false;
}
// for an insert statement, this property will return the ID of the last inserted row
console.log("Last inserted row ID = " + results.insertId);
}

// Transaction error callback
//
function errorCB(err) {
console.log("Error processing SQL: "+err.code);
}

// Transaction success callback
//
function successCB() {
var db = window.openDatabase("Database", "1.0", "Cordova Demo", 200000); //Why create a new DB again??
db.transaction(queryDB, errorCB);
}

// Cordova is ready
//
function onDeviceReady() {
var db = window.openDatabase("Database", "1.0", "Cordova Demo", 200000);
db.transaction(populateDB, errorCB, successCB); //upon the success of create a database, jump to successCB
}

</script>
</head>
<body>
<h1>Example</h1>
<p>Database</p>
</body>
</html>

最佳答案

对 window.openDatabase 的调用将返回一个新的数据库对象,但如果您要求相同的数据库名称(在本例中为“Database”),则每个数据库对象将引用相同的物理数据库。

关于cordova - 如何使用window.openDatabase访问phonegap中的旧数据库?,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/11108165/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com