- 尝试一下 » - 在线编辑器

<!DOCTYPE HTML>
<html>
<head>
  <meta charset="UTF-8">
  <script type="text/javascript">
    var db = openDatabase('mydb', '1.0', 'Test 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.mifengjc.com")');
      msg = '<p>数据表已创建，且插入了两条数据。</p>';
      document.querySelector('#status').innerHTML = msg;
    });
    db.transaction(function(tx) {
      tx.executeSql('DELETE FROM LOGS  WHERE id=1');
      msg = '<p>删除 id 为 1 的记录。</p>';
      document.querySelector('#status').innerHTML = msg;
    });
    db.transaction(function(tx) {
      tx.executeSql('UPDATE LOGS SET log=\'mifengjc.com\' WHERE id=2');
      msg = '<p>更新 id 为 2 的记录。</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;
        for (i = 0; i < len; i++) {
          msg = "<p><b>" + results.rows.item(i).log + "</b></p>";
          document.querySelector('#status').innerHTML += msg;
        }
      }, null);
    });
  </script>

</head>

<body>
  <div id="status" name="status">状态信息</div>
</body>

</html>
​x
 
<!DOCTYPE HTML>
<html>
<head>
  <meta charset="UTF-8">
  <script type="text/javascript">
    var db = openDatabase('mydb', '1.0', 'Test 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.mifengjc.com")');
      msg = '<p>数据表已创建，且插入了两条数据。</p>';
      document.querySelector('#status').innerHTML = msg;
    });
    db.transaction(function(tx) {
      tx.executeSql('DELETE FROM LOGS  WHERE id=1');
      msg = '<p>删除 id 为 1 的记录。</p>';
      document.querySelector('#status').innerHTML = msg;
    });
    db.transaction(function(tx) {
      tx.executeSql('UPDATE LOGS SET log=\'mifengjc.com\' WHERE id=2');
      msg = '<p>更新 id 为 2 的记录。</p>';
      document.querySelector('#status').innerHTML = msg;
    });