html5 websql

来源：互联网发布：java入门要多久编辑：程序博客网时间：2024/05/16 14:41

自测通过，如下代码：

<!DOCTYPE HTML>  <html>  <head>  <script type="text/javascript">  var db = openDatabase('webdb', '1.0', 'HTML5 DB', 5 * 1024 * 1024);   var msg;   db.transaction(function (tx) {    tx.executeSql('CREATE TABLE IF NOT EXISTS TAGS (id unique, tag)');     tx.executeSql('INSERT INTO TAGS (id, tag) VALUES (1, "liaojianguo")');     tx.executeSql('INSERT INTO TAGS (id, tag) VALUES (2, "love html5")');     msg = '<p>tag message created and row inserted.</p>';     document.querySelector('#divId').innerHTML =  msg;   });     db.transaction(function (tx) {    tx.executeSql('SELECT * FROM TAGS', [], function (tx, results) {     var len = results.rows.length, i;      msg = "<p>Found rows: " + len + "</p>";      document.querySelector('#divId').innerHTML +=  msg;      for (i = 0; i < len; i++){       msg = "<p><b>" + results.rows.item(i).tag + "</b></p>";        document.querySelector('#divId').innerHTML +=  msg;      }   }, null);   });   </script>  </head>  <body>  <div id="divId">Tag</div>  </body> </html>