如果產生的樹只有一層,那麼action可以做如下修改:
/**<br />* 產生使用者已管理的欄目樹<br />* @return<br />*/<br />public String getMyManageType(){<br />List<JSONTreeNode> treeNodeArray = new ArrayList<JSONTreeNode>();<br />String SQLString = "SELECT TYPECODE,TYPENAME FROM DX_FM_TYPE WHERE TYPECODE IN (SELECT DISTINCT TYPECODE FROM DX_FM_ATP_MAP WHERE MANAGERID =?) ORDER BY TYPECODE";<br />String[] params1 = new String[] {userId};</p><p>List jsonList = new ArrayList();<br />List list1 = dao.QueryByParamSql(SQLString, 0, 0, params1);<br />if(null!=list1&&0!=list1.size()){<br />for(int i=0;i<list1.size();i++){<br />Object[] obj = (Object[]) list1.get(i);<br />String typecode = obj[0].toString();<br />String typename = obj[1].toString();</p><p>JSONTreeNode treeNode = new JSONTreeNode();<br />treeNode.setId(typecode);<br />treeNode.setText(typename);<br />treeNode.setCls("x-html-editor-tip");<br />treeNode.setLeaf(true); //注意這裡要設定為葉子結點<br />treeNode.setExpanded(false);<br />treeNodeArray.add(treeNode);<br />}<br />}<br />JSONArray JsonArray = JSONArray.fromObject(treeNodeArray); // 得到JSON數組<br />JsonString = JsonArray.toString();//返回JSON資料 </p><p>return "success";// 返回JSON資料<br />} </p><p>