Controller
@RequestMapping("userList") @ResponseBody public Map<String, Object> getAll(HttpServletRequest request){ int currentPage=Integer.parseInt(request.getParameter("page")); int pageSize=Integer.parseInt(request.getParameter("rows")); int total = userService.getAllRecord(); List<User> list =userService.getAllUser(currentPage,pageSize); Map<String, Object> map=new HashMap<String,Object>(); map.put("total", total); map.put("rows", list); return map; } @RequestMapping("goMymain") public String go(){ return "main"; }
Service
@Override public List<User> getAllUser(int currentPage, int pageSize) { Map<Object,Object> map = new HashMap<>(); map.put("currentPage",(currentPage-1)*pageSize ); map.put("pageSize", pageSize); return userMapper.getAllUser(map); }
Mapper
<select id="getAllRecord" resultType="int"> select count(*) from user </select> <select id="getAllUser" resultType="com.wlc.pojo.User" parameterType="map"> select * from user limit #{currentPage},#{pageSize}