mybatis配置分页

为什么分页

减少数据的处理量 7.1、limit分页

SELECt *FROM USER LIMIT 2,2

接口UserMapper

    //分页
    public List getUserByLimit(Map map);

配置文件Mapper

    
        select * from user limit #{begin},#{end};
    

方法测试

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

        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        HashMap map = new HashMap();
        map.put("begin",1);
        map.put("end",2);

        List userByLimit = mapper.getUserByLimit(map);

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

        sqlSession.close();
    }

不使用SQL实现分页

1.接口

    public List getUserByRowBounds();

2.Mapper.xml

    
        select *from user
    

3.测试

    @Test
    public void getUserByRowBounds(){

        //RowBounds实现
        RowBounds rowBounds = new RowBounds(1,2);

        SqlSession sqlSession = MybatisUtils.getSqlSession();

        List userList = sqlSession.selectList("com.lin.mapper.UserMapper.getUserByRowBounds", null, rowBounds);

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

        sqlSession.close();
    }