mybatis04分页实现

原创已于 2022-10-09 21:59:55 修改 · 199 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mybatis #java #mysql

于 2022-10-07 14:40:09 首次发布

limit分页实现

第一种（推荐使用）

UserMapper接口类

List<User> getUserListLimit(Map<String,Integer> map);

UserMapper.xml

<!--分页查询-->
<select id="getUserListLimit" parameterType="map" resultMap="UserMap">
    select * from mybatis.user limit #{startIndex},#{pageSize}
</select>

测试类

@Test
public void getLimit(){
    SqlSession sqlSession = MybatisUtils.getSqlSession();
    HashMap<String, Integer> map = new HashMap<>();
    map.put("startIndex",0);
    map.put("pageSize",3);
    UserMapper mapper = sqlSession.getMapper(UserMapper.class);
    List<User> listLimit = mapper.getUserListLimit(map);
    for (User user : listLimit) {
        System.out.println(user);
    }
    sqlSession.close();
}

第二种使用RowBounds

UserMapper接口类

//分页查询2
List<User> getUserListLimit2();

UserMapper.xml

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

测试类

@Test
public void getLimit2(){
    SqlSession sqlSession = MybatisUtils.getSqlSession();
    RowBounds rowBounds = new RowBounds(0, 3);
    List<User> list = sqlSession.selectList("com.ybw.dao.UserMapper.getUserListLimit2",null,rowBounds);
    for (User user : list) {
        System.out.println(user);
    }
    sqlSession.close();
}