随記mybatis遞歸查詢寫法

sql遞歸速記

<select id="selectOrgTree" parameterType="com.jx.uac.api.doman.dto.OrganizationDto"
        resultType="com.jx.uac.api.doman.vo.OrganizationTreeVO">
    select
    ID,PID,NAME title, name label
    from SSO_ORGAN
    <include refid="getChild"></include>
</select>

<!-- 遞歸查詢擷取所有父級機構 -->
<select id="selectParentOrgan" parameterType="com.jx.uac.api.doman.dto.OrganizationDto"
        resultType="com.jx.uac.api.doman.vo.ParentOrganVO">
    select
    ID,NAME
    from SSO_ORGAN
    <include refid="getChild"></include>
</select>