Mybatis - 批量操作

批量操作，使用 for each

collection=“list” ，这里需要注意，如果对象里有list属性，比如userList，list要换成userList

<foreach collection="list" index="index" item="item" open="(" close=")" separator=",">
  #{item}
 </foreach>

以批量查询为例子，如下

mapper

   /**
     * 批量查询联系处置
     *
     * @param list
     * @return
     */
    List<MissiveExport> selectMissiveList(List<String> list);

mapper.xml

<select id="selectMissiveList" resultType="com.bonc.entity.excel.MissiveExport">
        SELECT
        missive_id,
        missive_no,
        missive_title,
        draft_dept,
        connection_dept_name,
        to_char(send_date,'yyyy-mm-dd') send_date,
        to_char(missive_deadline,'yyyy-mm-dd') missive_deadline,
        current_node,
        (case missive_status
        when '100801' then '拟稿'
        when '100802' then '审批中'
        when '100803' then '处置中'
        when '100804' then '反馈'
        when '100805' then '办结'
        end) as missive_status,
        feedback_time
        FROM
        RM_MISSIVE_INFO_T
        WHERE missive_id IN
        <foreach collection="list" index="index" item="item" open="(" close=")" separator=",">
            #{item}
        </foreach>
        order by send_date desc
    </select>