MyBatis案例:批量删除
- 编写接口方法:Mapper接口
- 参数:数组
- 结果:void
- 编写SQL语句:SQL映射文件
- 执行方法,测试
<!--SQL映射文件中的部分代码,多条件查询语句的配置-->
<!--动态修改字段-->
<!--
mybatis会将数组参数,封装为一个Map集合
* 默认: array = 数组
* 使用@Param注解改变map集合的默认key的名称
-->
<!--<delete id="deleteByIds">
delete from tb_brand where id
in (
<foreach collection="ids" item="id" separator=",">
#{id}
</foreach>
);
</delete>-->
<delete id="deleteByIds">
delete from tb_brand where id
in
<foreach collection="ids" item="id" separator="," open="(" close=")">
#{id}
</foreach>
;
</delete>