实际项目中的对表的批量删除操作

1.在对应的mapper.xml中编写删除语句 collection代表数组

<delete id="deleteAll">
delete from PACKING_LIST_C where PACKING_LIST_ID in
<foreach collection="ids" item="id" open="(" close=")"
separator=",">
#{id}
</foreach>
</delete>

2.在对应的mapper接口中创建删除方法，务必方法名与mapper.xml中的id一致

 int  deleteAll(@param("ids")String[] id);

3.对应的service和serviceimpl代码

service:

/**
* 根据id批量删除装箱单信息
* 
* @return
*/
int deleteAll(String[] id);

serviceImpl:

@Override
public int deleteAll(String[] id) {
return packingListMapper.deleteAll(id);
}

4.最后在相对应的controller中调用该方法即可

/**
* 批量删除
* 
* @param id
* @return
*/
@RequestMapping("/cargo/packinglist/deleteBatch.action")
public ModelAndView deleteAll(String[] id) {
ModelAndView m = null;
packingListService.deleteAll(id);
return m = new ModelAndView(new RedirectView("jPackingListList"));
}