Mybatis进行分页的实现
1. 2.
public class test01 {
/**
* index:当前页的起始索引
* pageSize:每页显示的条数
* pageNum:当前页的页码
* index=(pageNum-1)*pageSize
*/
@Test
public void tsetPage() throws IOException {
InputStream inputStream=Resources.getResourceAsStream("mybatis-config.xml");
SqlSessionFactoryBuilder sessionFactoryBuilder=new SqlSessionFactoryBuilder();
SqlSessionFactory sessionFactory=sessionFactoryBuilder.build(inputStream);
SqlSession sqlSession=sessionFactory.openSession(true);
EmpMapper empMapper=sqlSession.getMapper(EmpMapper.class);
Page<Object> page=PageHelper.startPage(1,3);
List<Emp> list=empMapper.selectByExample(null);
PageInfo<Emp> pageInfo=new PageInfo<>(list,5);
//list.forEach(emp -> System.out.println(emp));
System.out.println(page);
}
}
经过Mybatis逆向工程生成的实体类需要在类中生成toString的方法,已经构造方法。