MyBatis分页、注解开发

Java 更新时间：2026-04-07 21:44:17 发布时间：1427天前 IT归档最新发布模块sitemap 名妆网法律咨询聚返吧英语巴士网伯小乐网商动力

分页 limit分页：

SELECt * from user limit startIndex,pageSize;

Mybatis分页，基于SQL

1.接口

List getUserByLimit(Map map);

2.mapper

    
        select * from user limit #{startIndex},#{pageSize}

3.测试

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

        UserMapper mapper = sqlSession.getMapper(UserMapper.class);

        HashMap map = new HashMap<>();
        map.put("startIndex", 2);
        map.put("pageSize", 2);

        List userByLimit = mapper.getUserByLimit(map);
        for (User user : userByLimit) {
            System.out.println(user);
        }
        sqlSession.close();
    }

RowBounds分页

不再基于SQL，基于JAVA对象实现
1.接口

List getUserByRowBounce(Map map);

2.mapper