Spring 实现excel及pdf导出表格示例

package light.mvc.utils.excel;  import java.util.Date; import java.util.List; import java.util.Map;  import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse;  import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFCellStyle; import org.apache.poi.hssf.usermodel.HSSFFont; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.springframework.web.servlet.view.document.AbstractExcelView;  import light.mvc.pageModel.sys.Log; import light.mvc.utils.Tools;   public class ExcelView extends AbstractExcelView{      private HSSFSheet sheet;   private HSSFCell cell;    @Override   protected void buildExcelDocument(Map<String, Object> model,       HSSFWorkbook workbook, HttpServletRequest request,       HttpServletResponse response) throws Exception {     // TODO Auto-generated method stub     Date date = new Date();     String filename = Tools.date2Str(date, "yyyyMMddHHmmss");     String title_content = (String) model.get("title_content");     response.setContentType("application/octet-stream");     response.setHeader("Content-Disposition", "attachment;filename="+filename+".xls");     sheet = workbook.createSheet(title_content);          List<String> titles = (List<String>) model.get("titles");     int len = titles.size();     HSSFCellStyle headerStyle = workbook.createCellStyle(); //标题样式     headerStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);     headerStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);     HSSFFont headerFont = workbook.createFont();  //标题字体     headerFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);     headerFont.setFontHeightInPoints((short)11);     headerStyle.setFont(headerFont);     short width = 20,height=25*20;     sheet.setDefaultColumnWidth(width);     for(int i=0; i<len; i++){ //设置标题       String      cell = getCell(sheet, 0, i);       cell.setCellStyle(headerStyle);       setText(cell,title);     }     sheet.getRow(0).setHeight(height);          HSSFCellStyle contentStyle = workbook.createCellStyle(); //内容样式     contentStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);     String type = (String) model.get("type");     if ("log".equals(type)){       List<Log> logList = (List<Log>) model.get("list");       logExcel(logList, contentStyle);     }        }   /**    *   * @Title: logExcel   * @Description: 日志导出   * @param @param logList   * @param @param contentStyle   * @return void   * @throws    */   public void logExcel(List<Log> logList, HSSFCellStyle contentStyle){     int logCount = logList.size();     if (logList != null && logCount > 0){       for(int i=0; i<logCount; i++){         Log log = logList.get(i);         String loginname = log.getLoginname();         cell = getCell(sheet, i+1, 0);         cell.setCellStyle(contentStyle);         setText(cell,loginname);                  String username = log.getName();         cell = getCell(sheet, i+1, 1);         cell.setCellStyle(contentStyle);         setText(cell,username);                  String IP = log.getIp();         cell = getCell(sheet, i+1, 2);         cell.setCellStyle(contentStyle);         setText(cell,IP);                  String organizationName = log.getOrganizationName();         cell = getCell(sheet, i+1, 3);         cell.setCellStyle(contentStyle);         setText(cell,organizationName);                  String usertype = log.getUsertype()==0 ? "管理员" : "员工";         cell = getCell(sheet, i+1, 4);         cell.setCellStyle(contentStyle);         setText(cell,usertype);                  String msg = log.getMsg();         cell = getCell(sheet, i+1, 5);         cell.setCellStyle(contentStyle);         setText(cell,msg);                  Date lastLogin = log.getCreatedatetime()!=null ? log.getCreatedatetime() : null;         cell = getCell(sheet, i+1, 6);         cell.setCellStyle(contentStyle);         setText(cell,Tools.date2Str(lastLogin));       }     }   } } 

package light.mvc.utils.pdf; import java.io.ByteArrayOutputStream; import java.io.OutputStream; import java.util.Map;  import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.springframework.web.servlet.view.AbstractView;  import com.itextpdf.text.Document; import com.itextpdf.text.DocumentException; import com.itextpdf.text.PageSize; import com.itextpdf.text.pdf.PdfWriter;  /**  * 这里就全部复制spring 的，然后引入的东西改成第5版的就行了 代码 几乎不变，唯一变的是引用路径~。  *  *  */ public abstract class AbstractIText5PdfView extends AbstractView {   public AbstractIText5PdfView() {     setContentType("application/pdf");   }    @Override   protected boolean generatesDownloadContent() {     return true;   }    @Override   protected final void renderMergedOutputModel(Map<String, Object> model, HttpServletRequest request,       HttpServletResponse response) throws Exception {     // 获得流     ByteArrayOutputStream baos = createTemporaryOutputStream();     Document document = newDocument();     PdfWriter writer = newWriter(document, baos);     prepareWriter(model, writer, request);     buildPdfMetadata(model, document, request);     document.open();     buildPdfDocument(model, document, writer, request, response);     document.close();     writeToResponse(response, baos);   }    protected Document newDocument() {     return new Document(PageSize.A4);   }    protected PdfWriter newWriter(Document document, OutputStream os) throws DocumentException {     return PdfWriter.getInstance(document, os);   }    protected void prepareWriter(Map<String, Object> model, PdfWriter writer, HttpServletRequest request)       throws DocumentException {      writer.setViewerPreferences(getViewerPreferences());   }    protected int getViewerPreferences() {     return PdfWriter.ALLOW_PRINTING | PdfWriter.PageLayoutSinglePage;   }    protected void buildPdfMetadata(Map<String, Object> model, Document document, HttpServletRequest request) {   }    protected abstract void buildPdfDocument(Map<String, Object> model, Document document, PdfWriter writer,       HttpServletRequest request, HttpServletResponse response) throws Exception; } 

package light.mvc.utils.pdf;  import java.io.IOException; import java.util.ArrayList; import java.util.List; import java.util.Map;  import com.itextpdf.text.Chunk; import com.itextpdf.text.DocumentException; import com.itextpdf.text.Font; import com.itextpdf.text.Paragraph; import com.itextpdf.text.pdf.BaseFont;  /** * @ClassName: PDFUtil * @Description: * @author liuyajun * @date 2017年3月2日 下午1:21:21 * */ public class PDFUtil {   // 对参数的封装形式比如{name}   public static final String BEGIN = "{";   public static final String END = "}";   // 换行形式{#}   public static final String NEW_LINE = "#";   // 默认的行间距、首行距离等，自己添加   public static final float DEFAULT_LEADING = 20;   public static final float DEFAULT_LINE_INDENT = 30;         // 基本字体和样式   public static BaseFont bfChinese;   public static Font fontChinese;   public static Font UNDER_LINE = null;   static{     try {       // SIMKAI.TTF 默认系统语言，这里没使用第三方语言包       bfChinese = BaseFont.createFont("D:/home/java/contract/web/fonts/simsun.ttf",BaseFont.IDENTITY_H,BaseFont.NOT_EMBEDDED);       //bfChinese = BaseFont.createFont("STSong-Light", "UniGB-UCS2-H", BaseFont.NOT_EMBEDDED);              fontChinese = new Font(bfChinese, 12, Font.NORMAL);       UNDER_LINE = new Font(bfChinese, 14,Font.UNDERLINE);     } catch (DocumentException e) {       e.printStackTrace();     } catch (IOException e) {       e.printStackTrace();     }   }       // 默认样式   public static Paragraph getParagraph(String context){     return getParagraph(context,fontChinese);   }      public static Paragraph getParagraph(Chunk chunk){     return new Paragraph(chunk);   }      // 指定字体样式   public static Paragraph getParagraph(String context,Font font){     return new Paragraph(context,font);   }      // 获得新行,首行缩进,和行间距   public static Paragraph getNewParagraph(String context,float fixedLeading,float firstLineIndent){     Paragraph p = getParagraph(context);     p.setLeading(fixedLeading);     p.setFirstLineIndent(firstLineIndent);     return p;   }       public static Paragraph getParagraph(String content , Font font , float fixedLeading , int alignment){       Paragraph p = getParagraph(content);      p.setFont(font);      p.setLeading(fixedLeading);      p.setAlignment(alignment);      return p;     }      // 默认段落样式   public static Paragraph getDefaultParagraph(String context){     Paragraph p = getParagraph(context);     // 默认行间距     p.setLeading(DEFAULT_LEADING);     // 默认首行空隙     p.setFirstLineIndent(DEFAULT_LINE_INDENT);     return p;   }      // 将参数和字符串内容组合成集合   public static List<Paragraph> createParagraphs(String context ,Map<String,Object> map){     int index = 0;     List<Paragraph> list = new ArrayList<Paragraph>();     Paragraph p = getDefaultParagraph(null);     while((index = context.indexOf(BEGIN)) > -1){       String text = context.substring(0,index);       context = context.substring(index, context.length());       index = context.indexOf(END);       String param = null;       if(index > 0){          param = context.substring(BEGIN.length(),index);       }       p.add(text);       if(!NEW_LINE.equals(param)){         Object value = map.get(param);         if(value != null){           p.add(new Chunk(value.toString(),UNDER_LINE));         }else{           p.add(new Chunk(""));         }       }else{         list.add(p);         p = getDefaultParagraph(null);         p.setSpacingBefore(0);       }       context = context.substring(index+END.length(),context.length());     }     list.add(p);     list.add(getParagraph(context));     return list;   } } 

package light.mvc.utils.pdf;  import java.util.Date; import java.util.List; import java.util.Map;  import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse;  import com.itextpdf.text.Chunk; import com.itextpdf.text.Document; import com.itextpdf.text.Font; import com.itextpdf.text.Paragraph; import com.itextpdf.text.pdf.PdfPTable; import com.itextpdf.text.pdf.PdfWriter;  import light.mvc.pageModel.sys.Log; import light.mvc.utils.Tools;  /** * @ClassName: LogPdfView * @Description: * @author liuyajun * @date 2017年3月2日 上午11:18:44 * */ public class PdfView extends AbstractIText5PdfView{    @Override   protected void buildPdfDocument(Map<String, Object> model, Document document, PdfWriter writer,       HttpServletRequest request, HttpServletResponse response) throws Exception {     try{        document.open();        // 标题居中        String title_content = (String) model.get("title_content");       Paragraph             new Chunk(title_content,new Font(PDFUtil.bfChinese,16,Font.BOLD)));        title.setAlignment(Paragraph.ALIGN_CENTER);        document.add(title);                // 表格标题        List<String> titles = (List<String>) model.get("titles");       int len = titles.size();       PdfPTable table = new PdfPTable(len);        table.setSpacingBefore(20);        table.setSpacingAfter(30);        for(int i=0; i<len; i++){ //设置标题         String str = titles.get(i);         table.addCell(PDFUtil.getParagraph(str));        }              // 表格数据        String type = (String) model.get("type");       if ("log".equals(type)){         List<Log> logList = (List<Log>) model.get("list");          table = logPdf(table, logList);       }              document.add(table);        // 关闭        document.close();      }catch (Exception e) {        e.printStackTrace();      }         }      /**    *   * @Title: logPdf   * @Description: 日志导出   * @param @param table   * @param @param logList   * @param @return   * @return PdfPTable   * @throws    */   public PdfPTable logPdf(PdfPTable table, List<Log> logList){     int logCount = logList.size();     if (logList != null && logCount > 0){       for(int i=0; i<logCount; i++){         Log log = logList.get(i);         String loginname = log.getLoginname();         table.addCell(PDFUtil.getParagraph(loginname));                   String username = log.getName();         table.addCell(PDFUtil.getParagraph(username));                  String IP = log.getIp();         table.addCell(PDFUtil.getParagraph(IP));                  String organizationName = log.getOrganizationName();         table.addCell(PDFUtil.getParagraph(organizationName));                  String usertype = log.getUsertype()==0 ? "管理员" : "员工";         table.addCell(PDFUtil.getParagraph(usertype));                  String msg = log.getMsg();         table.addCell(PDFUtil.getParagraph(msg));                  Date lastLogin = log.getCreatedatetime()!=null ? log.getCreatedatetime() : null;         table.addCell(PDFUtil.getParagraph(Tools.date2Str(lastLogin)));       }     }     return table;        }  } 

/**    * 导出用户信息到excel/pdf    * @return    */   @RequestMapping("/download")   public ModelAndView export2Excel(HttpServletRequest request, Log log){     SessionInfo sessionInfo = (SessionInfo) request.getSession().getAttribute(GlobalConstant.SESSION_INFO);     if (!"admin".equals(sessionInfo.getLoginname())){       log.setUsertype(1);       log.setOrganizationId(sessionInfo.getOrganizationid());     }     if ("1".equals(sessionInfo.getUsertype())){       log.setLoginname(sessionInfo.getLoginname());     }     PageFilter ph = new PageFilter();     ph.setSort("createdatetime");     ph.setOrder("desc");     List<Log> list = logService.dataGrid(log, ph);     Map<String,Object> dataMap = new HashMap<String,Object>();     List<String> titles = new ArrayList<String>();     titles.add("登录名");     titles.add("姓名");     titles.add("IP地址");     titles.add("所属部门");     titles.add("用户类型");     titles.add("操作内容");     titles.add("操作时间");     dataMap.put("titles", titles);     dataMap.put("list", list);     dataMap.put("title_content", "日志");     dataMap.put("type", "log");     String str = request.getParameter("str");     ModelAndView mv = null;     if ("excel".equals(str)){       ExcelView excel = new ExcelView();       mv = new ModelAndView(excel,dataMap);     } else if("pdf".equals(str)){       PdfView pdf = new PdfView();       mv = new ModelAndView(pdf,dataMap);     }     insertlog(request,"下载"+str+"文件",2);     return mv;   }