@[TOC](
一.后台
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> <a href=\"javascript:gotoPage("+pageBean.getPreviousPager()+");\">上一页</a> ");
}else {
sb.append("首页 上一页");
}
if(pageBean.getPage()!=pageBean.getMaxPager()) {
sb.append("<a href=\"javascript:gotoPage("+pageBean.getNextPager()+");\">下一页</a> <a href=\"javascript:gotoPage("+pageBean.getMaxPager()+");\">末页</a> ");
}
sb.append("<input id=\"skipPage\" value=\"\" type=\"text\" style=\"width:30px;\"> <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> <a href="javascript:gotoPage(${pageBean.getPreviousPager()});">上一页</a>
</c:if>
<c:if test="${pageBean.page!=pageBean.getMaxPager()}">
<a href="javascript:gotoPage(${pageBean.getNextPager()});">下一页</a> <a href="javascript:gotoPage(${pageBean.getMaxPager()});">末页</a>
</c:if>
<input id="skipPage" value="" type="text" style="width:30px;"> <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);
}
}