JasperReport与Java程序，导出不同格式的报表，包括pdf,excel,html,报表打印等功能

package com.jie.servlet; import java.io.IOException; import java.io.OutputStream; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.jie.dao.DBManager; import net.sf.jasperreports.engine.JRAbstractExporter; import net.sf.jasperreports.engine.JRException; import net.sf.jasperreports.engine.JRExporterParameter; import net.sf.jasperreports.engine.JasperCompileManager; import net.sf.jasperreports.engine.JasperFillManager; import net.sf.jasperreports.engine.JasperPrint; import net.sf.jasperreports.engine.export.JRXlsExporter; import net.sf.jasperreports.engine.export.JRXlsExporterParameter; import net.sf.jasperreports.engine.util.JRLoader; /** * 类名称: ExportExcel.java * 创建者: 曾小杰 * 创建时间: Oct 26, 2010 10:24:45 AM * 版本： **/ public class ExportExcel extends HttpServlet { protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { /** * 导出格式为Excel * 1.编译jrxml文件 * 2.填充数据，load * 3.设置文件输出流 * 4.实例化文件导出器，并设置其参数 * 5.导出 */ String path = request.getRealPath("/"); DBManager db = new DBManager(); try { JasperCompileManager.compileReportToFile(path+"/myReport.jrxml", path+"/myReport.jasper"); String file = JasperFillManager.fillReportToFile(path+"/myReport.jasper", null, db.getConn()); JasperPrint print = (JasperPrint)JRLoader.loadObject(file); OutputStream os = response.getOutputStream(); response.setHeader("Content-Disposition", "inline; filename=\""+new String("aa".getBytes("utf-8")) + ".xls"+ "\""); response.setContentType("appliction/x-excel"); response.setCharacterEncoding("utf-8"); JRAbstractExporter exporter = new JRXlsExporter(); exporter.setParameter(JRExporterParameter.JASPER_PRINT, print); exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, os); // 删除记录最下面的空行 exporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE); exporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_COLUMNS, Boolean.TRUE); exporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.TRUE); exporter.setParameter(JRXlsExporterParameter.IS_AUTO_DETECT_CELL_TYPE, Boolean.TRUE); exporter.exportReport(); } catch (JRException e) { // TODO Auto-generated catch block e.printStackTrace(); } } }