SSM框架下项目的开发当中,对于多条记录的显示,通常会采用分页查询的方法,是页面看起来更方便。这里记录页面的分页查询方法。在IDEA环境下实现。
1.首先创建分页工具类:
public class Page implements Serializable {
private static final long serialVersionUID = -3198048449643774660L;
private int pageNow = 1; // 当前页数
private int pageSize = 4; // 每页显示记录的条数
private int totalCount; // 总的记录条数
private int totalPageCount; // 总的页数
@SuppressWarnings("unused")
private int startPos; // 开始位置,从0开始
/**
* 通过构造函数 传入 总记录数 和 当前页
* @param totalCount
* @param pageNow
*/
public Page(int totalCount, int pageNow) {
this.totalCount = totalCount;
this.pageNow = pageNow;
}
/**
* 取得总页数,总页数=总记录数/每页显示记录的条数
* @return
*/
public int getTotalPageCount() {
totalPageCount = getTotalCount() / getPageSize();
return (totalCount % pageSize == 0) ? totalPageCount //总页数
: totalPageCount + 1;
}
public void setTotalPageCount(int totalPageCount) {
this.totalPageCount = totalPageCount;
}
public int getPageNow() {
return pageNow;
}
public void setPageNow(int pageNow) {
this.pageNow = pageNow;
}
public int getPageSize() {
return pageSize;
}
public void setPageSize(int pageSize) {
this.pageSize = pageSize;
}
public int getTotalCount() {
return totalCount;
}
public void setTotalCount(int totalCount) {
this.totalCount = totalCount;
}
/**
* 取得选择记录的初始位置
* @return
*/
public int getStartPos() {
return (pageNow - 1) * pageSize;
}
public void setStartPos(int startPos) {
this.startPos = startPos;
}
}
2.创建mapper。xml文件
/**
-
用户总数
*/
public long getUserCount();
4.service接口:
private UserMapper userMapper;
@Override
public void showUserByPage(HttpServletRequest request, Model model) {
// TODO Auto-generated method stub
String pageNow = request.getParameter(“pageNow”);Page page = null; List<User> user = new ArrayList<User>();
//查询用户总数
int totalCount = (int) userMapper.getUserCount();if (pageNow != null) { page = new Page(totalCount, Integer.parseInt(pageNow)); user = this.userMapper.selectUserByPage(page.getStartPos(), page.getPageSize()); } else { page = new Page(totalCount, 1); user = this.userMapper.selectUserByPage(page.getStartPos(), page.getPageSize()); } model.addAttribute("user", user); model.addAttribute("page", page);
}
5.controller方法:
public class UserController {
@Autowired
private UserService userService;
@RequestMapping("/pagingUser.action")
public String pagingUser(HttpServletRequest request,Model model){
userService.showUserByPage(request, model);
return “pagingUser”;}
}
之后我们需要完成自己的页面显示功能,基本上就完成了页面分页功能。