分页

最新推荐文章于 2022-11-10 20:45:08 发布

weixin_42322903

最新推荐文章于 2022-11-10 20:45:08 发布

阅读量700

点赞数 1

本文链接：https://blog.csdn.net/weixin_42322903/article/details/109480882

版权

方法一：SQL语句分页

语法：SELECT * from user limit startIndex,pageSize;
SELECT * from user limit 3;  #[0,n]

方法二：RowBounds分页
定义接口

List<User> getUserByRowBounds();

配置*mapper.xml文件

<select id="getUserByRowBounds" resultMap="UserMap">
    select * from  mybatis.user
</select>

调用RowBounds

@Test
public void getUserByRowBounds(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
//RowBounds实现
RowBounds rowBounds = new RowBounds(1, 2);
//通过Java代码层面实现分页
List<User> userList = sqlSession.selectList("com.kuang.dao.UserMapper.getUserByRowBounds",null,rowBounds);
 for (User user : userList) {
    System.out.println(user);
    }
sqlSession.close();
    }

方法三：调用插件
比如pageHelper