@mybatis xml 中直接编写树
1、xml配置
2、select配置
3、实体类
4、调用接口
5、api调用
6、主流前端框架树可能不需要返回数据结构,只需展示所有子节点(包含孙子节点)sql
select * from
(SELECT A.ID, A.TYPE_NAME, A.PARENT_ID, NULL as LINKURL, ‘MENU’ as TYPE,A.show_index,‘’ as news_pic FROM
MW_APP.MWT_CMS_CONTENTTYPE A
UNION ALL
SELECT B.ID, B.ITEM_TITLE as TYPE_NAME , B.TYPE_ID as PARENT_ID , B.LINK_URL , NULL as
TYPE,B.SHOW_INDEX,b.news_pic FROM MW_APP.MWT_CMS_CONTENTITEM B where (B.is_pub = ‘1’ or B.is_pub is null or B.is_pub = ‘’))t
START WITH t.ID = ‘0x41F1E5D859B3951B507F570D70273416’ CONNECT BY PRIOR t.ID = t.PARENT_ID ORDER SIBLINGS BY show_index