通用分页（二）

BK_201H

于 2019-07-22 06:50:51 发布

阅读量88

点赞数

分类专栏：通用分页

本文链接：https://blog.csdn.net/qq_45105634/article/details/96809738

版权

通用分页专栏收录该内容

2 篇文章 0 订阅

订阅专栏

通用分页核心思路
将上一次查询请求再发一次，只不过页码变了

如何将斗破查询关键字传到下一次请求？
将查询参数保存到pagebean中
Map paramMap 存储参数键值对

如何将上一次查询请求再发一次
在pagebean定义一个属性存放上一次的请求

继通用分页(一)的工程

1. PageBean
分页三要素
page 页码视图层传递过来
rows 页大小视图层传递过来
total 总记录数后台查出来

pagination 是否分页视图层传递过来
PageBean类

package com.BK_201.util;
//分页工具类

import java.util.HashMap;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;

public class PageBean {
	private int page = 1;// 页数
	private int rows = 10;// 每页的条数
	private int total = 0;// 总数
	// 保留上一次的请求地址
	private String url;
	// 保留上一次请求所携带的参数
	private Map<String, String[]> map = new HashMap<>();

	public void setRequest(HttpServletRequest req) {
		this.setPage(req.getParameter("page"));
		this.setRows(req.getParameter("rows"));
		this.setPagination(req.getParameter("pagination"));
		
		this.setUrl(req.getRequestURL().toString());
		this.setMap(req.getParameterMap());
	}
	
	public void setPagination(String pagination) {
		if("false".equals(pagination)) {
			this.setPagination(false);
		}
	}

	public void setRows(String rows) {
		if(StringUtils.isNotBlank(rows)) {
			this.setRows(Integer.valueOf(rows));
		}
	}
	
	public void setPage(String page) {
		if (StringUtils.isNotBlank(page)) {
			this.setPage(Integer.valueOf(page));
		}
	}

	public String getUrl() {
		return url;
	}

	public void setUrl(String url) {
		this.url = url;
	}

	public Map<String, String[]> getMap() {
		return map;
	}

	public void setMap(Map<String, String[]> map) {
		this.map = map;
	}

	private boolean pagination = true;// 是否分页

	public PageBean() {
		super();
	}

	public int getPage() {
		return page;
	}

	public void setPage(int page) {
		this.page = page;
	}

	public int getRows() {
		return rows;
	}

	public void setRows(int rows) {
		this.rows = rows;
	}

	public int getTotal() {
		return total;
	}

	public void setTotal(int total) {
		this.total = total;
	}

	public void setTotal(String total) {
		this.total = Integer.parseInt(total);
	}

	public boolean isPagination() {
		return pagination;
	}

	public void setPagination(boolean pagination) {
		this.pagination = pagination;
	}

	// 获得起始下标
	public int getStartIndex() {
		return (this.page - 1) * this.rows;
	}

	@Override
	public String toString() {
		return "PageBean [page=" + page + ", rows=" + rows + ", total=" + total + ", pagination=" + pagination + "]";
	}
	//获取最大页码
	public int getMaxPage() {
		return this.total % this.rows==0? this.total/this.rows:this.total/this.rows+1;
	}
	//获取下一页
	public int getNextPage() {
		return this.page<this.getMaxPage()? this.page+1 : this.page;
	}
	//获取上一页
	public int getPreviousPage() {
		return this.page>1? this.page-1 : this.page;
	}
	

}

2. 后台
2.1 entity
2.2 dao
第一次查满足条件的总记录数
第二次查指定页码并满足条件的记录
二次查询的条件要一致
2.3 控制层
Servlet
BookServlet 类

package com.BK_201.web;
import java.io.IOException;
import java.sql.SQLException;
import java.util.List;
import java.util.Map;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.BK_201.dao.BookDao;
import com.BK_201.entity.Book;
import com.BK_201.util.PageBean;


public class BookServlet extends HttpServlet {

	/**
	 * 
	 */
	private static final long serialVersionUID = 1059722281226538304L;
	/**
	 * 
	 */
	private BookDao bookDao=new BookDao();
	
	@Override
	protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		doPost(req, resp);
	}
	
	@Override
	protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		String bname= req.getParameter("bname");
		Book book=new Book();
		book.setBname(bname);
		PageBean pageBean=new PageBean();
		
		
		try {
    		List<Book> list=bookDao.list(book, pageBean);
    		req.setAttribute("bookList", list);
    		req.setAttribute("pageBean", pageBean);
    		req.getRequestDispatcher("/bookList.jsp").forward(req, resp);
    	} catch (SQLException | InstantiationException | IllegalAccessException e) {
    		// TODO Auto-generated catch block
    		e.printStackTrace();
    	}
    }
	}

主页代码
bookList.jsp

<%@ page language="java" contentType="text/html; charset=utf-8"
	pageEncoding="utf-8"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@taglib uri="/BK_201" prefix="z"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>
	<h2>小说目录</h2>
	<br>

	<form
		action="${pageContext.request.contextPath}/bookServlet"
		method="post">
		<input type="hidden" name="rows" value="20">
		书名：<input type="text" name="bname"> 
		<!-- 书籍类别<input type="checkbox" name="bookType" value="1">玄幻
		<input type="checkbox" name="bookType" value="2">都市
		<input type="checkbox" name="bookType" value="3">悬疑 -->
		<input type="submit" value="确定">
	</form>
	<table border="1" width="100%">
		<tr>
			<td>编号</td>
			<td>名称</td>
			<td>价格</td>
		</tr>
		<c:forEach items="${bookList }" var="b">
			<tr>
				<td>${b.bid }</td>
				<td>${b.bname }</td>
				<td>${b.price }</td>
			</tr>
		</c:forEach>
	</table>
	<z:page pageBean="${pageBean}"></z:page>
	
	
	
<%-- 	${pageBean }
 --%>
 
	
</body>
</html>

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" id="WebApp_ID" version="3.1">
   <display-name>page</display-name>
  <filter>
  <filter-name>encodingFiter</filter-name>
  <filter-class>com.BK_201.util.EncodingFiter</filter-class>
  </filter>
  <filter-mapping>
  <filter-name>encodingFiter</filter-name>
  <url-pattern>/*</url-pattern>
  </filter-mapping>
  <servlet>
  <servlet-name>bookServlet</servlet-name>
  <servlet-class>com.BK_201.web.BookServlet</servlet-class>
  </servlet>
  <servlet-mapping>
  <servlet-name>bookServlet</servlet-name>
  <url-pattern>/bookServlet</url-pattern>
  </servlet-mapping>
</web-app>

z.tld自定义标签

<?xml version="1.0" encoding="UTF-8" ?>

<taglib xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-jsptaglibrary_2_0.xsd"
	version="2.0">

	<description>BK_201 1.1 core library</description>
	<display-name>BK_201 core</display-name>
	<tlib-version>1.1</tlib-version>
	<short-name>c</short-name>
	<uri>/BK_201</uri>

	<tag>
		<!-- 标签库中的标签名 -->
		<name>page</name>
		<!-- 标签对应的后台助手类 -->
		<tag-class>com.BK_201.tag.PageTag</tag-class>
		<!-- 标签类别 -->
		<body-content>JSP</body-content>
		<attribute>
			<!-- 自定义标签携带的属性 -->
			<name>pageBean</name>
			<!-- 属性值是否必填 -->
			<required>true</required>
			<!-- 是否支持表达式（EL/ognl） -->
			<rtexprvalue>true</rtexprvalue>
		</attribute>
	</tag>


</taglib>

3. 视图层
PageTag

package com.BK_201.tag;

import java.util.Map;
import java.util.Map.Entry;
import java.util.Set;

import javax.servlet.jsp.JspException;
import javax.servlet.jsp.JspWriter;
import javax.servlet.jsp.tagext.BodyTagSupport;

import com.BK_201.util.PageBean;
import com.sun.org.apache.xml.internal.serializer.ToHTMLStream;

public class PageTag extends BodyTagSupport {

	/**
	 * 
	 */
	private static final long serialVersionUID = -7662435905410916559L;
	
	private PageBean pageBean;

	public PageBean getPageBean() {
		return pageBean;
	}

	public void setPageBean(PageBean pageBean) {
		this.pageBean = pageBean;
	};

	@Override
	public int doStartTag() throws JspException {
		JspWriter out = pageContext.getOut();
		try {
			out.print(toHTML());
		} catch (Exception e) {
			e.printStackTrace();
		}
		return SKIP_BODY;
	}

	private String toHTML() {
		StringBuilder sb = new StringBuilder();

		// 拼接下一次分页请求所提交的分页表单
		sb.append("<form id='pageBeanForm' action='" + pageBean.getUrl() + "' method='post'>");
		sb.append("<input type='hidden' name='page'>");
		Map<String, String[]> map = pageBean.getMap();
		if (map != null && map.size() > 0) {
			Set<Entry<String, String[]>> entrySet = map.entrySet();
			for (Entry<String, String[]> entry : entrySet) {
				for (String value : entry.getValue()) {
					sb.append("<input type='hidden' name='" + entry.getKey() + "' value='" + value + "'>");
				}
			}
		}
		sb.append("</form>");
		
		// 拼接分页条
		sb.append("<div style='text-align: right; font-size:" + "12px;'>");
		sb.append("每页"+pageBean.getRows()+"条，共"+pageBean.getTotal()+"条，第"+pageBean.getPage()+"页，共"+pageBean.getMaxPage()+"页 "+ "&nbsp;&nbsp;<a");
		sb.append(" href='javascript:gotoPage(1)'>首页</a>&nbsp;&nbsp;<a");
		sb.append(" href='javascript:gotoPage("+pageBean.getPreviousPage()+")'>上一页</a>&nbsp;&nbsp;<a");
		sb.append(" href='javascript:gotoPage("+pageBean.getNextPage()+")'>下一页</a>&nbsp;&nbsp;<a");
		sb.append(" href='javascript:gotoPage("+pageBean.getMaxPage()+")'>尾页</a>&nbsp;&nbsp;<input type='text'");
		sb.append(" id='skipPage'");
		sb.append(" style='text-align: center; font-size: 12px; width: 50px;'>&nbsp;&nbsp;<a");
		sb.append(" href='javascript:skipPage()'>Go</a>");
		sb.append("</div>");
		
		// 拼接分页的javascript代码
		sb.append("<script type='text/javascript'>");
		sb.append(" function gotoPage(page) {");
		sb.append("		document.getElementById('pageBeanForm').page.value = page;");
		sb.append("		document.getElementById('pageBeanForm').submit();");
		sb.append("}");
		sb.append(" function skipPage() {");
		sb.append(" 	var page =document.getElementById('skipPage').value;");
		sb.append("		if(!page || isNaN(page) || parseInt(page)<1 || parseInt(page)>"+pageBean.getMaxPage()+"){");
		sb.append(" 		alert('请输入1~N的数字');");
		sb.append("			return;");
		sb.append("}");
		sb.append("		gotoPage(page);");
		sb.append("}");
		sb.append("</script>");
		return sb.toString();
	}

}