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

最新推荐文章于 2020-05-26 16:11:12 发布

天涯在身边

最新推荐文章于 2020-05-26 16:11:12 发布

阅读量179

点赞数

分类专栏： J2EE 文章标签： Excel Java Apache Servlet JSP

本文链接：https://blog.csdn.net/liuzidong_liuzidong/article/details/83734625

版权

J2EE 专栏收录该内容

49 篇文章 0 订阅

订阅专栏

一参考资料

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

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

1 jmesa官方网址: [url]http://code.google.com/p/jmesa/[/url]
2 所需要的jar文件有:见附件图片:jmesa-lib.jpg
[img]http://dl.iteye.com/upload/attachment/334493/5d3ba73e-04c6-396c-beaf-ccc4f9862251.jpg[/img]
[img]http://dl.iteye.com/upload/attachment/334496/35e7f0f0-ab42-31fb-9ba6-0e543eca1c5e.jpg[/img]
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

天涯在身边

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
Jmesa示例[分页,排序,导出CSV,EXCEL,PDF]

一参考资料1 [url]http://blog.csdn.net/prufeng/archive/2009/05/24/4213218.aspx[/url]2 [url]http://blog.csdn.net/fenglibing/archive/2009/04/24/4106564.aspx[/url]3 [url]http://fansofjava.iteye....
复制链接

扫一扫