Java通用分页

@[TOC](

Java通用分页(待更) )

一.后台

 1.创建实体类 Book

package com.zking.pagination.entity;

import java.io.Serializable;

public class Book implements Serializable {

	private int bid;
	private String bname;
	private float bprice;
	private String btype;
	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 getBprice() {
		return bprice;
	}
	public void setBprice(float bprice) {
		this.bprice = bprice;
	}
	public String getBtype() {
		return btype;
	}
	public void setBtype(String btype) {
		this.btype = btype;
	}
	public Book() {
		super();
		// TODO Auto-generated constructor stub
	}
	public Book(String bname, float bprice, String btype) {
		super();
		this.bname = bname;
		this.bprice = bprice;
		this.btype = btype;
	}
	@Override
	public String toString() {
		return "Book [bid=" + bid + ", bname=" + bname + ", bprice=" + bprice + ", btype=" + btype + "]";
	}

}

 2.编写助手类 (PageBean DBHelper EncodingFilter StringUtils CommonUtils)

      PageBean:分页工具类

package com.zking.pagination.util;

import java.io.Serializable;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;
/**
 * 分页工具类
 * @author Cytheria
 *
 */
public class PageBean implements Serializable {

	//页码
	private int page=1;
	//每页显示条数
	private int rows=20;
	//总页数
	private int total=0;
	//是否要分页
	private boolean pagination=true;
	//获取上次请求路径
	private String url;
	//获取请求参数集合
	private Map<String,String[]> map;
	
	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;
	}
	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 boolean isPagination() {
		return pagination;
	}
	public void setPagination(boolean pagination) {
		this.pagination = pagination;
	}
	
	//重载setpage setrows setpagination方法
	public void setPage(String page) {
		if(null!=page&&!"".equals(page))
			this.page=Integer.parseInt(page);
	}
	public void setRows(String rows) {
		if(null!=rows&&!"".equals(rows))
			this.rows=Integer.parseInt(rows);
	}
	public void setPagination(String pagination) {
		if(null!=pagination&&!"".equals(pagination))
			this.pagination=Boolean.parseBoolean(pagination);
	}
	
	public void setRequest(HttpServletRequest req) {
		//获取前端提交的page/rows/pagination参数
		String page=req.getParameter("page");
		String rows=req.getParameter("rows");
		String pagination=req.getParameter("pagination");
		
		//赋值
		this.setPage(page);
		this.setPagination(pagination);
		this.setRows(rows);
		
		//设置上一次请求路径
		this.url=req.getRequestURI();
		//获取请求参数集合
		this.map=req.getParameterMap();
		
	}
	
	//获取分页的起始页位置
	public int getStartIndex() {
		return (this.page-1)*this.rows;
	}
	
	//获取末页 上一页 下一页
	public int getMaxPager() {
		int maxPager=this.total/this.rows;
		if(this.total%this.rows!=0)
			maxPager++;
		return maxPager;		
	}
	
	public int getPreviousPager() {
		int previousPager=this.page-1;
		if(this.page<=1)
			previousPager=1;
		return previousPager;
	}
	
	public int getNextPager() {
		int nextPager=this.page+1;
		if(this.page>getMaxPager())
			nextPager=getMaxPager();
		return nextPager;
	}
	@Override
	public String toString() {
		return "PageBean [page=" + page + ", rows=" + rows + ", total=" + total + ", pagination=" + pagination
				+ ", url=" + url + ", map=" + map + "]";
	}
		
}

      EncodingFilter:编码过滤器

package com.zking.pagination.util;

import java.io.IOException;
import java.util.Iterator;
import java.util.Map;
import java.util.Set;

import javax.servlet.Filter;
import javax.servlet.FilterChain;
import javax.servlet.FilterConfig;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * 中文乱码处理
 * @author Cytheria
 *
 */
public class EncodingFilter implements Filter {

	private String encoding = "UTF-8";//默认字符集

	public EncodingFilter() {
		super();
	}

	public void destroy() {
	}

	public void doFilter(ServletRequest request, ServletResponse response,
			FilterChain chain) throws IOException, ServletException {
		HttpServletRequest req = (HttpServletRequest) request;
		HttpServletResponse res = (HttpServletResponse) response;

		// 中文处理必须放到 chain.doFilter(request, response)方法前面
		res.setContentType("text/html;charset=" + this.encoding);
		if (req.getMethod().equalsIgnoreCase("post")) {
			req.setCharacterEncoding(this.encoding);
		} else {
			Map map = req.getParameterMap();// 保存所有参数名=参数值(数组)的Map集合
			Set set = map.keySet();// 取出所有参数名
			Iterator it = set.iterator();
			while (it.hasNext()) {
				String name = (String) it.next();
				String[] values = (String[]) map.get(name);// 取出参数值[注：参数值为一个数组]
				for (int i = 0; i < values.length; i++) {
					values[i] = new String(values[i].getBytes("ISO-8859-1"),
							this.encoding);
				}
			}
		}

		chain.doFilter(request, response);
	}

	public void init(FilterConfig filterConfig) throws ServletException {
		String s = filterConfig.getInitParameter("encoding");// 读取web.xml文件中配置的字符集
		if (null != s && !s.trim().equals("")) {
			this.encoding = s.trim();
		}
	}

}

      StringUtils:字符判空工具类

package com.zking.pagination.util;

public class StringUtils {
	// 私有的构造方法，保护此类不能在外部实例化
	private StringUtils() {
	}

	/**
	 * 如果字符串等于null或去空格后等于""，则返回true，否则返回false
	 * 
	 * @param s
	 * @return
	 */
	public static boolean isBlank(String s) {
		boolean b = false;
		if (null == s || s.trim().equals("")) {
			b = true;
		}
		return b;
	}
	
	/**
	 * 如果字符串不等于null或去空格后不等于""，则返回true，否则返回false
	 * 
	 * @param s
	 * @return
	 */
	public static boolean isNotBlank(String s) {
		return !isBlank(s);
	}

}

      DBHelper:数据库连接工具类

package com.zking.pagination.util;

import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

/**
 * 提供了一组获得或关闭数据库对象的方法
 * 
 */
public class DBHelper {
	private static String driver;
	private static String url;
	private static String user;
	private static String password;

	static {// 静态块执行一次，加载 驱动一次
		try {
			InputStream is = DBHelper.class
					.getResourceAsStream("config.properties");

			Properties properties = new Properties();
			properties.load(is);

			driver = properties.getProperty("driver");
			url = properties.getProperty("url");
			user = properties.getProperty("user");
			password = properties.getProperty("pwd");

			Class.forName(driver);
		} catch (Exception e) {
			e.printStackTrace();
			throw new RuntimeException(e);
		}
	}

	/**
	 * 获得数据连接对象
	 * 
	 * @return
	 */
	public static Connection getConnection() {
		try {
			Connection conn = DriverManager.getConnection(url, user, password);
			return conn;
		} catch (SQLException e) {
			e.printStackTrace();
			throw new RuntimeException(e);
		}
	}

	public static void close(ResultSet rs) {
		if (null != rs) {
			try {
				rs.close();
			} catch (SQLException e) {
				e.printStackTrace();
				throw new RuntimeException(e);
			}
		}
	}

	public static void close(Statement stmt) {
		if (null != stmt) {
			try {
				stmt.close();
			} catch (SQLException e) {
				e.printStackTrace();
				throw new RuntimeException(e);
			}
		}
	}

	public static void close(Connection conn) {
		if (null != conn) {
			try {
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
				throw new RuntimeException(e);
			}
		}
	}

	public static void close(Connection conn, Statement stmt, ResultSet rs) {
		close(rs);
		close(stmt);
		close(conn);
	}

	public static boolean isOracle() {
		return "oracle.jdbc.driver.OracleDriver".equals(driver);
	}

	public static boolean isSQLServer() {
		return "com.microsoft.sqlserver.jdbc.SQLServerDriver".equals(driver);
	}
	
	public static boolean isMysql() {
		return "com.mysql.jdbc.Driver".equals(driver);
	}

	public static void main(String[] args) {
		Connection conn = DBHelper.getConnection();
		DBHelper.close(conn);
		System.out.println("isOracle：" + isOracle());
		System.out.println("isSQLServer：" + isSQLServer());
		System.out.println("isMysql：" + isMysql());
		System.out.println("数据库连接(关闭)成功");
	}
}

      CommonUtils:数据结果集处理

package com.zking.pagination.util;

import java.lang.reflect.Field;
import java.lang.reflect.Method;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class CommonUtils {

	/**
	 * 将ResultSet结果集转换成list集合
	 * @param rs ResultSet结果集
	 * @param cla 类对象
	 * @return 返回list集合
	 */
	public static <T> List<T> toList(ResultSet rs,Class<T> cla){
		
		//定义返回集合
		List<T> lst=new ArrayList<T>();
		try {
			//获取当前ResultSet结果集的metadata列信息
			ResultSetMetaData metadata=rs.getMetaData();
			//定义实体类对象
			T obj=null;
			//获取类对象的所有属性数组
			Field[] fields = cla.getDeclaredFields();
			//遍历result set结果集
			while(rs.next()) {
				//通过反射机制,实例化对象
				obj=cla.newInstance();
				//遍历metadata列信息
				for (int i = 0; i < metadata.getColumnCount(); i++) {
					//获取result set结果集中的列名
					String colName = metadata.getColumnLabel(i+1);
					for (Field field : fields) {
						//获取属性名
						String fieldName = field.getName();
						//将属性名与列名进行比较
						if(fieldName.toUpperCase().equals(colName.toUpperCase())) {
							//拼接set赋值方法 set方法有个特点属性首字母大写
							String methodName ="set"+ fieldName.substring(0, 1).toUpperCase()+fieldName.substring(1);
							//反射调用方法
							Method method= cla.getDeclaredMethod(methodName, field.getType());
							//设置方法访问权限
							method.setAccessible(true);
							method.invoke(obj, rs.getObject(colName));
							break;
						}
					}
				}
				lst.add(obj);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		return lst;
	}
	
	
	/**
	 * 将resultset结果集转化成list集合
	 * @param rs
	 * @return
	 */
	public static List<Map<String, Object>> toList(ResultSet rs){
		List<Map<String,Object>> lst=new ArrayList<Map<String,Object>>();
		try {
			//获取当前ResultSet结果集的metadata列信息
			ResultSetMetaData metadata=rs.getMetaData();
			//定义map对象 相当于实体对象
			Map<String,Object> item=null;
			//遍历resultset结果集
			while(rs.next()) {
				item=new HashMap<>();
				for (int i = 0; i < metadata.getColumnCount(); i++) {
					String colName = metadata.getColumnLabel(i+1);
					item.put(colName, rs.getObject(colName));
				}
				lst.add(item);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		return lst;
	}
	
}

 3.编写通用分页的dao类:BaseDao

package com.zking.pagination.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;

import com.zking.pagination.util.DBHelper;
import com.zking.pagination.util.PageBean;

public class BaseDao<T> {

	/**
	 * 定义匿名内部类的接口类
	 * @author Cytheria
	 * @param <E> 集合元素
	 */
	public static interface CallBack<E> {
		public List<E> forEach(ResultSet rs) throws SQLException;
	}
	
	/**
	 * 分页查询
	 * @param sql 传过来的普通sql
	 * @param pageBean 分页帮助类
	 * @return 返回需要的集合
	 */
	public List<T> excuteQuery(String sql,PageBean pageBean,CallBack<T> callBack){
		
		Connection con=null;
		PreparedStatement ps=null;
		ResultSet rs=null;
		
		try {
			con=DBHelper.getConnection();
			//判断是否分页
			if(null!=pageBean&&pageBean.isPagination()) {
				//第一次查询总记录数
				String countSql=this.getCountSql(sql);
				ps=con.prepareStatement(countSql);
				rs=ps.executeQuery();
				if(rs.next()) {
					int count = rs.getInt(1);
					pageBean.setTotal(count);
				}
				
				//第二次查询满足条件的分页数据集
				sql=this.getPagerSql(sql, pageBean);
			}
			ps=con.prepareStatement(sql);
			rs=ps.executeQuery();
			return callBack.forEach(rs);
		} catch (Exception e) {
			e.printStackTrace();
		}finally {
			DBHelper.close(con, ps, rs);
		}
		return null;
	}
	
	/**
	 * 将普通的sql转换成查询总记录数的sql语句
	 * @param sql 普通sql语句
	 * @return 返回总记录数的sql语句
	 */
	public String getCountSql(String sql) {
		return " select count(1) from ("+sql+") t1";
	}
	
	/**
	 * 将普通sql转换成 符合分页条件查询的sql语句
	 * @param sql 普通sql
	 * @param pageBean 分页帮助类
	 * @return 返回分页sql
	 */
	public String getPagerSql(String sql,PageBean pageBean) {
		return sql+" limit "+pageBean.getStartIndex()+","+pageBean.getRows();
	}
	
}

 4.编写Book的dao类:BookDao

package com.zking.pagination.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
import java.util.Map;

import javax.security.auth.callback.Callback;

import com.zking.pagination.entity.Book;
import com.zking.pagination.util.CommonUtils;
import com.zking.pagination.util.DBHelper;
import com.zking.pagination.util.PageBean;
import com.zking.pagination.util.StringUtils;

public class BookDao extends BaseDao {

	/**
	 * 新增书本信息
	 * @param book 书本对象
	 */
	public void addBook(Book book) {
		String sql="insert into t_book(bname,bprice,btype) values(?,?,?)";
		Connection con=null;
		PreparedStatement ps=null;
		try {
			con=DBHelper.getConnection();
			ps=con.prepareStatement(sql);
			ps.setString(1, book.getBname());
			ps.setFloat(2, book.getBprice());
			ps.setString(3, book.getBtype());
			ps.executeUpdate();
		} catch (Exception e) {
			e.printStackTrace();
		}finally {
			DBHelper.close(con, ps, null);
		}
	}
	
	@SuppressWarnings("unchecked")
	public List<Map<String,Object>> queryMapPager(Book book,PageBean pageBean){
		String sql="select bid,bname,bprice,btype from t_book where 1=1 ";
		if(StringUtils.isNotBlank(book.getBname()))
			sql+=" and bname like '%"+book.getBname()+"%'";
		return super.excuteQuery(sql, pageBean, new CallBack<Map<String,Object>>(){

			public List<Map<String, Object>> forEach(ResultSet rs) throws SQLException {
				return CommonUtils.toList(rs);
			}
			
		});
	}
	
	/**
	 * 查询书本信息
	 * @param book 用于模糊查询的书本对象
	 * @return 返回书本信息的集合
	 */
	@SuppressWarnings("unchecked")
	public List<Book> queryBookPager(Book book,PageBean pageBean){
		String sql="select bid,bname,bprice,btype from t_book where 1=1 ";
		if(StringUtils.isNotBlank(book.getBname()))
			sql+=" and bname like '%"+book.getBname()+"%'";
		
		return super.excuteQuery(sql, pageBean, new CallBack<Book>() {

			@Override
			public List<Book> forEach(ResultSet rs) throws SQLException {
				/*Book bk=null;
				List<Book> books=new ArrayList<>();
				while(rs.next()) {
					bk=new Book();
					bk.setBid(rs.getInt("bid"));
					bk.setBname(rs.getString("bname"));
					bk.setBprice(rs.getFloat("bprice"));
					bk.setBtype(rs.getString("btype"));
					books.add(bk);
				}*/
				return CommonUtils.toList(rs, Book.class);
			}
			
		});
		
		/*Connection con=null;
		PreparedStatement ps=null;
		ResultSet rs=null;
		List<Book> books=new ArrayList<>();
		Book bk=null;
		try {
			con=DBHelper.getConnection();
			ps=con.prepareStatement(sql);
			rs=ps.executeQuery();
			while(rs.next()) {
				bk=new Book();
				bk.setBid(rs.getInt("bid"));
				bk.setBname(rs.getString("bname"));
				bk.setBprice(rs.getFloat("bprice"));
				bk.setBtype(rs.getString("btype"));
				books.add(bk);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}finally {
			DBHelper.close(con, ps, rs);
		}
		return books;*/
	}
	
	
}

二.前端

 1.编写标签助手类:PaginationTag

package com.zking.pagination.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.zking.pagination.util.PageBean;

public class PaginationTag extends BodyTagSupport {

	//分页工具对象
	private PageBean pageBean;//一定要提供get和set方法
	
	public PageBean getPageBean() {
		return pageBean;
	}

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

	public int doEndTag() throws JspException {
		return EVAL_PAGE;
	}

	//开始标签
	public int doStartTag() throws JspException {
		JspWriter out = pageContext.getOut();
		try {
			out.write(toHtml());//将内容写出到jsp页面
		} catch (Exception e) {
			e.printStackTrace();
		}
		return SKIP_BODY;
	}

	private String toHtml() {
		//判断是否分页
		if(null==pageBean || !pageBean.isPagination())
			return "";
		else {
			StringBuilder sb=new StringBuilder();
			sb.append("<form id=\"pageBeanForm\" method=\"post\" action=\""+pageBean.getUrl()+"\">");
			sb.append("<input type=\"hidden\" name=\"page\">");
			
			Map<String, String[]> map = pageBean.getMap();
			Set<Entry<String, String[]>> entrySet = map.entrySet();
			for (Entry<String, String[]> entry : entrySet) {
				String name = entry.getKey();
				String[] values=entry.getValue();
				if("page".equals(name))
					continue;
				for (String value : values) {
					sb.append("<input type=\"hidden\" name=\""+name+"\" value=\""+value+"\">");
				}
			}
			sb.append("</form>");
			
			sb.append("<div style=\"width:100%;text-align:right;\" >");
			sb.append("第"+pageBean.getPage()+"页/共"+pageBean.getMaxPager()+"页,总共"+pageBean.getTotal()+"条记录,");
			if(pageBean.getPage()!=1) {
				sb.append("<a href=\"javascript:gotoPage(1);\">首页</a>&nbsp;<a href=\"javascript:gotoPage("+pageBean.getPreviousPager()+");\">上一页</a>&nbsp;");
			}else {
				sb.append("首页&nbsp;上一页");
			}
			if(pageBean.getPage()!=pageBean.getMaxPager()) {
				sb.append("<a href=\"javascript:gotoPage("+pageBean.getNextPager()+");\">下一页</a>&nbsp;<a href=\"javascript:gotoPage("+pageBean.getMaxPager()+");\">末页</a>&nbsp;");
			}
			sb.append("<input id=\"skipPage\" value=\"\" type=\"text\" style=\"width:30px;\">&nbsp;<a href=\"javascript:skipPage();\">GO</a>");
			
			sb.append("<script type=\"text/javascript\">\r\n" + 
					"	function gotoPage(page){document.getElementById('pageBeanForm').page.value=page;document.getElementById('pageBeanForm').submit();\r\n" + 
					"	}");
			
			sb.append("function skipPage(maxPage){var page=document.getElementById('skipPage').value;if(isNaN(page) || page<1 || page>maxPage){alert('请输入1~'+maxPage+\"的数字!\");return false;}gotoPage(page);\r\n" + 
					"	}\r\n" + 
					"</script>");
			
			sb.append("</div>");
			
			return sb.toString();
		}
	}
	
}

 2.创建标签描述文件:z.tld

<!DOCTYPE taglib
  PUBLIC "-//Sun Microsystems, Inc.//DTD JSP Tag Library 1.2//EN"
   "http://java.sun.com/dtd/web-jsptaglibrary_1_2.dtd">
<!-- 标签库描述符 -->
<taglib xmlns="http://java.sun.com/JSP/TagLibraryDescriptor">
	<!-- 代表标签库的版本号 -->
	<tlib-version>1.0</tlib-version>
	<!-- 代表jsp的版本 -->
	<jsp-version>1.2</jsp-version>
	<!-- 你的标签库的简称 -->
	<short-name>z</short-name>
	<!-- 你标签库的引用uri -->
	<uri>/zking</uri>

	<tag>
		<!-- 标签名 -->
		<name>pagination</name>
		<!-- 标签工具类 -->
		<tag-class>com.zking.pagination.tag.PaginationTag</tag-class>
		<!-- 标签的内容类型：empty表示空标签，jsp表示可以为任何合法的JSP元素 -->
		<body-content>empty</body-content>
		<!-- 自定义标签的属性定义,请注意一定要在标签类中提供对应的get/set方法 -->
		<attribute>
			<!-- 自定义标签的属性名称 -->
			<name>pageBean</name>
			<!-- true表示必填 -->
			<required>true</required>
			<!-- true支持动态值,可以向值里面填jsp表达式、EL表达式,false则不支持 -->
			<rtexprvalue>true</rtexprvalue>
		</attribute>
	</tag>
</taglib>

 3.编写数据展示页面:boojlist.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="z" uri="/zking" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>通用分页</title>
</head>
<!-- <script type="text/javascript">
	function gotoPage(page){document.getElementById('pageBeanForm').page.value=page;document.getElementById('pageBeanForm').submit();
	}
	function skipPage(maxPage){var page=document.getElementById('skipPage').value;if(isNaN(page) || page<1 || page>maxPage){alert('请输入1~'+maxPage+"的数字!");return false;}gotoPage(page);
	}
</script> -->
<body>
<h1>当前系统时间戳<%=System.currentTimeMillis() %></h1>
<form method="post" action="index.action">
	<label>书本名称:</label><input name="bname" type="text">
	<input value="查询" type="submit">
</form>
<br/>
<table style="width:100%" border="1" cellpadding="0" cellspacing="0">
	<thead>
		<th>书本编号</th>
		<th>书本名称</th>
		<th>书本价格</th>
		<th>书本类型</th>
	</thead>
	
	<tbody>
		<c:forEach var="book" items="${books }">
			<tr align="center">
				<td>${book.bid }</td>
				<td>${book.bname }</td>
				<td>${book.bprice }</td>
				<td>${book.btype }</td>
			</tr>
		</c:forEach>
	</tbody>
</table>
<z:pagination pageBean="${pageBean}"/>
<%-- <form id="pageBeanForm" method="post" action="${pageBean.url}">
	<!-- 当前页码 -->
	<input type="hidden" name="page">
	<!-- 获取请求参数 -->
</form>
<div style="width:100%;text-align:right;" >
	第${pageBean.page }页/共${pageBean.getMaxPager() }页,总共${pageBean.total }条记录,
	<c:if test="${pageBean.page!=1}">
		<a href="javascript:gotoPage(1);">首页</a>&nbsp;<a href="javascript:gotoPage(${pageBean.getPreviousPager()});">上一页</a>&nbsp;
	</c:if>
	<c:if test="${pageBean.page!=pageBean.getMaxPager()}">
		<a href="javascript:gotoPage(${pageBean.getNextPager()});">下一页</a>&nbsp;<a href="javascript:gotoPage(${pageBean.getMaxPager()});">末页</a>&nbsp;
	</c:if>
	<input id="skipPage" value="" type="text" style="width:30px;">&nbsp;<a href="javascript:skipPage(${pageBean.getMaxPager()});">GO</a>
</div> --%>
</body>
</html>

 4.编写用于数据交互的servlet:BookServlet

package com.zking.pagination.action;

import java.io.IOException;
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.zking.pagination.dao.BookDao;
import com.zking.pagination.entity.Book;
import com.zking.pagination.util.PageBean;

public class BookServlet extends HttpServlet {

	BookDao bookDao=new BookDao();
	
	protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		this.doPost(req, resp);
	}

	protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		Book book=new Book();
		String bname=req.getParameter("bname");
		book.setBname(bname);
		PageBean pageBean=new PageBean();
		pageBean.setRequest(req);
		List<Book> books = bookDao.queryBookPager(book,pageBean);
		req.setAttribute("books", books);
		req.setAttribute("pageBean", pageBean);
		req.getRequestDispatcher("bookList.jsp").forward(req, resp);
	}

}

三.总结