分页查询

超、凢脫俗 2022-05-15 04:11 438阅读 0赞

/**
* 真分页
* @param
* @param req
* @return
* @return 对象page
*/
private static Page truePaging (int allRecord,HttpServletRequest req){
//设置每页显示数
int pageSizeStr = 5;
// 得到当前页数
String pageIndexStr = req.getParameter(“pageIndex”);
if (pageIndexStr == null) {
pageIndexStr = “1”;
}
int pageIndex = Integer.parseInt(pageIndexStr);
req.setAttribute(“pageIndex”, pageIndex);

//得到总页数
int allPage = (allRecord % pageSizeStr == 0) ? (allRecord / pageSizeStr)
: (allRecord / pageSizeStr + 1);
req.setAttribute(“allPage”, allPage);

//返回总共记录数
req.setAttribute(“allRecord”, allRecord) ;
int toIndex = pageSizeStr * (pageIndex);
// 判断是不是最9后一页
if (pageIndex == allPage) {
toIndex = allRecord;
}
Page page = new Page();
page.setFirstline(pageSizeStr * (pageIndex - 1));
page.setLastline(toIndex);
return page;
}

/**
* 假分页
* @param list
* @param req
* @return
*/
private static List paging(List list,HttpServletRequest req){
//设置每页显示数
int pageSizeStr = 5;
// 得到当前页数
String pageIndexStr = req.getParameter(“pageIndex”);
if (pageIndexStr == null) {
pageIndexStr = “1”;
}
int pageIndex = Integer.parseInt(pageIndexStr);
req.setAttribute(“pageIndex”, pageIndex);

//得到总页数
int allPage = (list.size() % pageSizeStr == 0) ? (list.size() / pageSizeStr)
: (list.size() / pageSizeStr + 1);
req.setAttribute(“allPage”, allPage);
//返回总共记录数
req.setAttribute(“allRecord”, list.size()) ;
int toIndex = pageSizeStr * (pageIndex);
// 判断是不是最后一页
if (pageIndex == allPage) {
toIndex = list.size();
}
List list2 = list.subList(pageSizeStr * (pageIndex - 1),toIndex);
return list2;
}

真分页的调用

Page page =truePaging(allRecord,req);
book.setPage(page);

list = adminBiz.findBookAll(book);
if(list.size() == 0){
req.setAttribute(“allRecord”, 0);
return “/All_book.jsp”;
}
req.setAttribute(“bookInfo”, book);
req.setAttribute(“bookList”,list);

return “/All_book.jsp”;

假分页

List list2 = paging(list, req);
req.setAttribute(“informAll”, list2);
return “/pbshow_list.jsp”;

页面样式



${allRecord}条记录,当前显示第 ${pageIndex} 



发表评论

表情:
评论列表 (有 0 条评论,438人围观)

还没有评论,来说两句吧...

相关阅读

    相关 查询

    AngularJS+Bootstrap 分页功能实现,同时支持模糊查询分页 发表于2017/9/11 20:18:56  209人阅读 因为项目的需要需要实现页面的分页

    相关 查询

    CURD- 1. 添加用户 表单项的name,JavaBean的属性名,数据库表的字段名,建议保持一致 注意:提交的表单中有中文,要解决中文参数乱码问题