html5websql登录界面,HTML5 Web SQL

点击运行

入门小站(rumenz.com)

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, "http://rumenz.com")');

msg = '

数据表已创建，且插入了两条数据。

';

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

});

db.transaction(function (tx) {

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

var len = results.rows.length, i;

msg = "

查询记录条数: " + len + "

";

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

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

msg = "

" + results.rows.item(i).log + "

";

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

}

}, null);

});

状态信息