难道是sql语句错了？求大神，，，急急急啊

Question

springmvc+mabatis框架，显示权限模块的树状图
这是sql语句

SELECT M_ID as id, M_PID as pId, M_NAME as name, M_NODE as isParent,'true' checked, M_CODE,'true' open FROM T_MODULES t WHERE M_PID = #{NODE,jdbcType=VARCHAR} and M_ID in
(SELECT M_ID FROM T_ROLES_MODULES WHERE R_ID = #{RID,jdbcType=VARCHAR})
UNION
SELECT M_ID as id, M_PID as pId, M_NAME as name, M_NODE as isParent,'false' checked, M_CODE,'true' open FROM T_MODULES t WHERE M_PID = #{NODE,jdbcType=VARCHAR} and M_ID NOT IN
(SELECT M_ID FROM T_ROLES_MODULES WHERE R_ID = #{RID,jdbcType=VARCHAR}) ORDER BY M_CODE ASC

Answer 1

怎么才能显示数据