mybatis_分页

1、使用limit分页

A、在接口中加入方法

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

B、在mapper.xml写SQL

<select id="getUserByLimit" parameterType="map" resultType="user1">
    select *from mybatis.user limit #{startIndex},#{pageSize}
</select>

C、测试代码

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

    UserMapper mapper = sqlSession.getMapper(UserMapper.class);
    HashMap<String, Object> map = new HashMap<String, Object>();
    map.put("startIndex",2);
    map.put("pageSize",2);
    List<User> userByLimit = mapper.getUserByLimit(map);
    for (User user : userByLimit) {
        System.out.println(user);
    }

    sqlSession.close();
}

2、RowBounds分页

A、 在接口中加入方法

List<User> getUserByRowBounds();

B、在mapper.xml写SQL

<select id="getUserByRowBounds" resultType="user1">
    select *from mybatis.user
</select>

C、测试代码

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

    RowBounds rowBounds = new RowBounds(2,2);
    //通过Java代码层面分页
    List<User> userList = sqlSession.selectList("com.xiao.dao.UserMapper.getUserByRowBounds",null,rowBounds);
    for (User user : userList) {
        System.out.println(user);
    }

    sqlSession.close();
}

3、插件分页

链接：MyBatis 分页插件 PageHelper