如何向resultMap中的collection中配置的select传递条件：配置报错

Mybatis 3.2.7 +Mysql 做一个小项目

现在需求是图书和作者多对多关系,配置了一个中间表图书的resultMap中有一个作者的collection，现在有条件查询，需要根据作者查书，又涉及到分页。。

直接多表联合查询，因为图书和作者是多对多关系，有重复数据，分页做不好，就考虑用嵌套查询。嵌套查询作者的id不知道怎么传递给collection了，各位帮帮忙，看看有什么办法结局~谢谢。
附上源码：

</resultMap>
<select id="queryAuthorByBookid" parameterType="java.util.HashMap" resultType="cn.edu.bjut.zj.tims.entity.Author">        SELECT t_abref.BOOKID,
           t_author.AUTHORID,
           t_author.AUTHORNAME        FROM t_author INNER JOIN t_abref ON t_author.AUTHORID = t_abref.AUTHORID        Where bookid=#{bookid} and t_author.AUTHORID, =#{authorid} </select>
<select id="queryAllBook" parameterType="cn.edu.bjut.zj.tims.entity.BookVo" resultMap="BaseResultMap"> SELECT t.TYPENAME,
   p.PUBLISHERNAME,
   b.BOOKID book_id,
   b.TYPEID,
   b.PUBLISHERID,
   b.BOOKNAME,
   b.NUM,
   b.ISBN,
   b.PRICE FROM t_publisher p INNER JOIN t_book b ON p.PUBLISHERID = b.PUBLISHERID    INNER JOIN t_type t ON t.TYPEID = b.TYPEID        <where>                       <if test="typeid!=0">                and b.TYPEID=#{typeid}            </if>            <if test="bookname!=null and bookname !=''">                and bookname like #{bookname}            </if>                 </where>         </select>

<select id="searchBykey" resultType="map" parameterType="java.util.Map"> SELECT tcs.id, tp.name, tcs.remark, tcs.gmt_create gmtCreate, tcs.gmt_modified gmtModified, tcs.is_delete FROM t_custom_setting tcs LEFT JOIN t_setting ts ON tcs.setting_id = ts.id AND ts.is_delete = 0 LEFT JOIN t_param tp on tp.value = tcs.set_code and tp.obj = 'setting' and tp.is_delete = 0 WHERE tcs.is_delete = 0 and tcs.set_key = #{Key} <if test="Code != '' and Code != null"> and tcs.set_code = #{Code}</if> </select>

如何向resultMap中的collection中配置的select传递条件 ： 配置报错

相关文章

相关电子书

如何向resultMap中的collection中配置的select传递条件：配置报错