SSM学习日记四，模糊查找+批量删除

SSM学习日记四，模糊查找+批量删除

继之前，加入了模糊查找和批量删除功能 Mapper.xml

<select id="getTotalCount" resultType="int"> select count(*) from db_user <if test="username!=null and username!=''"> where username like concat("%",#{username},"%") </if> </select> <delete id="deleteAll" parameterType="list"> delete from db_user where id in <foreach collection="ids" item="id" open="(" close=")" separator=","> #{id} </foreach> </delete>

Control,改写了原先的findAll，新加了deleteAll

@RequestMapping("/findAll.do") public ModelAndView findAll(@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.findAll(currentPage,username); ModelAndView modelAndView=new ModelAndView(); modelAndView.addObject("pageInfo", pageInfo); modelAndView.setViewName("user-list"); return modelAndView; } @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:findAll.do"; }

Service

@Override public PageInfo<User> findAll(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.findAll(start,username); pageInfo.setList(userList); return pageInfo; } @Override public void deleteAll(List<Integer> ids) { userDao.deleteAll(ids); }

UserDao和IUserService

public interface UserDao { User findUserByUserName(String username); List<User> findAll(@Param("start") int start,@Param("username") String username); void deleteById(int id); void add(User user); User selectUserById(int id); void update(User user); int getTotalCount(@Param("username") String username); void deleteAll(@Param("ids") List<Integer> ids); } public interface IUserService { boolean login(String username,String password); PageInfo<User> findAll(int currentPage,String username); void deleteById(int id); void add(User user); User selectUserById(int id); void update(User user); void deleteAll(List<Integer> ids); }

jsp

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