如何在PhoneGap的应用程序实现数据库？ [英] How to implement database in PhoneGap App ?

问题描述

我是新来的这一点，我想建立一个应用程序部署与PhoneGap的，这两个Android和iOS。 我想知道如何链接到将存储的时间表数据的数据库。

I'm new to this, and I am trying to build an app to be deployed with PhoneGap, to both Android and iOS. I am wondering how to link to a database which will store timetable data.

我的问题是如何将其纳入数据库，以便它可以与PhoneGap的包装。

My question is how to include the database so it can be packaged with PhoneGap.

我已经看过了PhoneGap的文档，而且他们并不真正意义对我来说，如何设置/创建数据库

I have looked at the PhoneGap docs, and they don't really make sense to me as to how to set up/create the database

更新： 该网站显示的本地存储一些信息，但是当我把它放在，挂装形象。

Update: This website shows some info on local storage, but when i put it in, hangs on the loading image.

任何进一步的想法？

http://www.aquim.com/web-article-237.html

推荐答案

请参考以下链接，操作简单，SQ-lite.and你也可以得到存储API从上面的链接。

Please refer below link for simple operation with Sq-lite.and also you can get basic idea of Storage API from above link.

简单操作SQ-精简版： 的http://www.raymondcamden.com/index.cfm/2011/10/20/Example-of-PhoneGaps-Database-Support

Simple operation with Sq-lite : http://www.raymondcamden.com/index.cfm/2011/10/20/Example-of-PhoneGaps-Database-Support

编辑于2013年5月8日

与数据库基本操作：

<script type="text/javascript" charset="utf-8" src="cordova-x.x.x.js"></script>
<script type="text/javascript" charset="utf-8">
// Wait for Cordova to load
document.addEventListener("deviceready", onDeviceReady, false);

// Cordova is ready
function onDeviceReady() {
    var db = window.openDatabase("Database", "1.0", "Cordova 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>

refrence

您可以检查数据库中的文件资源管理器

You can check Data base in File explorer

在ADT包 窗口>>展示视图>>文件浏览器

In ADT bundle Window>>show view>> File Explorer

这篇关于如何在PhoneGap的应用程序实现数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！