MyBatis批量删除

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>
posted @ 2018-09-22 17:20  忧臣解读  阅读(270)  评论(0编辑  收藏  举报