一、mapper接口
/**
* 根据剧典id list查询剧典
*/
public List<Drama>
selectByIds(@
Param("dramaIds")List<Long> dramaIds);
二、mapper.xml文件
<select id="selectByIds" resultMap="DramaImageResultMap">
select * from drama where drama_id in
<foreach collection="dramaIds" item="dramaId" open="(" close=")" separator=",">
#{dramaId}
</foreach>
</select>
