<script>

   var db = openDatabase('ysdb', '1.0', 'My first DB', 2 * 1024 * 1024);

   var msg;

   db.transaction(function (tx) {

      tx.executeSql('CREATE TABLE IF NOT EXISTS logs (id unique, log)');

      tx.executeSql('INSERT INTO logs (id, log) VALUES (1, "简单教程")');

      tx.executeSql('INSERT INTO logs (id, log) VALUES (2, "www.twle.cn")');

      msg = '<p>数据表已创建，且插入了两条数据</p>';

      document.querySelector('#status').innerHTML =  msg;

   });

​

   db.transaction(function (tx) {

      tx.executeSql('SELECT * FROM logs', [], function (tx, results) {

         var len = results.rows.length, i;

         msg = "<p>查询记录条数: " + len + "</p>";

         document.querySelector('#status').innerHTML +=  msg;