poi根据模版导出多页word,带插入图片,并压缩下载

2 篇文章 0 订阅

工具类代码

package cn.edu.nfu.jw.srs.utils;

import org.apache.poi.xwpf.usermodel.*;
import org.apache.xmlbeans.XmlOptions;
import org.openxmlformats.schemas.wordprocessingml.x2006.main.CTBody;

import javax.servlet.http.HttpServletResponse;
import java.io.*;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
import java.util.zip.ZipEntry;
import java.util.zip.ZipOutputStream;

public class WordUtils {
    /**
     * 根据模板生成word
     *
     * @param path      模板的路径
     * @param params    需要替换的参数
     * @param tableList 需要插入的参数
     * @param fileName  生成word文件的文件名
     * @param response
     */
    public void getWord(String path, Map<String, Object> params, List<String[]> tableList, String fileName, HttpServletResponse response) throws Exception {
        File file = new File(path);
        InputStream is = new FileInputStream(file);
        CustomXWPFDocument doc = new CustomXWPFDocument(is);
        this.replaceInPara(doc, doc, params);    //替换文本里面的变量
        this.replaceInTable(doc, doc, params, tableList); //替换表格里面的变量
        OutputStream os = response.getOutputStream();
        response.setHeader("Content-disposition", "attachment; filename=" + fileName);
        doc.write(os);
        this.close(os);
        this.close(is);
    }

    /**
     * 替换段落里面的变量
     *
     * @param doc    要替换的文档
     * @param params 参数
     */
    public void replaceInPara(CustomXWPFDocument firstDoc, CustomXWPFDocument doc, Map<String, Object> params) {
        Iterator<XWPFParagraph> iterator = doc.getParagraphsIterator();
        XWPFParagraph para;
        while (iterator.hasNext()) {
            para = iterator.next();
            this.replaceInPara(firstDoc, para, params, doc);
        }
    }

    /**
     * 替换段落里面的变量
     *
     * @param para   要替换的段落
     * @param params 参数
     */
    private void replaceInPara(CustomXWPFDocument firstDoc, XWPFParagraph para, Map<String, Object> params, CustomXWPFDocument doc) {
        List<XWPFRun> runs;
        Matcher matcher;
        if (this.matcher(para.getParagraphText()).find()) {
            runs = para.getRuns();
            int start = -1;
            int end = -1;
            String str = "";
            for (int i = 0; i < runs.size(); i++) {
                XWPFRun run = runs.get(i);
                String runText = run.toString();
                if ('$' == runText.charAt(0) && '{' == runText.charAt(1)) {
                    start = i;
                }
                if ((start != -1)) {
                    str += runText;
                }
                if ('}' == runText.charAt(runText.length() - 1)) {
                    if (start != -1) {
                        end = i;
                        break;
                    }
                }
            }

            for (int i = start; i <= end; i++) {
                para.removeRun(i);
                i--;
                end--;
            }

            for (Map.Entry<String, Object> entry : params.entrySet()) {
                String key = entry.getKey();
                if (str.indexOf(key) != -1) {
                    Object value = entry.getValue();
                    if (value instanceof String) {
                        str = str.replace(key, value.toString());
                        para.createRun().setText(str, 0);
                        break;
                    } else if (value instanceof Map) {
                        str = str.replace(key, "");
                        Map pic = (Map) value;
                        int width = Integer.parseInt(pic.get("width").toString());
                        int height = Integer.parseInt(pic.get("height").toString());
                        int picType = getPictureType(pic.get("type").toString());
                        byte[] byteArray = (byte[]) pic.get("content");
                        ByteArrayInputStream byteInputStream = new ByteArrayInputStream(byteArray);
                        try {
                            String ind = firstDoc.addPictureData(byteInputStream, picType);
                            int id = firstDoc.getNextPicNameNumber(picType);
                            firstDoc.createPicture(ind, id, width, height, para);
                            // 由于图片重复则显示错误,重写create方法
                            // firstDoc.addPictureData(byteInputStream, picType);
                            // firstDoc.createPicture(firstDoc.getAllPictures().size() - 1, width, height, para, firstDoc);
                            para.createRun().setText(str, 0);
                            break;
                        } catch (Exception e) {
                            e.printStackTrace();
                        }
                    }
                }
            }
        }
    }


    /**
     * 为表格插入数据,行数不够添加新行
     *
     * @param table     需要插入数据的表格
     * @param tableList 插入数据集合
     */
    private static void insertTable(XWPFTable table, List<String[]> tableList) {
        //创建行,根据需要插入的数据添加新行,不处理表头
        for (int i = 0; i < tableList.size(); i++) {
            XWPFTableRow row = table.createRow();
        }
        //遍历表格插入数据
        List<XWPFTableRow> rows = table.getRows();
        int length = table.getRows().size();
        for (int i = 1; i < length - 1; i++) {
            XWPFTableRow newRow = table.getRow(i);
            List<XWPFTableCell> cells = newRow.getTableCells();
            for (int j = 0; j < cells.size(); j++) {
                XWPFTableCell cell = cells.get(j);
                String s = tableList.get(i - 1)[j];
                cell.setText(s);
            }
        }
    }

    /**
     * 替换表格里面的变量
     *
     * @param doc    要替换的文档
     * @param params 参数
     */
    public void replaceInTable(CustomXWPFDocument firstDoc, CustomXWPFDocument doc, Map<String, Object> params, List<String[]> tableList) {
        Iterator<XWPFTable> iterator = doc.getTablesIterator();
        XWPFTable table;
        List<XWPFTableRow> rows;
        List<XWPFTableCell> cells;
        List<XWPFParagraph> paras;
        while (iterator.hasNext()) {
            table = iterator.next();
            if (table.getRows().size() > 1) {
                //判断表格是需要替换还是需要插入,判断逻辑有$为替换,表格无$为插入
                if (this.matcher(table.getText()).find()) {
                    rows = table.getRows();
                    for (XWPFTableRow row : rows) {
                        cells = row.getTableCells();
                        for (XWPFTableCell cell : cells) {
                            paras = cell.getParagraphs();
                            for (XWPFParagraph para : paras) {
                                this.replaceInPara(firstDoc, para, params, doc);
                            }
                        }
                    }
                } else {
                    insertTable(table, tableList);  //插入数据
                }
            }
        }
    }

    /**
     * 正则匹配字符串
     *
     * @param str
     * @return
     */
    private Matcher matcher(String str) {
        Pattern pattern = Pattern.compile("\\$\\{(.+?)\\}", Pattern.CASE_INSENSITIVE);
        Matcher matcher = pattern.matcher(str);
        return matcher;
    }

    /**
     * 根据图片类型,取得对应的图片类型代码
     *
     * @param picType
     * @return int
     */
    public int getPictureType(String picType) {
        int res = CustomXWPFDocument.PICTURE_TYPE_PICT;
        if (picType != null) {
            if (picType.equalsIgnoreCase("png")) {
                res = CustomXWPFDocument.PICTURE_TYPE_PNG;
            } else if (picType.equalsIgnoreCase("dib")) {
                res = CustomXWPFDocument.PICTURE_TYPE_DIB;
            } else if (picType.equalsIgnoreCase("emf")) {
                res = CustomXWPFDocument.PICTURE_TYPE_EMF;
            } else if (picType.equalsIgnoreCase("jpg") || picType.equalsIgnoreCase("jpeg")) {
                res = CustomXWPFDocument.PICTURE_TYPE_JPEG;
            } else if (picType.equalsIgnoreCase("wmf")) {
                res = CustomXWPFDocument.PICTURE_TYPE_WMF;
            }
        }
        return res;
    }

    public  byte[] input2byte(InputStream inStream) throws IOException {
        ByteArrayOutputStream swapStream = new ByteArrayOutputStream();
        byte[] buff = new byte[inStream.available()];
        int rc = 0;
        while ((rc = inStream.read(buff, 0, 100)) > 0) {
            swapStream.write(buff, 0, rc);
        }
        byte[] in2b = swapStream.toByteArray();
        swapStream.close();
        return in2b;
    }

    /**
     * 将输入流中的数据写入字节数组
     *
     * @param in
     * @return
     */
    public static byte[] inputStream2ByteArray(InputStream in, boolean isClose) {
        byte[] byteArray = null;
        try {
            int total = in.available();
            byteArray = new byte[total];
            in.read(byteArray);
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            if (isClose) {
                try {
                    in.close();
                } catch (Exception e2) {
                    e2.getStackTrace();
                }
            }
        }
        return byteArray;
    }

    /**
     * 关闭输入流
     *
     * @param is
     */
    public void close(InputStream is) {
        if (is != null) {
            try {
                is.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    }

    /**
     * 关闭输出流
     *
     * @param os
     */
    public void close(OutputStream os) {
        if (os != null) {
            try {
                os.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    }

    /**
     * @Description: 保存图片(用来插入)
     * @Param:
     * @return:
     * @Author: lgc
     * @Date: 2019/4/24
     */
    public static byte[] readInputStream(InputStream inStream) throws Exception {
        ByteArrayOutputStream outStream = new ByteArrayOutputStream();
        //创建一个Buffer字符串
        byte[] buffer = new byte[1024];
        //每次读取的字符串长度,如果为-1,代表全部读取完毕
        int len = 0;
        //使用一个输入流从buffer里把数据读取出来
        while ((len = inStream.read(buffer)) != -1) {
            //用输出流往buffer里写入数据,中间参数代表从哪个位置开始读,len代表读取的长度
            outStream.write(buffer, 0, len);
        }
        //关闭输入流
        inStream.close();
        //把outStream里的数据写入内存
        return outStream.toByteArray();
    }

    //两个对象进行追加
    public static CustomXWPFDocument mergeWord(CustomXWPFDocument document, CustomXWPFDocument doucDocument2) throws Exception {
        CustomXWPFDocument src1Document = document;
        XWPFParagraph p = src1Document.createParagraph();
        //设置分页符
        p.setPageBreak(true);
        CTBody src1Body = src1Document.getDocument().getBody();
        CustomXWPFDocument src2Document = doucDocument2;
        CTBody src2Body = src2Document.getDocument().getBody();
        XWPFParagraph p2 = src2Document.createParagraph();
        XmlOptions optionsOuter = new XmlOptions();
        optionsOuter.setSaveOuter();
        String appendString = src2Body.xmlText(optionsOuter);
        String srcString = src1Body.xmlText();
        String prefix = srcString.substring(0, srcString.indexOf(">") + 1);
        String mainPart = srcString.substring(srcString.indexOf(">") + 1, srcString.lastIndexOf("<"));
        String sufix = srcString.substring(srcString.lastIndexOf("<"));
        String addPart = appendString.substring(appendString.indexOf(">") + 1, appendString.lastIndexOf("<"));
        CTBody makeBody = CTBody.Factory.parse(prefix + mainPart + addPart + sufix);
        src1Body.set(makeBody);
        return src1Document;
    }

    //压缩输出
    public static void createZipPath(String path, HttpServletResponse response, String zipName) throws IOException {
        ZipOutputStream zipOutputStream = null;
        OutputStream output = response.getOutputStream();
        response.reset();
        String fileNameZip = new String((zipName + ".zip").getBytes("UTF-8"), "iso-8859-1");
        response.setHeader("Content-disposition", "attachment; filename=" + fileNameZip);
        response.setContentType("application/msword");
        zipOutputStream = new ZipOutputStream(output);
        File[] files = new File(path).listFiles();
        FileInputStream fileInputStream = null;
        byte[] buf = new byte[1024];
        int len = 0;
        if (files != null && files.length > 0) {
            for (File wordFile : files) {
                String fileName = wordFile.getName();
                fileInputStream = new FileInputStream(wordFile);
                //放入压缩zip包中;
                zipOutputStream.putNextEntry(new ZipEntry(fileName));
                //读取文件;
                while ((len = fileInputStream.read(buf)) > 0) {
                    zipOutputStream.write(buf, 0, len);
                }
                //关闭;
                zipOutputStream.closeEntry();
                if (fileInputStream != null) {
                    fileInputStream.close();
                }
            }
        }

        if (zipOutputStream != null) {
            zipOutputStream.close();
        }
    }
    /**
     * 将InputStream写入本地文件
     * @param destination 写入本地目录
     * @param input 输入流
     * @throws IOException IOException
     */
    public void writeToLocal(String destination, InputStream input)
            throws IOException {
        int index;
        byte[] bytes = new byte[1024];
        FileOutputStream downloadFile = new FileOutputStream(destination);
        while ((index = input.read(bytes)) != -1) {
            downloadFile.write(bytes, 0, index);
            downloadFile.flush();
        }
        input.close();
        downloadFile.close();

    }
    /***
     * 删除文件夹
     *
     * @param folderPath 文件夹完整绝对路径
     */
    public static void delFolder(String folderPath) {
        try {
            delAllFile(folderPath); // 删除完里面所有内容
            String filePath = folderPath;
            filePath = filePath.toString();
            java.io.File myFilePath = new java.io.File(filePath);
            myFilePath.delete(); // 删除空文件夹
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    /***
     * 删除指定文件夹下所有文件
     *
     * @param path 文件夹完整绝对路径
     * @return
     */
    public static boolean delAllFile(String path) {
        boolean flag = false;
        File file = new File(path);
        if (!file.exists()) {
            return flag;
        }
        if (!file.isDirectory()) {
            return flag;
        }
        String[] tempList = file.list();
        File temp = null;
        for (int i = 0; i < tempList.length; i++) {
            if (path.endsWith(File.separator)) {
                temp = new File(path + tempList[i]);
            } else {
                temp = new File(path + File.separator + tempList[i]);
            }
            if (temp.isFile()) {
                temp.delete();
            }
            if (temp.isDirectory()) {
                delAllFile(path + "/" + tempList[i]);// 先删除文件夹里面的文件
                delFolder(path + "/" + tempList[i]);// 再删除空文件夹
                flag = true;
            }
        }
        return flag;
    }
}

创建图片工具类

package cn.edu.nfu.jw.srs.utils;

import org.apache.poi.openxml4j.opc.OPCPackage;
import org.apache.poi.xwpf.usermodel.XWPFDocument;
import org.apache.poi.xwpf.usermodel.XWPFParagraph;
import org.apache.xmlbeans.XmlException;
import org.apache.xmlbeans.XmlToken;
import org.openxmlformats.schemas.drawingml.x2006.main.CTNonVisualDrawingProps;
import org.openxmlformats.schemas.drawingml.x2006.main.CTPositiveSize2D;
import org.openxmlformats.schemas.drawingml.x2006.wordprocessingDrawing.CTInline;

import java.io.IOException;
import java.io.InputStream;

public class CustomXWPFDocument extends XWPFDocument {

    public CustomXWPFDocument(InputStream in) throws IOException {
        super(in);
    }

    public CustomXWPFDocument() {
        super();
    }

    public CustomXWPFDocument(OPCPackage pkg) throws IOException {
        super(pkg);
    }

    /**
     * @param id
     * @param width     宽
     * @param height    高
     * @param paragraph 段落
     */
    public void createPicture(int id, int width, int height, XWPFParagraph paragraph, CustomXWPFDocument doc) {
        final int EMU = 9525;
        width *= EMU;
        height *= EMU;
        String blipId = doc.getAllPictures().get(id).getPackageRelationship().getId();
        CTInline inline = paragraph.createRun().getCTR().addNewDrawing().addNewInline();
        String picXml = ""
                + "<a:graphic xmlns:a=\"http://schemas.openxmlformats.org/drawingml/2006/main\">"
                + "   <a:graphicData uri=\"http://schemas.openxmlformats.org/drawingml/2006/picture\">"
                + "      <pic:pic xmlns:pic=\"http://schemas.openxmlformats.org/drawingml/2006/picture\">"
                + "         <pic:nvPicPr>" + "            <pic:cNvPr id=\""
                + id
                + "\" name=\"Generated\"/>"
                + "            <pic:cNvPicPr/>"
                + "         </pic:nvPicPr>"
                + "         <pic:blipFill>"
                + "            <a:blip r:embed=\""
                + blipId
                + "\" xmlns:r=\"http://schemas.openxmlformats.org/officeDocument/2006/relationships\"/>"
                + "            <a:stretch>"
                + "               <a:fillRect/>"
                + "            </a:stretch>"
                + "         </pic:blipFill>"
                + "         <pic:spPr>"
                + "            <a:xfrm>"
                + "               <a:off x=\"0\" y=\"0\"/>"
                + "               <a:ext cx=\""
                + width
                + "\" cy=\""
                + height
                + "\"/>"
                + "            </a:xfrm>"
                + "            <a:prstGeom prst=\"rect\">"
                + "               <a:avLst/>"
                + "            </a:prstGeom>"
                + "         </pic:spPr>"
                + "      </pic:pic>"
                + "   </a:graphicData>" + "</a:graphic>";

        inline.addNewGraphic().addNewGraphicData();
        XmlToken xmlToken = null;
        try {
            xmlToken = XmlToken.Factory.parse(picXml);
        } catch (XmlException xe) {
            xe.printStackTrace();
        }
        inline.set(xmlToken);

        CTPositiveSize2D extent = inline.addNewExtent();
        extent.setCx(width);
        extent.setCy(height);

        CTNonVisualDrawingProps docPr = inline.addNewDocPr();
        docPr.setId(id);
        docPr.setName("图片" + blipId);
        docPr.setDescr("头像");
    }

    public void createPicture(String blipId, int id, int width, int height, XWPFParagraph paragraph) {
        final int EMU = 9525;
        width *= EMU;
        height *= EMU;
        //String blipId = getAllPictures().get(id).getPackageRelationship().getId();
        CTInline inline = paragraph.createRun().getCTR().addNewDrawing().addNewInline();

        String picXml = "" +
                "<a:graphic xmlns:a=\"http://schemas.openxmlformats.org/drawingml/2006/main\">" +
                "   <a:graphicData uri=\"http://schemas.openxmlformats.org/drawingml/2006/picture\">" +
                "      <pic:pic xmlns:pic=\"http://schemas.openxmlformats.org/drawingml/2006/picture\">" +
                "         <pic:nvPicPr>" +
                "            <pic:cNvPr id=\"" + id + "\" name=\"Generated\"/>" +
                "            <pic:cNvPicPr/>" +
                "         </pic:nvPicPr>" +
                "         <pic:blipFill>" +
                "            <a:blip r:embed=\"" + blipId + "\" xmlns:r=\"http://schemas.openxmlformats.org/officeDocument/2006/relationships\"/>" +
                "            <a:stretch>" +
                "               <a:fillRect/>" +
                "            </a:stretch>" +
                "         </pic:blipFill>" +
                "         <pic:spPr>" +
                "            <a:xfrm>" +
                "               <a:off x=\"0\" y=\"0\"/>" +
                "               <a:ext cx=\"" + width + "\" cy=\"" + height + "\"/>" +
                "            </a:xfrm>" +
                "            <a:prstGeom prst=\"rect\">" +
                "               <a:avLst/>" +
                "            </a:prstGeom>" +
                "         </pic:spPr>" +
                "      </pic:pic>" +
                "   </a:graphicData>" +
                "</a:graphic>";

        inline.addNewGraphic().addNewGraphicData();
        XmlToken xmlToken = null;
        try {
            xmlToken = XmlToken.Factory.parse(picXml);
        } catch (XmlException xe) {
            xe.printStackTrace();
        }
        inline.set(xmlToken);

        CTPositiveSize2D extent = inline.addNewExtent();
        extent.setCx(width);
        extent.setCy(height);

        CTNonVisualDrawingProps docPr = inline.addNewDocPr();
        docPr.setId(id);
        docPr.setName("图片" + id);
        docPr.setDescr("头像");
    }
}

操作ftp文件工具类

package cn.edu.nfu.jw.srs.utils;

import java.io.*;
import java.net.URLEncoder;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.apache.commons.net.ftp.FTPClient;
import org.apache.poi.hwpf.HWPFDocument;
import org.apache.poi.hwpf.usermodel.Range;

import cn.edu.nfu.jw.exception.ServiceException;
import cn.edu.nfu.jw.srs.domain.SrsJbzl;
import cn.edu.nfu.jw.srs.domain.SrsPunishment;

/**
 * 创建word文档
 * 
 * @author manolin
 *
 */
public class CommonUtil {
	private static final Log log = LogFactory.getLog(CommonUtil.class);
	public static void createDocumentByTemplate(String realname, HttpServletResponse response,
			String templeteName, SrsPunishment info) {
		
		OutputStream outp = null;
		InputStream in = null;
		templeteName=File.separator+"doc"+File.separator+templeteName; // 模板文件名字
		String fileName = realname; //输出文件名称
		try {
			fileName = URLEncoder.encode(fileName, "UTF-8") ;
			if(!fileName.endsWith(".doc")){
				fileName=fileName+".doc";
			}
			response.reset();
			response.setContentType("application/doc");
			response.addHeader("Content-Disposition", "attachment; filename="+fileName);
			response.setContentType("application/octet-stream;charset=UTF-8");
			outp = response.getOutputStream();
			in = CommonUtil.class.getClassLoader().getResourceAsStream(templeteName);
			//替换变量
			HWPFDocument doc = new HWPFDocument(in);
			Range range = doc.getRange();
			range.replaceText("${name}", info.getSrsJbzl().getXm());
			range.replaceText("${punishment}", info.getPunishment());
			range.replaceText("${gender}",getGender(info.getSrsJbzl()));
			range.replaceText("${xh}",info.getSrsJbzl().getXh());
			range.replaceText("${yxmc}",info.getSrsJbzl().getFesYx().getYxmc());
			range.replaceText("${zymc}",info.getSrsJbzl().getFesZy().getZymc());
			range.replaceText("${rxnj}",info.getSrsJbzl().getRxnj().toString());
			range.replaceText("${cheatTime}",formatDate(info.getCheatTime()));
			range.replaceText("${cheatSubject}",info.getCheatSubject());
			range.replaceText("${cheatDetail}",info.getCheatDetail());
			range.replaceText("${rule}",info.getRules());
			range.replaceText("${cTime}",formatDate(info.getcTime()));
			ByteArrayOutputStream ostream = new ByteArrayOutputStream();
			doc.write(ostream);
			outp.write(ostream.toByteArray());
			outp.flush();
		} catch (Exception e) {
			e.printStackTrace();
			log.error("occur exception on get file template: "  + e.getLocalizedMessage());
		} finally {
			try {
				if (in != null) {
					in.close();
				}
				if (outp != null) {
					outp.close();
				}
			} catch (Exception e) {
				log.error("occur exception on closing stream: "  + e.getLocalizedMessage());
			}
		}
	}
	private static String getGender(SrsJbzl srsJbzl){
		String gender="";
		if(srsJbzl.getXbdm().equals("1")){
			gender="男";
		}else if(srsJbzl.getXbdm().equals("2")){
			gender="女";
		}else{
			log.error("gender data error! student id="+srsJbzl.getId()); 
			throw new ServiceException(-1,"学生性别数据异常!");
		}
		return gender;
	}
	private static String formatDate(Date date){
		DateFormat dft=new SimpleDateFormat("yyyy年MM月dd日");
		return dft.format(date);
	}

	/**
	 * 上传文件
	 * @param file
	 * @param filePath
	 * @param fileName
	 */
	public static void uploadFile(byte[] file, String filePath, String fileName) {
		File targetFile = new File(filePath);
		if(!targetFile.exists()){
			targetFile.mkdirs();
		}
		FileOutputStream out = null;
		try {
			out = new FileOutputStream(filePath + fileName);
			out.write(file);
			out.flush();
		} catch (Exception e) {

		} finally {
			try {
				if (out != null)
					out.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
	}

	/**
	 * 上传文件到ftp服务器
	 * @param host
	 * @param port
	 * @param username
	 * @param pwd
	 * @param path
	 * @param local
	 * @param filename
	 */
	public static boolean uploadFile(String host, int port, String username, String pwd,
									 String path, InputStream local, String filename){
		boolean result = false;
		//创建客户端对象
		FTPClient ftp = new FTPClient();
		try {
			//连接ftp服务器
			ftp.connect(host, port);
			//登录
			ftp.login(username, pwd);
			//检查上传路径是否存在 如果不存在返回false
			boolean flag = ftp.changeWorkingDirectory(path);
			if(!flag){
				//创建上传的路径  该方法只能创建一级目录,在这里如果/home/ftpuser存在则可创建image
				ftp.makeDirectory(path);
			}
			//指定编码
			//ftp.setControlEncoding("GBK");
			//防止数据链路不通
			ftp.enterLocalPassiveMode();
			//指定上传路径
			ftp.changeWorkingDirectory(path);
			//指定上传文件的类型  二进制文件
			ftp.setFileType(FTPClient.BINARY_FILE_TYPE);
			//第一个参数是文件名
			ftp.storeFile(new String(filename.getBytes(),"iso-8859-1"), local);
			result = true;
		} catch (IOException e) {
			log.error("occur exception on uploading green channel file to ftp server : " + e.getLocalizedMessage());
			e.printStackTrace();
		} finally {
			try {
				//关闭文件流
				local.close();
				//退出
				ftp.logout();
				//断开连接
				ftp.disconnect();
			} catch (IOException e) {
				log.error("occur exception on close stream on uploading green channel file to ftp server : " + e.getLocalizedMessage());
				e.printStackTrace();
			}
		}
		return result;
	}

	/**
	 * 返回流
	 * @param host
	 * @param port
	 * @param username
	 * @param pwd
	 * @param path
	 * @param response
	 * @param ftpfilename
	 * @return
	 */
	public static boolean getFileIo(String host, int port, String username, String pwd,
									String path, HttpServletResponse response, String ftpfilename){
		boolean result = false;
		//创建客户端对象
		FTPClient ftp = new FTPClient();
		try {
			//连接ftp服务器
			ftp.connect(host, port);
			//登录
			ftp.login(username, pwd);
			//检查上传路径是否存在 如果不存在返回false
			boolean flag = ftp.changeWorkingDirectory(path);
			if (!flag) {
				//创建上传的路径  该方法只能创建一级目录,在这里如果/home/ftpuser存在则可创建image
				ftp.makeDirectory(path);
			}
			//指定编码
			//ftp.setControlEncoding("GBK");
			//防止数据链路不通
			ftp.enterLocalPassiveMode();
			//切换目录
			ftp.changeWorkingDirectory(path);
			//指定上传文件的类型  二进制文件
			ftp.setFileType(FTPClient.BINARY_FILE_TYPE);
			//设置文件返回类型
			response.setContentType("image/*");
			response.addHeader("Content-Disposition", "attachment; filename="+ftpfilename+".png");
			result = ftp.retrieveFile(new String(ftpfilename.getBytes(),"iso-8859-1"), response.getOutputStream());
		} catch (IOException e) {
			log.error("occur exception on get ftp file io from ftp server : " + e.getLocalizedMessage());
			e.printStackTrace();
		} finally {
			try {
				//退出
				ftp.logout();
				//断开连接
				ftp.disconnect();
			} catch (IOException e) {
				log.error("occur exception on close stream on get ftp file io from ftp server : " + e.getLocalizedMessage());
				e.printStackTrace();
			}
		}
		return result;
	}

	/**
	 * 获取文件输入流
	 * @param host
	 * @param port
	 * @param username
	 * @param pwd
	 * @param path
	 * @param ftpfilename
	 * @return
	 */
	public static InputStream  getFileInputStream(String host, int port, String username, String pwd,
									String path, String ftpfilename){
		//创建客户端对象
		FTPClient ftp = new FTPClient();
		InputStream inputStream = null;
		try {
			//连接ftp服务器
			ftp.connect(host, port);
			//登录
			ftp.login(username, pwd);
			//检查上传路径是否存在 如果不存在返回false
			boolean flag = ftp.changeWorkingDirectory(path);
			if (!flag) {
				//创建上传的路径  该方法只能创建一级目录,在这里如果/home/ftpuser存在则可创建image
				ftp.makeDirectory(path);
			}
			//指定编码
			//ftp.setControlEncoding("GBK");
			//防止数据链路不通
			ftp.enterLocalPassiveMode();
			//切换目录
			ftp.changeWorkingDirectory(path);
			//指定上传文件的类型  二进制文件
			ftp.setFileType(FTPClient.BINARY_FILE_TYPE);
			//设置文件返回类型
			inputStream = ftp.retrieveFileStream(new String(ftpfilename.getBytes(), "iso-8859-1"));
		} catch (IOException e) {
			log.error("occur exception on get ftp file io from ftp server : " + e.getLocalizedMessage());
			e.printStackTrace();
		} finally {
			try {
				//退出
				ftp.logout();
				//断开连接
				ftp.disconnect();
			} catch (IOException e) {
				log.error("occur exception on close stream on get ftp file io from ftp server : " + e.getLocalizedMessage());
				e.printStackTrace();
			}
		}
		return inputStream;
	}

	/**
	 * 从ftp服务器上删除文件
	 * @param host
	 * @param port
	 * @param username
	 * @param pwd
	 * @param path
	 * @param ftpfilename
	 * @return
	 */
	public static boolean delFile(String host, int port, String username, String pwd,
								  String path, String ftpfilename){
		boolean result = false;
		//创建客户端对象
		FTPClient ftp = new FTPClient();
		try {
			//连接ftp服务器
			ftp.connect(host, port);
			//登录
			ftp.login(username, pwd);
			//检查上传路径是否存在 如果不存在返回false
			boolean flag = ftp.changeWorkingDirectory(path);
			if (!flag) {
				//创建上传的路径  该方法只能创建一级目录,在这里如果/home/ftpuser存在则可创建image
				ftp.makeDirectory(path);
			}
			//指定编码
			//ftp.setControlEncoding("GBK");
			//防止数据链路不通
			ftp.enterLocalPassiveMode();
			//指定上传路径
			ftp.changeWorkingDirectory(path);
			//指定上传文件的类型  二进制文件
			ftp.deleteFile(ftpfilename);
			result = true;
		} catch (IOException e) {
			log.error("occur exception on deletting green channel file from ftp server : " + e.getLocalizedMessage());
			e.printStackTrace();
		} finally {
			try {
				//退出
				ftp.logout();
				//断开连接
				ftp.disconnect();
			} catch (IOException e) {
				log.error("occur exception on close stream on deletting green channel file from ftp server : " + e.getLocalizedMessage());
				e.printStackTrace();
			}
		}
		return result;
	}

	/**
	 * 下载模板信息
	 * 适用于windows和linux
	 * @param response
	 * @param request
	 * @param templeteName
	 * @throws IOException
	 */
	public static void downloadTemplate(String realname, HttpServletResponse response, HttpServletRequest request, String templeteName) {
		OutputStream outp = null;
		InputStream in = null;
		try {
			String fileName = templeteName; //要下载的模板文件
			if(templeteName!=null){
				if(!templeteName.endsWith(".doc")){
					fileName = templeteName + ".doc";
				}
			}
			//String filedownload = CommonUtil.class.getClassLoader().getResource("").getPath();
			//filedownload += fileName;
			fileName = URLEncoder.encode(fileName, "UTF-8") ;
			// 要下载的模板所在的绝对路径
			response.reset();
			response.addHeader("Content-Disposition", "attachment; filename="+fileName);
			response.setContentType("application/octet-stream;charset=UTF-8");
			outp = response.getOutputStream();
			in = cn.edu.nfu.jw.srs.utils.CommonUtil.class.getClassLoader().getResourceAsStream(realname);
			//new File(ResourceUtils.getURL("classpath:").getPath());
			//in = new FileInputStream(filedownload);
			byte[] b = new byte[1024];
			int i;
			while ((i = in.read(b)) > 0) {
				outp.write(b, 0, i);
			}
			outp.flush();
		} catch (Exception e) {
			e.printStackTrace();
			log.error("occur exception on get file template: "  + e.getLocalizedMessage());
		} finally {
			try {
				if (in != null) {
					in.close();
				}
				if (outp != null) {
					outp.close();
				}
			} catch (Exception e) {
				log.error("occur exception on closing stream: "  + e.getLocalizedMessage());
			}
		}
	}
}

自己实现的业务代码

public void batchPrintXjxx(HttpServletResponse response, SrsJbzl obj) {
        obj.setPageSize(Integer.MAX_VALUE);
        obj.setStart(0);
        List<SrsJbzl> userList = dao.listPage(obj);

        //创建压缩包位置
        File fileZip = new File("/wordZip");
        if (!fileZip.exists()) {
            fileZip.mkdirs();
        }
        //到处的登记表名称
        String wordName = "中山大学南方学院本科生学籍登记表";
        String filesPath = "/wordZip/" + new Date().getTime();
        //合并模板的个数就是每次要解析多少个当前的模板 ,那么就需要首先定义一个集合
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
        //我用的是2007版本以后poi对word进行解析的docx
        //首先定义一个XWPFDocument 集合 这个对象可以进行word 解析 合并 还有下载都离不开这个对象
        List<CustomXWPFDocument> xwpfDocuments = new ArrayList<>();
        //由于合并时将所有图片都存在第一个doc里面,所以定义方便图片传值
        CustomXWPFDocument firstDoc = null;
        //判断需要的参数
        Integer sex;
        Date playStartTime;
        List<Map<String, Object>> allZzmm = xsjbxxDao.getAllZzmm();
        String filePath = ResourceUtils.CLASSPATH_URL_PREFIX + "中山大学南方学院本科生学籍登记表" + ".docx";
        //期次我们先解析word模板 替换其中的占位符
        int index = 0;
        Integer handleTime = 1;
        try {
            for (SrsJbzl srsJbzl : userList) {
                WordUtils wordUtils = new WordUtils();
                Map<String, Object> params = new HashMap<>();
                //从ftp下载图片
                InputStream fileInputStream = CommonUtil.getFileInputStream(FTP_ADDRESS, FTP_PORT, FTP_USERNAME, FTP_PASSWORD, FTP_BASEPATH, srsJbzl.getXh());
                if (fileInputStream != null) {
                    Map<String, Object> header = new HashMap<>();
                    header.put("width", 100);
                    header.put("height", 150);
                    header.put("type", "jpg");
                    byte[] bytes = wordUtils.input2byte(fileInputStream);
//                    byte[] bytes1 = WordUtils.inputStream2ByteArray(fileInputStream, true);
                    header.put("content", bytes);
                    params.put("${headImage}", header);
                } else {
                    params.put("${headImage}", "");
                }
                params.put("${xm}", srsJbzl.getXm());
                params.put("${cym}", srsJbzl.getCym());
                params.put("${ywxm}", srsJbzl.getYwxm());
                params.put("${xh}", srsJbzl.getXh());
                params.put("${xb}", "1".equals(srsJbzl.getXbdm()) ? "男" : "2".equals(srsJbzl.getXbdm()) ? "女" : "");
               

# params.put("${jkzk}", srsJbzl.getSrsJkzkdm()==null?"":srsJbzl.getSrsJkzkdm().getJkzkmc());//健康状况 params.put("${sznj}", srsJbzl.getSznj() == null ? "" : srsJbzl.getSznj().toString());//年级 params.put("${csrq}", srsJbzl.getCsrq() ==null ?"":sdf.format(srsJbzl.getCsrq()));//出生时间 params.put("${gj}", srsJbzl.getFesDqGjdm() == null ? "":srsJbzl.getFesDqGjdm().getGjmc());//国籍 params.put("${mz}", srsJbzl.getFesMzdm() == null ? "":srsJbzl.getFesMzdm().getMzmc());//民族 params.put("${hf}", srsJbzl.getFesHyzkdm() == null?"":srsJbzl.getFesHyzkdm().getHyzkmc());//婚否 params.put("${cc}", srsJbzl.getCc());//层次 //to String zzmmc = ""; for (Map<String, Object> stringObjectMap : allZzmm) { if((Long)stringObjectMap.get("ID")==srsJbzl.getZzmmdm().getId().longValue()){ zzmmc = (String)stringObjectMap.get("ZZMMMC"); } } params.put("${zzmm}", zzmmc);//政治面貌 params.put("${jtcs}", srsJbzl.getSrsJtcsdm()==null?"":srsJbzl.getSrsJtcsdm().getJtcsMc());//家庭出身 params.put("${jg}", srsJbzl.getJgFesDqXsdm()==null?"":srsJbzl.getJgFesDqXsdm().getXsmc());//籍贯 params.put("${csd}", srsJbzl.getHkszd());//出生地 params.put("${lxdh}", srsJbzl.getYxlxdh());//联系电话 params.put("${sfzh}", srsJbzl.getSfzjh());//身份证号 params.put("${email}", srsJbzl.getEmail());//E-mail params.put("${yxmc}", srsJbzl.getFesYx()==null?"":srsJbzl.getFesYx().getYxmc());//系别 params.put("${zymc}", srsJbzl.getFesZy()==null?"":srsJbzl.getFesZy().getZymc());//专业 params.put("${rtsjdd}", srsJbzl.getRtsjdd());//何时何地加入共青团 params.put("${rdsjdd}", srsJbzl.getRdsjdd());//何时何地加入何党派 params.put("${txmxdz}", srsJbzl.getTxmxdz());//通讯地址 params.put("${hjdqdm1}", srsJbzl.getHjdqdm());//邮编 params.put("${hjdqdm2}", srsJbzl.getHjdqdm());//邮编 params.put("${jtzz}", srsJbzl.getJtzz());//家庭地址 params.put("${jtdh}", srsJbzl.getJtdh());//家庭电话 params.put("${chcddz}", srsJbzl.getChcddz());//乘火车到达站 params.put("${rxsj}", srsJbzl.getRxny()==null?"":sdf.format(srsJbzl.getRxny()));//入学时间 params.put("${rxfs}",srsJbzl.getSrsRxfsdm()==null?"":srsJbzl.getSrsRxfsdm().getRxfsmc());//入学方式 params.put("${rxqxl}", srsJbzl.getFesRxsfdm()==null?"":srsJbzl.getFesRxsfdm().getRxsfmc());//入学前学历 //查宿舍信息 String shByXsid = xsjbxxDao.getShByXsid(srsJbzl.getId()); params.put("${xxss}", shByXsid);//学校宿舍 params.put("${hq}", srsJbzl.getYnHq()!=null&&srsJbzl.getYnHq() ? "是" : "否");//是否华侨 params.put("${ga}", srsJbzl.getYnHq()!=null&&srsJbzl.getYnGas() ? "是" : "否");//是否港澳生 params.put("${qj}", srsJbzl.getYnHq()!=null&&srsJbzl.getYnQj() ? "是" : "否");//是否侨眷 List<SrsGzjlzl> srsGzjlzls = gzjlzlDao.listByMySelf(srsJbzl); List<SrsJtzl> srsJtzls = jtzlDao.listByMySelf(srsJbzl); if(srsGzjlzls!=null && srsGzjlzls.size()>0){ for (int i=0; i<srsGzjlzls.size() ;i++) { if (i==3) break;//个人简历不超过3条 String qsrq = sdf.format(srsGzjlzls.get(i).getQsrq()); String jsrq = sdf.format(srsGzjlzls.get(i).getQsrq()); params.put("${qzny"+(i+1)+"}", qsrq+"到"+jsrq); params.put("${szdw"+(i+1)+"}", srsGzjlzls.get(i).getSzdw()); params.put("${zw"+(i+1)+"}", srsGzjlzls.get(i).getZw()); params.put("${zmr"+(i+1)+"}",srsGzjlzls.get(i).getZmr()); } } if(srsJtzls!=null && srsJtzls.size()>0){ for (int i=0; i<srsJtzls.size() ;i++) { if (i==2) break;//监护人不超过2条 params.put("${cyxm"+(i+1)+"}", srsJtzls.get(i).getCyxm()); params.put("${ybrgx"+(i+1)+"}", srsJtzls.get(i).getYbrgx()); params.put("${sflx"+(i+1)+"}", srsJtzls.get(i).getSflx()); params.put("${cysrzh"+(i+1)+"}",srsJtzls.get(i).getCysrzh()); params.put("${lxdh"+(i+1)+"}",srsJtzls.get(i).getLxdh()); } } //学籍异动日志 Page page = new Page(); page.setCurrent(0); page.setPageSize(100); SrsRecord srsRecord = new SrsRecord(); srsRecord.setJbzl(srsJbzl); List<SrsRecord> srsRecordlist = srsRecordService.list(srsRecord, page); if(srsRecordlist!=null && srsRecordlist.size()>0){ for (int i=0; i<srsRecordlist.size() ;i++) { if (i==3) break;//最多只显示三条 params.put("${ctime"+(i+1)+"}", srsRecordlist.get(i).getCtime()!=null?sdf.format(srsRecordlist.get(i).getCtime()):""); params.put("${ydlxName"+(i+1)+"}", srsRecordlist.get(i).getYdlxName()); params.put("${reason"+(i+1)+"}", srsRecordlist.get(i).getReason()); } } params.put("${jcqk}", srsJbzl.getJcqk());//何时何地何原因受过何种奖励或处分 params.put("${ahtc}", srsJbzl.getAhtc());//有何爱好与特长 params.put("${syxwrq}", srsJbzl.getSyxwrq()!=null?sdf.format(srsJbzl.getSyxwrq()):"");//学位证书时间 params.put("${sjbysj}",srsJbzl.getSjbysj()!=null?sdf.format(srsJbzl.getSjbysj()):"");//毕业证书时间 params.put("${xwzh}", srsJbzl.getXwzh());//学位证书编号 params.put("${byzsh}", srsJbzl.getByzsh());//毕业证书编号

                //返回一个新的xwpfDocument对象
                File file = ResourceUtils.getFile(filePath);
                InputStream is = new FileInputStream(file);
                CustomXWPFDocument doc = new CustomXWPFDocument(is);
                if (index == 0 || (index != 1 && index % 49 == 1)) {
                    firstDoc = doc;
                }
                wordUtils.replaceInPara(firstDoc, doc, params);
                wordUtils.replaceInTable(firstDoc, doc, params, null);
                xwpfDocuments.add(doc);
                is.close();
                //每50条输出一次
                if (userList.size() > 50 && index != 0 && (index == userList.size() - 1 || index % 49 == 0)) {
                    File files = new File(filesPath);
                    if (!files.exists()) {
                        files.mkdirs();
                    }
                    //这样第一步将所有word内容替换之后生成多个   xwpfDocument
                    //现在将多个xwpfDocument 进行合并 追加 生成word文件
                    CustomXWPFDocument xwpfDocument = xwpfDocuments.get(0);
                    for (int i = 0; i < xwpfDocuments.size(); i++) {
                        //每次的追加为了避免样式和格式混乱 加上分页符
                        //当是只有一条数据的时候 直接输出
                        if (i == 0) {
                            xwpfDocument = xwpfDocuments.get(0);
                            continue;
                        } else {
                            //当存在多条时候
                            xwpfDocument = WordUtils.mergeWord(xwpfDocument, xwpfDocuments.get(i));
                        }
                    }
                    //合并之后返回XWPFDocument对象 写出就可以了
                    String fileName = wordName + handleTime + ".docx";
                    FileOutputStream fout = new FileOutputStream(filesPath + "/" + new File(fileName));
                    xwpfDocument.write(fout);
                    fout.close();
                    handleTime++;
                    xwpfDocuments.clear();
                }
                index++;
            }
            if (userList.size() > 50) {
                createZipPath(filesPath, response, "中山大学南方学院本科生学籍登记表");
                File files = new File(filesPath);
                if (files.exists()) {
                    delFolder(files.getPath());
                }
            } else {
                if (xwpfDocuments.size() > 0) {
                    //这样第一步将所有word内容替换之后生成多个   xwpfDocument
                    //现在将多个xwpfDocument 进行合并 追加 生成word文件
                    CustomXWPFDocument xwpfDocument = xwpfDocuments.get(0);
                    for (int i = 0; i < xwpfDocuments.size(); i++) {
                        //每次的追加为了避免样式和格式混乱 加上分页符
                        //当是只有一条数据的时候 直接输出
                        if (i == 0) {
                            xwpfDocument = xwpfDocuments.get(0);
                            continue;
                        } else {
                            //当存在多条时候
                            xwpfDocument = WordUtils.mergeWord(xwpfDocument, xwpfDocuments.get(i));
                        }
                    }
                    //合并之后返回XWPFDocument对象 写出就可以了
                    OutputStream os = response.getOutputStream();
                    String fileName = new String((wordName + ".docx").getBytes("UTF-8"), "iso-8859-1");
                    response.setHeader("Content-disposition", "attachment; filename=" + fileName);
                    xwpfDocument.write(os);
                    os.close();
                }
            }
        } catch (IOException e) {
            e.printStackTrace();
        } catch (Exception e) {
            e.printStackTrace();
        }

    }

最后查看效果图

在这里插入图片描述

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

Richard Chijq

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值