通过Ajax实现用户的批量删除。
jsp
<script type="text/javascript">
function deleteAll() {
var checkNum = $("input[name='ids']:checked").length;
if (checkNum == 0) {
alert("请至少选择一项!");
return;
}
if (confirm("确认要删除吗?")) {
var userList = new Array();
$("input[name='ids']:checked").each(function () {
userList.push($(this).val())
});
}
// alert(userList);
$.ajax({
type: "post",
url: "${pageContext.request.contextPath}/user/deleteAll.do",
data: {userList: userList.toString()},
success: function () {
alert("删除成功");
location.reload();
},
error: function () {
alert("删除失败");
}
})
}
</script>
controller
@RequestMapping("deleteAll.do")
@ResponseBody
public String deleteAll(String userList) {
String[] strs = userList.split(",");
List<Integer> ids = new ArrayList<>();
for (int i = 0; i < strs.length; i++) {
ids.add(Integer.parseInt(strs[i]));
}
userInfoService.deleteAll(ids);
return "ok";
}
mapper
<delete id="deleteAll" parameterType="list">
delete from userinfo where id in
<foreach collection="list" item="id" open="(" close=")" separator=",">
#{id}
</foreach>
</delete>
dao,service等自行补充