分页的实现的几种方法

数据量太大的时候为了减少数据的处理量

SELECt * FROM ljqdb.`user` LIMIT num1,num2;

从num1开始查 查num2个
num1=startIndex  num2=Pagesize

Mapper.xml的编写 

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

 Mapper以及测试类的编写

    List getUserByLimit(Map map);


测试类:
 SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        Map map = new HashMap<>();
        map.put("startIndex",1);
        map.put("pageSize",3);
        List userByLimit = mapper.getUserByLimit(map);
        for (User user : userByLimit) {
            System.out.println(user);
        }
        sqlSession.close();

UserMapper的编写

    List getUserByRowBrunds();

UserMapper.xml的编写

 
        select * from ljqdb.user
    

测试类的编写

public void gerUserByRowBounds(){

        SqlSession sqlSession = MybatisUtils.getSqlSession();
        RowBounds rowBounds = new RowBounds(1, 4);
        List userList = sqlSession.selectList("dao.UserMapper.getUserByRowBrunds", null, rowBounds);
        for (User user : userList ) {
            System.out.println(user);
        }

        sqlSession.close();

    }

MyBatis 分页插件 PageHelperhttps://pagehelper.github.io/