7、分页操作

7、分页

思考：为啥要分页

• 减少数据的处理量

7.1、使用Limit分页

语法：SELECT * from user limit startIndex,pageSize
SELECT  * from user limit 3 #[0,n]

使用mybatis实现分页，核心SQL

1.接口

    //分页查询
    List<User> getUserByLimit(Map<String,Integer> map);

2.Mapper.xml

 <select id="getUserByLimit" parameterType="map" resultMap="userMap">
        /* 左闭右开 [startIndex,pageSize)*/
        select * from user limit #{startIndex},#{pageSize}
    </select>

3.测试

    //分页查询
    @Test
    public void getUserByLimit(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);

        Map<String, Integer> map = new HashMap<String, Integer>();
        //左闭右开 [0,2)
        map.put("startIndex",0);
        map.put("pageSize",2);
        List<User> users = mapper.getUserByLimit(map);
        for (User user : users) {
            System.out.println(user);
        }
        sqlSession.close();
    }