从Android的HTML资产创建SQLite表资产、Android、HTML、SQLite

2023-09-05 04:30:28 作者:任人宰割i

我试图用一个HTML的机器人来创建一个sqlite的表,但它不能正常工作

I tried to use a HTML in android to create a table in sqlite but it is not working

样本HTML是这里

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

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

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

// PhoneGap is ready
//
function onDeviceReady() {
    var db = openDatabase("Database", "1.0", "PhoneGap Demo", 200000);
    db.transaction(populateDB, errorCB, successCB);
}

// 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")');
}

// Transaction error callback
//
function errorCB(tx, err) {
    alert("Error processing SQL: "+err);
}

// Transaction success callback
//
function successCB() {
    alert("success!");
}

</script>
</head>
<body onload="onDeviceReady()">
<h1>Example</h1>
<p>Database</p>
</body>
</html>

的Andr​​oid 2.2 我无法看到任何数据库中创建的机器人。请一些建议

Android 2.2 I am not able to see any database create in android. Please some suggestion

推荐答案

的WebView有通过javascript code调用Java code的能力。如何尝试这种解决方案?

WebView has the ability to invoke java code through javascript code. How about trying this solution?