Jmesa示例[分页,排序,导出CSV,EXCEL,PDF]

liuzidong

浏览: 2291312 次
性别:
来自: 成都

最近访客更多访客>>

joechl

njdccy

mushroom12

musicxujun

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

博客分类：

J2EE

Excel Java Apache Servlet JSP

一参考资料

1   http://blog.csdn.net/prufeng/archive/2009/05/24/4213218.aspx
2   http://blog.csdn.net/fenglibing/archive/2009/04/24/4106564.aspx
3   http://fansofjava.iteye.com/category/86946
4   http://blog.csdn.net/jockCreate/archive/2008/02/20/2110310.aspx

二环境:XP+Myeclipse6.6+JDK1.5+Tomcat6.20

1 jmesa官方网址: http://code.google.com/p/jmesa/
2 所需要的jar文件有:见附件图片:jmesa-lib.jpg

3 示例Java代码

import java.io.IOException;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.jmesa.facade.TableFacade;
import org.jmesa.facade.TableFacadeFactory;
import org.jmesa.limit.ExportType;

public class ExportServlet extends HttpServlet {

	private static final long serialVersionUID = 1L;	
	public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {		
		doPost(request,response);
	}

	@SuppressWarnings("deprecation")
	@Override
	public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {		
		
		TableFacade tableFacade = TableFacadeFactory.createTableFacade("presidents", request);
		tableFacade.setColumnProperties("id","name.firstName", "name.lastName", "term","career", "born");       
        tableFacade.setItems(new PresidentDao().getPresidents());
        tableFacade.setExportTypes(response, ExportType.CSV, ExportType.EXCEL, ExportType.PDF);
        //直接展现方式
        String html = tableFacade.render();			
		request.setAttribute("presidents", html);
		String tag = request.getParameter("tag");
		String url = "/index.jsp";
		if("2".equals(tag)){
			url = "/index-el.jsp";
		}		
		
		try {   
			RequestDispatcher rd = request.getRequestDispatcher(url);   			
		    rd.forward(request, response);   
		    return;   
		}catch(Exception e){
			/**
			 * 不加上异常处理在控制台报如下错误:
			 *  严重: Servlet.service() for servlet ExportServlet threw exception
				java.lang.IllegalStateException: Cannot forward after response has been committed
					at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:312)
					at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
					at demo.ExportServlet.doPost(ExportServlet.java:55)
					at demo.ExportServlet.doGet(ExportServlet.java:36)
					at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
					at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
					at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
					at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
					at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
					at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
					at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
					at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
					at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
					at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
					at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
					at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
					at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
					at java.lang.Thread.run(Thread.java:619)
			 * */
		}  
		
	}
}

4 页面代码

<%@ page language="java" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
	<head>	
		<title>我的第一个jmesa测试示例</title>	
		<link rel="STYLESHEET" type="text/css" href="css/jmesa.css" />
		<link rel="STYLESHEET" type="text/css" href="css/jmesa-pdf.css" />
		<script type="text/javascript" src="js/jquery-1.3.min.js" /></script>
		<script type="text/javascript" src="js/jmesa.js" /></script>
		<script type="text/javascript" src="js/jquery.jmesa.js" /></script>		
		<script type="text/javascript">
			function onInvokeAction(id) {
			    setExportToLimit(id, '');
			    createHiddenInputFieldsForLimitAndSubmit(id);
			}
			function onInvokeExportAction(id) {       
			    var parameterString = createParameterStringForLimit(id);  			   
			    location.href = "<%= request.getContextPath() %>/ExportServlet?" + parameterString;       
			}   
			
		</script>
</head>
<body>
<form name="personForm" action="<%= request.getContextPath() %>/ExportServlet" method="post">
<table  border="0" align="center" cellpadding="0" cellspacing="0">
<tr><td  align="center" width="100%">${presidents}</td></tr>
</table>	
</form>
</body>
</html>

5 显示效果见附件:jmesa-demo.jpg
6 示例工程见:MyJmesa.rar

MyJmesa.rar (4.9 MB)
下载次数: 213

查看图片附件

分享到：

Request To JavaBean(请求对象转换为JavaBe ... | Jasperreport相关资料

2010-10-20 17:17
浏览 5153
评论(0)
分类:Web前端
查看更多

发表评论

您还没有登录,请您登录后再发表评论

最近访客更多访客>>

博主相关

文章分类

社区版块

存档分类

最新评论

Jmesa示例[分页,排序,导出CSV,EXCEL,PDF]

评论

发表评论

相关推荐

最近访客 更多访客>>

博主相关

文章分类

社区版块

存档分类

最新评论

Jmesa示例[分页,排序,导出CSV,EXCEL,PDF]

评论

发表评论

相关推荐

【转载】Eclipse Class Decompiler——Java反编译插件

Java多线程序源码

Spring & Junit

XSS之xssprotect

myeclispe之图解weblogic81配置

Cannot forward a response that is already committed

WebLogic之Cannot parse POST parameters of request解决方法

WebLogic之weblogic.xml.jaxp.RegistrySAXTransformerFactory

Quartz之一个任务绑定多个触发器

Quartz之QuartzInitializerListener

Quartz之QuartzInitializerServlet

jQuery与Java实现图片的剪切

WebLogic之Session

Frameset导致Cookies和Session丢失的原因及解决办法

java,javascript对18位身份证格式的验证算法

Quartz之CronTrigger

Quartz之CronExpression

Quartz之SimpleTrigger

Quartz2之入门示例

Sprint之java.util.Time

最近访客更多访客>>