对于初学mybatis的同学来说,在后台删除多条数据是一个比较棘手的事情,在这里分享一下自己操作过的后台删除数据
Controller层
@RequestMapping(value = "/delMore", method = RequestMethod.POST,headers = "Accept=application/json")
public QueryDada delMore(@RequestBody Integer [] list) throws Exception {
QueryDada queryDada = new QueryDada();
try {
userServiceImpl.delMore(list);
queryDada.setCode(Constans.SUCCESS_CODE);
queryDada.setMessage(Constans.QUERY_USER_MESSAGE);
} catch (Exception e) {
e.printStackTrace();
queryDada.setCode(Constans.QUERY_USER_ERROR_MESSAGE);
queryDada.setMessage(Constans.QUERY_USER_ERROR_MESSAGE);
}
return queryDada;
}
service层
public void delMore(Integer [] list) {
userDao.delMore(list);
}
dao/mapper层
void delMore(Integer [] list);
mapper.xml
<delete id="delMore" parameterType="java.util.Arrays">
delete from user
where id in
<foreach collection="array" index="index" item="item" open="(" separator="," close=")">
#{item}
</foreach>
</delete>
postman端
![](https://i-blog.csdnimg.cn/blog_migrate/c43b292744ce8c04cf7a4470ab071e02.png)
queryData类
public class QueryDada {
private String code;
private Object data;
private String Message;
public String getCode() {
return code;
}
public void setCode(String code) {
this.code = code;
}
public Object getData() {
return data;
}
public void setData(Object data) {
this.data = data;
}
public String getMessage() {
return Message;
}
public void setMessage(String message) {
Message = message;
}
}