Mybatis-分页

为什么要分页？ 减少数据的处理量

1.使用limit分页

select * from user where limit startindex,pagesize;

2.Mybatis里用limit

List<User> getUserByLimit(Map<String,Integer> map);

    <select id="getUserByLimit" parameterType="map" resultType="com.kakafa.pojo.User">
        select * from mybatistest.user limit #{startIndex},#{pageSize};
    </select>

@Test
    public void getUserByLimit(){


        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);//得到一个UserMapper类型的对象

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

        List<User> userList = mapper.getUserByLimit(map);
        for (User user : userList) {
            System.out.println(user);
        }
        //关闭sqlSession
        sqlSession.close();
    }

3.RowBounds分页（了解即可）

4.MyBatis的分页插件（了解即可）

官网链接