ContentCatService
//删除
public void delete(Integer id);
public class ContentCatServiceImpl implements ContentCatService{
//删除
public void delete(Integer id){
List<Integer> idList = new ArrayList<>();
idList.add(id);
contentCatMapper.deleteBatchIds(idList);
}
public class ContentCatController {
//删除
private SysResult delete(@PathVariable Integer id){
try {
contentCatService.delete(id);
return SysResult.ok();
}catch (Exception e){
e.printStackTrace();
return SysResult.build(201,"删除失败");
}
请问如果改为批量删除呢
https://blog.csdn.net/qq_36125733/article/details/81750824
批量删除你要传一个list
通过mybatis 的动态sql 拼接
<delete id="batchDelete" parameterType="java.util.List">
delete from tm_user where user_id in (
values
<foreach collection="instances" item="item" index="index" separator=",">
#{item.userId}
</foreach>
)
</delete>
批量新增差不多
<insert id="batchInsert" parameterType="java.util.List">
insert into tm_e_coupon_instance(e_coupon_id,batch_no)
values
<foreach collection="instances" item="item" index="index" separator=",">
(#{item.eCouponId},#{item.batchNo})
</foreach>
</insert>
mybatisPlus批量删除或者是插入都是通过service来调用的,而不是mapper, userService.insertBatch(List entityList),
userService.deleteBatchIds(Collection<? extends Serializable> idList)