MyBatis分页

MySQL分页语句：select * fromuser limit startIndex,pageSize

1.      使用map进行分页

A.     Mapper映射文件

<!-- 使用map分页 --> <select id="getUsers" resultType="User" parameterType="Map" >     select * from user_test limit #{startIndex},#{pageSize} </select>

B.     dao中的写法

public List<User> getUsers(intcurrentPage,intpageSize) throws IOException {       SqlSession session = MyBatisUtil.getSqlSession();       Map<String,Integer> map = new HashMap<>();       map.put("startIndex", (currentPage-1)*pageSize);       map.put("pageSize", pageSize);       List<User> list = session.selectList("com.oiios.entity.UserMapper.getUsers", map);       session.close();       returnlist;    }

2.      使用RowBounds进行分页

A.     Mapper映射文件

<!-- 使用RowBounds分页 -->    <select id="getUsers2" resultType="User">       select * from user_test    </select>

B.     dao中的写法

public List<User> getUsers2(intcurrentPage,intpageSize) throws IOException {     SqlSession session = MyBatisUtil.getSqlSession();     RowBounds rowBounds = new RowBounds((currentPage-1)*pageSize, pageSize);     List<User> list = session.selectList("com.oiios.entity.UserMapper.getUsers2",null,rowBounds);     session.close();     returnlist; }