Mapper
<select id="方法名" parameterType="java.util.List" resultMap="返回类型">
select ***
FROM
****
WHERE *** in
<foreach collection="list" item="item" index="index" open="(" close=")" separator=",">
#{item}
</foreach>
</select>
Dao
List<返回类型> 方法名(@Param("list") List<String> list);