详解前端HTML5几种存储方式的总结

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

//openDatabase() 方法对应的五个参数分别为：数据库名称、版本号、描述文本、数据库大小、创建回调 

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

db.transaction(function (tx) {  

   tx.executeSql('CREATE TABLE IF NOT EXISTS WIN (id unique, name)');

}); 

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

db.transaction(function (tx) {

   tx.executeSql('CREATE TABLE IF NOT EXISTS WIN (id unique, name)');

   tx.executeSql('INSERT INTO WIN (id, name) VALUES (1, "winty")');

   tx.executeSql('INSERT INTO WIN (id, name) VALUES (2, "LuckyWinty")');

}); 

db.transaction(function (tx) {

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

      var len = results.rows.length, i;

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

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

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

         alert(results.rows.item(i).name );

      }

   }, null);

});