数据库blob二进制文件下载到本地
1、从数据库获取到二进制字段内容
2、通过浏览器响应下载到本地
var id = p_item.getValue("OBJ_ID");
var filename = p_item.getValue("REALNAME");
var content = p_item.getValue("WJ"); // 拿到从数据库取出的二进制文件字段是base64字符串
// 由于new Blob(参数) 参数需为二进制数组,所以要进行转换
var blob = new Blob([base64ToArrayBuffer(content)]);
if ('download' in document.createElement('a')) { // 非IE下载
const elink = document.createElement('a')
elink.download = filename;
console.log(filename);
elink.style.display = 'none'
elink.target="_blank";
elink.href = URL.createObjectURL(blob)
document.body.appendChild(elink)
elink.click()
URL.revokeObjectURL(elink.href) // 释放URL 对象
document.body.removeChild(elink)
} else { // IE10+下载
navigator.msSaveBlob(blob, filename)
}
转化二进制数组方法
function base64ToArrayBuffer(base64) {
var binaryString = window.atob(base64);
var binaryLen = binaryString.length;
var bytes = new Uint8Array(binaryLen);
for (var i = 0; i < binaryLen; i++) {
var ascii = binaryString.charCodeAt(i);
bytes[i] = ascii;
}
return bytes;
}