Web SQL初体验之新手指导(全功能解析)

1。创建并打开数据库

var db = window.openDatabase("myDatabase", "1.0", "My WebSQL test database", 5*1024*1024); 
// 参数含义：数据库名称，版本号，描述，占用大小(bytes)

 

2。创建数据表

db.transaction(function (tx) {
   tx.executeSql("CREATE TABLE IF NOT EXISTS fightclub (id INTEGER PRIMARY KEY AUTOINCREMENT, rules TEXT)");
});

 

 

3。插入数据

db.transaction(function (tx) {
   tx.executeSql( "INSERT INTO fightclub(rules) VALUES(?)", ['You do not talk about Fight Club']);
});

// or

db.transaction(function (tx) {
    tx.executeSql( "INSERT INTO fightclub(rules) VALUES(?)",['I like u']);
});

 

浏览器web sql数据展示格式:

 

 

4。查询数据

// db.readTransaction or db.transaction即可查询
db.transaction(function (tx) {
  tx.executeSql( "SELECT * FROM fightclub",[],function(tx, results){
    var items = results.rows;
    Object.keys(items).map(k=>console.log(items[k]));
  });
});

 

其他SQL操作可参考sqlite语法。