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])); }); });