首页 > 技术文章 > MyBatis批量删除

anxminise 2018-09-22 17:20 原文

Mybatis中的Dao层

public interface FileSaveMapper {
  int batchDeleteFiles(List<String> fileIds);
}

Xml中

<delete id="batchDeleteFiles" parameterType="String">
    delete from tab_files where file_id in
    <foreach item="item" collection="list" open="(" separator="," close=")">
      #{item}
    </foreach>
 </delete>

推荐阅读