mybatis里面批量删除的使用方法:

//删除

    function fDelete() {

        var usecheckbox;

        var singDel;

        var AllDel ="";

        var delCount= 0;

        <c:forEach items="${pageBean.list}" var="list" varStatus="status">

        usecheckbox = document.all["checkbox" + '${status.index}'];

        if (usecheckbox.checked){

            //singDel="'"+document.all["tbemail"+'${status.index}'].value+"'";

            singDel = document.all["tbemail" + '${status.index}'].value;

            delCount = delCount + 1;

            //组字符串

           if (AllDel == "") {

                AllDel = singDel;

            } else {

                AllDel = AllDel + "," + singDel;

            }

        }

        </c:forEach>

        if (AllDel== "") {

            alert("您没有选择要删除的数据");

            return false;

        }

        document.all["pageBean.pageNo"].value = 0;

        document.all["id"].value = AllDel;

        document.emailBottom.action = "admin/deleteTbemail.do";

        if (confirm("是否进行删除")) {

            document.emailBottom.submit();

        }

    }

 

    //全部选中checkbox

    function fCheckAll() {

        var vIndex;

        var vTopBh =document.emailTop.id.value;

        var objForm= document.emailBottom;

        var length =objForm.elements.length;

        var bChecked= $("#sel_check_all").is(":checked");

        for ( var i = 0; i< length; i++) {

            if (objForm.elements[i].type== "checkbox") {

                if (objForm.elements[i].name!= "checkName") {

                    if (bChecked!= objForm.elements[i].checked) {

                        objForm.elements[i].click();

                        if (vTopBh!= null && vTopBh != "") {

                            if (vTopBh== objForm.elements[i].id) {

                                vIndex = i;

                            }

                        }

                    }

                }

            }

        }

        if (vTopBh== null || vTopBh == "") {

            document.emailTop.reset();

            $("#id").val("");

        } else {

            objForm.elements[vIndex].click();

            objForm.elements[vIndex].click();

        }

    }

<input type=button value="删除所选"

                            class="inputbutton"onclick="fDelete()"></td>

Controller:

    // 删除单个

    @RequestMapping("/deleteTbemail")

    public String deletetbemail(Tbemail tbemail) throws Exception {

        System.out.println(tbemail.getId());

       int i= tbemailService.deleteByPrimaryKey(tbemail.getId());

       return "redirect:findTbemail/1.do";

 

    }

ServiceImpl里面

   @Override

    public int deleteByPrimaryKey(String id) {

       // TODO Auto-generated method stub

       String [] arrIds = id.split(",");

       Map<String, Object> params = new HashMap<String, Object> ();  

       params.put("ids",arrIds);

       return dao.deleteByPrimaryKey(params);

    }

Service:

public int  deleteByPrimaryKey(String id);//删除

mybatis的XML页面:

<delete id="deleteByPrimaryKey"parameterType="java.util.Map">

    delete from tb_email

    where id IN

    <foreach item="tempId" collection="ids"open="(" separator=","close=")">

        #{tempId}

    </foreach>

  </delete>