140 lines
3.9 KiB
HTML
140 lines
3.9 KiB
HTML
<!DOCTYPE html>
|
||
<html lang="zh-cn">
|
||
<head>
|
||
<meta charset="UTF-8">
|
||
<title>sqlite数据库测试</title>
|
||
<script src="https://unpkg.com/axios/dist/axios.min.js"></script>
|
||
<script src="https://cdn.bootcss.com/sql.js/0.5.0/js/sql-optimized.js"></script>
|
||
</head>
|
||
<body>
|
||
|
||
<p>sqlite数据库测试，使用js操作sqlite数据库</p>
|
||
<p>这里使用axios读取test.db文件，进行初始化数据库连接，</p>
|
||
<p>查询速度不快，除非不想写后台要直接操作数据库，不然没什么用。</p>
|
||
<p>具体效果可查看代码和控制台打印的数据。</p>
|
||
<button onclick="exportfile()"></button>
|
||
|
||
|
||
<script>
|
||
//export csv
|
||
function tableToExcel(){
|
||
//要导出的json数据
|
||
const jsonData = [
|
||
{
|
||
name:'路人甲',
|
||
phone:'123456789',
|
||
email:'000@123456.com'
|
||
},
|
||
{
|
||
name:'炮灰乙',
|
||
phone:'123456789',
|
||
email:'000@123456.com'
|
||
},
|
||
{
|
||
name:'土匪丙',
|
||
phone:'123456789',
|
||
email:'000@123456.com'
|
||
},
|
||
{
|
||
name:'流氓丁',
|
||
phone:'123456789',
|
||
email:'000@123456.com'
|
||
},
|
||
]
|
||
//列标题，逗号隔开，每一个逗号就是隔开一个单元格
|
||
let str = `姓名,电话,邮箱\n`;
|
||
//增加\t为了不让表格显示科学计数法或者其他格式
|
||
for(let i = 0 ; i < jsonData.length ; i++ ){
|
||
for(let item in jsonData[i]){
|
||
str+=`${jsonData[i][item] + '\t'},`;
|
||
}
|
||
str+='\n';
|
||
}
|
||
//encodeURIComponent解决中文乱码
|
||
let uri = 'data:text/csv;charset=utf-8,\ufeff' + encodeURIComponent(str);
|
||
//通过创建a标签实现
|
||
let link = document.createElement("a");
|
||
link.href = uri;
|
||
//对下载的文件命名
|
||
link.download = "json数据表.csv";
|
||
document.body.appendChild(link);
|
||
link.click();
|
||
document.body.removeChild(link);
|
||
}
|
||
//tableToExcel()
|
||
</script>
|
||
|
||
<script>
|
||
|
||
function downloadUrl(filename, url) {
|
||
var element = document.createElement('a');
|
||
element.setAttribute('href', url);
|
||
element.setAttribute('download', filename);
|
||
|
||
element.style.display = 'none';
|
||
document.body.appendChild(element);
|
||
|
||
element.click();
|
||
|
||
document.body.removeChild(element);
|
||
}
|
||
|
||
function DownloadContent(filename,content) {
|
||
var eleLink = document.createElement('a');
|
||
eleLink.download = filename;
|
||
eleLink.style.display = 'none';
|
||
// 字符内容转变成blob地址
|
||
var blob = new Blob([content]);
|
||
eleLink.href = URL.createObjectURL(blob);
|
||
// 触发点击
|
||
document.body.appendChild(eleLink);
|
||
eleLink.click();
|
||
// 然后移除
|
||
document.body.removeChild(eleLink);
|
||
};
|
||
|
||
function exportfile(){
|
||
var data;
|
||
axios.get('deescloud/getDeesAuthDb', {
|
||
})
|
||
.then(function (response) {
|
||
console.log(response.data);
|
||
data = response.data;
|
||
|
||
//console.log(data)
|
||
//downloadUrl("auth.db",'deescloud/getDeesAuthDb?id=123')
|
||
downloadUrl("auth.db",'file/foo.db')
|
||
|
||
var d=new Array();
|
||
console
|
||
for (var i = 0; i < data.length; i++) {
|
||
d.push(data[i]);
|
||
}
|
||
//DownloadContent("auth.db",d);
|
||
|
||
//exportRaw('auth.db',data)
|
||
})
|
||
.catch(function (error) {
|
||
console.log(error);
|
||
});
|
||
}
|
||
|
||
|
||
function fakeClick(obj) {
|
||
var ev = document.createEvent("MouseEvents");
|
||
ev.initMouseEvent("click", true, false, window, 0, 0, 0, 0, 0, false, false, false, false, 0, null);
|
||
obj.dispatchEvent(ev);
|
||
}
|
||
|
||
function exportRaw(name, data) {
|
||
var urlObject = window.URL || window.webkitURL || window;
|
||
var export_blob = new Blob([data]);
|
||
var save_link = document.createElementNS("http://www.w3.org/1999/xhtml", "a")
|
||
save_link.href = urlObject.createObjectURL(export_blob);
|
||
save_link.download = name;
|
||
fakeClick(save_link);
|
||
}
|
||
|
||
</script>
|
||
</body>
|
||
</html> |