mybatis springmvc batch deletion code sharing

service层：

 

@Override

public void batchDeletes(List list) {

creditDao.batchDeletes(list);

 

}

控制层controller:

 

/**
* Batch deletion batch
*/
   @RequestMapping(value="/batchDeletes")
   @ResponseBody
   public List batchDeletes(HttpServletRequest request,HttpServletResponse response){
       String items = request.getParameter("creditIdbox");
       List delList = new ArrayList();
       String[] strs = items.split(",");
       for (String str : strs) {
           delList.add(str);
       }
       creditService.batchDeletes(delList);
       List list=creditService.queryUserInfo(null);
      ModelAndView mv = new ModelAndView();
      Map model = new HashMap();
      model.put("creditVOList", list);
      mv.addAllObjects(model);
      mv.setViewName("queryregister");
      return list;
   }

mapper.xml:

   

            DELETE FROM t_credit where t_credit_id in

          

            #{item}   

         

   

页面：

##

     

     

        登录名:

       

       身份证: 

       

                提交状态:  

               

           全部

           已提交

           未提交

       

         

         

        

       

# & LT; input Type = "Hidden" name = "Status" ID = "Statushidden" Value = "$ {Status}" /& gt;

#                                                                                                                                                                                                                                                                                     "0" cellpadding=0

#                                                                                                                                    ="margin-right:5px;"/>Select all

                                                                                                                                                                                                                                              #                                                                                                                                              Land-line number

## td > Email address "address">Submission status

##                                                                                                                          td >Operation

##            

##                                                      "${creditVOList}" varStatus="status">

           

                                                                                                                 ##                                                                                                                                          

                                                                                                                 

## & LT; TD & GT; $ {Credit.telephonumber} & lt;/td & gt;

# & LT; TD & GT; $ {Credit.email}

##                                                                  

           ${credit.status ==0 ? '已提交':'未提交'}

           ${creditVO.createtime}

           

       

         删除

           

           

           

 

     

     没有任何员工信息.

   

     

     

     

     

         

 

 

 

service层：@Override public void batchDeletes(List list) { creditDao.batchDeletes(list); } 控制层controller/** * Delete batch batch*/ @RequestMapping(value="/batchDeletes") @ResponseBody public List<Credit> batchDeletes(HttpServletRequest request,HttpServletResponse response){ String items = request.getParameter("creditIdbox"); List<String> delList = new ArrayList<String>(); String[] strs = items.split(","); for (String str : strs) { delList.add(str); } creditService.batchDeletes(delList); List<Credit> list=creditService.queryUserInfo(null); ModelAndView mv = new ModelAndView(); Map model = new HashMap(); model.put("creditVOList", list); mv.addAllObjects(model); mv.setViewName("queryregister"); return list; }mapper.xml <delete id="batchDeletes" parameterType="java.util.List"> DELETE FROM t_credit where t_credit_id in <foreach collection="list" index="index" item="item" open="(" separator="," close=")"> #{item} foreach> delete>页面：<script type="text/javascript" src="../jquery/jquery-2.1.3.js">script><script type="text/javascript" src="../easyui/jquery.easyui.min.js">script><script type="text/javascript" src="../easyui/locale/easyui-lang-zh_CN.js" >script><script type="text/javascript" src="../easyui/js/index.js">script><link rel="stylesheet" type="text/css" href="../easyui/themes/default/easyui.css" /><link rel="stylesheet" type="text/css" href="../easyui/themes/icon.css" /><script type="text/javascript" > $(function(){ $("#button").click(function(){ var form=$("#registerform"); form.prop("action","http://localhost:8080/ssmy2/CreditController/intiqu.do"); form.submit(); }); //Method 2: /*$(function(){ $("#button").click(function(){ document.registerform.action="http://localhost:8080/ssmy /CreditController/intiqu.do"; document.registerform.submit(); });**/ //Determine the status of the query button $("#status").val($("#statushidden").val( )); }); function selectAll(){ if ($("#SelectAll").is(":checked")) { $( ":checkbox").prop("checked", true);//All selection boxes are checked } else { $(":checkbox").prop("checked" , false); } } $(function(){ $("#deleteuser").click(function(){ //Judge that at least one item has been written var checkedNum = $("input[name='creditIdbox']:checked").length; console.log (checkedNum); if(checkedNum==0){ alert("Please select at least one item!"); return false; } if(confirm("Are you sure you want to delete the selected item?")){ var checkedList = new Array(); $("input[name= 'creditIdbox']:checked").each(function(){ checkedList.push($(this).val()); }); console.log(checkedList[0]); $.ajax({ type:"POST", url:"http://localhost:8080/ssmy2/CreditController/batchDeletes.do", data:{"creditIdbox":checkedList.toString()}, datatype:"json", success:function(data){ $("[name='creditIdbox']:checkbox").attr("checked",false); alert('删除成功!'); setTimeout("location.reload()",1000);//页面刷新 }, error:function(data){ alert('删除失败!'); } }); } /* var form=$("#registerform"); form.prop("action","http://localhost:8080/ssmy/CreditController/deleteuser.do"); form.submit(); */ }); $("#exports").click(function(){ var form =$("#registerform"); form.prop("action","http://localhost:8080/ssmy2/CreditController/exprotExcel.do"); form.submit(); }); $("#delete").click(function(){ var form =$("#registerform"); form.prop("action","http://localhost:8080/ssmy2/CreditController/batchDeletes.do?creditIdbox=${credit.creditId}"); form.submit(); }); $("#uploadFile").click(function(){ var form =$("#registerform"); form.prop("action","http://localhost:8080/ssmy2/CreditController/uploadFile.do"); form.submit(); }); }); script>head><body><div id="head"> <form id="registerform" name ="registerform" action="" method="post" enctype="multipart/form-data"> <div class="search-box" style="width:100%;height:40px;"> <label> 登录名: label> <input type="text" name="loginName" id="loginName"/> <label style= "margin-left:10px;">ID card:< ;/label> <input type="text" name=" IDCard" id="IDCard" /> <label style="margin-left:10px;"> Submission status:< /label> <select id="status" name="status" style="width:100px;height:20px;"> <option value="">全部option> <option value="0">已提交option> <option value="1">未提交option> select> <input type="button" id="button" value="查询" style="width:65px;height:22px;margin-left:20px;"/> <input type="submit" id="exports" value="导出" style="width:65px;height:22px;margin-left:20px;"/>

Select all < c:forEach var="credit" items="${creditVOList}" varStatus="status">

Login name

Login password

Confirm password

ID card No.

Landline number

Mobile phone number

E-mail address

Residential address< /td>

Submit status

Creation time

Operation

${status.index}

${credit.loginName}

${credit.loginPwd}

${credit.againPwd}

${credit.IDCard}

${credit.fixedTelephoneNumber}

${credit.telephoneNumber}

${credit.email}

${credit.address}

${credit.status ==0 ? 'Submitted':'Not submitted'}

${ creditVO.createtime}

Delete

None Employee information.
< div id="box" style="border: 1px solid #ccc;">

The above is the detailed content of mybatis springmvc batch deletion code sharing. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn