1.接口调用
/** 导出按钮操作 */
handleExport() {
let obj = {
name: this.form.sqlName,
content: this.form.sqlContent,
// content: encrypt(this.form.sqlContent),
programId: this.programId,
userId: this.user.userId,
userCode: this.user.userCode,
dataSourceId: this.form.dataSourceId,
database: this.form.dataBaseName,
};
exportData(obj).then((res) => {
// 该实例化的方式第一个参数必须是数组的格式
const blob = new Blob([res], {
type: 'application/vnd.ms-excel',
});
const url = window.URL.createObjectURL(blob)
const a = document.createElement('a');
a.href = url;
a.download = '导出文件';
a.click();
window.URL.revokeObjectURL(url);
}).catch((r) => {
console.error(r)
})
2.接口,参数要交加上 responseType: ‘blob’
export function exportData(params) {
return request({
responseType: ‘blob’,
url: ‘//export’,
method: ‘post’,
data: params
})
}