如何从cordova sqlite同步获取数据?我正在解决这个问题。我在脑海中提出了很多问题。为什么sqlite没有序列化模式。意思是:为什么不逐行执行。。?
我这样解决。。
var db = "";
//will create database Dummy_DB or open it
//function will be called when device ready
var caseNames=new Array();
function onDeviceReady() {
db = window.openDatabase("Casepad", "1.0", "Casepad", 200000);
if (window.localStorage.getItem("isAddSomeData") == "yes") {
db.transaction(getallTableData, errorCB);
/*db.transaction(function (tx) {
tx.executeSql('SELECT * FROM a', [],
// tx.executeSql('SELECT EXISTS(SELECT * FROM b)', [],
function(tx, results) {
t=results.rows.length;
alert(t)
});
});*/
}
}
function insertData() {
db.transaction(createTable, errorCB, afterSuccessTableCreation);
}
//create table and insert some record
function createTable(tx) {
tx.executeSql('CREATE TABLE IF NOT EXISTS CaseTable (id INTEGER PRIMARY KEY AUTOINCREMENT, CaseName VARCHAR(100) unique NOT NULL ,CaseDate INTEGER ,TextArea VARCHAR(200) NOT NULL)');
tx.executeSql('INSERT OR IGNORE INTO CaseTable(CaseName,CaseDate,TextArea) VALUES ("' + $('.caseName_h').val() + '", "' + $('.caseDate_h').val() + '","' + $('.caseTextArea_h').val() + '")');
}
//function will be called when an error occurred
function errorCB(err) {
navigator.notification.alert("Error processing SQL: " + err.code);
}
//function will be called when process succeed
function afterSuccessTableCreation() {
console.log("success!");
db.transaction(getallTableData, errorCB);
}
//select all from SoccerPlayer
function getallTableData(tx) {
tx.executeSql('SELECT * FROM CaseTable', [], querySuccess, errorCB);
}
/*function querySuccess(){
for (var i = 0; i < len; i++) {
alert(result.rows.item(0).CaseName)
db.transaction(function (tx) {
tx.executeSql('SELECT * FROM "'+result.rows.item(0).CaseName+'"', [],
// tx.executeSql('SELECT EXISTS(SELECT * FROM b)', [],
function(tx, results) {
t=results.rows.length;
alert(t)
});
});
}
}*/
function querySuccess(tx, result) {
var len = result.rows.length;
$('#folderData').empty();
for (var i = 0; i < len; i++) {
test=result.rows.item(i).CaseName;
if(test=="a"){
var t=Test(test);
alert("yes" +t)
}
$('#folderData').append(
'<li class="caseRowClick" id="' + result.rows.item(i).id + '" data-rel="popup" data-position-to="window">' + '<a href="#">' + '<img src="img/Blue-Folder.png">' + '<h2>' + result.rows.item(i).CaseName + '</h2>' + '<p>' + result.rows.item(i).TextArea + '</p>' + '<p>' + result.rows.item(i).CaseDate + '</p>' + '</a>' +
'<span class="ctrl togg"><fieldset data-role="controlgroup" data-type="horizontal" data-mini="true" ><button class="edit button_design">Edit</button><button class="del button_design">Delete</button></fieldset><span>'+'</li>'
);
}
$('#folderData').listview('refresh');
}
function Test(test){
alert(test)
db.transaction(function (tx) {
$yoursql = 'SELECT * FROM "'+test+'"';
tx.executeSql($yoursql, [], function (tx, results) {
return results.rows.length+"TableName"+test;
});
});
}
运行后,我将首先得到是未定义,然后是表名。在控制台中,我得到这个错误
未捕获错误:无法在初始化之前调用listview上的方法;尝试调用方法"刷新"
更改此项:
$('#folderData').listview('refresh');
到此:
$('#folderData').listview().listview('refresh');
在某些情况下,列表视图必须用listview()
初始化,然后才能用listview('refresh')
刷新。
$('#ID').trigger('create');
然后
$('#ID').append(APPEND_CONTENT).listview('refresh');