其他具体代码接上文-》mybatis自定义处理器
1.导入坐标
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>3.7.5</version>
</dependency>
<dependency>
<!-- 解析器-->
<groupId>com.github.jsqlparser</groupId>
<artifactId>jsqlparser</artifactId>
<version>0.9.1</version>
</dependency>
2.在UserMapper(dao)接口中定以findAll方法
public List<User> findAll();
2.在UserMapper.xml中添加sql查询
<select id="findAll" resultType="user">
select * from user
</select>
3.测试
public class MapperTest {
@Test
public 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.结果