mybatis中collection的使用，递归查询

<!--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>

注意以上参数的个数，预编译需要几个，下面动态就要传递几个