java web中使用过滤器实现数据查询的分页显示

最新推荐文章于 2021-09-10 10:25:02 发布

liushuaibaicai

最新推荐文章于 2021-09-10 10:25:02 发布

阅读量873

点赞数

CC 4.0 BY-SA版权

分类专栏： java web 文章标签： java web string list filter jsp

本文链接：https://blog.youkuaiyun.com/liushuaibaicai/article/details/6991501

java 同时被 2 个专栏收录

4 篇文章

订阅专栏

web

4 篇文章

订阅专栏

本文介绍如何在Java Web应用中利用过滤器（Filter）实现数据查询的分页显示，主要涉及jsp、string、list和filter的使用。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

jsp：

<div class="listfoot">
				<a href="${pageContext.request.contextPath }/admin/view/index.jsp?page=1">首页</a>
				    
				<a href="${pageContext.request.contextPath }/admin/view/index.jsp?page=${page-1}">上一页</a>
				    
				第${page}页 
				    
				<a href="${pageContext.request.contextPath }/admin/view/index.jsp?page=${page+1}">下一页</a> 
				    
				<a href="${pageContext.request.contextPath }/admin/view/index.jsp?page=-1">尾页</a>
			</div>

Filter:

	/**
	 * @see Filter#doFilter(ServletRequest, ServletResponse, FilterChain)
	 */
	@Override
	public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain) throws IOException, ServletException {
		// TODO Auto-generated method stub
		// place your code here
		
		HttpServletRequest httpServletRequest = (HttpServletRequest) request;
		String string = httpServletRequest.getParameter("page");
		int page = Integer.parseInt(string);
		
		int count = GetGoodsCount.getCount("SELECT count(*) FROM goods where goods_state=1");
		int pagecount = (count-1)/25+1;
		if(page==-1 || page>pagecount)
			page=pagecount;
		if(page==0)
			page=1;
		List<Goods> list;
		list = ListGoods.getListGoods("select * from goods where goods_state=1 order by goods_id desc limit "+(page-1)*25+",25");//执行具体获取方法

		request.setAttribute("list", list);//将结果放入request
		request.setAttribute("page", page);
		
		// pass the request along the filter chain
		chain.doFilter(request, response);
	}