select c.CATEGORY_ID,c.PARENT_ID,ct.CATEGORY_NAME,c.IS_BOTTOM
from n_category c,n_categorytrans ct where ct.CATEGORY_ID=c.CATEGORY_ID
and ct.CUR_LANGUAGE='zh' and c.TYPE=3
start with c.PARENT_ID=0 connect by prior c.PARENT_ID=c.CATEGORY_ID
order by c.PARENT_ID,c.ORDER_NUMBER
出来的数据放到一个list里面。传到页面上。
List li = this.baseService.getListForSql(sql,new Object[]{curLanguage,type,0});
HttpServletRequest request = ServletActionContext.getRequest();
request.setAttribute("ncategoryTree", li);
2.jsp的页面如下:
String path = request.getContextPath();
%>
var show = function (node) { $("#compassClassID").val($(node).attr('cateid')); $("#nodeName").html($(node).html()); $("#treeMessage").html(""); $("#compassClass").hide(); } var d = new dTree('d',''); d.add(0,-1,""); var fnStr = ""; fnStr = "show(this);"; d.add(${node[0]},${node[1]},'${node[2]}',fnStr); $("#theTree").html(d.toString()); |
posted on 2008-08-18 17:20 智者无疆 阅读(1377) 评论(0) 编辑 收藏 所属分类: about java