模糊查找和利用ajax实现批量删除

模糊查找和利用ajax实现批量删除

改写两个findAllUser()方法，将username传过来，并且将sql语句改成模糊查找的形式。

@Override public PageInfo<User> findAllUser(int currentPage,String username) { PageInfo<User> pageInfo=new PageInfo(); pageInfo.setSize(5); int tc=userDao.getTotalCount(username); pageInfo.setTotalCount(tc); int tp=(int) Math.ceil(tc/5.0); pageInfo.setTotalPage(tp); if (currentPage<1){ pageInfo.setCurrentPage(1); }else if (currentPage>tp){ pageInfo.setCurrentPage(tp); }else{ pageInfo.setCurrentPage(currentPage); } int start=(pageInfo.getCurrentPage()-1)*5; List<User> userlist =userDao.findAllUser(start,username); pageInfo.setUserList(userlist); return pageInfo; } @RequestMapping("/findAllUser.do") public ModelAndView findAllUser(@RequestParam (defaultValue="1")int currentPage,String username,@RequestParam(defaultValue = "0")int type,HttpSession session){ //当搜索的时候 if(type==1){ session.setAttribute("searchname",username); }else { username= (String) session.getAttribute("searchname"); } PageInfo<User> pageInfo=userService.findAllUser(currentPage,username); ModelAndView modelAndView=new ModelAndView(); modelAndView.addObject("pageInfo",pageInfo); modelAndView.setViewName("user-list"); return modelAndView; } <select id="findAllUser" parameterType="int" resultType="user"> select * from User <if test="username!=null and username!=''"> WHERE username LIKE concat("%",#{username},"%") </if> limit #{start},5 </select>

在按钮上添加功能并在脚本里添加方法，通过ajax将网页上拿到的userList数据放在data属性里传到后端

<button type="button" class="btn btn-default" title="删除" onclick="deleteAll() "><i class="fa fa-refresh"></i> 删除</button> function deleteAll() { var checkedNum=$("input[name='ids']:checked").length; alert("共"+checkedNum+"条"); if (checkedNum==0) { alert("请至少选择一个进行删除！"); return; } if (confirm("你确认要删除这些用户吗？")){ var userList=new Array(); $("input[name='ids']:checked").each( function () { userList.push($(this).val()) } ); alert("id为："+userList); $.ajax({ type:"post", url: "${pageContext.request.contextPath}/user/deleteAll.do", data:{userList:userList.toString()}, success:function () { alert("删除成功"); location.reload(); }, error:function () { alert("删除失败"); } }) } }

写一个deleteAll()方法处理拿到的id，相应的接口同时也得实现

@RequestMapping("/deleteAll.do") public String deleteAll(String userList){ String[] strs=userList.split(","); List<Integer> ids=new ArrayList<>(); for (String s:strs){ ids.add(Integer.parseInt(s)); } userService.deleteAll(ids); return "redirect:findAllUser.do"; }

在usermapper里加一个用于批量删除的sql语句就行了。

<delete id="deleteAll" parameterType="list"> delete from User where id in <foreach collection="ids" item="id" open="(" close=")" separator=","> #{id} </foreach> </delete>