<!DOCTYPE html>
<html>
<head>
<title>明镜止水</title>
<script type="text/javascript">
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,"foobar")');
tx.executeSql('INSERT INTO LOGS(id,log) VALUES(2,"logmsg")');
msg='<p>完成消息创建和插入行操作。</p>';
document.querySelector('#status').innerHTML=msg;
});
db.transaction(function(tx) {
tx.executeSql('SELECT * FROM LOGS',[],function(tx,results){
var len=results.rows.length,i;
msg="<p>查询行数:"+len+"</p>";
document.querySelector('#status').innerHTML+=msg;
for(i=0;i<len;i++){
msg="<p><b>"+results.rows.item(i).log+"</b></p>";
document.querySelector('#status').innerHTML+=msg;
}
},null);
});
</script>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8">
</head>
<body>
<div id="status" name="status">
</div>
</body>
</html>
<html>
<head>
<title>明镜止水</title>
<script type="text/javascript">
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,"foobar")');
tx.executeSql('INSERT INTO LOGS(id,log) VALUES(2,"logmsg")');
msg='<p>完成消息创建和插入行操作。</p>';
document.querySelector('#status').innerHTML=msg;
});
db.transaction(function(tx) {
tx.executeSql('SELECT * FROM LOGS',[],function(tx,results){
var len=results.rows.length,i;
msg="<p>查询行数:"+len+"</p>";
document.querySelector('#status').innerHTML+=msg;
for(i=0;i<len;i++){
msg="<p><b>"+results.rows.item(i).log+"</b></p>";
document.querySelector('#status').innerHTML+=msg;
}
},null);
});
</script>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8">
</head>
<body>
<div id="status" name="status">
</div>
</body>
</html>