实体转word文件下载

一 新建Word文件

二 填充固定字段名,并另存为xml格式

三 XML格式化

四 在字段后写 ${字段}

五 将修改好的xml的文件,修改为ftl类型

(将ftl文件存在项目static目录下)

六 接口样例

 /***
     * 导出Word
     * @return
     * @throws Exception
     */
    @RequestMapping(value = "exportMillCertificate", method = RequestMethod.GET)
    @ResponseBody
    public void exportMillCertificate(@RequestParam("id") Integer id,HttpServletRequest request,
                                      HttpServletResponse response) throws Exception {
        //获得数据，系统相关，就不展示了
        ProjectQuestionEntity entity = baseService.findById(id);
        if (entity != null) {
            // 实体字段改变 注意修改map转换 getData()
            WordUtils.exportMillCertificateWord(request,response,getData(entity));
        }
    }

/**
     * 实体转map
     * @param entity
     * @return
     */
    private Map<String, String> getData(ProjectQuestionEntity entity) {
        Map<String, String> map = new HashMap<>();
        // 解决方案
        map.put("solvedWay", entity.getSolvedWay() == null ? "" : entity.getSolvedWay());
        // 回复时间
        map.put("replyTime", entity.getReplyTime() == null ? "" : entity.getReplyTime().toString());
        // 回复部门
        map.put("replyUser", entity.getReplyUser() == null ? "" : entity.getReplyUser());
        // 牵头责任 部门
        map.put("dept", entity.getDept() == null ? "" : entity.getDept());
        // 项目名称
        map.put("projectName", entity.getProjectName() == null ? "" : entity.getProjectName());
        // 企业名称
        map.put("companyName", entity.getCompanyName() == null ? "" : entity.getCompanyName());
        // 工单号
        map.put("workOrder", entity.getWorkOrder() == null ? "" : entity.getWorkOrder());
        // 服务事项
        map.put("questionDetail", entity.getQuestionDetail() == null ? "" : entity.getQuestionDetail());
        // 相关部门
        map.put("relevantDepartments", entity.getRelevantDepartments() == null ? "" : entity.getRelevantDepartments());
        // 提出时间
        map.put("createTime", entity.getCreateTime2() == null ? "" : entity.getCreateTime2());
        return map;
    }

六 Word导出工具类

package com.zjhcsoft.bi.huznth.common.util;

import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStreamWriter;
import java.io.Writer;
import java.net.URLEncoder;
import java.util.Map;

import freemarker.template.Configuration;
import freemarker.template.Template;

/**
 * word下载工具类
 */
public class WordUtils {
    //配置信息,代码本身写的还是很可读的,就不过多注解了
    private static final Configuration configuration ;
    //这里注意的是利用WordUtils的类加载器动态获得模板文件的位置
//    private static final String templateFolder = "static\\uploadPath\\2022\\07\\18";
    // todo 服务工单 服务器文件地址
    private static final String templateFolder = "/data/home/huznth/server/static/uploadPath/2022/07/18";
    static {
        configuration = new Configuration();
        configuration.setDefaultEncoding("utf-8");
        try {
            configuration.setDirectoryForTemplateLoading(new File(templateFolder));
        } catch (IOException e) {
            e.printStackTrace();
        }
   }

    private WordUtils() {
        throw new AssertionError();
    }

    public static void exportMillCertificateWord(HttpServletRequest request, HttpServletResponse response, Map map) throws IOException {
        Template freemarkerTemplate = configuration.getTemplate("服务事项模板.ftl");
        File file = null;
        InputStream fin = null;
        ServletOutputStream out = null;
        try {
            // 调用工具类的createDoc方法生成Word文档
            file = createDoc(map,freemarkerTemplate);
            fin = new FileInputStream(file);

            response.setCharacterEncoding("utf-8");
            response.setContentType("application/msword");
            // 设置浏览器以下载的方式处理该文件名
            String fileName = "服务工单.doc";
            response.setHeader("Content-Disposition", "attachment;filename="
                    .concat(String.valueOf(URLEncoder.encode(fileName, "UTF-8"))));

            out = response.getOutputStream();
            byte[] buffer = new byte[512];  // 缓冲区
            int bytesToRead = -1;
            // 通过循环将读入的Word文件的内容输出到浏览器中
            while((bytesToRead = fin.read(buffer)) != -1) {
                out.write(buffer, 0, bytesToRead);
            }
        } finally {
            if(fin != null) fin.close();
            if(out != null) out.close();
            if(file != null) file.delete(); // 删除临时文件
        }
    }

    private static File createDoc(Map<?, ?> dataMap, Template template) {
        String name =  "test.doc";
        File f = new File(name);
        Template t = template;
        try {
            // 这个地方不能使用FileWriter因为需要指定编码类型否则生成的Word文档会因为有无法识别的编码而无法打开
            Writer w = new OutputStreamWriter(new FileOutputStream(f), "utf-8");
            t.process(dataMap, w);
            w.close();
        } catch (Exception ex) {
            ex.printStackTrace();
            throw new RuntimeException(ex);
        }
        return f;
    }
}