MyBatis根据List批量更新及删除记录

查询

//根据多个设备id获取设备信息
public List<Devices> getDevicesList(@Param("devicesIds") String[] devicesIds);

<select id="getDevicesList" resultMap="BaseResultMap">
    select
    <include refid="Base_Column_List"/>
    from sys_devices d
    where d.devices_id in
    <foreach item="devices_id" index="index" collection="devicesIds"
            open="(" separator="," close=")">
        #{devices_id}
    </foreach>
</select>

删除

//根据主键ID批量删除记录
int deleteCategory(String[] categoryIds); 

<!-- 根据主键批量删除记录 -->
<delete id="deleteCategory">
    delete from category
    where Category_ID in
    <foreach item="item" index="index" collection="array" open="(" separator="," close=")">
        #{item}
    </foreach>
</delete>

更新

int updateNotifyStatusForJob(List<Long> notifyIds);

<update id="updateNotifyStatusForJob" parameterType="java.util.List">
    update notify_info
    set notify_status='doing'
    where notify_id IN
    <foreach collection="list" index="index" item="item" open="(" separator="," close=")">
        #{item}
    </foreach>
</update>