【脚本工具】使用sql操作json

最新推荐文章于 2024-04-29 03:42:10 发布

好吃吗

最新推荐文章于 2024-04-29 03:42:10 发布

阅读量146

点赞数

分类专栏：脚本&工具文章标签：脚本

本文链接：https://blog.csdn.net/xhdxhdxhd/article/details/102867740

版权

脚本&工具专栏收录该内容

34 篇文章 0 订阅

订阅专栏

工具界面

工具说明

Infer Types:
Short numbers: integer or long, if name is id or something, it is long
Datetime: matches YYYY-mm-DD HH:mm:ss
Timestamp: the prefix is 15…
Other types are considered string

示例代码

from MDN

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>';
  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>Found rows: " + 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);
});