JS html5 操作SQLite

標籤：

//執行查詢$("#btnSQL").tap(function(){ <span style="white-space:pre"></span>var db = openDatabase('mydb', '1.0', 'Test DB', 2 * 1024 * 1024);  db.transaction(function (tx) {                 <span style="white-space:pre"></span>tx.executeSql('CREATE TABLE IF NOT EXISTS testHtml (id unique, contentText)');     <span style="white-space:pre"></span>tx.executeSql('INSERT INTO testHtml (contentText) VALUES ("insert data test1!")');       });        <span style="white-space:pre"></span>db.transaction(function(tx){                tx.executeSql('SELECT * FROM testHtml',[],function(tx,result){           <span style="white-space:pre"></span>var len=result.rows.length;          <span style="white-space:pre"></span>app.alert(len);    <span style="white-space:pre"></span>var str=result.rows.item(0);    <span style="white-space:pre"></span>app.alert(str.contentText);        <span style="white-space:pre"></span>},null);     <span style="white-space:pre"></span>}); });

JS html5 操作SQLite