Web SQL数据库的使用教程

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

db.transaction(function (tx) { 

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

});

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

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.cnblogs.com")');

});

db = openDatabase(, , ,  *  *

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

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.cnblogs.com")');

});

db.transaction(function (tx) {

   tx.executeSql('SELECT * FROM LOGS', [], function (tx, results) {      var len = results.rows.length;

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

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

      for (i = 0; i < len; i++){

          msg = "<p><b>" + results.rows[i].log + "</b></p>";

      }

   }, null);

});

db.transaction(function (tx) {

    tx.executeSql('DELETE FROM LOGS  WHERE id=1');

});

db.transaction(function(tx) {

    tx.executeSql('DELETE FROM LOGS WHERE id=?', [id]);

});

tx.executeSql("UPDATE CC SET logname='www.baidu.com' WHERE id=2");

tx.executeSql("UPDATE CC SET logname='www.baidu.com' WHERE id=?", [id]);