通过上次通用分页_1,我们写了BookDao为线索,这次我们在写一个类来继承HttpServlet,调用BookDao,
如下代码:
package com.ly.web;
import java.io.IOException;
import java.sql.SQLException;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.ly.dao.BookDao;
import com.ly.entity.Book;
import com.ly.util.PageBean;
public class BookServlet extends HttpServlet {
private BookDao bookDao = new BookDao();
private static final long serialVersionUID = -4869970056358215491L;
@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 (InstantiationException e) {
e.printStackTrace();
} catch (IllegalAccessException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
再写一个前台页;
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!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="text" name="bname"> <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>
<form id='pageBeanForm' action='' method='post'>
<input type='hidden' name=''> <input type='hidden' name='page'>
</form>
<div style='text-align: right; font-size: 12px;'>
每页N条,共N条,第N页,共N页 <a href='javascript:gotoPage(?)'>首页</a> <a
href='javascript:gotoPage(?)'>上一页</a> <a
href='javascript:gotoPage(?)'>下一页</a> <a
href='javascript:gotoPage(?)'>尾页</a> <input type='text'
id='skipPage'
style='text-align: center; font-size: 12px; width: 50px;'> <a
href='javascript:skipPage()'>Go</a>
</div>
<script type='text/javascript'>
function gotoPage(page) {
document.getElementById('pageBeanForm').page.value = page;
document.getElementById('pageBeanForm').submit();
}
function skipPage() {
var page = document.getElementById('skipPage').value;
if(!page || isNaN(page) || parseInt(page)<1 || parseInt(page)>maxPage){
alert('请输入1~N的数字');
return;
}
gotoPage(page);
}
</script>
</body>
</html>
这时候,我们就可以看到一个基本完整的数据表了,因此实现查询分页功能,探究其思路,方法。
在这里,我们首先要解决的第一个问题就是,第一页查询出想要的数据了,那第二页,第三页等如何继续展示想要的同样的资料呢?
首先我们明确:通用分页核心思路
将上一次查询请求再发一次,只不过页码变了
由于最优解决问题,我们这里是将参数查询关键字传到下一次请求,可以通过将查询参数保存到我们的pagebean中,
那又如何去将其接受定义呢?
例如,传过来的可能是一个参数或者数组,
这时候,我们就可以通过Map集合来解决了,paramMap存储参数键值对。
如何将上一次查询请求再发一次?
在pagebean定义一个属性存放上一次的请求
package com.ly.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 boolean pagination = true;// 是否分页
private String url;
private Map<String, String[]> paramMap = new HashMap<>();
public void setRequest(HttpServletRequest req) {
this.setPage(req.getParameter("page"));
this.setRows(req.getParameter("rows"));
this.setPagination(req.getParameter("pagination"));
// getRequestURL获取到浏览器请求的全路径
this.setUrl(req.getRequestURL().toString());
// getParameterMap可以获取到一次url请求所携带的所有参数
this.setParamMap(req.getParameterMap());
}
public void setPagination(String pagination) {
if (StringUtils.isNotBlank(pagination)) {
this.setPagination(!"false".equals(pagination));
}
}
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 PageBean() {
super();
}
public String getUrl() {
return url;
}
public void setUrl(String url) {
this.url = url;
}
public Map<String, String[]> getParamMap() {
return paramMap;
}
public void setParamMap(Map<String, String[]> paramMap) {
this.paramMap = paramMap;
}
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;
}
/**
* 获得起始记录的下标
*
* @return
*/
public int getStartIndex() {
return (this.page - 1) * this.rows;
}
@Override
public String toString() {
return "PageBean [page=" + page + ", rows=" + rows + ", total=" + total + ", pagination=" + pagination + "]";
}
/**
* 获取到总页数
* @return
*/
public int getMaxPage() {
return this.total % this.rows == 0 ?
this.total / this.rows :
(this.total / this.rows) + 1;
}
/**
* 获取下一页页码
* @return
*/
public int getNextPage() {
return this.page < this.getMaxPage() ? this.page+1 : this.page;
}
/**
* 获取上一页页码
* @return
*/
public int getPreviousPage() {
return this.page > 1 ? this.page-1 : this.page;
}
}
在属性里面,我们写了页数,行数,是否分页方法,接受URL
怎么接收URL?
String contextPath = req.getContextPath();//根目录
String url = req.getServletPath();//请求的地址
req.getRequestURL() //获取请求全路径
Map<String, String[]> parameterMap = req.getParameterMap();//获得请求中的所有参数
属性改造完毕,我们还要求其最大页数
用总数%rows
获取上一页 下一页方法:
如果当前页小于最大页,那就+1(循环).如果不小于那就是最大页数了(可以进行的下一页操作)
如果说当前页大于1,就-1,否则,为最小页数。(上一页操作)。
那么,我们思考一下有代码可以代替很多我们刚刚写的分页功能,是不是很好呢?
我们来探究一下:
首先我们来写这样一个类,
package com.ly.tags;
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.ly.util.PageBean;
public class PageTag extends BodyTagSupport {
private static final long serialVersionUID = 2411829139570358249L;
private PageBean pageBean;
@Override
public int doStartTag() throws JspException {
JspWriter out = pageContext.getOut();
try {
out.write(toHTML());
} catch (IOException e) {
e.printStackTrace();
}
return super.doStartTag();
}
public String toHTML() {
StringBuffer sb = new StringBuffer();
// 下一次请求提交到后台的表单html代码拼接
sb.append("<form id='pageBeanForm' action='" + pageBean.getUrl() + "' method='post'>");
Map<String, String[]> paramMap = pageBean.getParamMap();
if (paramMap != null && paramMap.size() > 0) {
for (Entry<String, String[]> entry : paramMap.entrySet()) {
if (!"page".equals(entry.getKey())) {
for(String val : entry.getValue()) {
sb.append("<input type='hidden' name='" + entry.getKey() + "' value='" + val + "' >");
}
}
}
}
sb.append("<input type='hidden' name='page'>");
sb.append("</form>");
// 分页条html代码拼接
sb.append("<div style='text-align: right; font-size: 12px;'>");
sb.append(" 每页"+pageBean.getRows()+"条,共"+pageBean.getTotal()+"条,第"+pageBean.getPage()+"页,共"+pageBean.getMaxPage()+"页 <a ");
sb.append(" href='javascript:gotoPage(1)'>首页</a> <a");
sb.append(" href='javascript:gotoPage("+pageBean.getPreviousPage()+")'>上一页</a> <a");
sb.append(" href='javascript:gotoPage("+pageBean.getNextPage()+")'>下一页</a> <a");
sb.append(" href='javascript:gotoPage("+pageBean.getMaxPage()+")'>尾页</a> <input type='text'");
sb.append(" id='skipPage'");
sb.append(" style='text-align: center; font-size: 12px; width: 50px;'> <a");
sb.append(" href='javascript:skipPage()'>Go</a>");
sb.append("</div>");
// 分页所需要调用的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)>"+pageBean.getMaxPage()+"){");
sb.append(" alert('请输入1~N的数字');");
sb.append(" return;");
sb.append(" }");
sb.append(" gotoPage(page);");
sb.append(" }");
sb.append("</script>");
return sb.toString();
}
public PageBean getPageBean() {
return pageBean;
}
public void setPageBean(PageBean pageBean) {
this.pageBean = pageBean;
}
}
将我们原先写的前台代码放进此页面,并改活数据。
配置tld
测试
<z:page pageBean="${pagebean}"></z:page>
进行代码调试,这样我们就完成了简介的分页查询。