mysql 根据 ids 批量删除数据

Mapper

<delete id="deleteDetailsByIds" parameterType="String">
        delete from update_details where id in
        <foreach item="id" collection="array" open="(" separator="," close=")">
            #{id}
        </foreach>
</delete>

Java 调用方法：

public int deleteBizWorkflowByIds(String ids) {
      Mapper.deleteDetailsByIds(Convert.toStrArray(ids));
}

其中，ids 是以","分割的 id 字符串。