<!--zyj new add 根据父级id查询子级数据 -->
<select id="findSysRoleFuncObjectTree" resultMap="cascadeLoadSysRoleFunc" parameterType="sysFunctionVO">
SELECT CONCAT(#{srId}) AS sr_id,st.* FROM (SELECT * FROM sys_function WHERE sf_id IN
(SELECT sf_id FROM sys_role_function WHERE sr_id = #{srId})) AS st
WHERE st.sys_sf_id = #{sfId}
order by sf_order
</select>
<!--zyj new add 根据父级获取子集返回对象-->
<resultMap id="cascadeLoadSysRoleFunc" type="sysFunctionVO">
<id property="sfId" column="sf_id" />
<result property="sfParentId" column="sys_sf_id" />
<result property="sfName" column="sf_name" />
<result property="sfOrder" column="sf_order" />
<result property="srId" column="sr_id" />
<collection property="sysFunctionVOList" column="{srId=sr_Id,srId=sr_Id,sfId=sf_id}" ofType="sysFunctionVO" javaType="java.util.ArrayList"
select="findSysRoleFuncObjectTree"></collection>
</resultMap>
注意以上参数的个数,预编译需要几个,下面动态就要传递几个