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; } |