Jmesa 实例研究

Jmesa

新项目要用到这个组件，用了一天多的时间简单学习了一下，感觉Jmesa在处理设计表格风格上还是很强大的，不足的是标签不是很完善，貌似不能用标签来设计导出功能。

 

Jmesa官网：http://code.google.com/p/jmesa/

 

一.下载Jmesa.

我下载的是jmesa-3.0_live-source.zip，里面有一个例子代码。因为Jmesa的文档几乎没有，只能看源码了。

 

二.如果想看Jmesa的效果，可以下载jmesa-3.0_live.war部署到tomcat里，这个压缩包里有Jmesa需要的JAR包。

 

三.环境搭建

无论写什么程序，环境是很重要的。

 

将jmesa-3.0_live-source.zip中web文件夹下的文件拷贝到你的Web项目中覆盖掉原文件。

四.编程要点

1.在JSP中使用标签展示表格。

    ①在后台（Servlet或者Action）传递集合到request.如：

request.setAttribute("emps", dao.findAll()); 

    ②在JSP中使用如下标签来取数据，并遍历

<jmesa:tableModel id="tagBasic" items="${emps}" maxRows="12" maxRowsIncrements="12,20,36" stateAttr="restore" var="bean"> <jmesa:htmlTable caption="emps" width="700px"> <jmesa:htmlRow> <jmesa:htmlColumn property="eName" title="eName"> ${bean.eName} </jmesa:htmlColumn> <jmesa:htmlColumn property="cName" title="cName" /> <jmesa:htmlColumn property="pgName" /> <jmesa:htmlColumn property="region" /> <jmesa:htmlColumn property="email" /> <jmesa:htmlColumn property="mobile" /> <jmesa:htmlColumn property="customer" /> <jmesa:htmlColumn property="state" /> </jmesa:htmlRow> </jmesa:htmlTable> </jmesa:tableModel> </form> 

③加入分页功能

function onInvokeAction(id) { $.jmesa.setExportToLimit(id, ''); $.jmesa.createHiddenInputFieldsForLimitAndSubmit(id); }

2.加入导出功能。

从官网上的例子里没有发现可以直接用标签来加导出功能的，所以需要自己来写一些代码。主要代码如下：

package com.pccw.emp.table; import org.jmesa.model.TableModel; import org.jmesa.view.component.Table; import org.jmesa.view.html.component.HtmlColumn; import org.jmesa.view.html.component.HtmlRow; import org.jmesa.view.html.component.HtmlTable; public class BasicEmployee { public static void setTableProperties(TableModel tableModel){ tableModel.setStateAttr("restore"); tableModel.setTable(getBasicHtmlTable()); } public static Table getBasicHtmlTable(){ //设置表格标题和宽度 HtmlTable htmlTable = new HtmlTable().caption("Employee List").width("700px"); HtmlRow htmlRow = new HtmlRow(); htmlTable.setRow(htmlRow); HtmlColumn eName = new HtmlColumn("eName").title("英文名"); HtmlColumn cName = new HtmlColumn("cName").title("中文名"); HtmlColumn pgName = new HtmlColumn("pgName").title("项目组"); HtmlColumn region = new HtmlColumn("rgion").title("家庭地区"); HtmlColumn email = new HtmlColumn("rgion").title("邮箱"); HtmlColumn mobile = new HtmlColumn("rgion").title("手机"); HtmlColumn customer = new HtmlColumn("customer").title("客户"); HtmlColumn state = new HtmlColumn("state").title("状态"); htmlRow.addColumn(eName);htmlRow.addColumn(cName); htmlRow.addColumn(pgName);htmlRow.addColumn(region); htmlRow.addColumn(email);htmlRow.addColumn(mobile); htmlRow.addColumn(customer);htmlRow.addColumn(state); return htmlTable; } }

package com.pccw.emp.table; import org.jmesa.limit.ExportType; import org.jmesa.model.TableModel; import org.jmesa.view.component.Column; import org.jmesa.view.component.Row; import org.jmesa.view.component.Table; public class BasicExportEmployee { public static void setTableProperties(TableModel tableModel){ tableModel.setExportTypes(new ExportType[]{ExportType.CSV,ExportType.JEXCEL}); tableModel.setStateAttr("restore"); if(tableModel.isExporting()){ System.out.println("正在导出...."); tableModel.setTable(getBassicExportTable()); }else{ tableModel.setTable(BasicEmployee.getBasicHtmlTable()); } } private static Table getBassicExportTable(){ Table table = new Table().caption("Employees"); Row row = new Row(); table.setRow(row); Column eName = new Column("eName").title("eName"); Column cName = new Column("cName").title("cName"); Column pgName = new Column("pgName").title("pgName"); Column region = new Column("region").title("region"); Column email= new Column("email").title("email"); Column mobile = new Column("mobile").title("mobile"); Column customer = new Column("customer").title("customer"); Column state = new Column("state").title("state"); row.addColumn(cName);row.addColumn(eName); row.addColumn(pgName);row.addColumn(region); row.addColumn(email);row.addColumn(mobile); row.addColumn(customer);row.addColumn(state); return table; } }  

package com.pccw.emp.actions; 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.model.TableModel; import org.jmesa.web.HttpServletRequestWebContext; import com.pccw.emp.dao.EmployeeDao; import com.pccw.emp.table.BasicEmployee; import com.pccw.emp.table.BasicExportEmployee; public class EmployeeAction extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String type = request.getParameter("type"); String html = getTable(type, request, response); if(html == null){ return; } request.setAttribute("employees", html); RequestDispatcher dispatcher = request.getRequestDispatcher("/jsp/"+type+".jsp"); dispatcher.forward(request, response); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { } public String getTable(String type,HttpServletRequest request, HttpServletResponse response){ EmployeeDao dao = new EmployeeDao(new HttpServletRequestWebContext(request)); TableModel tableModel = new TableModel(type,request,response); tableModel.setItems(dao.findAll(0, 0)); if("basic".equals(type)){ BasicEmployee.setTableProperties(tableModel); }else if("tagBasic".equals(type)){ request.setAttribute("emps", dao.findAll(0, 0)); BasicEmployee.setTableProperties(tableModel); }else if("basicExport".equals(type)){ BasicExportEmployee.setTableProperties(tableModel); } String html = tableModel.render(); return html; } }  

最终效果：

 

PS,如果标签页支持导出过滤功能，那就更强大了。（支持么？）