Tbcategory tb=new Tbcategory ();
Criteria criteria= tb.createCriteria()
criteria.andparentidEqualto(parentid);
List<tb> tbs=criteria.selectbyexample(criteria);
select * from tb where parentid =parentid;
TbItemExample example = new TbItemExample();
//在查询之前,必须先设置分页
PageHelper.startPage(page, rows);
//执行查询,自动分页查询,自动生成limit,count
List<TbItem> list = tbItemMapper.selectByExample(example);
//select * from tb limit 1,10
//创建PageINfo对象,封装分页数据 有参构造PageInfo<TbItem> pageInfo = new PageInfo<TbItem>(list);
//创建分页返回值包装类对象
PageBeanResult result=new PageBeanResult();
result.setTotal(pageInfo.getTotal());
result.setRows(list);