mybatis 嵌套

一张栏目表t_column_video

一张栏目下的视频列表t_attachment_video 

xml:

<resultMap type="java.util.HashMap" id="definedMap">
  <id column="code" property="code" jdbcType="VARCHAR" />
  <result column="columnname" property="columnname" jdbcType="VARCHAR" />
  <result column="columnname" property="code" jdbcType="VARCHAR" />
 <collection column="code" property="children" javaType="java.util.ArrayList" select="selectvideo"  /> 

  </resultMap>

 <select id="find" resultMap ="definedMap" >
  select code ,columnname from t_column_video

  </select>

  <select id="selectvideo" resultMap ="definedMap" >
  select id, oldName, newName, columnCode, src, code, fileSuffix, fileSize, uploadTime, fileFullName, 
    fkTopicCode from t_attachment_video where columnCode = #{code}

  </select>

mapper

List<Map<String,Object>> find();