Phonegap Sqlite (android)

Below Android environment use Phonegap operates Sqlite, code sees accessory.

(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(' adds successful'); newly$('#selectBtn').trigger('click');$('#msgdiv').empty();$('#idfield').val('');$('#datafield').val('');});}else{$('#msgdiv').text(' inputs Idand Data please! ! ');}}function onDeleteBtnClick(){var db = getDb('test','1.0','testDb',1000000);db.transaction(function(tx){tx.executeSql('DELETE FROM DEMO');}, errorCB, function(){Alert(' deletes overall recordsuccessfully! ');$('#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(' deletes a success,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 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('INSERTINTO DEMO (Id, data) VALUES (3, "Phonegap Sqlitechecks ")'); } , errorCB, function(){Alert(' establishs asuccess, dbName='+dbName);$('#selectBtn').trigger('click');});}function errorCB(err) {alert("Error processing SQL: "+err.code);}})();