Mybatis如何根据List批量查询List结果

/**

  * 根据剧典id list查询剧典

  */

public List<Drama> selectByIds( @Param ( "dramaIds" )List<Long> dramaIds);

<!-- 根据剧典id list查询剧典 -->

< select id = "selectByIds" resultMap = "DramaImageResultMap" >

    select * from drama where drama_id in 

    < foreach collection = "dramaIds" item = "dramaId" open = "(" close = ")" separator = "," >

    #{dramaId}

    </ foreach >

</ select >

//接口方法

ArrayList< User > selectByIds(Integer [] ids);

//xml映射文件

< select id = "selectByIds" resultMap = "BaseResultMap" >

    select

    *

    from user where id in

    < foreach item = "item" index = "index" collection = "array" open = "(" separator = "," close = ")" >

        #{item}

    </ foreach >

</ select >

//接口方法

ArrayList< User > selectByIds(List< Integer > ids);

//xml映射文件

< select id = "selectByIds" resultMap = "BaseResultMap" >

    Select

    < include refid = "Base_Column_List" />

    from jria where ID in

    < foreach item = "item" index = "index" collection = "list" open = "(" separator = "," close = ")" >

          #{item}

      </ foreach >

   </ select > 

< select id = "selectWhere" resultMap = "BaseResultMap" >

    select 

      < include refid = "Base_Column_List" />

    from table

      < where >

      table.a = a  and table.b in 

    < foreach collection = "list" item = "item" index = "index" open = "(" separator = "," close = ")" >

      '${item}'

    </ foreach >

    </ where >

   </ select >

List< T > selectWhere(@Param("list")List< String > list ,@Param("a") String a);