Mybatis之分页

最新推荐文章于 2025-12-13 12:19:21 发布

原创最新推荐文章于 2025-12-13 12:19:21 发布 · 216 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java #sql

SSM框架专栏收录该内容

21 篇文章

订阅专栏

本文介绍了如何在MyBatis中使用LIMIT和RowBounds两种方式实现分页查询。LIMIT方法直接在SQL语句中指定开始位置和每页大小，而RowBounds则通过对象层面实现分页，无需修改SQL。示例代码详细展示了接口、Mapper配置及测试用例的实现过程。

Limit分页

select * from user limit 0,2;

接口:

//分页查询
List<User> getUserByLimit(Map<String,Integer> map);

Mapper:

<select id="getUserByLimit" parameterType="map" resultMap="UserMap">
    select * from mybatis.user limit #{startId},#{pageSize}
</select>

test

@Test
public void getUserByLimit(){
    SqlSession sqlSession = MybatisUtils.getSqlSession();
    UserMapper mapper = sqlSession.getMapper(UserMapper.class);
    HashMap stringIntegerHashMap = new HashMap<String, Integer>();
    stringIntegerHashMap.put("startId",0);
    stringIntegerHashMap.put("pageSize",2);
    List<User> userByLimit = mapper.getUserByLimit(stringIntegerHashMap);
    for (User user : userByLimit) {
        System.out.println(user);
    }
    sqlSession.close();

}

RowBounds分页(了解)

不再使用SQL实现分页

1.接口

List<User> getUserByRowBounds();

2.Mapper.XML

<!--    分页查询-->
<select id="getUserByRowBounds"  resultMap="UserMap">
    select * from mybatis.user
</select>

3.测试

@Test
public void getUserByRowBounds() {
    SqlSession sqlSession = MybatisUtils.getSqlSession();

    //RowRounds实现
    RowBounds rowBounds = new RowBounds(1, 2);

    //通过对象层面实现分页
    List<User> objects = sqlSession.selectList(
            "com.chen.dao.UserMapper.getUserByRowBounds",
            null, rowBounds);
    for (User object : objects) {
        System.out.println(object);
    }
    sqlSession.close();
}