HTML5 Web SQL数据库程序操作示例
<!DOCTYPE HTML>
<html>
<head>
<script type="text/javascript">
var dab = openDatabase('empdb', '1.0', 'test DB', 2 * 1024 * 2048);
var masg;
dab.transaction(function (txt) {
txt.executeSql('CREATE TABLE IF NOT EXISTS LOGIN (id unique, logs)');
txt.executeSql('INSERT INTO LOGIN (id, logs) VALUES (1, "amrit")');
txt.executeSql('INSERT INTO LOGIN (id, logs) VALUES (2, "loginmessage")');
txt.executeSql('INSERT INTO LOGIN (id, logs) VALUES (3, "my message")');
masg = '<p>LOGIN message created and row inserted.</p>';
document.querySelector('#status').innerHTML = masg;
});
dab.transaction(function (txt) {
txt.executeSql('SELECT * FROM LOGIN', [], function (txt, results) {
var leng = results.rows.length, i;
masg = "<p>Found rows: " + leng + "</p>";
document.querySelector('#status').innerHTML += masg;
for (i = 0; i < leng; i++){
masg = "<p>your message is=  " + results.rows.item(i).logs +"   AND ID=  " +results.rows.item(i).id + "</p>";
document.querySelector('#status').innerHTML += masg;
}
}, null);
});
</script>
</head>
<body>
<div id="status" name="status">Status Message</div>
</body>
</html>
日期：2020-04-11 23:04:12 来源：oir作者：oir