Java Web前端页面中分页的实现

╰+攻爆jí腚メ 2022-07-14 03:23 170阅读 0赞

1、查询信息的封装

public class QueryInfo {
    	private int currentPage = 1;
    	private int pageSize = 1;
    	private int startIndex;
    
    	public int getCurrentPage() {
    		return currentPage;
    	}
    
    	public void setCurrentPage(int currentPage) {
    		this.currentPage = currentPage;
    	}
    
    	public int getPageSize() {
    		return pageSize;
    	}
    
    	public void setPageSize(int pageSize) {
    		this.pageSize = pageSize;
    	}
    
    	public int getStartIndex() {
    		startIndex = (this.currentPage - 1) * this.pageSize;
    		return startIndex;
    	}
    
    }

2、查询结果的封装

public class QueryResult {
    	private List list;
    	private int totalrecord;
    
    	public List getList() {
    		return list;
    	}
    
    	public void setList(List list) {
    		this.list = list;
    	}
    
    	public int getTotalrecord() {
    		return totalrecord;
    	}
    
    	public void setTotalrecord(int totalrecord) {
    		this.totalrecord = totalrecord;
    	}
    
    }

3、前端页面显示的封装

public class PageBean {
    
    	private List list;
    	private int totalrecord;
    	private int pagesize;
    	private int totalpage;
    	private int currentpage;
    	private int previouspage;
    	private int nextpage;
    	private int[] pagebar;
    
    	public List getList() {
    		return list;
    	}
    
    	public void setList(List list) {
    		this.list = list;
    	}
    
    	public int getTotalrecord() {
    		return totalrecord;
    	}
    
    	public void setTotalrecord(int totalrecord) {
    		this.totalrecord = totalrecord;
    	}
    
    	public int getPagesize() {
    		return pagesize;
    	}
    
    	public void setPagesize(int pagesize) {
    		this.pagesize = pagesize;
    	}
    
    	public int getTotalpage() {
    		// 100 5 20
    		// 101 5 21
    		// 99 5 20
    
    		if (this.totalrecord % this.pagesize == 0) {
    			this.totalpage = this.totalrecord / this.pagesize;
    		} else {
    			this.totalpage = this.totalrecord / this.pagesize + 1;
    		}
    
    		return totalpage;
    	}
    
    	public int getCurrentpage() {
    		return currentpage;
    	}
    
    	public void setCurrentpage(int currentpage) {
    		this.currentpage = currentpage;
    	}
    
    	public int getPreviouspage() {
    		if (this.currentpage - 1 < 1) {
    			this.previouspage = 1;
    		} else {
    			this.previouspage = this.currentpage - 1;
    		}
    		return previouspage;
    	}
    
    	public int getNextpage() {
    		if (this.currentpage + 1 >= this.totalpage) {
    			this.nextpage = this.totalpage;
    		} else {
    			this.nextpage = this.currentpage + 1;
    		}
    		return nextpage;
    	}
    
    	public int[] getPagebar() {
    		int startpage;
    		int endpage;
    		int pagebar[] = null;
    		if (this.totalpage <= 10) {
    			pagebar = new int[this.totalpage];
    			startpage = 1;
    			endpage = this.totalpage;
    		} else {
    			pagebar = new int[10];
    			startpage = this.currentpage - 4;
    			endpage = this.currentpage + 5;
    
    			// 总页数=30 3 -1
    			// 总页数=30 29 34 21 30
    			if (startpage < 1) {
    				startpage = 1;
    				endpage = 10;
    			}
    
    			if (endpage > this.totalpage) {
    				endpage = this.totalpage;
    				startpage = this.totalpage - 9;
    			}
    		}
    
    		int index = 0;
    		for (int i = startpage; i <= endpage; i++) {
    			pagebar[index++] = i;
    		}
    
    		this.pagebar = pagebar;
    		return this.pagebar;
    
    	}
    
    }

4、分页查询的实现

public class StudentDao {
    
    	public QueryResult query(QueryInfo info) {
    		try {
    			QueryResult qr = new QueryResult();
    
    			String sql = "select * from student limit ?,?";
    			QueryRunner runner = new QueryRunner(JdbcUtils.getDataSource());
    			List<Student> lists = (List<Student>) runner.query(sql,
    					new Object[] { info.getStartIndex(), info.getPageSize() },
    					new BeanListHandler(Student.class));
    			qr.setList(lists);
    			System.out.println(lists.get(0).getId());
    			sql = "select count(*) from student";
    			Object[] data = (Object[]) runner.query(sql, new ArrayHandler() {
    			});
    			qr.setTotalrecord(((Long) data[0]).intValue());
    			return qr;
    		} catch (Exception e) {
    			throw new RuntimeException(e);
    		}
    	}
    }

5、Action的实现

public class PageServlet extends HttpServlet {
    
    	private StudentSerivce serivce = new StudentSerivce();
    
    	public void doGet(HttpServletRequest request, HttpServletResponse response)
    			throws ServletException, IOException {
    		doPost(request, response);
    
    	}
    
    	public void doPost(HttpServletRequest request, HttpServletResponse response)
    			throws ServletException, IOException {
    		response.setContentType("text/html");
    		// 用于封装请求信息到QueryInfo
    		QueryInfo info = WebUtils.request2Bean(request, QueryInfo.class);
    		PageBean pageBean = serivce.query(info);
    		request.getSession().setAttribute("pageBean", pageBean);
    		request.getRequestDispatcher("/FenYe.jsp").forward(request, response);
    	}
    
    }

6、运行截图

![20161125143633480][]

7、源码下载

[20161125143633480]: /images/20220714/8abfd1adcd1c461d9f936321a6496f6f.png