mybatis一对多查询

多查询
<resultMap id="appVersionContentMap" type="com.XX.AppVersionContentBean">
        <result column="version_code" property="versionCode"/>
        <result column="version_content" property="versionContent"/>
        <result column="version_order" property="versionOrder"/>
        <result column="version_info_id" property="versionInfoId"/>
    </resultMap>
一查询
    <resultMap id="appMap" type="com.XX.AppVersionBean">
        <result property="id" column="id" />
        <result property="versionName" column="version_name"/>
        <result property="filePath" column="file_path"/>
        <result property="createDate" column="create_Date"/>
        <result property="onlineDate" column="online_Date"/>
        <result property="publishStatus" column="publish_status"/>
        <!--<collection property="contentList" column="version_info_id" ofType="com.XX.AppVersionContentBean" select="findAppContent">-->
        <collection property="contentList" column="id" ofType="com.XX.AppVersionContentBean" select="findAppContent">
        </collection>
    </resultMap>
多查询
    <select id="findAppContent" resultMap="appVersionContentMap" parameterType="integer">
        select version_content, version_order
        from a_version_content
        where version_info_id = #{versionInfoId}
    </select>
    
一查询
    <select id="findAppVersion" resultMap="appMap">
        select a.id,a.version_name,a.file_path,a.create_date,a.online_date,a.publish_status
        from a_version_info a
         order by a.create_date desc
    </select>