我正在使用Electron开发桌面应用程序,该表需要显示在页面上,并且该表的数据源是一个DB文件。我在页面上构建了该表,使用SQlite3读取了DB中的数据,但是我不知道如何将数据放在页面上的表中。这是我创建表的代码。
<script type="text/javascript">
$(function () {
$("#myTable").bootstrapTable("destroy");
$("#myTable").bootstrapTable({
url: "json.json",
dataField: "rows",
search: true,
pagination: true,
pageSize: 20,
pageList: [5, 10, 20, 50],
pageNumber: 1,
smartDisplay: false,
sidePagination: "client",
contentType: "application/json",
dataType: "json",
method: "post",
searchAlign: "right",
queryParamsType: "limit",
queryParams: function getParams(params) {
params.other = "otherInfo";
return params;
},
searchOnEnterKey: false,
showRefresh: true,
showColumns: true,
buttonsAlign: "center",
toolbar: "#toolbar",
toolbarAlign: "right",
columns: [
{
title: "check",
field: "check",
checkbox: true,
width: 20,
align: "center",
valign: "middle",
},
{
title: "CollectTime",
field: "CollectTime",
sortable: true,
order: "desc",
},
],
locale: "zh-CN",
});
});
</script>
这是读取数据库数据的代码,使用SQlite3模块打开test.db
var sqlite3 = require("sqlite3").verbose();
const path = require("path");
var db = new sqlite3.Database(path.join(__dirname, "test.db"));
引用DB.js文件并读取所有数据
<script src="./db.js"></script>
<script type="text/javascript">
function getData() {
db.all("select * from DataGrpData", function (err, res) {
if (!err) {
var content = JSON.stringify(res);
console.log(content)
} else {
console.log(err);
}
});
}
getData();
</script>
$("#myTable").bootstrapTable("destroy");
$("#myTable").bootstrapTable({
toolbar: "#toolbar",
data: res,
columns: columns,
pagination: true,
pageSize: 20,
pageList: [5, 10, 20, 50],
pageNumber: 1,
locale: "zh-CN",
searchOnEnterKey: false,
showRefresh: true,
showColumns: true,
buttonsAlign: "center",
});
只需将结果(res)放入数据中