基于JavaWeb的旅游项目--分类分页功能

---

---

1、分类功能—界面展示

2、分类分页的后台代码

RouteServiceTest.java

(src\main\test\service)

 @Test
    public void test02() throws JsonProcessingException {
   
        //业务对象
        RouteService  routeService = new RouteService();
        //根据指定分类 cid 1 查找路线，但是路线记录需要使用分页来显示 currentPage1  pageSize20
        PageBean pb = routeService.findPageByCid(1,1,20);
        //生成json
        ResponseInfo responseInfo = new ResponseInfo();
        responseInfo.setCode(200);
        responseInfo.setData(pb);
        String json = new ObjectMapper().writeValueAsString(responseInfo);
        System.out.println(json);
    }

RouteService.java

(src\main\java\service)

 public PageBean findPageByCid(int cid, int currentPage, int pageSize) {
   
        //给pageBean的四个整数与一个集合 查找值
        PageBean pb = new PageBean();
        //设置当前页号
        pb.setCurrentPage(currentPage);//1*
        //设置每页记录数
        pb.setPageSize(pageSize);//2
        //设置总记录数
        RouteDao routeDao = MySessionUtils2.getMapper(RouteDao.class);

        int totalCount = routeDao.findCountByCid(cid);
        pb.setTotalCount(totalCount);//3*

        int totalPage = totalCount % pageSize == 0 ? totalCount / pageSize : totalCount / pageSize + 1;
        pb.setTotalPage(totalPage);//4*

        int start = (currentPage - 1) * pageSize;
        List<Route> list = routeDao.findPageByCid(cid, start, pageSize);
        pb.setList(list);//集合
        return pb;
    }

RouteDao.java

(src\main\java\dao)

  //select count(*) from tab_route where cid = 1;
    int findCountByCid(int cid);

    //select * from tab_route where cid = 5 limit 40,20;
    List<Route> findPageByCid(int cid, int start,