Jasper Util 种

import java.io.ByteArrayOutputStream;
import java.io.File;
import java.io.Writer;
import java.sql.Connection;
import java.util.Map;

import net.sf.jasperreports.engine.JRAbstractExporter;
import net.sf.jasperreports.engine.JRException;
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.export.JExcelApiExporter;
import net.sf.jasperreports.engine.export.JRHtmlExporter;
import net.sf.jasperreports.engine.export.JRHtmlExporterParameter;
import net.sf.jasperreports.engine.export.JRPdfExporter;
import net.sf.jasperreports.engine.export.JRPdfExporterParameter;
import net.sf.jasperreports.engine.export.JRXlsExporterParameter;
import net.sf.jasperreports.engine.util.JRLoader;

import org.apache.log4j.Logger;

import com.ssc.cba.report.ReportClient;
import com.ssc.cba.service.util.DBUtil;
import com.ssc.faw.util.GenException;

public class JasperReportUtil
{
    private static Logger logger = Logger.getLogger(JasperReportUtil.class);
    
    /**
     * export report
     * 
     * @param jasperPrint
     * @param param
     * @return
     * @throws Exception
     */
    public byte[] exportReport(JasperPrint jasperPrint, Map<String, Object> param) throws Exception
    {
	ByteArrayOutputStream oStream = new ByteArrayOutputStream();
	JRAbstractExporter exporter = fillJasperPrint(jasperPrint, param);
	exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, oStream);
	
	logger.info("[JasperReportUtil - exportReport] Exporting report starting...");
	long startTime = System.currentTimeMillis();
	exporter.exportReport();
	long endTime = System.currentTimeMillis();
	logger.info("[JasperReportUtil - exportReport] Exporting report end. It takes " + (endTime - startTime) + " ms");
	byte[] bytes = oStream.toByteArray();
	return bytes;
    }

    /**
     * fill the data into jasper print object
     * 
     * @param jasperPrint
     * @param param
     * @return
     * @throws Exception
     */
    public static JRAbstractExporter fillJasperPrint(JasperPrint jasperPrint, Map<String, Object> param) throws Exception
    {
	try
	{
	    String mode = (String) param.get(ReportClient.REPORT_TYPE);
	    logger.info("[JasperReportUtil - fillJasperPrint] The type of exported report is " + mode);
	    JRAbstractExporter exporter = getJRExporter(mode);
	    exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
	    return exporter;
	}
	catch (Exception e)
	{
	    logger.error("[JasperReportUtil - fillJasperPrint] Error occurs when filling Jasper report: " + e);
	    throw new GenException(e);
	}
    }

    /**
     * export report
     * 
     * @param param
     * @return
     * @throws GenException
     */
    public byte[] exportReport(Map<String, Object> param) throws GenException
    {
	byte[] bytes = null;
	Connection conn = null;
	try
	{
	    conn = DBUtil.getConnection();
	    JasperPrint jasperPrint = getJasperPrint(param, conn);
	    bytes = exportReport(jasperPrint, param);
	}
	catch (Exception e)
	{
	    logger.error("[JasperReportUtil - exportReport] Error occurs when exporting Jasper report: " + e);
	    throw new GenException(e);
	}
	finally
	{
	    DBUtil.closeConnection(conn);
	}
	return bytes;
    }

    /**
     * retrieve the Jasper exporter
     * 
     * @param docType
     * @return
     */
    public static JRAbstractExporter getJRExporter(String exportType) throws GenException
    {
	JRAbstractExporter exporter = null;

	if (ReportClient.EXPORT_PDF.equalsIgnoreCase(exportType))
	{
	    exporter = new JRPdfExporter();
	    configurePdfExporter(exporter);
	}
	else if (ReportClient.EXPORT_EXCEL.equalsIgnoreCase(exportType))
	{
	    exporter = new JExcelApiExporter();
	    configureXlsExporter(exporter);
	}
	else if (ReportClient.EXPORT_HTML.equalsIgnoreCase(exportType))
	{
	    exporter = new JRHtmlExporter();
	    configureHtmlExporter(exporter);

	}
	else
	{
	    throw new GenException("[JasperReportUtil - getJRExporter] The type of exported Jasper report doesn't exist!");
	}

	return exporter;
    }

    private static void configurePdfExporter(JRAbstractExporter exporter)
    {
	exporter.setParameter(JRPdfExporterParameter.CHARACTER_ENCODING, ReportClient.CHARACTER_ENCODING);
    }

    private static void configureXlsExporter(JRAbstractExporter exporter)
    {
	exporter.setParameter(JRXlsExporterParameter.CHARACTER_ENCODING, ReportClient.CHARACTER_ENCODING);
	exporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);
	exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);
	exporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);
    }

    private static void configureHtmlExporter(JRAbstractExporter exporter)
    {
	exporter.setParameter(JRHtmlExporterParameter.IS_USING_IMAGES_TO_ALIGN, Boolean.FALSE);
	exporter.setParameter(JRHtmlExporterParameter.ZOOM_RATIO, Float.parseFloat("1.2"));
	exporter.setParameter(JRHtmlExporterParameter.CHARACTER_ENCODING, ReportClient.CHARACTER_ENCODING);
    }

    /**
     * retrieve the Jasper Print Object
     * 
     * @param param
     * @param conn
     * @return
     * @throws GenException
     */
    public static JasperPrint getJasperPrint(Map<String, Object> param, Connection conn) throws GenException
    {
	JasperPrint jasperPrint = null;
	try
	{
	    String jasperFile = (String) param.get(ReportClient.REPORT_NAME);
	    if (jasperFile == null)
	    {
		throw new GenException("[JasperReportUtil - getJasperPrint] The Jasper report template can't be found out!");
	    }
	    JasperReport jasperReport = (JasperReport) JRLoader.loadObject(new File(jasperFile));
	    jasperPrint = JasperFillManager.fillReport(jasperReport, param, conn);
	}
	catch (JRException e)
	{
	    logger.error("[JasperReportUtil - getJasperPrint] Error occurs when retrieving JasperPrint Object: " + e);
	    throw new GenException(e);
	}
	return jasperPrint;
    }

    /**
     * preview html jasper report
     * 
     * @param param
     * @param writer
     * @throws GenException
     */
    public static void previewHtmlReport(Map<String, Object> param, Writer writer) throws GenException
    {
	Connection conn = null;
	try
	{
	    conn = DBUtil.getConnection();
	    JasperPrint jasperPrint = JasperReportUtil.getJasperPrint(param, conn);
	    JRAbstractExporter exporter = JasperReportUtil.fillJasperPrint(jasperPrint, param);
	    exporter.setParameter(JRHtmlExporterParameter.OUTPUT_WRITER, writer);
	    logger.info("[JasperReportUtil - previewHtmlReport] Preview report starting...");
	    long startTime = System.currentTimeMillis();
	    exporter.exportReport();
	    long endTime = System.currentTimeMillis();
	    logger.info("[JasperReportUtil - previewHtmlReport] Preview report end. It takes " + (endTime - startTime) + " ms");
	}
	catch (Exception e)
	{
	    logger.error("[JasperReportUtil - previewHtmlReport] Error occurs when previewing Html Report: " + e);
	    throw new GenException(e);
	}
	finally
	{
	    DBUtil.closeConnection(conn);
	}
    }
}