jdbc servlet ssm 实现简单的分页与批量删除

jdbc servlet ssm 实现简单的分页与批量删除

AJAX简介 AJAX = 异步 JavaScript 和 XML。 AJAX 是一种用于创建快速动态网页的技术。 通过在后台与服务器进行少量数据交换，AJAX 可以使网页实现异步更新。这意味着可以在不重新加载整个网页的情况下，对网页的某部分进行更新。

UserMapper中的代码

<select id="search" parameterType="String" resultType="com.wu.bean.User"> select * from tb_user where username like "%"#{username}"%" </select> <delete id="deleteAll" parameterType="list"> delete from tb_user where id in <foreach collection="ids" item="id" open="(" close=")" separator=","> #{id} </foreach> </delete>

UserDao

public interface UserDao { User findUserByUserName(String username); List<User> findAll(@Param("start") int start,@Param("username") String username); void deleteById(int id); void addUser(User user); User selectById(int id); void update(User user); int getTotalCount(@Param("username") String username); List<User> search(String username); void deleteAll(@Param("ids") List<Integer> ids); }

IUserService

public interface IUserService { boolean login(String username,String password); PageInfo<User> findAll(int currentPage,String username); void deleteById(int id); void addUser(User user); User selectUserById(int id); void update(User user); List<User> search(String username); void deleteAll(List<Integer> ids); }

UserController

@Controller @RequestMapping("/user") public class UserController { @Autowired private IUserService userService; @RequestMapping("/login.do") public ModelAndView login(User user, HttpSession session){ boolean flag = userService.login(user.getUsername(), user.getPassword()); ModelAndView modelAndView=new ModelAndView(); if(flag){ session.setAttribute("user",user); modelAndView.setViewName("main"); }else { modelAndView.setViewName("../failer"); } return modelAndView; } @RequestMapping("/findAll.do") public ModelAndView findAll(@RequestParam(defaultValue = "1") int currentPage,String username,HttpSession session,@RequestParam(defaultValue = "0") int type) { 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("/deleteById.do") public String delete(int id){ userService.deleteById(id); return "redirect:findAll.do"; } @RequestMapping("/addUser.do") public String add(User user){ userService.addUser(user); return "redirect:findAll.do"; } @RequestMapping("/toUpdate.do") public ModelAndView toUpdate(int id){ User user=userService.selectUserById(id); ModelAndView modelAndView=new ModelAndView(); modelAndView.addObject("user",user); modelAndView.setViewName("user-update"); return modelAndView; } @RequestMapping("/update") public String update(User user){ userService.update(user); return "redirect:findAll.do"; } @RequestMapping("/search") public ModelAndView search(String username){ List<User> userList=userService.search(username); ModelAndView modelAndView=new ModelAndView(); modelAndView.addObject("userList", userList); modelAndView.setViewName("user-list"); return modelAndView; } @RequestMapping("/deleteAll") 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"; } }

UserService

@Service public class UserService implements IUserService { @Autowired private UserDao userDao; @Override public boolean login(String username, String password) { User user = userDao.findUserByUserName(username); if (user!=null && user.getPassword().equals(password)){ return true; } return false; } @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 deleteById(int id) { userDao.deleteById(id); } @Override public void addUser(User user) { userDao.addUser(user); } @Override public User selectUserById(int id) { return userDao.selectById(id); } @Override public void update(User user) { userDao.update(user); } @Override public List<User> search(String username){ return userDao.search(username); } @Override public void deleteAll(List<Integer> ids) { userDao.deleteAll(ids); } } 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(userList); $.ajax({ type:"post", url:"${pageContext.request.contextPath}/user/deleteAll.do", data:{userList:userList.toString()}, success:function () { alert("删除成功"); location.reload(); }, error:function () { alert("删除失败"); } }); } }