jasper导出Excel文件，debug导出文件异常，非debug是正常的

2015-07-06 08:38:37 172 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

Jaspersoft Studio参数全解析：从定义到集成的动态报表开发指南在报表开发领域，参数是实现数据动态查询与展示的核心机制，它充当了静态报表模板与动态业务数据之间的桥梁。其工作原理是通过预定义的参数体系，接收外部输入的条件值，并安全地注入到数据查询与报表渲染流程中。这项技术的核心价值在于，它使得同一份报表模板能够根据不同的输入条件，灵活生成多样化的数据视图，极大地提升了报表的复用性和交互性。在实际应用场景中，参数技术被广泛应用于需要按条件筛选数据的业务报表、管理驾驶舱以及数据可视化看板。特别是在处理多值参数与复杂查询时，JasperReports提供的$X{IN}等高级语法阅读详情

public class ReportUtil {
public static void http_export_Excel(HttpServletRequest request, HttpServletResponse response,
String jasperTemplateName, List<?> list,String exportname) {

response.setContentType("application/vnd.ms-excel");
JasperReport jasperReport = null;
JasperPrint jasperPrint = null;
// String url = ReportUtil.class.getResource("ReportUtil.class").getFile().toString();
// String jasperPath = url.substring(0,url.indexOf("WEB-INF"))+"/jasper/"+jasperTemplateName;
// File reportFile = new File(jasperPath.replace("file:", ""));
String jasperPath = "F:/ireport/loaninformationquery.jasper";
File reportFile = new File(jasperPath);

try {

String fileName = new String((exportname+".xls").getBytes("gbk"), "ISO8859_1");
response.setHeader("Content-disposition", "attachment; filename=" + fileName);
jasperReport = (JasperReport) JRLoader.loadObjectFromFile(reportFile.getPath());
jasperPrint = JasperFillManager.fillReport(jasperReport, null, new JRBeanCollectionDataSource(list));
Exporter<ExporterInput, XlsReportConfiguration, XlsExporterConfiguration, OutputStreamExporterOutput> exporter = new JRXlsExporter();
SimpleXlsReportConfiguration config = new SimpleXlsReportConfiguration();
config.setRemoveEmptySpaceBetweenColumns(true);
config.setRemoveEmptySpaceBetweenRows(true);
config.setWhitePageBackground(false);
config.setDetectCellType(true);
exporter.setConfiguration(config);
ExporterInput exporterInput = new SimpleExporterInput(jasperPrint);
ServletOutputStream ouputStream = response.getOutputStream();
OutputStreamExporterOutput exporterout = new SimpleOutputStreamExporterOutput(ouputStream);
exporter.setExporterInput(exporterInput);
exporter.setExporterOutput(exporterout);
exporter.exportReport();

} catch (JRException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}

}
上面是我的源码
下面是报错堆栈信息：
[ERROR] Error for /mcms-portal/crzDebit/account/toGetExcel.do
java.lang.OutOfMemoryError: PermGen space
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClassCond(ClassLoader.java:631)
at java.lang.ClassLoader.defineClass(ClassLoader.java:615)
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:141)
at java.net.URLClassLoader.defineClass(URLClassLoader.java:283)
at java.net.URLClassLoader.access$000(URLClassLoader.java:58)
at java.net.URLClassLoader$1.run(URLClassLoader.java:197)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
at org.mortbay.jetty.webapp.WebAppClassLoader.loadClass(WebAppClassLoader.java:366)
at org.mortbay.jetty.webapp.WebAppClassLoader.loadClass(WebAppClassLoader.java:337)
at ch.qos.logback.classic.spi.ThrowableProxy.<init>(ThrowableProxy.java:55)
at ch.qos.logback.classic.spi.LoggingEvent.<init>(LoggingEvent.java:124)
at ch.qos.logback.classic.Logger.buildLoggingEventAndAppend(Logger.java:447)
at ch.qos.logback.classic.Logger.filterAndLog_0_Or3Plus(Logger.java:403)
at ch.qos.logback.classic.Logger.log(Logger.java:803)
at org.apache.commons.logging.impl.SLF4JLocationAwareLog.debug(SLF4JLocationAwareLog.java:147)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:910)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1093)
at com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter.java:129)
at com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:77)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
at com.suning.mcms.web.auth.filter.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:204)
at com.suning.mcms.web.auth.filter.FilterSecurityInterceptor.doFilterHttp(FilterSecurityInterceptor.java:131)
at com.suning.mcms.web.auth.filter.SecurityFilter.doFilter(SecurityFilter.java:52)
at com.suning.mcms.web.auth.filter.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:216)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:83)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
[ERROR] EXCEPTION
java.lang.OutOfMemoryError: PermGen space
java.lang.reflect.InvocationTargetException
[ERROR] handle failed
java.lang.OutOfMemoryError: PermGen space

...全文