完整实例
实例
vardb = openDatabase('mydb', '1.0', 'Test DB', 2 * 1024 * 1024);varmsg; 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, "www.runoob.com")'); msg = '
数据表已创建，且插入了两条数据。
'; document.querySelector('#status').innerHTML = msg;}); db.transaction(function(tx){tx.executeSql('SELECT * FROM LOGS', [], function(tx, results){ varlen = 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 ) ; } ) ;