和爪哇一起走過的日子

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sql-map
PUBLIC "-//iBATIS.com//DTD SQL Map 1.0//EN"
"http://www.ibatis.com/dtd/sql-map.dtd">
<sql-map name="jivecategory">
<!-- =============================================
    mapped-statement find 
============================================= -->
<dynamic-mapped-statement name="findjivecategoryDao"  result-class="java.util.HashMap">
   select $listfield$  from JIVECATEGORY
   <dynamic prepend="where">
      <isPropertyAvailable prepend="and" property="CATEGORYID" >
         <isNotNull prepend="" property="CATEGORYID" >
             CATEGORYID=#CATEGORYID#
         </isNotNull>
      </isPropertyAvailable>
      <isPropertyAvailable prepend="and" property="NAME" >
         <isNotNull prepend="" property="NAME" >
             NAME=#NAME#
         </isNotNull>
      </isPropertyAvailable>
      <isPropertyAvailable prepend="and" property="DESCRIPTION" >
         <isNotNull prepend="" property="DESCRIPTION" >
             DESCRIPTION=#DESCRIPTION#
         </isNotNull>
      </isPropertyAvailable>
      <isPropertyAvailable prepend="and" property="CREATIONDATE" >
         <isNotNull prepend="" property="CREATIONDATE" >
             CREATIONDATE=#CREATIONDATE#
         </isNotNull>
      </isPropertyAvailable>
      <isPropertyAvailable prepend="and" property="MODIFIEDDATE" >
         <isNotNull prepend="" property="MODIFIEDDATE" >
             MODIFIEDDATE=#MODIFIEDDATE#
         </isNotNull>
      </isPropertyAvailable>
      <isPropertyAvailable prepend="and" property="LFT" >
         <isNotNull prepend="" property="LFT" >
             LFT=#LFT#
         </isNotNull>
      </isPropertyAvailable>
      <isPropertyAvailable prepend="and" property="RGT" >
         <isNotNull prepend="" property="RGT" >
             RGT=#RGT#
         </isNotNull>
      </isPropertyAvailable>
   </dynamic>	  
</dynamic-mapped-statement>

</sql-map>

//對應字段，其中key為主表的字段，value是從表的字段。
private HashMap keymap;
//菜單的名稱
private String MenuName;
//標題
private String Title;
//標題字段
private String TitleField;
//需要讀取的字段
private String listField;
//是否需要顯示
private boolean needShow=true;

<?xml version="1.0" encoding="UTF-8"?> 
<java version="1.4.2_03" class="java.beans.XMLDecoder"> 
 <object class="java.util.HashMap"> 
  <void method="put"> 
   <string>message</string> 
   <object class="com.ewuxi.champion.MenuDefine"> 
    <void property="keymap"> 
     <object class="java.util.HashMap"> 
      <void method="put"> 
       <string>MESSAGEID</string> 
       <string>PARENTMESSAGEID</string> 
      </void> 
     </object> 
    </void> 
    <void property="listField"> 
     <string>MESSAGEID,SUBJECT</string> 
    </void> 
    <void property="menuName"> 
     <string>message</string> 
    </void> 
    <void property="sqlMapName"> 
     <string>jivemessage</string> 
    </void> 
    <void property="sqlName"> 
     <string>findjivemessageDao</string> 
    </void> 
    <void property="submenuName"> 
     <string>message</string> 
    </void> 
    <void property="title"> 
     <string>文章</string> 
    </void> 
    <void property="titleField"> 
     <string>SUBJECT</string> 
    </void> 
   </object> 
  </void> 
  <void method="put"> 
   <string>category</string> 
   <object class="com.ewuxi.champion.MenuDefine"> 
    <void property="keymap"> 
     <object class="java.util.HashMap"> 
      <void method="put"> 
       <string>CATEGORYID</string> 
       <string>CATEGORYID</string> 
      </void> 
     </object> 
    </void> 
    <void property="listField"> 
     <string>CATEGORYID,NAME</string> 
    </void> 
    <void property="menuName"> 
     <string>category</string> 
    </void> 
    <void property="sqlMapName"> 
     <string>jivecategory</string> 
    </void> 
    <void property="sqlName"> 
     <string>findjivecategoryDao</string> 
    </void> 
    <void property="submenuName"> 
     <string>forum</string> 
    </void> 
    <void property="title"> 
     <string>大分類</string> 
    </void> 
    <void property="titleField"> 
     <string>NAME</string> 
    </void> 
   </object> 
  </void> 
  <void method="put"> 
   <string>forum</string> 
   <object class="com.ewuxi.champion.MenuDefine"> 
    <void property="keymap"> 
     <object class="java.util.HashMap"> 
      <void method="put"> 
       <string>FORUMID</string> 
       <string>FORUMID</string> 
      </void> 
     </object> 
    </void> 
    <void property="listField"> 
     <string>FORUMID,NAME</string> 
    </void> 
    <void property="menuName"> 
     <string>forum</string> 
    </void> 
    <void property="sqlMapName"> 
     <string>jiveforum</string> 
    </void> 
    <void property="sqlName"> 
     <string>findjiveforumDao</string> 
    </void> 
    <void property="submenuName"> 
     <string>thread</string> 
    </void> 
    <void property="title"> 
     <string>子分類</string> 
    </void> 
    <void property="titleField"> 
     <string>NAME</string> 
    </void> 
   </object> 
  </void> 
  <void method="put"> 
   <string>thread</string> 
   <object class="com.ewuxi.champion.MenuDefine"> 
    <void property="keymap"> 
     <object class="java.util.HashMap"> 
      <void method="put"> 
       <string>THREADID</string> 
       <string>THREADID</string> 
      </void> 
      <void method="put"> 
       <string>FORUMID</string> 
       <string>FORUMID</string> 
      </void> 
      <void method="put"> 
       <string>ROOTMESSAGEID</string> 
       <string>MESSAGEID</string> 
      </void> 
     </object> 
    </void> 
    <void property="listField"> 
     <string>THREADID,ROOTMESSAGEID</string> 
    </void> 
    <void property="menuName"> 
     <string>thread</string> 
    </void> 
    <void property="needShow"> 
     <boolean>false</boolean> 
    </void> 
    <void property="sqlMapName"> 
     <string>jivethread</string> 
    </void> 
    <void property="sqlName"> 
     <string>findjivethreadDao</string> 
    </void> 
    <void property="submenuName"> 
     <string>message</string> 
    </void> 
    <void property="title"> 
     <string>欄目</string> 
    </void> 
    <void property="titleField"> 
     <string>ROOTMESSAGEID</string> 
    </void> 
   </object> 
  </void> 
 </object> 
</java> 

    

public class TreeDemoSession {
	//通過名稱和參數來得到樹
	public MenuComponent getMenu(String name, Map keys) throws Exception {
		Map menuMap =
			(Map) (new XmlUtils().read(Service.getPath() + "/menu.xml"));
		MenuComponent menu = new MenuComponent();

		if (menuMap.get(name) != null) {
			MenuDefine rootMenudefine = (MenuDefine) menuMap.get(name);
			menu.setTitle(rootMenudefine.getTitle());
			menu.setName(rootMenudefine.getMenuName());

			menu = submenuAdd(menu, keys, menuMap, name);
		}
		return menu;
	}

	/**一個典型的遞歸函數。用以組織樹。
	 * @param menu
	 * @param map
	 * @param menuMap
	 * @param menuName
	 * @return
	 * @throws DaoException
	 * @throws Exception
	 */
	private MenuComponent submenuAdd(
		MenuComponent menu,
		Map map,
		final Map menuMap,
		String menuName)
		throws DaoException, Exception {
		try {
			//得到菜單定義
			MenuDefine menudefine = (MenuDefine) menuMap.get(menuName);
			//listfield,表示需要讀取哪幾個字段
			map.put("listfield", menudefine.getListField());
			//查詢，返回列表。
			List list = DaoCommon.findbyName(map, menudefine.getSqlName());

			int namei = 0;
			for (Iterator iter = list.iterator(); iter.hasNext();) {
				Map element = (Map) iter.next();
                //建立當前節點
				MenuComponent submenu = new MenuComponent();
				submenu.setName(menu.getName() + String.valueOf(namei++));
				submenu.setTitle(
					String.valueOf(element.get(menudefine.getTitleField())));
					//如果不需要顯示，則使用父節點作為當前節點
				if (!menudefine.isNeedShow())
					submenu = menu;
				//如果有子菜單，則遞歸調用。	
				if (menudefine.getSubmenuName() != null) {

					submenu =
						submenuAdd(
							submenu,
							getSubMenuInfo(menudefine, element),
							menuMap,
							menudefine.getSubmenuName());
				}
				//將當前節點放到樹中。(如果不需要顯示就不用放)
				if (menudefine.isNeedShow())
					menu.addMenuComponent(submenu);
			}
			return menu;
		} catch (DaoException e) {

			throw e;
		} catch (Exception e) {

			throw e;
		}
	}

	/**將父菜單的關鍵字段的值作為參數給子菜單
	 * @param menudefine
	 * @param element
	 * @return
	 */
	private HashMap getSubMenuInfo(MenuDefine menudefine, Map element) {
		HashMap map = new HashMap();
		for (Iterator iter = menudefine.getKeymap().keySet().iterator();
			iter.hasNext();
			) {
			String key = (String) iter.next();
			map.put(menudefine.getKeymap().get(key), element.get(key));
		}
		return map;
	}
}