html5_websql
2024-10-07 13:12:10
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>Log message created and row inserted.</p>';
console.log(msg);
});
db.transaction(function (tx) {
tx.executeSql('SELECT * FROM LOGS', [], function (tx, results) {
var len = results.rows.length, i;
msg = "<p>Found rows: " + len + "</p>";
console.log(msg);
for (i = 0; i < len; i++){
msg = "<p><b>" + results.rows.item(i).log + "</b></p>";
console.log(msg);
}
}, null);});
最新文章
- mfc+vtk
- XCode6 开发本地化应用
- SpringMVC Model
- Python socket (多线程)
- hdu 3288 Resource Allocation
- Python：if-while-for
- SQL语句 打印等腰三角形，菱形
- HDU 4828 (卡特兰数+逆)
- swift之向ftp服务器传文件
- windows phone 8.1开发：socket通信聊天
- Linux操作数据库基本
- FreeRTOS——错误排查
- c# Linq操作XML，查找节点数据
- CF 291E. Tree-String Problem [dfs kmp trie图优化]
- day 15 - 1 内置函数
- POJ 3126 Prime Path【BFS】
- 学习node.js 第1篇 介绍nodejs
- solus 系统 - 安装 mariadb
- C#使用MiniDump捕获异常
- 使用C#获取Windows Phone手机的各种数据（转）