mybatis中使用limit实现分页

1.写UserMapper接口

//实现分页查询
List SelectAllUserLimit(Map map);

2.将接口映射到UserMapper.xml中

    select id,name as username,pwd from user limit #{startIndex},#{pageSize};

3.测试，会输出user表中前三条数据

    //实现分页查询
    @Test
    public void selectAllUserLimit(){
        SqlSession sqlSession = ConnectMySQLUtil.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        Map map=new HashMap<>();
        map.put("startIndex",0);
        map.put("pageSize",3);
        List users = mapper.SelectAllUserLimit(map);
        for (User user : users) {
            System.out.println(user);
        }
    }