ssm框架mysql分页显示_SSM框架实现分页

SSM框架实现分页

1,、首先创建一个分页的工具类

package cn.page.po;

import java.io.Serializable;

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文件

/p>

PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

select *

from user limit #{startPos},#{pageSize}

SELECT COUNT(*) FROM user

3、mapper接口

/**

* 使用注解方式传入多个参数

* @param page

* @return startPos},#{pageSize}

*/

public List selectUserByPage(@Param(value="startPos") Integer startPos,

@Param(value="pageSize") Integer pageSize);

/**

* 用户总数

*/

public long getUserCount();

4、service接口与实现类

void showUserByPage(HttpServletRequest request,Model model);

@Autowired

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 = new ArrayList();

//查询用户总数

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

}

4、controller方法

@Controller

public class UserController {

@Autowired

private UserService userService;

@RequestMapping("/pagingUser.action")

public String pagingUser(HttpServletRequest request,Model model){

userService.showUserByPage(request, model);

return "pagingUser";

}

}

5、页面显示

${user.emplnumb }${user.username }${user.address }${user.telephone }

共 ${page.totalPageCount} 页 第

${page.pageNow} 页 首页

上一页

上一页

下一页

下一页

下一页

尾页

尾页

参考博客：http://blog.csdn.net/zhshulin/article/details/26447713