网站上看了别人写的博客,没咋看懂是怎么实现的,后来自己钻研了一下,看了很多文档,写个通俗易懂案例吧,
看代码:
测试方法
main方法里调用传入currentPage当前页
//查询所有留言talk分页
public void selectForListByPage (int currentPage) throws IOException {
SqlSession sqlSession = GetSqlSession.getSqlSession();
TalkMapper mapper = sqlSession.getMapper(TalkMapper.class);
//设置分页的起点和limit显示几条
RowBounds rowBounds = new RowBounds((currentPage - 1) * 2, 2);
List<Talk> talkList = mapper.selectForListByPage(rowBounds);//传入rowBounds 对象即可;
System.out.println(talkList);
if (sqlSession != null) {
sqlSession.close();
}
}
mapper接口:
List<Talk> selectForListByPage (RowBounds rowBounds);//很简单吧
talkmapper.xml接下来xml配置
<select id="selectForListByPage" resultType="com.colin.bean.Talk">
select * from talk
</select>
还没看懂的话,可以留言联系我!!
希望你能学会哦,加油