使用Mybatis实现分页查询
● 1、接口
//分页查询
List<User> getUserByLimit(Map<String, Integer> map);
● 2、Mapper.xml
<select id="getUserByLimit" resultMap="UserMap" parameterType="map">
select *
from mybatis.user
limit #{
startIndex},#{
pageSize}
</select>
● 3、测试
@Test
public void getUserByLimit() {
SqlSession sqlSession = MybatisUtils.getSqlSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
HashMap<String, Integer> map = new HashMap<>();
map.put("startIndex", 1);
map.put("pageSize", 2);
List<User> userByLimit = mapper.getUserByLimit(map);
for (User user : userByLimit) {
System.out.println(user);
}
sqlSession.close();
}
RowBounds实现分页【了解】
手写分页
dto前端传来的数据,vo后端传给前端的数据
1、建一个dto类接收前端传来的页码和每页有多少数据
package cn.zhy.mybatis_01.dto;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@AllArgsConstructor
@NoArgsConstructor
public class PageInfosDTO {
private Integer pageNum;
private Integer pageSize