在使用JasperReports+iReport+struts2打开报表是,页面报出Jasper Output Error:Error executing SQL statement for : test01 。在action类中的接口代码为:
public void doReportPrintPDF(){
HttpServletResponse response = ServletActionContext.getResponse();
// 加载.jasper文件
File jasperRile = new File(ServletActionContext.getServletContext().getRealPath("/report/report1.jasper"));
try{
Class.forName("oracle.jdbc.OracleDriver");
Connection conn= DriverManager.getConnection("jdbc:oracle:thin:@172.19.24.239:1521:NSOA", "JXKHOA", "JXKHOA");
// 构造JasperReport 文件
JasperReport jasperReport = (JasperReport)JRLoader.loadObject(jasperRile.getPath());
// 用数据填充JasperReport文件
JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, null, conn);
// pdf导出设置
response.setContentType("application/pdf");
response.setCharacterEncoding("UTF-8");
// 使用JRPdfExproter导出器导出pdf
JRPdfExporter exporter = new JRPdfExporter();
// 设置JasperPrintList
exporter.setParameter(JRPdfExporterParameter.JASPER_PRINT, jasperPrint);
// 设置导出流
exporter.setParameter(JRPdfExporterParameter.OUTPUT_STREAM, response.getOutputStream());
// 开始导出
exporter.exportReport();
}catch(Exception e){
e.printStackTrace();
}
}
请各位高手帮看看为什么在页面中报出了Jasper Output Error:Error executing SQL statement for : test01 这个错误。