function batchRemove() {
var rows = $('#exampleTable').bootstrapTable('getSelections'); // 返回所有选择的行,当没有选择的记录时,返回一个空数组
if (rows.length == 0) {
layer.msg("请选择要删除的数据");
return;
}
layer.confirm("确认要删除选中的'" + rows.length + "'条数据吗?", {
btn : [ '确定', '取消' ]
// 按钮
}, function() {
var ids = new Array();
// 遍历所有选择的行数据,取每条数据对应的ID
$.each(rows, function(i, row) {
ids[i] = row['userId'];
});
$.ajax({
type : 'POST',
data : {
"ids" : ids
},
url : prefix + '/batchRemove',
success : function(r) {
if (r.code == 0) {
layer.msg(r.msg);
reLoad();
} else {
layer.msg(r.msg);
}
}
});
}, function() {
});
}
后台代码:
@RequiresPermissions("sys:user:batchRemove")
@Log("批量删除用户")
@PostMapping("/batchRemove")
@ResponseBody
R batchRemove(@RequestParam("ids[]") Long[] userIds) {
// return R.error("演示系统不允许删除");
List<Long> Ids = Arrays.asList(userIds);
int r = userService.batchremove(Ids);
System.out.println(r);
if (r > 0) {
return R.ok();
}
return R.error();
}
@Transactional
@Override
public int batchremove(List<Long> userIds) {
int count = userMapper.batchRemove(userIds);
userRoleMapper.batchRemoveByUserId(userIds);
return count;
}
@Delete("<script>"+
"delete from sys_user where user_id in "+
"<foreach collection=\"list\" index=\"i\" open=\"(\" separator=\",\" close=\")\" item=\"item\" >#{item}</foreach>"+
"</script>")
int batchRemove(List<Long> list);
@Delete("<script>" + "delete from sys_user_role where user_id in"
+ " <foreach collection=\"list\" index=\"i\" open=\"(\" separator=\",\" close=\")\" item=\"item\" >#{item}</foreach>"
+ "</script>")
int batchRemoveByUserId(List<Long> list);