1.mapper.xml
傳入的參數可以是List也可以是Array數組,ParameterType都寫List就可以collection="array"也可以寫成collection=“lsit”
delete from sys_menu where menu_id in
#{id}
2.dao層
int deleteMenuIds(Long[] ids);
3.pojo層
package com.qingfeng.pojo;
import java.io.Serializable;
public class SysMenu implements Serializable {
private Long menuId;
private Long parentId;
private String name;
private String url;
public Long getMenuId() {
return menuId;
}
public void setMenuId(Long menuId) {
this.menuId = menuId;
}
public Long getParentId() {
return parentId;
}
public void setParentId(Long parentId) {
this.parentId = parentId;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name == null ? null : name.trim();
}
public String getUrl() {
return url;
}
public void setUrl(String url) {
this.url = url == null ? null : url.trim();
}
}
4.service層
public R deleteMenu(Long[] ids) {
int i = sysMenuMapper.deleteMenuIds(ids);
if (i>0){
return R.ok();
}else {
return R.error("删除失敗");
}
}
5.controller層
@PostMapping("/sys/delete")
@ResponseBody
public R del(Long[] ids){
return sysMenuService.deleteMenu(ids);
}
6.測試
http://localhost:8080/sys/delete?ids=1,2,5