view_excel_report.java

一个专门用来快速开发网站的框架

package com.core.report;

import java.io.File;
import java.io.IOException;
import java.sql.Connection;
import java.util.HashMap;
import java.util.Map;

import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import net.sf.jasperreports.engine.JasperRunManager;
import net.sf.jasperreports.engine.export.JRXlsExporter;
import net.sf.jasperreports.engine.export.JRXlsExporterParameter;
import net.sf.jasperreports.engine.JRExporterParameter;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.util.JRLoader;
import org.hibernate.Session;
import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JasperRunManager;

import com.core.persistence.HibernateUtil;

public class View_EXCEL_Report extends HttpServlet{
    public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doTask(request, response);
    }
    public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doTask(request, response);
    }
    public void doTask(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        response.reset();
        // 获得参数
        String strFileName = request.getParameter("r_file");
        String strKey = request.getParameter("r_id");
        // 测试语句
//            System.out.println("strFileName="+strFileName);
//            System.out.println("strKey="+strKey);
//            System.out.println("File Name="+servletContext.getRealPath(strFileName));
        try {
            // 1、获得数据库连接
            Session session = HibernateUtil.getSession();
            Connection conn = session.connection();

            // 2、生成jrprint文件，使用到了参数
            Map reportParams = new HashMap();
            reportParams.put("id",strKey);
            ServletContext servletContext = this.getServletContext();
            JasperPrint jasperPrint = JasperFillManager.fillReport(servletContext.getRealPath(strFileName), reportParams, conn);

            response.setContentType("application/vnd.ms-excel");
            ServletOutputStream ouputStream = response.getOutputStream();
            JRXlsExporter exporter = new JRXlsExporter();
            exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
            exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, ouputStream);
            exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.TRUE);
            exporter.exportReport();
            ouputStream.flush();
            ouputStream.close();
        } catch (JRException jre) {
            System.out.println("JRException:" + jre.getMessage());
        } catch (Exception e) {
            System.out.println("Exception:" + e.getMessage());
        }
    }


}