在Controller控制层的代码删除sort的排序
@RequestMapping("pageList") @ResponseBody public Page<List<Map>> pageList(HttpServletRequest request) { Sort sort = null; sort = new Sort(Sort.Direction.DESC,"id"); Integer NowPage = Integer.parseInt(request.getParameter("NowPage")); Pageable Page = PageRequest.of(NowPage-1,5); Page<List<Map>> data = personService.pageAllMap(Page); return data; }
在dao层写入 order by id asc 的排序
@Query(value = "select * from person inner join cname on person.cid = cname.ccid order by id asc ",nativeQuery = true) Page<List<Map>> findAllMap(Pageable pageable);