SSH集成JasperReport例子，支持预览导出Exce导出Pdf

package com.xxxx.report.action; import java.io.File; import java.io.ObjectOutputStream; import java.util.List; import java.util.Map; import javax.servlet.ServletOutputStream; import javax.servlet.http.HttpServletResponse; import net.sf.jasperreports.engine.JRExporterParameter; import net.sf.jasperreports.engine.JasperFillManager; import net.sf.jasperreports.engine.JasperPrint; import net.sf.jasperreports.engine.JasperReport; import net.sf.jasperreports.engine.base.JRBaseReport; import net.sf.jasperreports.engine.data.JRBeanCollectionDataSource; import net.sf.jasperreports.engine.export.JExcelApiExporter; import net.sf.jasperreports.engine.export.JRPdfExporter; import net.sf.jasperreports.engine.export.JRXlsAbstractExporter; import net.sf.jasperreports.engine.export.JRXlsAbstractExporterParameter; import net.sf.jasperreports.engine.util.FileBufferedOutputStream; import net.sf.jasperreports.engine.util.JRLoader; import org.apache.struts2.ServletActionContext; import com.xxxx.report.persistence.pojo.ReportDataBean; import com.xxxx.report.service.IReportDataService; /* * 打印抽象类 */ public abstract class ReportAction extends BaseAction implements IReport{ private static final long serialVersionUID = 1L; private static String PARAM_SUB_REPORT_DIR="SUBREPORT_DIR"; private static String PARAM_EXCEL_EXPORT="EXCEL_EXPORT"; private static String VALUE_EXCEL_EXPORT_ENABLE="1"; private static String VALUE_EXCEL_EXPORT_DISABLE="0"; private IReportDataService reportDataService; private List<ReportDataBean> dataSource; /** * 打印预览 * @return */ public String printPreView(){ try{ String reportPath = ServletActionContext.getRequest().getRealPath(this.getJasperFile()); File reportFile = new File(reportPath); JasperReport jasperReport = (JasperReport)JRLoader.loadObject(reportFile); List<ReportDataBean> reportDataSource = this.getReportDataBean(); Map<String,Object> paramMap = this.getJasperPrintParam(); if(this.hasSubReport()==true){ paramMap.put(ReportAction.PARAM_SUB_REPORT_DIR, reportFile.getParent()+"/"); } paramMap.put(ReportAction.PARAM_EXCEL_EXPORT,ReportAction.VALUE_EXCEL_EXPORT_DISABLE); JasperPrint jasperPrint=JasperFillManager.fillReport( jasperReport,paramMap, new JRBeanCollectionDataSource(reportDataSource)); //System.out.println("Date fill end:"+new Date()); /*通过反射改变页边距 java.lang.reflect.Field margin = JRBaseReport.class.getDeclaredField("leftMargin"); margin.setAccessible(true); margin.setInt(jasperReport, 0); */ //System.out.println("Date show start:"+new Date()); if (jasperPrint != null) { HttpServletResponse response = ServletActionContext.getResponse(); response.setContentType("application/octet-stream"); ServletOutputStream ouputStream = response.getOutputStream(); ObjectOutputStream oos = new ObjectOutputStream(ouputStream); oos.writeObject(jasperPrint); oos.flush(); oos.close(); ouputStream.flush(); ouputStream.close(); } //System.out.println("Date show end:"+new Date()); }catch(Exception e){ e.printStackTrace(); } return null; } /** * 导出XLS * @return */ public String exportXLS(){ FileBufferedOutputStream fbos = null; ServletOutputStream ouputStream = null; try{ String reportPath = ServletActionContext.getRequest().getRealPath(this.getJasperFile()); File reportFile = new File(reportPath); JasperReport jasperReport = (JasperReport)JRLoader.loadObject(reportFile); List<ReportDataBean> reportDataSource = this.getReportDataBean(); Map<String,Object> paramMap = this.getJasperPrintParam(); if(this.hasSubReport()){ paramMap.put(ReportAction.PARAM_SUB_REPORT_DIR, reportFile.getParent()+"/"); } paramMap.put(ReportAction.PARAM_EXCEL_EXPORT,ReportAction.VALUE_EXCEL_EXPORT_ENABLE); //通过反射改变页边距 //kill left margin java.lang.reflect.Field margin = JRBaseReport.class.getDeclaredField("leftMargin"); margin.setAccessible(true); margin.setInt(jasperReport, 0); //kill top margin margin = JRBaseReport.class.getDeclaredField("topMargin"); margin.setAccessible(true); margin.setInt(jasperReport, 0); JasperPrint jasperPrint=JasperFillManager.fillReport( jasperReport,paramMap, new JRBeanCollectionDataSource(reportDataSource)); if(null != jasperPrint){ fbos = new FileBufferedOutputStream(); JRXlsAbstractExporter exporter = new JExcelApiExporter(); exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, fbos); exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); exporter.setParameter(JRXlsAbstractExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE); exporter.setParameter(JRXlsAbstractExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE); exporter.setParameter(JRXlsAbstractExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE); exporter.setParameter(JRXlsAbstractExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE); exporter.exportReport(); fbos.close(); if(fbos.size()>0) { HttpServletResponse response = ServletActionContext.getResponse(); response.setContentType("application/exl"); //TODO response.setHeader("Content-Disposition", "attachment;filename=\"target.xls\""); response.setContentLength(fbos.size()); ouputStream = response.getOutputStream(); fbos.writeData(ouputStream); fbos.dispose(); ouputStream.flush(); } } }catch (Exception e1) { e1.printStackTrace(); }finally{ try{ if(null != ouputStream) { ouputStream.close(); } if(null !=fbos){ fbos.close(); fbos.dispose(); } }catch(Exception e2){ e2.printStackTrace(); } } return null; } /** * 导出PDF * @return */ public String exportPDF(){ FileBufferedOutputStream fbos = null; ServletOutputStream ouputStream = null; try{ String reportPath = ServletActionContext.getRequest().getRealPath(this.getJasperFile()); File reportFile = new File(reportPath); JasperReport jasperReport = (JasperReport)JRLoader.loadObject(reportFile); List<ReportDataBean> reportDataSource = this.getReportDataBean(); Map<String,Object> paramMap = this.getJasperPrintParam(); if(this.hasSubReport()==true){ paramMap.put(ReportAction.PARAM_SUB_REPORT_DIR, reportFile.getParent()+"/"); } //System.out.println("Date fill start:"+new Date()); JasperPrint jasperPrint=JasperFillManager.fillReport( jasperReport,paramMap, new JRBeanCollectionDataSource(reportDataSource)); if(null != jasperPrint){ fbos = new FileBufferedOutputStream(); JRPdfExporter exporter = new JRPdfExporter(); exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, fbos); exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); exporter.exportReport(); fbos.close(); if(fbos.size()>0) { HttpServletResponse response = ServletActionContext.getResponse(); response.setContentType("application/pdf"); //TODO response.setHeader("Content-Disposition", "attachment;filename=\"target.pdf\""); re