jsp上使用jasper做报表

Mr.Cheney

浏览: 216752 次
性别:
来自: 武汉

最近访客更多访客>>

wyk525

Union365

q4421

wuxia_2001

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

博客分类：

JasperReport

1、先用ireport工具新建jrxml文件，再制作报表样式！

2、可以通过在控件的右键上设置边框，这是为了产生表格效果

好了初步工作已经有了，我们经过编译后得到了一个jasper文件，那么我们怎么用在J2EE的项目中呢？

3、将下列信息配置在web.xml

	<servlet>
		<servlet-name>ImageServlet</servlet-name>
		<servlet-class>net.sf.jasperreports.j2ee.servlets.ImageServlet</servlet-class>
	</servlet>

	<servlet-mapping>
		<servlet-name>ImageServlet</servlet-name>
		<url-pattern>/servlets/image</url-pattern>
	</servlet-mapping>

4、导入运行jasper所要用到的5个jar包，jar包在下面的附件里。可以下载获得

5、配置完成后如何使用呢？先学习如何在java类中使用，生成excel 、html、pdf等格式

package com.test;

import java.io.File;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

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.data.JRBeanCollectionDataSource;
import net.sf.jasperreports.engine.export.JRHtmlExporter;
import net.sf.jasperreports.engine.export.JRPdfExporter;
import net.sf.jasperreports.engine.export.JRXlsExporter;
import net.sf.jasperreports.engine.export.JRXlsExporterParameter;
import net.sf.jasperreports.engine.util.JRLoader;

@SuppressWarnings("unchecked")
public class Test3 {
	private static final String TASK_PDF = "pdf";
	private static final String TASK_XML = "xml";
	private static final String TASK_XML_EMBED = "xmlEmbed";
	private static final String TASK_HTML = "html";
	private static final String TASK_RTF = "rtf";
	private static final String TASK_XLS = "xls";
	private static final String TASK_JXL = "jxl";
	private static final String TASK_CSV = "csv";
	private static final String TASK_ODT = "odt";
	private static final String file = "D:\\workspase\\reportTest\\WebRoot\\report\\report3.jasper";

	private static final String exportFilePath = "f:\\report3";

	private static List getDataList() {
		List list = new ArrayList();
		for (int i = 0; i < 5; i++) {
			Map dataList = new HashMap();
			dataList.put("serialNo", "995400116528" + i);
			dataList.put("reqDate", "2009111" + i);
			dataList.put("businessType", "认购");
			dataList.put("productCode", "111409015" + i);
			dataList.put("productName", "2009年汇理财稳利系列F7计划");
			dataList.put("currencyType", "USD钞");
			dataList.put("reqMoney", "5300.00");
			dataList.put("transStatus", "正常");
			list.add(dataList);
		}
		return list;
	}

	private static Map getParameterMap() {
		Map parameterMap = new HashMap();
		parameterMap.put("CUSTOMER_NAME", "赵六");
		parameterMap.put("CUSTOMER_ACCOUNT", "98430100829415");
		parameterMap.put("TRANS_BANK", "9502");
		parameterMap.put("TRANS_DATE", "20091118");
		parameterMap.put("TRANS_OPERATOR", "11001157");
		return parameterMap;
	}

	public static void export(String fileType) {
		// 填充报表数据
		File reportFile = new File(file);
		JasperReport jasperReport = null;
		JasperPrint jasperPrint = null;
		try {
			jasperReport = (JasperReport) JRLoader.loadObject(reportFile
					.getPath());
			jasperPrint = JasperFillManager.fillReport(jasperReport,
					getParameterMap(), new JRBeanCollectionDataSource(
							getDataList()));

			// 导出报表文件
			if (TASK_XLS.equals(fileType)) {
				JRXlsExporter exporter = new JRXlsExporter();
				exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET,Boolean.TRUE);
				exporter.setParameter(JRExporterParameter.JASPER_PRINT,jasperPrint);
				exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME,	exportFilePath + "." + TASK_XLS);
				exporter.exportReport();

			} else if (TASK_HTML.equals(fileType)) {
				JRHtmlExporter export = new JRHtmlExporter();
				export.setParameter(JRExporterParameter.JASPER_PRINT,jasperPrint);
				export.setParameter(JRExporterParameter.OUTPUT_FILE_NAME,exportFilePath + "." + TASK_HTML);
				export.exportReport();
			}else if(TASK_PDF.equals(fileType)){
				JRPdfExporter export  = new JRPdfExporter();
				export.setParameter(JRExporterParameter.JASPER_PRINT,jasperPrint);
				export.setParameter(JRExporterParameter.OUTPUT_FILE_NAME,exportFilePath + "." + TASK_PDF);
				export.exportReport();
			}
		} catch (JRException e) {
			e.printStackTrace();
		}

	}

	public static void main(String[] args) {
		export("xls");
		
	}

}

如何在jsp中使用呢？如下：

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.DriverManager"%>
<%@ page import="net.sf.jasperreports.engine.*" %>
<%@ page import="net.sf.jasperreports.engine.util.*" %>
<%@ page import="net.sf.jasperreports.engine.export.*" %>
<%@ page import="net.sf.jasperreports.j2ee.servlets.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.io.*" %>
<%@page import="net.sf.jasperreports.engine.data.JRBeanCollectionDataSource"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'index.jsp' starting page</title>
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->
  </head>
  
  <body>
   <%
	Map parameterMap = new HashMap();
	parameterMap.put("ItemProjecID", "10010");
	parameterMap.put("SupervisionID", "1000000001");
	parameterMap.put("ConformityCode", "201109102218");
                //提供jasper所需要的parameters
    	List list = new ArrayList();
		Map dataList = new HashMap();
			dataList.put("workAreaName", "995400116528");
			dataList.put("UnitProjectType", "2009111");
			dataList.put("UnitProjectAddress", "test");
			dataList.put("UnitProjectSubType", "111409015");
			dataList.put("Scale", "2009年汇理财稳利系列F7计划");
			dataList.put("BargainStartDate", "USD钞");//提供jasper所需要的Fileds
		list.add(dataList);
		
	try {
		File reportFile = new File(application.getRealPath("/report/bj.jasper"));
		JasperReport jasperReport = (JasperReport)JRLoader.loadObject(reportFile.getPath());
		JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport,
				parameterMap, new JRBeanCollectionDataSource(list));

		JRHtmlExporter exporter = new JRHtmlExporter();
		
		session.setAttribute(ImageServlet.DEFAULT_JASPER_PRINT_SESSION_ATTRIBUTE, jasperPrint);
		
		exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
		exporter.setParameter(JRHtmlExporterParameter.IMAGES_URI, "./servlets/image?image=");
		exporter.setParameter(JRExporterParameter.OUTPUT_WRITER, out);
		
		exporter.exportReport();
	} catch (Exception e) {
		e.printStackTrace();
	}
   
   %>
  </body>
</html>

搞定！

附件中是一个小例子，大家可以参考！