前后端分离项目之数据导出为word实例

1.后台restful api，组装文件输出流对象到response响应包输出到前端(vue+webpack node管理)。
后台接口：根据projectId查询相关数据，并将相关字段封装到word模板中，最后用流输出文件。

控制层代码

@RequestMapping("/exportToWord")    @ResponseBody    public void exportToWord(HttpServletRequest request,             HttpServletResponse response,            @RequestParam(value = "projectId", required = true) String projectId) {        try {            String path = request.getSession().getServletContext().getRealPath("\\");            projectDocService.exportToWord(response,projectId,path);        } catch (Exception e) {            logger.error("事项导出成word失败:", e);        }    }

业务层代码

public void exportToWord(HttpServletResponse response,String projectId,String path) throws Exception{        HashMap<String,Object> params=new HashMap<String,Object>();        params.put("projectId", projectId);        HashMap<String, Object> projectMap = projectDao.queryProjectDetailByPid(params);        if(projectMap!=null){            // 导出基本信息            operatorProject(projectMap, path);            String downpath = path + "FileDownload/govsdm/Download/project.docx";            String erweimapath = path + "FileDownload/govsdm/QRCode/project.jpg";            String srcpath = path + "FileDownload/govsdm/Export/project.docx";            FileInputStream inputStream = new FileInputStream(erweimapath);            Map<String, FileInputStream> maps = new HashMap<String, FileInputStream>(                    0);            maps.put("$erweima", inputStream);            CustomXWPFDocument customXWPFDocument = new CustomXWPFDocument();            // 插入二维码            customXWPFDocument.searchAndReplaceImg(srcpath, downpath,                    erweimapath, maps);            download(downpath, response, projectMap.get("projectName").toString());        }    }

导出的word模板如下图：

public void operatorProject(Map<String, Object> projectMap, String path) throws Exception {        HashMap<String, Object> map = new HashMap<String, Object>();        //事项基本信息        map.put("${projectNo}", projectMap.get("projectNo"));        map.put("${projectName}", projectMap.get("projectName"));        map.put("${PROJECTNAMEBIAOTI}", projectMap.get("projectName"));        map.put("${deptName}", projectMap.get("deptName"));        map.put("${itemName}", projectMap.get("itemName"));        map.put("${projectItemNo}", projectMap.get("projectItemNo"));        map.put("${projectShowNo}", projectMap.get("projectShowNo"));        map.put("${gridNo}", projectMap.get("gridNo"));        map.put("${PROJECT_TYPE_NAME}", projectMap.get("PROJECT_TYPE_NAME"));        map.put("${SERVICE_TYPE_NAME}", projectMap.get("SERVICE_TYPE_NAME"));        map.put("${CASE_TYPE_NAME}", projectMap.get("CASE_TYPE_NAME"));        map.put("${DEAL_TYPE_NAME}", projectMap.get("DEAL_TYPE_NAME"));        map.put("${TONGBAN_RANGE_NAME}", projectMap.get("TONGBAN_RANGE_NAME"));        map.put("${RUN_SYSTEM_TYPE_NAME}", projectMap.get("RUN_SYSTEM_TYPE_NAME"));        map.put("${POWER_UPDATE_TYPE_NAME}", projectMap.get("POWER_UPDATE_TYPE_NAME"));        map.put("${POWER_STATE_NAME}", projectMap.get("POWER_STATE_NAME"));        map.put("${ACCEPTING_RANGE_NAME}", projectMap.get("ACCEPTING_RANGE_NAME"));        map.put("${IMPLEMET_SUBJECT_NATURE_NAME}", projectMap.get("IMPLEMET_SUBJECT_NATURE_NAME"));        map.put("${AUTHORITY_DIVISION_NAME}", projectMap.get("AUTHORITY_DIVISION_NAME"));        map.put("${STREET_DEAL_AUTHORITY_NAME}", projectMap.get("STREET_DEAL_AUTHORITY_NAME"));        map.put("${DISTRIBUTE_SYS_TYPE_NAME}", projectMap.get("DISTRIBUTE_SYS_TYPE_NAME"));        map.put("${distributeSysUrl}", projectMap.get("distributeSysUrl"));        SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");        String date =sdf.format(new Date());        map.put("${riqi}", date);        //查询字典表--审批类型        HashMap<String,Object> projectTypeMap  = new HashMap<String,Object>();        projectTypeMap.put("dictCode", "1003");        List<HashMap<String, Object>> projectTypeList = sysDictInfoDao.findList(new RowBounds(), projectTypeMap);        String projectType = combinationString(projectTypeList, String.valueOf(projectMap.get("projectType")));        // 事项类型        map.put("${SHIXIANGLEIXING}", projectType);        //查询字典表--办理类型        HashMap<String,Object> dealTypeMap  = new HashMap<String,Object>();        dealTypeMap.put("dictCode", "1004");        List<HashMap<String, Object>> dealTypeList = sysDictInfoDao.findList(new RowBounds(), dealTypeMap);        String dealType = combinationString(dealTypeList, String.valueOf(projectMap.get("dealType")));        // 办理类型        map.put("${BANLILEIXING}", dealType);        //办事指南基本信息        HashMap<String, Object> paramsMap = new HashMap<String, Object>();        paramsMap.put("projectId",String.valueOf(projectMap.get("projectId")));        HashMap<String, Object> summaryList = projectSummaryDao.queryProjectSummaryById(paramsMap);        summaryList=StringUtils.clobToStringByMap(summaryList);//办事指南信息        List<HashMap<String,Object>> projectFoundationList=projectFoundationDao.findList(new RowBounds(), paramsMap);        projectFoundationList=StringUtils.clobToStringByList(projectFoundationList);//设立依据信息        String foundation="";        if(projectFoundationList!=null && projectFoundationList.size()>0){            for(HashMap<String,Object> map1:projectFoundationList){                String categoryName=map1.get("categoryName")==null?"":map1.get("categoryName").toString();                String name=map1.get("name")==null?"":map1.get("name").toString();                String organization=map1.get("organization")==null?"":map1.get("organization").toString();                String issueOrderno=map1.get("issueOrderno")==null?"":map1.get("issueOrderno").toString();                foundation+="["+categoryName+"]"+name+"("+organization+issueOrderno+")"+";";            }        }        map.put("${foundation}", foundation);        // 申请材料清单        String applyMaterial=summaryList.get("applyMaterial")==null?"":summaryList.get("applyMaterial").toString();        map.put("${applyMaterial}", StringEscapeUtils.unescapeHtml(applyMaterial));        //受理标准(条件)        String acceptCondition=summaryList.get("acceptCondition")==null?"":summaryList.get("acceptCondition").toString();        map.put("${acceptCondition}", StringEscapeUtils.unescapeHtml(acceptCondition));        //办理(审批)条件        String premitCond=summaryList.get("premitCond")==null?"":summaryList.get("premitCond").toString();        map.put("${premitCond}", StringEscapeUtils.unescapeHtml(premitCond));        //材料审核标准        String materAuditStandard=summaryList.get("materAuditStandard")==null?"":summaryList.get("materAuditStandard").toString();        map.put("${materAuditStandard}", StringEscapeUtils.unescapeHtml(materAuditStandard));        //收费标准        String chargeStandard=summaryList.get("chargeStandard")==null?"":summaryList.get("chargeStandard").toString();        map.put("${chargeStandard}", StringEscapeUtils.unescapeHtml(chargeStandard));        //收费依据        String chargeFoundation=summaryList.get("chargeFoundation")==null?"":summaryList.get("chargeFoundation").toString();        map.put("${chargeFoundation}", StringEscapeUtils.unescapeHtml(chargeFoundation));        //法定办理期限        String statutoryDays=summaryList.get("statutoryDays")==null?"":summaryList.get("statutoryDays").toString();        map.put("${statutoryDays}", StringEscapeUtils.unescapeHtml(statutoryDays));        //法定办理期限描述        String statutoryDesc=summaryList.get("statutoryDesc")==null?"":summaryList.get("statutoryDesc").toString();        map.put("${statutoryDesc}", StringEscapeUtils.unescapeHtml(statutoryDesc));        //承诺办理期限        String promiseDays=summaryList.get("promiseDays")==null?"":summaryList.get("promiseDays").toString();        map.put("${promiseDays}", StringEscapeUtils.unescapeHtml(promiseDays));        //承诺办理期限描述        String promiseDesc=summaryList.get("promiseDesc")==null?"":summaryList.get("promiseDesc").toString();        map.put("${promiseDesc}", StringEscapeUtils.unescapeHtml(promiseDesc));        //业务主管部门        String examAppDept=summaryList.get("examAppDept")==null?"":summaryList.get("examAppDept").toString();        map.put("${examAppDept}", StringEscapeUtils.unescapeHtml(examAppDept));        //实施机构(实施主体)        String acceptName=summaryList.get("acceptName")==null?"":summaryList.get("acceptName").toString();        map.put("${acceptName}", StringEscapeUtils.unescapeHtml(acceptName));        //联办机构        String jointlyOrganize=summaryList.get("jointlyOrganize")==null?"":summaryList.get("jointlyOrganize").toString();        map.put("${jointlyOrganize}", StringEscapeUtils.unescapeHtml(jointlyOrganize));        //办理处（科）室        String dealMain=summaryList.get("dealMain")==null?"":summaryList.get("dealMain").toString();        map.put("${dealMain}", StringEscapeUtils.unescapeHtml(dealMain));        //办理地点        String acceptAddress=summaryList.get("acceptAddress")==null?"":summaryList.get("acceptAddress").toString();        map.put("${acceptAddress}", StringEscapeUtils.unescapeHtml(acceptAddress));        //所在窗口        String windowAddress=summaryList.get("windowAddress")==null?"":summaryList.get("windowAddress").toString();        map.put("${windowAddress}", StringEscapeUtils.unescapeHtml(windowAddress));        //办理时间        String workTime=summaryList.get("workTime")==null?"":summaryList.get("workTime").toString();        map.put("${workTime}", StringEscapeUtils.unescapeHtml(workTime));        //中介服务        String intermediaryService=summaryList.get("intermediaryService")==null?"":summaryList.get("intermediaryService").toString();        map.put("${intermediaryService}", StringEscapeUtils.unescapeHtml(intermediaryService));        //数量限制        String quantityRestriction=summaryList.get("quantityRestriction")==null?"":summaryList.get("quantityRestriction").toString();        map.put("${quantityRestriction}", StringEscapeUtils.unescapeHtml(quantityRestriction));        //行使内容(权限说明)        String acceptAuthorityDesc=summaryList.get("acceptAuthorityDesc")==null?"":summaryList.get("acceptAuthorityDesc").toString();        map.put("${acceptAuthorityDesc}", StringEscapeUtils.unescapeHtml(acceptAuthorityDesc));        //特别程序及期限        String specialProcedure=summaryList.get("specialProcedure")==null?"":summaryList.get("specialProcedure").toString();        map.put("${specialProcedure}", StringEscapeUtils.unescapeHtml(specialProcedure));        //责任事项        String responsibilityMatters=summaryList.get("responsibilityMatters")==null?"":summaryList.get("responsibilityMatters").toString();        map.put("${responsibilityMatters}", StringEscapeUtils.unescapeHtml(responsibilityMatters));        //责任事项依据        String responsibilityFoundation=summaryList.get("responsibilityFoundation")==null?"":summaryList.get("responsibilityFoundation").toString();        map.put("${responsibilityFoundation}", StringEscapeUtils.unescapeHtml(responsibilityFoundation));        //职责边界        String responsibilityBoundary=summaryList.get("responsibilityBoundary")==null?"":summaryList.get("responsibilityBoundary").toString();        map.put("${responsibilityBoundary}", StringEscapeUtils.unescapeHtml(responsibilityBoundary));        //平均去现场次数        String sceneNum=summaryList.get("sceneNum")==null?"":summaryList.get("sceneNum").toString();        map.put("${sceneNum}", StringEscapeUtils.unescapeHtml(sceneNum));        //办理流程        String process=summaryList.get("process")==null?"":summaryList.get("process").toString();        map.put("${process}", StringEscapeUtils.unescapeHtml(process));        //内部流程描述        String insideProcessDesc=summaryList.get("insideProcessDesc")==null?"":summaryList.get("insideProcessDesc").toString();        map.put("${insideProcessDesc}", StringEscapeUtils.unescapeHtml(insideProcessDesc));        //证照形式及有效期        String certName=summaryList.get("certName")==null?"":summaryList.get("certName").toString();        map.put("${certName}", StringEscapeUtils.unescapeHtml(certName));        //证照名称        String licenseName=summaryList.get("licenseName")==null?"":summaryList.get("licenseName").toString();        map.put("${licenseName}", StringEscapeUtils.unescapeHtml(licenseName));        //填报人        String reporter=summaryList.get("reporter")==null?"":summaryList.get("reporter").toString();        map.put("${reporter}", StringEscapeUtils.unescapeHtml(reporter));        //填报人联系方式        String reporterPhone=summaryList.get("reporterPhone")==null?"":summaryList.get("reporterPhone").toString();        map.put("${reporterPhone}", StringEscapeUtils.unescapeHtml(reporterPhone));        //备注        String remark=summaryList.get("remark")==null?"":summaryList.get("remark").toString();        map.put("${remark}", StringEscapeUtils.unescapeHtml(remark));        //预留字段1        String reserve1=summaryList.get("reserve1")==null?"":summaryList.get("reserve1").toString();        map.put("${reserve1}", StringEscapeUtils.unescapeHtml(reserve1));        //预留字段2        String reserve2=summaryList.get("reserve2")==null?"":summaryList.get("reserve2").toString();        map.put("${reserve2}", StringEscapeUtils.unescapeHtml(reserve2));        //预留字段3        String reserve3=summaryList.get("reserve3")==null?"":summaryList.get("reserve3").toString();        map.put("${reserve3}", StringEscapeUtils.unescapeHtml(reserve3));        //预留字段4        String reserve4=summaryList.get("reserve4")==null?"":summaryList.get("reserve4").toString();        map.put("${reserve4}", StringEscapeUtils.unescapeHtml(reserve4));        //预留字段5        String reserve5=summaryList.get("reserve5")==null?"":summaryList.get("reserve5").toString();        map.put("${reserve5}", StringEscapeUtils.unescapeHtml(reserve5));        //导出模板的文件路径        String srcPath = path + "FileDownload\\govsdm\\Masterplate\\project.docx";        //导出的word路径        String destPath = path + "FileDownload\\govsdm\\Export\\project.docx";        List<HashMap<String, Object>> projectMaterList =                 projectMaterialsDao.queryProjectMaterialsByPid(paramsMap);        projectMaterList=StringUtils.clobToStringByList(projectMaterList);//将clob类型转换为string        if(projectMaterList!=null && projectMaterList.size()>0){            searchAndReplaceProject(srcPath, destPath, map,projectMaterList);        }    }

public static void searchAndReplaceProject(String srcPath, String destPath,            HashMap<String, Object> map,            List<HashMap<String, Object>> projectMaterialsList) throws IOException {        try {            File srcDocument = new File(srcPath);            OPCPackage pack = POIXMLDocument.openPackage(srcDocument.toString());            XWPFDocument document = new XWPFDocument(pack);            // 替换表格中的指定文字            Iterator<XWPFTable> itTable = document.getTablesIterator();            while (itTable.hasNext()) {                XWPFTable table = (XWPFTable) itTable.next();                int rcount = table.getNumberOfRows();                for (int i = 0; i < rcount; i++) {                    XWPFTableRow row = table.getRow(i);                    List<XWPFTableCell> cells = row.getTableCells();                    for (XWPFTableCell cell : cells) {                        for (Entry<String, Object> e : map.entrySet()) {                            if (cell.getText().equals(e.getKey())) {                                cell.removeParagraph(0);                                XWPFParagraph p=cell.addParagraph();                                try {                                    p.createRun().setText(e.getValue().toString());                                } catch (Exception e1) {                                    e1.printStackTrace();                                }                            }                        }                    }                }            }             try {                 List<XWPFTable> tableList=document.getTables();                 if (tableList!=null&&tableList.size()>0) {                     int length=tableList.size();                     XWPFTable table = (XWPFTable) tableList.get(length-1);                     for(int i=0;i<projectMaterialsList.size();i++){                         XWPFTableRow row=table.createRow();                         List<XWPFTableCell> cells = row.getTableCells();                         for (int j = 0; j < cells.size(); j++) {                             XWPFTableCell cell=cells.get(j);                             cell.removeParagraph(0);                             CTTcPr tcpr = cell.getCTTc().addNewTcPr();                             CTTblWidth cellw = tcpr.addNewTcW();                             cellw.setType(STTblWidth.DXA);                             cellw.setW(BigInteger.valueOf(360*5));                             if(j==0){                             cell.setText(String.valueOf(projectMaterialsList.get(i).get("materialName")));                             }if(j==1){                                 cell.setText(String.valueOf(projectMaterialsList.get(i).get("description")));                             }if(j==2){                                  if("01".equals(projectMaterialsList.get(i).get("materialType")))                                  {                                      cell.setText("■文本类 □表格类 □结果文书类 □其它类");                                  }else if("02".equals(projectMaterialsList.get(i).get("materialType")))                                  {                                      cell.setText("□文本类 ■表格类 □结果文书类 □其它类");                                  }else if("03".equals(projectMaterialsList.get(i).get("materialType")))                                  {                                      cell.setText("□文本类 □表格类 ■结果文书类 □其它类");                                  }else                                  {                                      cell.setText("□文本类 □表格类 □结果文书类 ■其它类");                                  }                              }                         }                     }                 }                 FileOutputStream outStream = null;                 outStream = new FileOutputStream(destPath);                 document.write(outStream);                 outStream.close();             } catch (Exception e) {                 e.printStackTrace();             }                /////////////////给WORD插入标题///////////////                //获得第一个段落对象                   XWPFParagraph paragraph = document.getParagraphs().get(3);                   //段落的格式,下面及个设置,将使新添加的文字向左对其,无缩进.                   paragraph.setIndentationLeft(0);                   paragraph.setIndentationHanging(0);                   paragraph.setWordWrap(true);                   //在段落中新插入一个run,这里的run我理解就是一个word文档需要显示的个体,里面可以放文字,参数0代表在段落的最前面插入                   XWPFRun run = paragraph.insertNewRun(0);                   //设置run内容                   run.setText(map.get("${PROJECTNAMEBIAOTI}")+"");                   run.setFontFamily("宋体");                   run.setBold(true);                   run.setFontSize(20);                FileOutputStream outStream = null;                outStream = new FileOutputStream(destPath);                document.write(outStream);                outStream.flush();                outStream.close();            }catch (Exception e) {                e.printStackTrace();            }    }

private String combinationString(List<HashMap<String, Object>> list, String type) {        String cString = "";        String[] typeArr = type.split(",");        boolean isSelected = false;        for (int i = 0; i < list.size(); i++) {            isSelected = false;            for(String type1 : typeArr){                if (list.get(i).get("dictId").equals(type1)) {                      isSelected = true;                }            }            if (isSelected) {                cString += "■" + list.get(i).get("dictName") + "  ";            }else{                cString += "□" + list.get(i).get("dictName") + "  ";            }        }        return cString;    }

最后输出文件流

public HttpServletResponse download(String path, HttpServletResponse response, String projectname) throws Exception {        // path是指欲下载的文件的路径。        File file = new File(path);        // 以流的形式下载文件。        InputStream fis = new BufferedInputStream(new FileInputStream(path));        byte[] buffer = new byte[fis.available()];        fis.read(buffer);        fis.close();        // 清空response        response.reset();        // 设置response的Header        response.addHeader("Content-Disposition", "attachment;filename="                + new String((projectname + ".docx").getBytes("gbk"),                        "iso-8859-1"));        response.addHeader("Content-Length", "" + file.length());        OutputStream toClient = new BufferedOutputStream(                response.getOutputStream());        response.setContentType("application/octet-stream");        toClient.write(buffer);        toClient.flush();        toClient.close();        return response;    }

前端vue代码片段；

<Button type="warning" size="small" @click="exports(item.projectId)" icon="share" v-if="btnData.indexOf('export')!==-1">导出</Button>

js代码

//导出        exports(projectId){            let token = localStorage.getItem('token');            //自定义form标签，初始化相关参数            var form = $("<form>");            form.attr('style', 'display:none');            form.attr('target', '');            form.attr('method', 'post');            form.attr('action', window.config.api + '/projectDocController/exportToWord.do');            var input1 = $('<input>');            input1.attr('type', 'hidden');            input1.attr('name', 'projectId');            input1.attr('value', projectId);            var input2 = $('<input>');            input2.attr('type', 'hidden');            input2.attr('name', 'token');            input2.attr('value', token);            $('body').append(form);            form.append(input1);            form.append(input2);            form.submit();            form.remove();        }

小结：针对文件流的操作，尽量用提交form表单的形式处理请求。