2009-03-20技术学习：Wicket+iBATIS 实现树控件的数据库绑定

用Wicket 和 iBATIS研究了一下关于TreeTable控件的绑定，可以从数据库中读取数据，页面中有层次的显示。以我们目前正在开发的系统中的菜单为例，表结构如下：

 

准备工作：

BaseDAO类，基础类用于配置SQlConfigMap：

/* * To change this template, choose Tools | Templates * and open the template in the editor. */ package kentop.net.lib.gtums.dao; import com.ibatis.common.resources.Resources; import com.ibatis.sqlmap.client.SqlMapClient; import com.ibatis.sqlmap.client.SqlMapClientBuilder; import java.io.IOException; import java.io.Reader; /** * * @author Administrator */ public class BaseDAO { private static SqlMapClient sqlMapper; public static SqlMapClient BuildSqlMapClient() { try { Reader reader = Resources.getResourceAsReader("kentop/net/lib/gtums/xml/SqlMapConfig.xml"); sqlMapper = SqlMapClientBuilder.buildSqlMapClient(reader); reader.close(); } catch (IOException e) { throw new RuntimeException("Something bad happened while building the SqlMapClient instance." + e, e); } return getSqlMapper(); } /** * @return the sqlMapper */ public static SqlMapClient getSqlMapper() { return sqlMapper; } }  

SysMenuDAO类，用于操作SysMenu类：

/* * To change this template, choose Tools | Templates * and open the template in the editor. */ package kentop.net.lib.gtums.dao; import com.ibatis.sqlmap.client.SqlMapClient; import com.ibatis.sqlmap.client.SqlMapSession; import java.sql.SQLException; import java.util.List; /** * * @author Administrator */ public class SysMenuDAO { private SqlMapClient sqlMapper; public SysMenuDAO() { sqlMapper = BaseDAO.getSqlMapper(); } public List getSysMenu() throws SQLException { return sqlMapper.queryForList("selectAllSysMenu"); } public List getSubSysMenuByParent(int parentID) throws SQLException { return sqlMapper.queryForList("selectSubSysMenuByParent", parentID); } }  

SysMenu.xml SysMenu类的Sql映射：

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd"> <sqlMap namespace="SysMenu"> <typeAlias alias="SysMenu" type="kentop.net.lib.gtums.beans.SysMenu" /> <resultMap id="getSysMenuResult" class="SysMenu"> <result property="menuID" column="MenuID" /> <result property="systemID" column="SystemID" /> <result property="code" column="Code" /> <result property="parentID" column="ParentID" /> <result property="name" column="Name" /> <result property="linkAddress" column="LinkAddress" /> <result property="visible" column="Visible" /> <result property="remark" column="Remark" /> <result property="menuType" column="MenuType" /> <result property="index" column="Index" /> <result property="logTypeID" column="LogTypeID" /> </resultMap> <select id="selectSysMenu" parameterClass="int" resultClass="SysMenu"> <!--[CDATA[ SELECT * FROM SysMenu WHERE MenuID = #menuID# ]]> </select> <select id="selectSubSysMenuByParent" parameterClass="int" resultClass="SysMenu"> <![CDATA[ SELECT * FROM SysMenu WHERE ParentID = #parentID# AND Visible = 1 ]]> </select> <select id="selectAllSysMenu" resultClass="SysMenu"> <![CDATA[ SELECT * FROM SysMenu ]]> </select> <select id="selectSysMenuByMenuID" parameterClass="int" resultClass="SysMenu"> <![CDATA[ SELECT MenuID, SystemID, Code, ParentID, Name, LinkAddress, Visible, Remark, MenuType, Index, LogTypeID FROM SysMenu WHERE MenuID = #menuID# ]]> </select> <insert id="insertSysMenu" parameterClass="SysMenu"> <![CDATA[ INSERT INTO SysMenu( MenuID, SystemID, Code, ParentID, Name, LinkAddress, Visible, Remark, MenuType, Index, LogTypeID) VALUES( #menuID#, #systemID#, #code#, #parentID#, #name#, #linkAddress#, #visible#, #remark#, #menuType#, #index#, #logTypeID#) ]]> </insert> <update id="updateSysMenu" parameterClass="SysMenu"> <![CDATA[ UPDATE SysMenu SET MenuID = #menuID#, SystemID = #systemID#, Code = #code#, ParentID = #parentID#, Name = #name#, LinkAddress = #linkAddress#, Visible = #visible#, Remark = #remark#, MenuType = #menuType#, Index = #index#, LogTypeID = #logTypeID# WHERE MenuID = #menuID# ]]> </update> <delete id="deleteSysMenu" parameterClass="int"> <![CDATA[ DELETE FROM SysMenu WHERE MenuID = #menuID# ]]--> </delete> </sqlMap> 

SysMenu类，表的映射类：

/* * To change this template, choose Tools | Templates * and open the template in the editor. */ package kentop.net.lib.gtums.beans; import java.io.Serializable; import javax.persistence.Basic; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.Id; import javax.persistence.NamedQueries; import javax.persistence.NamedQuery; import javax.persistence.Table; /** * * @author Administrator */ @Entity @Table(name = "SysMenu") @NamedQueries({@NamedQuery(name = "SysMenu.findAll", query = "SELECT s FROM SysMenu s"), @NamedQuery(name = "SysMenu.findByMenuID", query = "SELECT s FROM SysMenu s WHERE s.menuID = :menuID"), @NamedQuery(name = "SysMenu.findBySystemID", query = "SELECT s FROM SysMenu s WHERE s.systemID = :systemID"), @NamedQuery(name = "SysMenu.findByCode", query = "SELECT s FROM SysMenu s WHERE s.code = :code"), @NamedQuery(name = "SysMenu.findByParentID", query = "SELECT s FROM SysMenu s WHERE s.parentID = :parentID"), @NamedQuery(name = "SysMenu.findByName", query = "SELECT s FROM SysMenu s WHERE s.name = :name"), @NamedQuery(name = "SysMenu.findByLinkAddress", query = "SELECT s FROM SysMenu s WHERE s.linkAddress = :linkAddress"), @NamedQuery(name = "SysMenu.findByVisible", query = "SELECT s FROM SysMenu s WHERE s.visible = :visible"), @NamedQuery(name = "SysMenu.findByRemark", query = "SELECT s FROM SysMenu s WHERE s.remark = :remark"), @NamedQuery(name = "SysMenu.findByMenuType", query = "SELECT s FROM SysMenu s WHERE s.menuType = :menuType"), @NamedQuery(name = "SysMenu.findByIndex", query = "SELECT s FROM SysMenu s WHERE s.index = :index"), @NamedQuery(name = "SysMenu.findByLogTypeID", query = "SELECT s FROM SysMenu s WHERE s.logTypeID = :logTypeID")}) public class SysMenu implements Serializable { private static final long serialVersionUID = 1L; @Id @Basic(optional = false) @Column(name = "MenuID") private Integer menuID; @Basic(optional = false) @Column(name = "SystemID") private int systemID; @Basic(optional = false) @Column(name = "Code") private String code; @Basic(optional = false) @Column(name = "ParentID") private int parentID; @Basic(optional = false) @Column(name = "Name") private String name; @Column(name = "LinkAddress") private String linkAddress; @Basic(optional = false) @Column(name = "Visible") private short visible; @Column(name = "Remark") private String remark; @Column(name = "MenuType") private Integer menuType; @Basic(optional = false) @Column(name = "Index") private int index; @Basic(optional = false) @Column(name = "LogTypeID") private int logTypeID; public SysMenu() { } public SysMenu(Integer menuID) { this.menuID = menuID; } public SysMenu(Integer menuID, int systemID, String code, int parentID, String name, short visible, int index, int logTypeID) { this.menuID = menuID; this.systemID = systemID; this.code = code; this.parentID = parentID; this.name = name; this.visible = visible; this.index = index; this.logTypeID = logTypeID; } public Integer getMenuID() { return menuID; } public void setMenuID(Integer menuID) { this.menuID = menuID; } public int getSystemID() { return systemID; } public void setSystemID(int systemID) { this.systemID = systemID; } public String getCode() { return code; } public void setCode(String code) { this.code = code; } public int getParentID() { return parentID; } public void setParentID(int parentID) { this.parentID = parentID; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getLinkAddress() { return linkAddress; } public void setLinkAddress(String linkAddress) { this.linkAddress = linkAddress; } public short getVisible() { return visible; } public void setVisible(short visible) { this.visible = visible; } public String getRemark() { return remark; } public void setRemark(String remark) { this.remark = remark; } public Integer getMenuType() { return menuType; } public void setMenuType(Integer menuType) { this.menuType = menuType; } public int getIndex() { return index; } public void setIndex(int index) { this.index = index; } public int getLogTypeID() { return logTypeID; } public void setLogTypeID(int logTypeID) { this.logTypeID = logTypeID; } @Override public int hashCode() { int hash = 0; hash += (menuID != null ? menuID.hashCode() : 0); return hash; } @Override public boolean equals(Object object) { // TODO: Warning - this method won't work in the case the id fields are not set if (!(object instanceof SysMenu)) { return false; } SysMenu other = (SysMenu) object; if ((this.menuID == null && other.menuID != null) || (this.menuID != null && !this.menuID.equals(other.menuID))) { return false; } return true; } @Override public String toString() { return "kentop.net.lib.gtums.beans.SysMenu[menuID=" + menuID + "]"; } }  

TreePage，定义了TreeModel以及各列：

TreePage.html:

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns:wicket> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/> <title>TreePage</title> <link rel="stylesheet" type="text/css" href="style.css" mce_href="style.css"/> <link wicket:id='stylesheet'/> </head> <body> <span wicket:id='mainNavigation'/> </body> </html>  

TreePage.java:

/* * To change this template, choose Tools | Templates * and open the template in the editor. */ package kentop.net.lib.gtums.ui; import kentop.net.lib.gtums.dao.SysMenuDAO; import kentop.net.lib.gtums.beans.SysMenu; import org.apache.wicket.extensions.markup.html.tree.table.ColumnLocation; import org.apache.wicket.extensions.markup.html.tree.table.IColumn; import org.apache.wicket.extensions.markup.html.tree.table.PropertyRenderableColumn; import org.apache.wicket.extensions.markup.html.tree.table.PropertyTreeColumn; import org.apache.wicket.extensions.markup.html.tree.table.ColumnLocation.Alignment; import org.apache.wicket.extensions.markup.html.tree.table.ColumnLocation.Unit; import java.util.List; import java.util.ArrayList; import javax.swing.tree.DefaultMutableTreeNode; import javax.swing.tree.DefaultTreeModel; import javax.swing.tree.TreeModel; /** * * @author Administrator */ public class TreePage extends BasePage { private DefaultMutableTreeNode rootNode = new DefaultMutableTreeNode(); private final int rootMenuID = 0; private TreeModel treeModel; private IColumn columns[] = new IColumn[]{new PropertyTreeColumn(new ColumnLocation(Alignment.LEFT, 18, Unit.EM), "冠腾通讯", "userObject.name"), new PropertyRenderableColumn(new ColumnLocation(Alignment.LEFT, 12, Unit.EM), "标题", "userObject.linkAddress"),}; public TreePage() { treeModel = buildTreeModel(rootMenuID); } private TreeModel buildTreeModel(int parentID) { recursionSysMenu(rootNode, parentID); return new DefaultTreeModel(rootNode); } private void recursionSysMenu(DefaultMutableTreeNode rtNode, int parentID) { List sysMenuList = new ArrayList(); sysMenuList = getSubSysMenuByParent(parentID); for (int i = 0; i < sysMenuList.size(); i++) { SysMenu sysmenu = new SysMenu(); DefaultMutableTreeNode parentNode = new DefaultMutableTreeNode(sysmenu); sysmenu.setName(((SysMenu) sysMenuList.get(i)).getName()); sysmenu.setLinkAddress(((SysMenu) sysMenuList.get(i)).getLinkAddress()); rtNode.add(parentNode); //递归生成子菜单 recursionSysMenu(parentNode, ((SysMenu) sysMenuList.get(i)).getMenuID()); } } /** * @get subMenu by parentID */ private List getSubSysMenuByParent(int parentID) { SysMenuDAO dao = new SysMenuDAO(); List list = new ArrayList(); try { list = dao.getSubSysMenuByParent(parentID); } catch (Exception ex) { ex.printStackTrace(); } return list; } /** * @return the treeModel */ public TreeModel getTreeModel() { return treeModel; } /** * @return the columns */ public IColumn[] getColumns() { return columns; } }  

Tree页面，用来最终显示

Tree.html:

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/> <title>Tree</title> <link rel="stylesheet" type="text/css" href="style.css" mce_href="style.css"/> <link wicket:id='stylesheet'/> </head> <body> <span wicket:id='mainNavigation'/> <table style="border: 1px solid #eee" mce_style="border: 1px solid #eee" cellpadding="0" cellspacing="0" > <tr> <td> <div wicket:id="treeTable" class="my-tree"></div> </td> </tr> </table> <hr /> </body> </html>  

Tree.java:

/* * To change this template, choose Tools | Templates * and open the template in the editor. */ package kentop.net.lib.gtums.ui; import org.apache.wicket.PageParameters; import org.apache.wicket.extensions.markup.html.tree.table.TreeTable; /** * * @author Administrator */ public final class Tree extends TreePage { private static final long serialVersionUID = 1L; TreeTable tree; public Tree{ TreePage treePage = new TreePage(); tree = new TreeTable("treeTable", treePage.getTreeModel(), treePage.getColumns()) { }; tree.getTreeState().setAllowSelectMultiple(true); tree.setRootLess(true); tree.getTreeState().collapseAll(); add(tree); } }  

 

在TreePage中定义要显示的列，对于子菜单则使用递归的方法进行层次的生成。目前还没解决的问题就是菜单项点击时的事件处理。网上资料太少了，偶尔找到一些老外的代码还是以前的，郁闷中!