批量删除

来源:互联网 发布:尼崎事件 知乎 编辑:程序博客网 时间:2024/06/05 08:47

jsp 

     <a class="btn btn-small btn-danger" onclick="makeAll('确定要删除选中的数据吗?');" title="批量删除" ><i class='icon-trash'></i></a>

    <label><input type="checkbox" id="zcheckbox" /><span class="lbl"></span></label>  //复选框

    <label><input type='checkbox' name='ids' value="${var.id}" /><span class="lbl"></span></label>//复选框Id

js

      function makeAll(msg){
bootbox.confirm(msg,function(result){
if(result){
var str='';
for(var i=0; i<document.getElementsByName('ids').length;i++){
if(document.getElementsByName('ids')[i].check){
if(str==''){ str+=document.getElementsByName('ids')[i].value}
}else{
str+=','+document.getElementsByName('ids')[i].value
}
}if(str==''){
bootbox.dialog("您没有选择任何内容!", 
[
  {
"label" : "关闭",
"class" : "btn-small btn-success",
"callback": function() {
//Example.show("great success");
}
}
 ]
);

$("#zcheckbox").tips({
side:3,
            msg:'点这里全选',
            bg:'#17A099',
            time:8
        });

return;
}else{
if(msg == '确定要删除选中的数据吗?'){
top.jzts();
$.ajax({
type: "POST",
url: '<%=basePath%>lessionCtl/deleteAll.do?tm='+new Date().getTime(),
     data: {id:str},
dataType:'json',
//beforeSend: validateData,
cache: false,
success: function(data){
 $.each(data.list, function(i, list){
 setTimeout("self.location.reload()",100);
 });
}
});
}
}
}
});

java  

        /*
 * / 批量删除
 */
@RequestMapping(value = "deleteAll")
@ResponseBody
public Object deleteAll() {
Map<String, Object> map = new HashMap<String, Object>();
PageData pData = new PageData();
pData=this.getPageData();
try {
List<PageData> pdList = new ArrayList<PageData>();
String ids=pData.getString("id");
if(!ids.equals("")){
String[] id=ids.split(",");
lessionService.deleteAll(id);

 
pData.put("msg", "ok");
}else{
pData.put("msg", "no");
}
pdList.add(pData);
map.put("list", pdList);
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
return map;

}

xml

     <!-- 批量删除 -->
<delete id="deleteAll" parameterType="String">
delete from t_train_lession
where 
id in
<foreach item="item" index="index" collection="array" open="(" separator="," close=")">
                 #{item}
</foreach>
</delete>