mybatis分页

使用Limit分页

语法：SELECT * from user limit startIndex,pageSize;
SELECT * from user limit 3;  #[0,3]
SELECT * from user limit 1,3;  #[每页显示3个从第id为1开始查]

• 接口

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

• Maper.xml

 -<!--//分页-->
<select id="getUserByLimit" parameterType="map" resultMap="UserMap">
    select * from  mybatis.user limit #{startIndex},#{pageSize}
</select>

• 测试

@Test
public void getUserByLimit(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);

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

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

    sqlSession.close();
    }

RowBounds分页(不建议使用)

可以自行百度
不再使用SQL实现分页

分页插件

百度