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}   

         

   

页面：

 $(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 dead state of the query button

$("#status").val($("#statushidden").val());

});

function selectAll(){

if ($("#SelectAll").is(":checked")) {

$ (": Checkbox"). Prop ("Checked", TRUE); // Select all the selection boxes

} Else {

                                                                                                                                                                           $(":checkbox").prop(""checked", false); }

##$(function(){

$("#deleteuser").click(function() {

//Check 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!");

                                                                                                                                                alert("Please select at least one item!");

#                                                                                                                                                                 if(confirm("Are you sure to delete the selected item?")){

$ ("INPUT [name = 'creditidbox']: Checked"). );

##                   ); # $.ajax({

type:"POST",

## url:"http://localhost:8080/ssmy2/CreditController /batchDeletes.do",

                                                                                        use with using using ’           through   through   through out through out out through out out through out out out through out out’'s' out’s ’ ’ s ‐ ‐ ‐ ‐ ‐ ‐ n ‐ ​ ​ ​                                   through – – data:{"creditIdbox":checkedList.toString()},

##                                            . success:function(data){

                                                                                      $("[name='creditIdbox']:checkbox").attr("checked",false);

Alert ('Delete success!');

## stettimeout ("local

##                                                                                                                                          

#                                                                                                                                  /* 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");

## 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();

## });

});

##

     

     

        登录名:

       

       身份证: 

       

                提交状态:  

               

           全部

           已提交

           未提交

       

         

         

        

       

>

# & 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 ListCredit> batchDeletes(HttpServletRequest request,HttpServletResponse response){ String items = request.getParameter("creditIdbox"); ListString> delList = new ArrayListString>(); String[] strs = items.split(","); for (String str : strs) { delList.add(str); } creditService.batchDeletes(delList); ListCredit> 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

Login name

Login password

Confirm password

ID card No.

Landline number

Mobile phone number

E-mail address

Residential address

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.

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!