mybatis的分页方式(mybatisplus自定义分页查询)

#语法 
SELECt * FROM table LIMIT stratIndex，pageSize 
SELECt * FROM table LIMIT 5,10; // 检索记录行 6-15
SELECt * FROM table LIMIT 5; // 相当于【0,5】

    List getUser(Map map);

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

    @Test
    public void test(){

        SqlSession sqlSession = MybatisUtils.getSqlSession();

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

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

        List userList = mapper.getUser(map);

        for (User user : userList) {
            System.out.println(user);
        }

        sqlSession.close();
    }

    List getUserByrowbounds();

    
        select * from user
    

    @Test
    public void test(){

        SqlSession sqlSession = MybatisUtils.getSqlSession();

        List userList = sqlSession.selectList("com.jia.mapper.UserMapper.getUserByRowBounds",null,new RowBounds(0,3));

        for (User user : userList) {
            System.out.println(user);
        }

        sqlSession.close();
    }

MyBatis 分页插件 PageHelper