mybatis 批量删除

1. 按id集合删除

<delete id="deleteAll" parameterType="java.util.List">
delete from BS_MATCHDATA where MATCHID in
<foreach collection="list" item="item" index="index" open="("
close=")" separator=",">
#{item}
</foreach>
</delete>

2.按对象集合删除

<delete id="deleteByObject" parameterType="java.util.List">
delete from BS_MATCHDATA where MATCHID in
<foreach collection="list" item="item" index="index" open="("
close=")" separator=",">
#{item.matchid}
</foreach>
</delete>