Mybatis-plugins分页助手实现查询数据分页

1.导入坐标

	<dependency><groupId>com.github.pagehelpergroupId><artifactId>pagehelperartifactId><version>3.7.5version>dependency><dependency>
<groupId>com.github.jsqlparsergroupId><artifactId>jsqlparserartifactId><version>0.9.1version>dependency>

2.在UserMapper（dao）接口中定以findAll方法

public List<User> findAll();

2.在UserMapper.xml中添加sql查询

<select id="findAll" resultType="user">select * from userselect>

3.测试

public class MapperTest {@Testpublic void test1() throws IOException {InputStream stream = Resources.getResourceAsStream("SqlMapConfig.xml");SqlSession sqlSession = new SqlSessionFactoryBuilder().build(stream).openSession();UserMapper mapper = sqlSession.getMapper(UserMapper.class);//        设置分页相关参数PageHelper.startPage(2,3);List<User> list = mapper.findAll();//获得与分页相关的参数PageInfo<User> pageInfo=new PageInfo<User>(list);System.out.println("当前页："+pageInfo.getPageNum());System.out.println("每页显示条数："+pageInfo.getPageSize());System.out.println("总条数："+pageInfo.getTotal());System.out.println("总页数："+pageInfo.getPages());System.out.println("上一页："+pageInfo.getPrePage());System.out.println("下一页："+pageInfo.getNextPage());System.out.println("是否是第一页："+pageInfo.isIsFirstPage());System.out.println("是否是最后一页："+pageInfo.isIsLastPage());for(User user:list){System.out.println(user);}}
}

4.结果