mybaits collection 父查询参数如何传进子查询中

Question

##父集合 id在resultMap中，name在父查询的parameterType中
<resultMap type="cn.xxxVO" id="fatherResult">
        <result property="id"    column="id"    />
        <collection property="xxxList" ofType="cn.xxxResVO" javaType="java.util.List" column="{id, name}" select="selectResResult" />
    </resultMap>

##父查询
<select id="selectFatherResResult" resultMap="fatherResult" parameterType="cn.xxxDTO">
        select id from AAA 
</select>

##子查询
 <select id="selectSonResResult" resultMap="sonResResult" parameterType="java.util.Map">
        select a,b,c from xxx 
        <where>
            <if test="id!= null and id!= ''">
                and xxx.id = #{id}
            </if>
            <if test="name!= null and name!= ''">
                and xxx.name like concat('%', #{name}, '%')
            </if>
        </where>
    </select>

##查询报错
nested exception is org.apache.ibatis.executor.result.ResultMapException: Error attempting to get column 'name' from result set. Cause: org.apache.ibatis.executor.result.ResultMapException: Error attempting to get column 'name' from result set. Cause: java.sql.SQLException: Column 'name' not found.

Answer 1

https://blog.csdn.net/Weixiaohuai/article/details/103029996?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522170675021916800226527447%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fall.%2522%257D&request_id=170675021916800226527447&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v1~rank_v31_ecpm-5-103029996-null-null.142^v99^pc_search_result_base8&utm_term=mybaits%20collection%20%E7%88%B6%E6%9F%A5%E8%AF%A2%E5%8F%82%E6%95%B0%E5%A6%82%E4%BD%95%E4%BC%A0%E8%BF%9B%E5%AD%90%E6%9F%A5%E8%AF%A2%E4%B8%AD&spm=1018.2226.3001.4187