html操作sqlite数据库,JS html5 操作SQLite

//执行查询

$("#btnSQL").tap(function(){

var db = openDatabase('mydb', '1.0', 'Test DB', 2 * 1024 * 1024);

db.transaction(function (tx) {

tx.executeSql('CREATE TABLE IF NOT EXISTS testHtml (id unique, contentText)');

tx.executeSql('INSERT INTO testHtml (contentText) VALUES ("insert data test1!")');

});

db.transaction(function(tx){

tx.executeSql('SELECT * FROM testHtml',[],function(tx,result){

var len=result.rows.length;

app.alert(len);

var str=result.rows.item(0);

app.alert(str.contentText);

},null);

});

});

原文：http://blog.csdn.net/whx405831799/article/details/42428511