多选删除
function delBlxx(){
var row = $('#blxx_view').datagrid('getSelections');
var ids=[];
for(var i=0;i<row.length;i++){
if(row[i].id != undefined && row[i].id !="undefined")
ids.push(row[i].id);
}
if(row == null){
layer.alert('请选择需要删除的数据!',{icon:0});
return;
}
layer.confirm('确定要删除选中的数据吗?', {
icon:0,
title:'提示',
btn: ['是','否'] //按钮
}, function(index){
$.ajax({
type:"POST",
url:contextPath+'delBlxxInfo',
data:{id:ids.join(",")},
success:function(data){
$('#blxx_view').datagrid('reload');
layer.close(index);
}
})
});
}
controller
@RequestMapping(value = "/delBlxxInfo")
public void delBlxxInfo(HttpServletRequest request, HttpServletResponse response, Model model) throws IOException {
Map<String,Object> retMap = Maps.newHashMap();
retMap.put("result", true);
retMap.put("msg", "删除成功!");
try {
String id[] = request.getParameter("id").split(",");
Map<String,Object> paramMap = new HashMap<String,Object>();
paramMap.put("id", id);
blxxService.deleteBlxxTable(paramMap);
} catch (Exception e) {
retMap.put("result", false);
retMap.put("msg", "删除失败!");
e.printStackTrace();
}
JSONObject obj = JSONObject.fromObject(retMap);
response.setContentType("text/html;charset=utf-8");
response.getWriter().print(obj.toString());
}
多选删除
<select id="deleteBlxxTable">
DELETE FROM CLINIC_CASE_INFO
WHERE id in
<foreach collection="id" index="index" item="item" open="("
separator="," close=")">
#{item}
</foreach>
</select>
//笔记记录