Java批量导出word压缩后的zip文件案例

网友投稿 325 2022-11-19


Java批量导出word压缩后的zip文件案例

一、js代码,由于参数比较大所以利用form表单使用post导出

function export_word(){

var selectedRows = $("#dg").datagrid("getSelections");

if (selectedRows.length==0) {

showAlertWarning("请选择一条的信息...");

return;

}

if (selectedRows.length > 1) {//批量导出压缩文件

var id = "";

for (var i = 0; i < selectedRows.length; i++) {

var row = selectedRows[i];

id += row.id+"name"+row.user_name+"@@";

}

layer.confirm('请选择要导出考核表的类型?', {

btn: ['次数','具体条目'] //按钮

}, function(index){

postExportFile({"id":id,"type":0},"jee/AssessGradeSumC/exportWordsZip");

layer.close(index);

}, function(index){

postExportFile({"id":id,"type":1},"jee/AssessGradeSumC/exportWordsZip");

});

} else {//导出单个

layer.confirm('请选择要导出考核表的类型?', {

btn: ['次数','具体条目'] //按钮

}, function(index){

window.location.href= "jee/AssessGradeSumC/exportWord?id="+selectedRows[0].id;

layer.close(index);

}, function(index){

window.location.href= "jee/AssessGradeSumC/exportWordForSpecific?id="+selectedRows[0].id;

});

}

}

function postExportFile(params, url) { //params是post请求需要的参数,url是请求url地址

var form = document.createElement("form");

form.style.display = 'none';

form.action = url;

form.method = "post";

document.body.appendChild(form);

for(var key in params){

var input = document.createElement("input");

input.type = "hidden";

input.name = key;

input.value = params[key];

form.appendChild(input);

}

form.submit();

form.remove();

}

二、controller代码(读完压缩文件后删除文件)

/**

*

* @Description 考核成绩汇总考核表批量导出压缩

* @Fcunction exportWordsZip

* @param response

* @return ReturnDatas

*

*/

@ResponseBody

@SystemControllerLog(description = "考核成绩汇总考核表批量导出压缩")

@RequestMapping(value = "exportWordsZip")

public ReturnDatas exportWordsZip(HttpServletResponse response, String id, String type) {

ReturnDatas returnDatas = ReturnDatas.getSuccessReturnDatas();

try {

response.setCharacterEncoding("UTF-8");

response.setContentType("application/msexcle");

response.setHeader("content-disposition", "attachment;filename=" + new String("考核成绩汇总表".getBytes("gb2312"), "ISO8859-1") + ".zip");

String fileUrl = assessGradeSumService.exportWordsZip(id,type);

OutputStream outputStream = response.getOutputStream();

BufferedInputStream bis = new BufferedInputStream(new FileInputStream(fileUrl));;

BufferedOutputStream bos = new BufferedOutputStream(outputStream);

byte[] buff = new byte[2048];

int bytesRead;

while (-1 != (bytesRead = bis.read(buff, 0, buff.length))) {

bos.write(buff, 0, bytesRead);

}

bis.close();

bos.close();

outputStream.close();

File zip = new File(fileUrl);

if (zip.exists() && zip.isFile()) {

zip.delete();

}

return returnDatas;

} catch (Exception e) {

e.printStackTrace();

LogUtil.error("考核成绩汇总考核表批量导出压缩异常:" + e.getMessage(), e);

returnDatas.setStatus(ReturnDatas.ERROR);

returnDatas.setMessage("考核成绩汇总考核表批量http://导出压缩异常。");

}

return returnDatas;

}

三、实现类代码,其中exportWord()和exportWordForSpecific()都是具体的word导出方法,生成zip压缩文件后删除word文件,ZipUtils是压缩文件工具类

/**

*

* @Fcunction exportWordsZip

* @param id

* @param type

* @return String

*

*/

@Override

public String exportWordsZip(String id, String type)throws Exception{

String[] ids = id.split("@@");

List fileList = new ArrayList<>();

String url = "C:\\";

for (int i = 0; i < ids.length; i++) {

String id_name = ids[i];

String id_value = id_name.split("name")[0];

String name = id_name.split("name")[1];

String docUrl = url + name + ".doc";

fileList.add(new File(docUrl));

XWPFDocument workbook = null;

if ("0".equals(type)) {//按次

workbook = exportWord(id_value);

} else {//表单条目

workbook = exportWordForSpecific(id_value);

}

FileOutputStream out = new FileOutputStream(docUrl);

workbook.write(out);

}

String zipUrl = url+"考核成绩汇总表.zip";

FileOutputStream fos = new FileOutputStream(new File(zipUrl));

ZipUtils.toZip(fileList, fos);

for (File out:fileList) {

if (out.exists() && out.isFile()) {

out.delete();

}

}

return zipUrl;

}


版权声明:本文内容由网络用户投稿,版权归原作者所有,本站不拥有其著作权,亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容,请联系我们jiasou666@gmail.com 处理,核实后本网站将在24小时内删除侵权内容。

上一篇:poi导出word表格的操作讲解
下一篇:SpringBoot 改造成https访问的实现
相关文章

 发表评论

暂时没有评论,来抢沙发吧~