tkmapper分页

//分页查询
    int pageNum = 2;
    int pageSize = 10;
    int start = (pageNum-1)*pageSize;

    RowBounds rowBounds = new RowBounds(start,pageSize);
    List<Category> categories = categoryDAO.selectByRowBounds(new Category(), rowBounds);
        for (Category category: categories) {
        System.out.println(category);
    }

    //查询总记录数
    int i = categoryDAO.selectCount(new Category());
        System.out.println(i);


    //带条件分页
    //条件
    Example example = new Example(Category.class);
    Example.Criteria criteria = example.createCriteria();
        criteria.andEqualTo("categoryLevel",1);
    //分页
    int pageNum = 2;
    int pageSize = 3;
    int start = (pageNum-1)*pageSize;
    RowBounds rowBounds = new RowBounds(start,pageSize);

    List<Category> categories = categoryDAO.selectByExampleAndRowBounds(example,rowBounds);
        for (Category category: categories) {
        System.out.println(category);
    }

    //查询总记录数（满足条件）
    int i = categoryDAO.selectCountByExample(example);
        System.out.println(i);