对查询的数据进行分页java_java web中使用过滤器实现数据查询的分页显示 | 学步园...

jsp：

首页

上一页

第${page}页

下一页

尾页

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

}