/**
?* 根據(jù)劇典id list查詢劇典
?*/
public List<Drama> selectByIds(@Param("dramaIds")List<Long> dramaIds);

<!-- 根據(jù)劇典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);