sql 2005 树形表非循环递归 转json

Question

求大神给出遍历无限树形表装载成Json的算法····
WITH 
TREE AS( 
    SELECT * FROM ITE_CATALOG 
    WHERE PARENT_MAT_CATALOG_CODE = 1
    UNION ALL 
    SELECT ITE_CATALOG.* FROM ITE_CATALOG, TREE 
    WHERE ITE_CATALOG.PARENT_MAT_CATALOG_CODE = TREE.MAT_CATALOG_CODE
) 
SELECT * FROM TREE------------------------------------------------------------------------------
{
"土建材料":[{"黑色及有色金属":["钢板","钢筋","角钢","曹钢","工字钢","圆钢","扁钢","H型钢","铝板","钢带"],
"水泥，砖瓦":["瓦","水泥","砌块","砌砖","石子","沙","水泥及混泥土预制品","混泥土","砂浆"],
"砼、砂浆及其它配合比材料":["瓦","水泥","砌块","砌砖","石子","沙","水泥及混泥土预制品","混泥土","砂浆"],
"密封、电极、劳保 成型构件及加工件":["瓦","水泥","砌块","砌砖","石子","沙","水泥及混泥土预制品","混泥土","砂浆"],
"周转材料及工器具":["瓦","水泥","砌块","砌砖","石子","沙","水泥及混泥土预制品","混泥土","砂浆"],
"机械台班":["瓦","水泥","砌块","砌砖","石子","沙","水泥及混泥土预制品","混泥土","砂浆"]
   }],
"装饰材料":[{"黑色及有色金属":["钢板","钢筋","角钢","曹钢","工字钢","圆钢","扁钢","H型钢","铝板","钢带"],
"水泥，砖瓦":["瓦","水泥","砌块","砌砖","石子","沙","水泥及混泥土预制品","混泥土","砂浆"],
"砼、砂浆及其它配合比材料":["瓦","水泥","砌块","砌砖","石子","沙","水泥及混泥土预制品","混泥土","砂浆"],
"密封、电极、劳保 成型构件及加工件":["瓦","水泥","砌块","砌砖","石子","沙","水泥及混泥土预制品","混泥土","砂浆"],
"周转材料及工器具":["瓦","水泥","砌块","砌砖","石子","沙","水泥及混泥土预制品","混泥土","砂浆"],
"机械台班":["瓦","水泥","砌块","砌砖","石子","沙","水泥及混泥土预制品","混泥土","砂浆"]
   }],
"给排水材料":[{"黑色及有色金属":["钢板","钢筋","角钢","曹钢","工字钢","圆钢","扁钢","H型钢","铝板","钢带"],
"水泥，砖瓦":["瓦","水泥","砌块","砌砖","石子","沙","水泥及混泥土预制品","混泥土","砂浆"],
"砼、砂浆及其它配合比材料":["瓦","水泥","砌块","砌砖","石子","沙","水泥及混泥土预制品","混泥土","砂浆"],
"密封、电极、劳保 成型构件及加工件":["瓦","水泥","砌块","砌砖","石子","沙","水泥及混泥土预制品","混泥土","砂浆"],
"周转材料及工器具":["瓦","水泥","砌块","砌砖","石子","沙","水泥及混泥土预制品","混泥土","砂浆"],
"机械台班":["瓦","水泥","砌块","砌砖","石子","沙","水泥及混泥土预制品","混泥土","砂浆"]
   }]
}JSON算法树形表java

Answer 1

这用搞那么复杂，只有 ID,PID,name 就可以了
  [ 
     {id:xx,pid:xx,name:""},
     .........
  ]
这种格式输出就行了，直接数据库查出结果集转JSON就行了
父子关系，交给前台生成树的JS来处理

Answer 2

本帖最后由 showbo 于 2013-08-12 22:09:01 编辑

  

Answer 3

后来从数据库读出来放到JAVA多叉树结构中，在对多叉树用循环遍历，构建json`````