JSP中代码
<a href="userBookList.do?pageS=1">首页</a>
<c:if test="${page.dpage!=1}">
<a href="userBookList.do?pageS=${page.dpage-1}">上一页</a>
</c:if>
<c:if test="${page.dpage!=page.totalpage}">
<a href="userBookList.do?pageS=${page.dpage+1}">下一页</a>
</c:if>
<a href="userBookList.do?pageS=${page.totalpage}">尾页</a>
Page.java里的代码
package com.bean;
public class Page {
private Long totalcount;//总条数
private Integer pagecount=4;//每页显示的条数
private Long totalpage;//总页数
private Integer dpage;//当前显示的页码
public Long getTotalcount() {
return totalcount;
}
public void setTotalcount(Long totalcount) {
this.totalcount = totalcount;
}
public Integer getPagecount() {
return pagecount;
}
public void setPagecount(Integer pagecount) {
this.pagecount = pagecount;
}
public Long getTotalpage() {
return totalpage;
}
public void setTotalpage() {
if(totalcount%pagecount == 0)
this.totalpage = totalcount/pagecount;
else {
this.totalpage = totalcount/pagecount+1;
}
}
public Integer getDpage() {
return dpage;
}
public void setDpage(Integer dpage) {
this.dpage = dpage;
}
}
userBookList.do方法
@RequestMapping("/userBookList")
public String booklist2(Model model,Integer pageS) {
Long totalCount = adminService.getCount();
System.out.println(totalCount);
Paging paging = new Paging();
Page page = paging.checkByPage(totalCount, pageS);
List<Book> list=adminService.showBook(page);
model.addAttribute("page",page);
model.addAttribute("booklist", list);
return "shop";
}
paging里的代码
package com.paging;
import com.bean.Page;
public class Paging {
public Page checkByPage(Long totalCount,Integer pageS) {
Integer dpage = 1;
if (pageS != null) {
dpage = pageS;
}
Page page = new Page();
page.setTotalcount(totalCount);
page.setTotalpage();
page.setDpage(dpage);
return page;
}
}
adminService.showBook方法(在dao方法里面改名为selectAllBook了)
@Override
public List<Book> selectAllBook(Page page) {
Session session = hibernateUtil.openSession();
Transaction tran = session.beginTransaction();
Query query = session.createQuery("from Book");
query.setFirstResult((page.getDpage()-1) * page.getPagecount());
query.setMaxResults(page.getPagecount());
List<Book> booklist = query.list();
tran.commit();
session.close();
return booklist;
}