mybatis 关联查询

<association property="parentMenu" column="parent_code" select="getParent">  
</association>
<collection property="nodes" column="{menuCode=menu_code,isAdmin=is_admin}" ofType="menu" select="getNodes">
</collection>

<select id="getParent" resultMap="BaseResultMap" parameterType="java.lang.String">
  select
  <include refid="Base_Column_List" />
  from sys_menu where menu_code = #{parentCode}
</select>
<select id="getNodes" resultMap="MenuResultMap" parameterType="java.util.Map">
    select
    <include refid="Base_Column_List" />
    from sys_menu where level &lt;= 2 and parent_code = #{menuCode} and is_admin = #{isAdmin} and enabled = 1
    ORDER BY order_no DESC,create_date DESC
  </select>

传单个参数时，类型为String，不强行要求参数名称；传多个参数时，类型为map，参数名称必须为map中的key值。