java实现树形查询
首先这个树形查询,你肯定不能用他内置sql语句吧,所以这里我们自己在dao层写一句sql语句进行查询:@Query(value = "select * from TB_UIM_MENU_TEST t START WITH t.PID IS NULL" + " CONNECT BY PRIOR t.ID = t.PID order by t.PID NULLS first,t.MENU_SORT ASC",nativeQuery = true)List<MenuTestDTO>
原创
2021-06-01 16:22:20 ·
2684 阅读 ·
3 评论