MyBatis批量执行查询语句，入参是集合

Question

List<Map<Long, Long>> getRecBestEjobIdBatch(List<Map<Long, String>> list)

这是我的调用接口，入参里的每个map的key value其实就是usere_id和res_ids，

    <select id="getRecBestEjobId" parameterType="map"
            resultType="java.lang.Long">
        SELECT ejob_id
        FROM e_bole_recommend_info
        <where>
            usere_id=#{usere_id} AND res_id IN (${res_ids}) AND delflag =   0 AND source != 4
        </where>
        ORDER BY feedback, source, score DESC, createtime DESC
        LIMIT 1
    </select>

以上这个sql如果我入参只有一个map是可以做到的，但我现在是个List<map>,我想把这个sql循环执行，遍历list中的map执行 用mybatis该怎么做呢</map>

Answer 1

 <foreach collection="list" item="i" separator=",">
    and    usere_id=     #{i.user_id}
           AND res_id IN #{i.res_ids}
       
        </foreach>