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,"刪除失敗");
}請問如果改為批量刪除呢
3 回答
慕容708150
TA貢獻1831條經驗 獲得超4個贊
批量刪除你要傳一個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>添加回答
舉報
0/150
提交
取消