phonegap sqlite (android)

在android环境下使用phonegap操作sqlite,代码见附件。
效果图：
(function(){$('#main').live('pageshow',function(){$('#createBtn').bind('click',function(){create('test','1.0','testDb',1000000);});$('#DropBtn').bind('click',function(){dropTable('DEMO','test','1.0','testDb',1000000);});$('#selectBtn').bind('click',function(){select('test','1.0','testDb',1000000);});$('#insertBtn').bind('click',function(){$('#addWindow').popup('open');});$('#saveBtn').bind('click',onSaveBtnClick);$('#deleteBtn').bind('click',onDeleteBtnClick);});function onSaveBtnClick(){var id = $('#idfield').val();var data = $('#datafield').val();if(id!=''&& data!=''){var db = getDb('test','1.0','testDb',1000000);db.transaction(function(tx){tx.executeSql('INSERT INTO DEMO (id, data) VALUES (?, ?)', [id,data]);}, errorCB, function(){$('#addWindow').popup('close');alert('新增成功');$('#selectBtn').trigger('click');$('#msgdiv').empty();$('#idfield').val('');$('#datafield').val('');});}else{$('#msgdiv').text('请输入id和data!!');}}function onDeleteBtnClick(){var db = getDb('test','1.0','testDb',1000000);db.transaction(function(tx){tx.executeSql('DELETE FROM DEMO');}, errorCB, function(){alert('成功删除全部记录!');$('#resultList > tbody').empty();});}function getDb(dbName,dbVersion,dbDisplayname,dbSize){return window.openDatabase(dbName, dbVersion,dbDisplayname, dbSize);}function select(dbName,dbVersion,dbDisplayname,dbSize){var db = getDb(dbName,dbVersion,dbDisplayname,dbSize);db.transaction(queryDB, errorCB);        }function dropTable(tableName,dbName,dbVersion,dbDisplayname,dbSize){var db = getDb(dbName,dbVersion,dbDisplayname,dbSize);db.transaction(function(tx){tx.executeSql('DROP TABLE IF EXISTS '+tableName);}, errorCB,function(){alert('删除成功,tableName='+tableName);$('#resultList > tbody').empty();}); }function queryDB(tx) {$('#resultList > tbody').empty();    tx.executeSql('SELECT * FROM DEMO', [], function (tx, results) {    var len = results.rows.length;    var html = [];    for (var i=0; i'+rs.id+''+rs.data+'');    }    $('#resultList > tbody').append($(html.join('')));},errorCB);}function create(dbName,dbVersion,dbDisplayname,dbSize){var db = getDb(dbName,dbVersion,dbDisplayname,dbSize);db.transaction(function(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")');tx.executeSql('INSERT INTO DEMO (id, data) VALUES (3, "Phonegap sqlite测试")');}, errorCB, function(){alert('创建成功,dbName='+dbName);$('#selectBtn').trigger('click');});}function errorCB(err) {    alert("Error processing SQL: "+err.code);}})();
assets.rar (1.9 MB)
下载次数: 419
查看图片附件
更多相关文章

随机推荐
