需要在sqlite中从数据库中获取同步数据的示例。 [英] Need example of synchronous data fetch from database in sqlite.?

问题描述

您能告诉我如何同步获取数据的示例吗？实际上我创建了manecasepad的数据库。然后我在该数据库案例表中创建了一个表（ID，案例名称，日期）。现在我在该表上插入值。在插入时我也创建一个名称表（casename）。意思是如果我插入案例表的值（1，AB，2/13）。然后我创建AB表。现在我需要从案例表中获取价值（我得到），但我需要计算其他表格（AB）中的元素数量。我需要尝试这样的。

can you please tell me the example how to fetch data synchronously ? Actually I create the data base of mane "casepad".Then i create a table in that data base "case table" having (ID ,case name, date). Now i insert the value on that table .On insert i also create a table of name ("casename").mean if i insert value of case table (1,"AB",2/13).Then i create AB table.Now I need to get value from case table (i am getting) but along i need to count number of element in other table (AB).Here i am need trying like that.

function onDeviceReady() {

db = window.openDatabase("Casepad", "1.0", "Casepad", 200000);
db.transaction(getallTableData, errorCB);
}

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  TEXT unique NOT NULL ,CaseDate INTEGER ,TextArea TEXT 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(tx, result) {
    var len = result.rows.length;
    var t;
    $('#folderData').empty();
    for (var i = 0; i < len; i++) {
Here i need to call synchronize method which call the number of element in in that  result.rows.item(i).CaseName and insert it in this table
****************************************************************************
        $('#folderData').append(
                '<ul><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 + t+'</h2>' + '<p>' + result.rows.item(i).TextArea + '</p>' + '<p>' + result.rows.item(i).CaseDate + '</p>' + '<span class="ui-li-count">' + i + '</span></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>'+'</span></span></li></ul>'
                );
    }
    $('#folderData').listview('refresh');

}

在列表视图中显示i的值我需要显示多少元素在那张桌子里。我需要调用synchronize，因为我需要调用一些查询来计算此元素中result.rows.item（i）.CaseName中元素的数量..？

Instend of showing value of "i" in list view i need to show how many element in that table . I need to call synchronise because i need to call some query which count the number of element in "result.rows.item(i).CaseName" in this element..?

推荐答案

（' .caseName_h'）。val（）+ ' ，' +

('.caseName_h').val() + '", "' +

（' .caseDate_h'）。val（）+ ' ，' +

('.caseDate_h').val() + '","' +

（' .caseTextArea_h '）。val（）+ ' ）'）;


}
// 发生错误时将调用函数
function errorCB（err）{
navi gator .notification.alert（ 处理SQL时出错： + err.code）;
}

// 当流程成功时将调用该函数
function afterSuccessTableCreation（）{
console .log（ success！）;
db.transaction（getallTableData，errorCB）;
}



// 全选SoccerPlayer
function getallTableData（tx）{
tx.executeSql（'' SELECT * FROM CaseTable'，[]，querySuccess，errorCB）;
}



function querySuccess（tx，result）{
var len = result.rows.length;
var t;

('.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(tx, result) { var len = result.rows.length; var t;

这篇关于需要在sqlite中从数据库中获取同步数据的示例。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！