通用分页

回顾往期的通用分页核心思路

在前期，小王已经发过一次通用分页的核心思路，所以本次就不再重复讲解，如果您没看到的话，请点击这个链接：https://blog.csdn.net/qq_45432593/article/details/106440608 查看详情

分页的三要素

首先，先创建PageBean分页工具类

1. page 页码 视图层传递
2. rows 页大小 视图层传递
3. total 总记录数 后台查出

符合条件的记录数
select count(1) from (select * from t_mvc_book where bname like ‘%斗破%’) t;

分页的查询语句
select * from t_mvc_book where bname like ‘%斗破%’ limit start,offset
start 查询数据集的起始下标
offset：查询展示在当前页的记录

案例解析

1.entity类
创建书籍类

package com.wangcaihua.entity;

import java.io.Serializable;

public class Book implements Serializable {
	
	private int bid;
	private String bname;
	private float price;

	@Override
	public String toString() {
		return "Book [bid=" + bid + ", bname=" + bname + ", price=" + price + "]";
	}

	public Book() {
		
	}
	
	public Book(int bid, String bname, float price) {
	
		this.bid = bid;
		this.bname = bname;
		this.price = price;
	}

	public int getBid() {
		return bid;
	}

	public void setBid(int bid) {
		this.bid = bid;
	}

	public String getBname() {
		return bname;
	}

	public void setBname(String bname) {
		this.bname = bname;
	}

	public float getPrice() {
		return price;
	}

	public void setPrice(float price) {
		this.price = price;
	}

}

2.dao类
第一次查满足条件的总记录数
第二次查指定页码并满足条件的记录
二次查询的条件要一致

package com.wangcaihua.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.wangcaihua.entity.Book;
import com.wangcaihua.uitl.BaseDao;
import com.wangcaihua.uitl.DBAccess;
import com.wangcaihua.uitl.PageBean;
import com.wangcaihua.uitl.StringUtils;

public class BookDao extends BaseDao<Book> {
	public List<Book> list(Book book,PageBean pagebean) throws InstantiationException, IllegalAccessException, SQLException{
		String sql="select * from t_mvc_book where true ";
		   String bname=book.getBname();
		   if(StringUtils.isNotBlank(bname)) {
			   sql += " and bname like '%"+bname+"%'";
		   }
		   return super.executeQuery(sql, Book.class, pagebean);
	}
	
	
     public static void main(String[] args) throws SQLException, InstantiationException, IllegalAccessException {
		BookDao b=new BookDao();
		Book book=new Book();
		PageBean pagebean=new PageBean();
		List<Book> list = b.list(book, pagebean);
		for (Book b1 : list) {
			System.out.println(b1);
			
		}
	}
}

3. 控制层 servlet

package com.wangcaihua.action;

import java.io.IOException;
import java.sql.SQLException;
import java.util.List;

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

import com.wangcaihua.dao.BookDao;
import com.wangcaihua.entity.Book;
import com.wangcaihua.uitl.PageBean;
@WebServlet(name="book",urlPatterns="/book.action")
public class BookAction  extends HttpServlet{

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

4.视图层 pageTag

package com.wangcaihua.tag;

import java.io.IOException;
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.wangcaihua.uitl.PageBean;

public class PageTag  extends BodyTagSupport{

	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;

	private PageBean pageBean;

	public PageBean getPagebBean() {
		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 (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return super.doStartTag();
	}

	private String toHTML() {
		StringBuilder sb=new StringBuilder();
		//上一次查询的form 表单的html拼条
		sb.append(" <form id='pageBeanForm' action='"+pageBean.getUrl()+"' method='post'>");
		//查第几页的数据
		sb.append("<input type='hidden'  name='page'>");
		Map<String, String[]> parameterMap = pageBean.getParameterMap();
		if(parameterMap.size()>0) {
			Set<Entry<String, String[]>> entrySet = parameterMap.entrySet();
			for (Entry<String, String[]> entry : entrySet) {
				if(!"page".equals(entry.getKey())) {
				  for(String val:entry.getValue()) {
					  sb.append("<input type='hidden' value='"+val+"' name='"+entry.getKey()+"'>");
				  }
				}
				
			}
		}
		
		sb.append("</form>");
	
		
		//默认展示前四页，当前页，后面五页
		int page=pageBean.getPage();
		int max=pageBean.getMaxPage();
		int before=page > 4 ? 4 : page-1;
		int after=10-1-before;//5
		after=max-page > after ? after :max-page;
		//用来控制上一页的点击按钮特效的
		boolean startFalg=page>1;
		//用来控制下一页的点击按钮特效的
		boolean endFlag=page<max;
		//分页条
		
		sb.append(" <ul class=\"pagination justify-content-center\">");
//      拼接分页条
      sb.append("<ul class='pagination'>");
      sb.append("<li class='page-item "+(startFalg ? "disabled" : "")+"'><a class='page-link' href='javascript:gotoPage(1)'>首页</a></li>");
      sb.append("<li class='page-item "+(startFalg? "disabled" : "")+"'><a class='page-link' href='javascript:gotoPage("+pageBean.getprevPage()+")'>&lt;</a></li>");

//      代表了当前页的前4页
      for (int i = before; i > 0 ; i--) {
          sb.append("<li class='page-item'><a class='page-link' href='javascript:gotoPage("+(page-i)+")'>"+(page-i)+"</a></li>");
      }

      sb.append("<li class='page-item active'><a class='page-link' href='javascript:gotoPage("+pageBean.getPage()+")'>"+pageBean.getPage()+"</a></li>");

//      代表了当前页的后5页
      for (int i = 1; i <= after; i++) {
          sb.append("<li class='page-item'><a class='page-link' href='javascript:gotoPage("+(page+i)+")'>"+(page+i)+"</a></li>");
      }

      sb.append("<li class='page-item "+(endFlag ? "disabled" : "")+"'><a class='page-link' href='javascript:gotoPage("+pageBean.getNextPage()+")'>&gt;</a></li>");
      sb.append("<li class='page-item "+(endFlag ? "disabled" : "")+"'><a class='page-link' href='javascript:gotoPage("+pageBean.getMaxPage()+")'>尾页</a></li>");
      sb.append("<li class='page-item go-input'><b>到第</b><input class='page-link' type='text' id='skipPage' name='' /><b>页</b></li>");
      sb.append("<li class='page-item go'><a class='page-link' href='javascript:skipPage()'>确定</a></li>");
      sb.append("<li class='page-item'><b>共"+pageBean.getTotal()+"条</b></li>");
      sb.append("</ul>");

//      拼接分页的js代码
      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) > "+max+") {");
      sb.append("alert('请输入1~N的数字');");
      sb.append("return;");
      sb.append("}");
      sb.append("gotoPage(page);");
      sb.append("}");
      sb.append("</script>");

      return sb.toString();
	}
	
}

5.jsp页面布局

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="w" uri="/WEB-INF/wangcaihua.tld" %>
<!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">
<link href="https://cdn.bootcdn.net/ajax/libs/twitter-bootstrap/4.5.0/css/bootstrap.css" rel="stylesheet">
<script src="https://cdn.bootcdn.net/ajax/libs/twitter-bootstrap/4.5.0/js/bootstrap.js"></script>
<title>书籍列表</title>
<style type="text/css">
.page-item input {
	padding: 0;
	width: 40px;
	height: 100%;
	text-align: center;
	margin: 0 6px;
}

.page-item input,
.page-item b {
	line-height: 38px;
	float: left;
	font-weight: 400;
}

.page-item.go-input {
	margin: 0 10px;
}


</style>
</head>
<body>
<form class="form-inline" action="${pageContext.request.contextPath}/book.action" method="post">
  <div class="form-group mb-2">
    <input type="text"  class="form-control-plaintext" name="bname" value="bname" placeholder="请输入书籍名称">
  </div>
  <button type="submit" class="btn btn-primary mb-2">查询</button>
</form>

<table class="table table-striped">
  <thead>
    <tr>
      <th scope="col">书籍ID</th>
      <th scope="col">书籍名称</th>
      <th scope="col">书籍价格</th>
      
    </tr>
  </thead>
  <tbody>
  <c:forEach var="b" items="${booklist }">
  <tr>
      <th>${b.bid }</th>
      <td>${b.bname }</td>
      <td>${b.price }</td>
    </tr>
  </c:forEach>
  </tbody>
</table>
<w:page pageBean="${pageBean}"></w:page>


</body>
</html>

有人觉得html界面样式难调？这时我们可以去 bootcss官网去找样式，方便又省时间，官网的链接已经贴心放下面了：
https://v4.bootcss.com/docs/content/reboot/