SSM+maven+bootstrap实现分页##
分页是Java WEB项目常用的功能,由于刚学习Java这门语言,做起来有些费劲,在此记录一下,既能帮助我自己,也能帮助像我一样刚入门的程序猿。
使用的框架(MyBatis+SpringMVC+Spring)。
步骤1. 建立分页的工具类 ,在util包下建立一个Page的Java类。
Page类中的代码,复制粘贴即可。
package com.yu.util;
import java.io.Serializable;
public class Page implements Serializable{
private static final long serialVersionUID = -3198048449643774660L;
private int pageNow = 1; // 当前页数
private int pageSize = 6; // 每页显示记录的条数
private int totalCount; // 总的记录条数
private int totalPageCount; // 总的页数
@SuppressWarnings("unused")
private int startPos; // 开始位置,从0开始
@SuppressWarnings("unused")
private boolean hasFirst;// 是否有首页
@SuppressWarnings("unused")
private boolean hasPre;// 是否有前一页
@SuppressWarnings("unused")
private boolean hasNext;// 是否有下一页
@SuppressWarnings("unused")
private boolean hasLast;// 是否有最后一页
/**
* 通过构造函数 传入 总记录数 和 当前页
* @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;
}
/**
* 是否是第一页
* @return
*/
public boolean isHasFirst() {
return (pageNow == 1) ? false : true;
}
public void setHasFirst(boolean hasFirst) {
this.hasFirst = hasFirst;
}
/**
* 是否有首页
* @return
*/
public boolean isHasPre() {
// 如果有首页就有前一页,因为有首页就不是第一页
return isHasFirst() ? true : false;
}
public void setHasPre(boolean hasPre) {
this.hasPre = hasPre;
}
/**
* 是否有下一页
* @return
*/
public boolean isHasNext() {
// 如果有尾页就有下一页,因为有尾页表明不是最后一页
return isHasLast() ? true : false;
}
public void setHasNext(boolean hasNext) {
this.hasNext = hasNext;
}
/**
* 是否有尾页
* @return
*/
public boolean isHasLast() {
// 如果不是最后一页就有尾页
return (pageNow == getTotalCount()) ? false : true;
}
public void setHasLast(boolean hasLast) {
this.hasLast = hasLast;
}
}
有了这个分页的工具类后,首先编写MyBatis的xxxMapper.java接口中的方法和xxxMapper.xml配置文件中的SQL语句,如下:
xxxMapper.java中的代码
package com.yu.dao;
import java.util.List;
import org.apache.ibatis.annotations.Param;
import com.yu.model.UserInfo;
public interface UserInfoMapper {
/**
* 使用注解方式传入多个参数,分页,
* @param page
* @return startPos},#{pageSize}
*/
public List<UserInfo> selectProductsByPage(@Param(value="startPos") Integer startPos,@Param(value="pageSize") Integer pageSize);
/**
* 取得总数量信息,
* @return
*/
public long getProductsCount();
}
xxxMapper.xml中的代码
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.yu.dao.UserInfoMapper">
<resultMap id="userInfoResult" type="com.yu.model.UserInfo">
</resultMap>
<!-- 分页SQL语句 -->
<select id="selectProductsByPage" resultMap="userInfoResult">
select top ${pageSize} * from tiaoma where id not in (select top
${startPos} id from tiaoma)
<!--select top 2 * from tiaoma where id not in (select top
2 id from tiaoma)-->
</select>
<!-- 取得记录的总数 -->
<select id="getProductsCount" resultType="long">
SELECT COUNT(*) FROM tiaoma
</select>
</mapper>
接下来写service层中的方法,调用DAO层,进行业务逻辑的处理,request用来获取前端传入的参数,model用来向JSP页面返回处理结果。
service层的代码
package com.yu.service;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.ui.Model;
import com.yu.dao.UserInfoMapper;
import com.yu.model.UserInfo;
import com.yu.util.Page;
@Service
public class UserInfoService {
@Autowired
private UserInfoMapper mapper;
//分页
public void showProductsByPage(HttpServletRequest request, Model model) {
String pageNow = request.getParameter("pageNow");
System.out.println("pageNow的值"+pageNow);
Page page = null;
List<UserInfo> userInfos = new ArrayList<UserInfo>();
int totalCount = (int) mapper.getProductsCount();
System.out.println("totalCount的值"+totalCount);
if (pageNow != null) {
page = new Page(totalCount, Integer.parseInt(pageNow));
System.out.println("page.getStartPos()的值"+page.getStartPos());
System.out.println("page.getPageSize()的值"+page.getPageSize());
userInfos = this.mapper.selectProductsByPage(page.getStartPos(), page.getPageSize());
} else {
page = new Page(totalCount, 1);
userInfos = this.mapper.selectProductsByPage(page.getStartPos(), page.getPageSize());
}
model.addAttribute("userInfos", userInfos);
model.addAttribute("page", page);
}
}
接下来是controller层的编写,当用户需要跳转到某个页面时,就需要经过这个控制器中相应方法的处理,这个处理过程就是调用业务层的方法来完成,然后返回结果到JSP动态显示,服务器端生成好页面后传给客户端(浏览器)的过程,这就是一个MVC过程。
controller层的代码
package com.yu.controller;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import com.yu.model.UserInfo;
import com.yu.service.UserInfoService;
@Controller
public class UserInfoController {
@Autowired
private UserInfoService service;
/**
* 分页功能
* @param request
* @param model
* @return
*/
@RequestMapping(value = "/myProductPage")
public String showMyProduct(HttpServletRequest request, Model model) {
this.service.showProductsByPage(request, model);
return "userInfo.jsp";
}
}
前台JSP相关代码:
<!-- 分页功能 start -->
<div align="center">
<font size="2">共 ${page.totalPageCount} 页</font> <font size="2">第
${page.pageNow} 页</font> <a href="myProductPage?pageNow=1">首页</a>
<c:choose>
<c:when test="${page.pageNow - 1 > 0}">
<a href="myProductPage?pageNow=${page.pageNow - 1}">上一页</a>
</c:when>
<c:when test="${page.pageNow - 1 <= 0}">
<a href="myProductPage?pageNow=1">上一页</a>
</c:when>
</c:choose>
<c:choose>
<c:when test="${page.totalPageCount==0}">
<a href="myProductPage?pageNow=${page.pageNow}">下一页</a>
</c:when>
<c:when test="${page.pageNow + 1 < page.totalPageCount}">
<a href="myProductPage?pageNow=${page.pageNow + 1}">下一页</a>
</c:when>
<c:when test="${page.pageNow + 1 >= page.totalPageCount}">
<a href="myProductPage?pageNow=${page.totalPageCount}">下一页</a>
</c:when>
</c:choose>
<c:choose>
<c:when test="${page.totalPageCount==0}">
<a href="myProductPage?pageNow=${page.pageNow}">尾页</a>
</c:when>
<c:otherwise>
<a href="myProductPage?pageNow=${page.totalPageCount}">尾页</a>
</c:otherwise>
</c:choose>
</div>
<!-- 分页功能 End -->
最后附上一张运行效果图
注:实际项目中使用GitHub上面大神写的pagehelper插件,分页就两行代码