通用分页`

通用分页核心思路:

1、 为了提高查询性能及节约网络流量,每次只查询指定的记录数,而不是全部,在数量比较大时很有用
2、当点击下一页或指定页面的数据时,将带着所有的查询条件,再次执行查询
讲简单点就是将上一次查询请求再发一次,只不过页码变了

先在MySQL数据库创建表

 

结构:

导入jar包,jstl标签库jar包,以及mysql jar包

后端代码:

DBHelper.java

package com.zking.bookStore.utils;

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("数据库连接(关闭)成功");
	}
}

config.properties 

#oracle9i
#driver=oracle.jdbc.driver.OracleDriver
#url=jdbc:oracle:thin:@localhost:1521:orcl
#user=scott
#pwd=tiger


#sql2005
#driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
#url=jdbc:sqlserver://localhost:1433;DatabaseName=test1
#user=sa
#pwd=123


#sql2000
#driver=com.microsoft.jdbc.sqlserver.SQLServerDriver
#url=jdbc:microsoft:sqlserver://localhost:1433;databaseName=unit6DB
#user=sa
#pwd=888888


#mysql
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/t275?useUnicode=true&characterEncoding=UTF-8
user=root
pwd=123



 EncodingFilter.java

package com.zking.bookStore.utils;

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;

/**
 * 中文乱码处理
 * 
 */
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.java

package com.zking.bookStore.utils;

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);
	}

}

PageBean
页码,从页面传递过来——page
每页行数,从也能传递过来——rows
总记录数, 从数据库中统计得到——total
是否分页, 如果为true,则分页——pagination
查询参数, 点击上一页或下一页时需要及携带用户输入的所有查询参数——url
另外提供上页,下页,总页数等计算


PageBean.java

package com.zking.bookStore.utils;
/**
 * 用于分页的工具类
 * @author Administrator
 *
 */

import java.util.Map;

import javax.servlet.http.HttpServletRequest;

public class PageBean {
	
	//分页三要素
	
	private int page = 1; //页码  默认为1
	
	private int rows = 10; //页大小 默认为10
	
	private int total = 0; //总记录数  默认为0
	
	private boolean pagination = true; //是否分页  默认为分页
	
	private String url;  //保存请求路径
	
	private Map<String, String[]> map; //存放请求参数,用于生成隐藏域中的元素
	
	public int getPage() {
		return page;
	}

	public void setPage(int page) {
		this.page = page;
	}
	
	public void setPage(String page) {
		if(null!=page) {//如果页码不为空
			this.page=Integer.parseInt(page);
		}
	}
	
	public int getRows() {
		return rows;
	}

	public void setRows(int rows) {
		this.rows = rows;
	}
	
	public void setRows(String rows) {
		if(null!=rows) {//如果页大小不为空
			this.rows=Integer.parseInt(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;
	}

	public void setPagination(String pagination) {
		if(null!=pagination) {
			this.pagination=Boolean.parseBoolean(pagination);
		}
	}
	
	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 PageBean() {
		// TODO Auto-generated constructor stub
	}
	
	
	@Override
	public String toString() {
		return "PageBean [page=" + page + ", rows=" + rows + ", total=" + total + ", pagination=" + pagination
				+ ", url=" + url + ", map=" + map + "]";
	}

	/**
	 * 获取分页的起始下标
	 * @return
	 */
	public int getStartIndex() {
		return (this.page-1)*this.rows;
	}
	
	/**
	 * 请求初始化pageBean方法
	 * @param req
	 */
	public void setRequest(HttpServletRequest req) {
		String page = req.getParameter("page");
		String rows = req.getParameter("rows");
		String pagination = req.getParameter("pagination");
		
		String url = req.getRequestURI();
		Map<String, String[]> map = req.getParameterMap();
		
		//设置到pageBean中
		this.setPage(page);
		this.setRows(rows);
		this.setPagination(pagination);
		
		this.setUrl(url);
		this.setMap(map);
	}
	
	/**
	 * 获取上一页的页码
	 * @return
	 */
	public int getPrePage() {
		int prePage = this.page-1;
		if(this.page==1) {
			prePage = this.page;
		}
		return prePage;
		//return this.page - 1 > 0 ? this.page - 1 : 1;
	}
	
	/**
	 * 获取下一页的页码
	 * @return
	 */
	public int getNextPage() {
		int nextPage = this.page+1;
		if(this.page==getMaxPage()) {
			nextPage = getMaxPage();
		}
		return nextPage;
		//return this.page + 1 > getMaxPage() ? getMaxPage() : this.page + 1;
	}
	
	/**
	 * 获取最大的页码  总页数
	 * @return
	 */
	public int getMaxPage() {
		int maxPage = this.total/this.rows;
		if(this.total%this.rows!=0) {
			maxPage++;
		}
		return maxPage;
		
		/*if (this.getTotal() % this.rows == 0) {
			return this.getTotal() / this.rows;
		} else {
			return this.getTotal() / this.rows + 1;
		}*/

	}
}

Book.java

package com.zking.bookStore.entity;

import java.io.Serializable;
/**
 * 实体类   书本类
 * @author Administrator
 *
 */
public class Book implements Serializable{

	/**
	 * 
	 */
	private static final long serialVersionUID = 6883813152865156475L;
	
	private Integer id;
	private String bookName;
	private Float price;
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public String getBookName() {
		return bookName;
	}
	public void setBookName(String bookName) {
		this.bookName = bookName;
	}
	public Float getPrice() {
		return price;
	}
	public void setPrice(Float price) {
		this.price = price;
	}
	public Book() {
		// TODO Auto-generated constructor stub
	}
	public Book(Integer id, String bookName, Float price) {
		this.id = id;
		this.bookName = bookName;
		this.price = price;
	}
	@Override
	public String toString() {
		return "Book [id=" + id + ", bookName=" + bookName + ", price=" + price + "]";
	}
	
}

 BookDAO.java

package com.zking.bookStore.dao;

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

import com.zking.bookStore.base.BaseDAO;
import com.zking.bookStore.entity.Book;
import com.zking.bookStore.utils.DBHelper;
import com.zking.bookStore.utils.PageBean;
import com.zking.bookStore.utils.StringUtils;

public class BookDAO extends BaseDAO<Book>{
	
	private Connection con = null;
	private PreparedStatement ps = null;
	private ResultSet rs =  null;
	
	/**
	 * 书本增加
	 * @param book
	 */
	public void addBook(Book book) {
		try {
			String sql = "INSERT INTO t_book(book_name,price) VALUES(?,?)";
			//获取数据库连接对象
			con = DBHelper.getConnection();
			ps=con.prepareStatement(sql);
			ps.setString(1, book.getBookName());
			ps.setFloat(2, book.getPrice());
			ps.executeUpdate();
		} catch (Exception e) {
			throw new RuntimeException(e);
		}finally {
			DBHelper.close(con, ps, null);
		}
	}
	
	/**
	 * 书本删除
	 * @param book
	 */
	public void delBook(Book book) {
		try {
			String sql = "DELETE FROM t_book WHERE id=?";
			//获取数据库连接对象
			con = DBHelper.getConnection();
			ps=con.prepareStatement(sql);
			ps.setInt(1, book.getId());
			ps.executeUpdate();
		} catch (Exception e) {
			throw new RuntimeException(e);
		}finally {
			DBHelper.close(con, ps, null);
		}
	}
	/**
	 * 书本修改
	 * @param book
	 */
	public void editBook(Book book) {
		try {
			String sql = "UPDATE t_book SET book_name=?,price=?  WHERE id=? ";
			//获取数据库连接对象
			con = DBHelper.getConnection();
			ps=con.prepareStatement(sql);
			ps.setString(1, book.getBookName());
			ps.setFloat(2, book.getPrice());
			ps.setInt(3, book.getId());
			ps.executeUpdate();
		} catch (Exception e) {
			throw new RuntimeException(e);
		}finally {
			DBHelper.close(con, ps, null);
		}
	}
	/**
	 * 查询单个书本
	 * @param book
	 */
	public Book loadBook(Book book) {
		try {
			String sql = " SELECT id,book_name,price FROM t_book WHERE id=? ";
			//获取数据库连接对象
			con = DBHelper.getConnection();
			ps = con.prepareStatement(sql);
			ps.setInt(1, book.getId());
			rs = ps.executeQuery();
			Book b = null;
			if(rs.next()) {
				b = new Book();
				b.setId(rs.getInt("id"));
				b.setBookName(rs.getString("book_name"));
				b.setPrice(rs.getFloat("price"));
			}
			return b;
		} catch (Exception e) {
			throw new RuntimeException(e);
		}finally {
			DBHelper.close(con, ps, rs);
		}
	}
	/**
	 * 查询所有书本
	 * @param book
	 */
	public List<Book> listBook(Book book,PageBean pageBean) {
		
		String sql = " SELECT id,book_name,price FROM t_book WHERE 1=1 ";
		
		//模糊查询
		if(StringUtils.isNotBlank(book.getBookName())) {
			sql += " AND book_name LIKE '%"+book.getBookName()+"%'";
		}
		
		return this.executeQuery(sql, pageBean, new CallBack<Book>() {

			@Override
			public List<Book> forEachRs(ResultSet rs) throws Exception {
				List<Book> listBook = new ArrayList<>();
				Book b = null;
				while(rs.next()) {
					b = new Book();
					b.setId(rs.getInt("id"));
					b.setBookName(rs.getString("book_name"));
					b.setPrice(rs.getFloat("price"));
					listBook.add(b);
				}
				return listBook;
			}
		});
		
	}	
}

测试点击BookDAO鼠标右键New--->Other-->输入junit Test Case-->点Next-->勾选如图所示

点击Next-->勾选如图所示

点击Finish

调用BookDAO方法即可

package com.zking.bookStore.dao;

import java.util.List;

import org.junit.After;
import org.junit.Before;
import org.junit.Test;

import com.zking.bookStore.entity.Book;
import com.zking.bookStore.utils.PageBean;

public class BookDAOTest {
	
	private BookDAO bookDAO;
	private Book book;
	@Before
	public void setUp() throws Exception {
		bookDAO = new BookDAO();
		book = new Book();
	}

	@After
	public void tearDown() throws Exception {
	}

	@Test
	public void testAddBook() {
		for (int i = 1; i < 101; i++) {
			book.setBookName("孙悟空三打白骨精第"+i+"回");
			book.setPrice(66f);
			bookDAO.addBook(book);
		}
	}

	@Test
	public void testDelBook() {
			book.setId(1);
			bookDAO.delBook(book);
	}

	@Test
	public void testEditBook() {
		book.setId(2);
		book.setBookName("弼马温");
		book.setPrice(9.9f);
		bookDAO.editBook(book);
	}

	@Test
	public void testLoadBook() {
		book.setId(2);
		Book loadBook = bookDAO.loadBook(book);
		System.out.println(loadBook);
	}

	@Test
	public void testListBook() {
		book.setBookName("1");
		PageBean pageBean = new PageBean();
		pageBean.setPage(2);
		pageBean.setRows(5);
		List<Book> listBook = bookDAO.listBook(book,pageBean);
		for (Book b : listBook) {
			System.out.println(b);
		}
	}
}

测试如图所示: 点击方法右键找到Run As-->JUnit  Test

BaseDAO.java 

package com.zking.bookStore.base;

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

import com.zking.bookStore.utils.DBHelper;
import com.zking.bookStore.utils.PageBean;

public class BaseDAO<K> {
	
	/**
	 * 定义一个接口,用来遍历ResultSet
	 * @author Administrator
	 *
	 * @param <T>
	 */
	public interface CallBack<T>{
		public List<T> forEachRs(ResultSet rs) throws Exception;
	}
	
	
	
	/**
	 * 查询全部并且分页的方法
	 * @param sql  普通的查询全部的sql语句
	 * @param pageBean  分页的工具类
	 * @return
	 */
	public List<K> executeQuery(String sql,PageBean pageBean,CallBack callBack) {
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			//1.获取数据库连接
			conn = DBHelper.getConnection();
			
			//2.查询符合条件的总记录数
			if(null!=pageBean && pageBean.isPagination()) {//如果分页工具类不为空  并且pagination为true,则分页
				//将普通的sql语句转换成查询总记录数的sql语句
				String countSql = this.getCountSql(sql);
				ps = conn.prepareStatement(countSql);
				rs = ps.executeQuery();
				if(rs.next()) {
					int total = rs.getInt(1);
					//将查询的总记录数放到工具类 pageBean中
					pageBean.setTotal(total);
				}
				DBHelper.close(null, ps, rs);
				
			}
			
			//3.查询符合条件并且分页的记录
			if(null!=pageBean && pageBean.isPagination()) {//如果分页工具类不为空  并且pagination为true,则分页
				//将普通的sql语句转换成查询符合条件并且分页的sql语句
				sql = this.getPageSql(sql, pageBean);
			}
			
			ps = conn.prepareStatement(sql);
			rs = ps.executeQuery();
			
			//遍历rs
			
			return callBack.forEachRs(rs);
			
			
		} catch (Exception e) {
			throw new RuntimeException(e);
		}finally {
			DBHelper.close(conn, ps, rs);
		}
			
		
	}
	
	/**
	 * 将普通的sql语句转换成查询总记录数的sql语句
	 * @param sql  普通的sql语句
	 * @return
	 */
	private String getCountSql(String sql) {
		String countSql = "SELECT COUNT(*) FROM ("+sql+")t1 ";
		return countSql;
	}
	
	/**
	 * 将普通的sql语句转换成查询符合条件并且分页的sql语句
	 * @param sql 普通的sql
	 * @return
	 */
	private String getPageSql(String sql,PageBean pageBean) {
		String pageSql = sql + " LIMIT "+pageBean.getStartIndex()+","+pageBean.getRows();
		return pageSql;
	}
	
}

BookServlet.java 

package com.zking.bookStore.action;

import java.io.IOException;
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.zking.bookStore.dao.BookDAO;
import com.zking.bookStore.entity.Book;
import com.zking.bookStore.utils.PageBean;
@WebServlet("/bookservlet")
public class BookServlet extends HttpServlet{
	@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 {
		//设置编码
		req.setCharacterEncoding("utf-8");
		
		//获取请求参数
		String bookName = req.getParameter("bookName");
		
		//获取请求参数 ,设置到pageBean中
		PageBean pageBean = new PageBean();
		
		String requestURI = req.getRequestURI();
		
//		Map<String, String[]> parameterMap = req.getParameterMap();
//		System.out.println(requestURI);
		
		pageBean.setRequest(req);
		
		Book book = new Book();
		book.setBookName(bookName);
		
		BookDAO bookDAO = new BookDAO();
		
		
		List<Book> listBook = bookDAO.listBook(book, pageBean);
		
		req.setAttribute("listBook", listBook);
		
		req.setAttribute("pageBean", pageBean);
		
		//转发
		req.getRequestDispatcher("/book.jsp").forward(req, resp);
	}
	
	
}

 前端代码:

index.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!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>
	<a href="<%=request.getContextPath() %>/bookservlet">查询书本</a>
</body>
</html>

book.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 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>
<script type="text/javascript">
	/* function gotoPage(page){
		//将参数中的page值赋给表单中的page的value值
		document.getElementById('pageForm').page.value = page;
		//表单提交
		document.getElementById('pageForm').submit();
	}
	
	function skipPage(maxPage){
		//获取input框的输入的值
		var page = document.getElementById('zk').value;
		if(isNaN(page) || page<1 || page>maxPage){
			alert('请输入1-'+maxPage+'的数字!')
			return false; //结束方法
		}
		gotoPage(page);
	} */
</script>
</head>
<body>
<div align="center">
	<!--查询条件  -->
	<form action="<%=request.getContextPath() %>/bookservlet" method="post">
		书名:<input type="text" name="bookName">
		<input type="submit" value="查询">
	</form>
</div>
	<table border="1px" width="100%">
		<tr align="center">
			<td>编号</td>
			<td>书名</td>
			<td>价格</td>
		</tr>
		<c:forEach items="${listBook }" var="b" >
		<tr align="center">
			<td>${b.id }</td>
			<td>${b.bookName }</td>
			<td>${b.price }</td>
		</tr>
		</c:forEach>
	</table>
	
	<%-- <div>
		<!-- 隐藏表单,用来翻页时保存查询参数 -->
		<form id="pageForm" action="${pageBean.url}" method="post">
			<!-- 页码 -->
			<input name="page" type="hidden"/>
			<!-- 请求参数 -->
			<!-- 
			<input name="rows" type="hidden"/>
			<input name="pagination" type="hidden"/>
			 -->
		</form>
	</div>  --%>
	
	
	<%-- < <div style="float: right">
		第${pageBean.page }页/总共${pageBean.total }条记录
		<a href="javascript:gotoPage(1)">首页</a>&nbsp;
		<a href="javascript:gotoPage(${pageBean.getPrePage() })">上一页</a>&nbsp;
		<a href="javascript:gotoPage(${pageBean.getNextPage() })">下一页</a>&nbsp;
		<a href="javascript:gotoPage(${pageBean.getMaxPage() })">末页</a>&nbsp;
		<input style="width:30px;text-align: center" id="zk" name="zk"/>&nbsp;&nbsp;
		<a id="skipPage" href="javascript:skipPage(${pageBean.getMaxPage() })">跳转</a>&nbsp;
	</div> --%>
	<z:page pageBean="${pageBean}"/>
<%-- ${pageBean }--%>
</body>
</html>

 PageTag.java

写一个标签助手类拼接前端代码

package com.zking.bookStore.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.bookStore.utils.PageBean;

public class PageTag extends BodyTagSupport {
	private PageBean pageBean;

	public PageTag() {
		super();
	}

	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.println(toHtml());
		} catch (Exception e) {
			throw new RuntimeException(e);
		}
		return super.doStartTag();
	}
	
	
	private String toHtml() {
		//pageBean为空或者 不分页
		if(null==pageBean || !pageBean.isPagination()) {
			return "";
		}
		StringBuilder sb = new StringBuilder();
		//拼接form表单
		/*<form action="${pageBean.url}" method="post" id="pageBeanForm">
		<!-- 设置页码 -->
		<input type="hidden" name="page"/>
	    <!-- 参数列表 -->
		</form>*/
		sb.append("<form action=\""+pageBean.getUrl()+"\" method=\"post\" id=\"pageBeanForm\">");
		sb.append("<input type=\"hidden\" name=\"page\"/>");
		
		//参数列表
		
		Map<String, String[]> map = pageBean.getMap();
		String name =null;
		String[] values = null;
		// bookName = '不短命'  hobby="篮球"  hobby="足球" page="2"
		Set<Entry<String, String[]>> entrySet = map.entrySet();
		for (Entry<String, String[]> entry : entrySet) {
			name = entry.getKey();
			if(name.equals("page")) {
				continue;
			}
			values = entry.getValue();
			for (String value : values) {
				
				//<input type="hidden" name="bookName" value="不短命"/>
				//<input type="hidden" name="hobby" value="篮球"/>
				//<input type="hidden" name="hobby" value="足球"/>
				sb.append("<input type=\"hidden\" name=\""+name+"\" value=\""+value+"\"/>");
			}
		}
		sb.append("</form>");
		
		
		//拼接div部分
		/*<div style="width:100%;text-align: right;">
		第几页/总共多少页,共多少条记录 
		<a href="javascript:gotoPage(1)">首页</a>&nbsp;
		<a href="javascript:gotoPage(${pageBean.getPreviousPage()})">上一页</a>&nbsp;
		<a href="javascript:gotoPage(${pageBean.getNextPage()})">下一页</a>&nbsp;
		<a href="javascript:gotoPage(${pageBean.getMaxPage()})">末页</a>&nbsp;
		<input type="text" id="skipPage" style="width:30px;"/>&nbsp;
		<a href="javascript:skipPage(${pageBean.getMaxPage()})">GO</a>
	
	
	
		</div>*/
		sb.append("<div style=\"width:100%;text-align: right;\">");
		sb.append("第"+pageBean.getPage()+"页/总共"+pageBean.getMaxPage()+"页,共"+pageBean.getTotal()+"条记录 ");
		
		//首页  上一页
		if(pageBean.getPage()!=1) {
			sb.append("<a href=\"javascript:gotoPage(1)\">首页</a>&nbsp;\r\n" + 
					"		<a href=\"javascript:gotoPage("+pageBean.getPrePage()+")\">上一页</a>&nbsp;");
		}else {
			sb.append("<a>首页</a>&nbsp;<a>上一页</a>&nbsp;");
		}
		
		
		//末页 下一页
		
		if(pageBean.getPage()!=pageBean.getMaxPage()) {
			sb.append("<a href=\"javascript:gotoPage("+pageBean.getNextPage()+")\">下一页</a>&nbsp;\r\n" + 
					"		<a href=\"javascript:gotoPage("+pageBean.getMaxPage()+")\">末页</a>&nbsp;");
		}else {
			sb.append("<a>下一页</a>&nbsp;<a>末页</a>&nbsp;");
		}
		
		//跳转页
		sb.append("<input type=\"text\" id=\"skipPage\" style=\"width:30px;text-align: center\"/>&nbsp;");
		sb.append("<a href=\"javascript:skipPage()\">GO</a>");
		sb.append("</div>");
		
		//拼接js
		/*<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>*/
		
		sb.append("<script type=\"text/javascript\">\r\n" + 
				"	function gotoPage(page) {\r\n" + 
				"		document.getElementById('pageBeanForm').page.value=page;\r\n" + 
				"		document.getElementById('pageBeanForm').submit();\r\n" + 
				"	}\r\n" + 
				"	function skipPage() {\r\n" + 
				"		var page = document.getElementById('skipPage').value;\r\n" + 
				"		if(isNaN(page) || page<1 || page>"+pageBean.getMaxPage()+"){\r\n" + 
				"			alert(\"请输入1-\"+"+pageBean.getMaxPage()+"+\"的数字\");\r\n" + 
				"			return false;\r\n" + 
				"		}\r\n" + 
				"		gotoPage(page);\r\n" + 
				"	}\r\n" + 
				"\r\n" + 
				"</script>");
		
		
		return sb.toString();
	}
	
	
}

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>l</short-name>
	<!-- 你标签库的引用uri -->
	<uri>/zking</uri>

	<tag>
		<!-- 标签名 -->
		<name>page</name>
		<!-- 标签工具类 -->
		<tag-class>com.zking.bookStore.tag.PageTag</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>

效果图: 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值