ssh 分页查询

先写公用类PageBean泛型类

public class PageBean<T> {

//当前页
private Integer currentPage;
//总记录
private Integer totalCount;
//每页条数
private Integer pageSize;
//总页数
private Integer totalPage;
//开始位置
private Integer begin;
//list集合
private List<T> list;
public void setCurrentPage(Integer currentPage) {
this.currentPage = currentPage;
}
public Integer getTotalCount() {
return totalCount;
}
public void setTotalCount(Integer totalCount) {
this.totalCount = totalCount;
}
public Integer getPageSize() {
return pageSize;
}
public void setPageSize(Integer pageSize) {
this.pageSize = pageSize;
}
public Integer getTotalPage() {
return totalPage;
}
public void setTotalPage(Integer totalPage) {
this.totalPage = totalPage;
}
public Integer getBegin() {
return begin;
}
public void setBegin(Integer begin) {
this.begin = begin;
}
public List<T> getList() {
return list;
}
public void setList(List<T> list) {
this.list = list;
}

}
action方法中查询所有数据
private Integer currentPage;  get/set方法

 //分页方法
public String listpage(){

  if(currentPage==null){
currentPage = 1;
}

  PageBean<User> pageBean = userService.listpage(currentPage);
//放到与对象里面
request.setAttribute("pageBean",pageBean);
//放到与对象里面
request.setAttribute("pageBean",pageBean);
return "listpage";
}








service中方法
//分页

public PageBean<User> listpage(Integer currentPage) {
PageBean<User> pageBean = new PageBean<User>();

//当前页
pageBean.setCurrentPage(currentPage);

//总记录数  调用一个方法findCount()
int totalCount = userDao.findCount();
pageBean.setTotalCount(totalCount);

//meiye 条数
int pageSize= 3;

//总页数
int totalPage = 0;
if(totalCount%pageSize==0){
totalPage = totalCount/pageSize;
}else{
totalPage = totalCount/pageSize+1;
} 
pageBean.setTotalPage(totalPage);
//开始位置
int begin = (currentPage-1)*pageSize;
//list集合
List<User> list = userDao.findAll(begin,pageSize);
pageBean.setList(list);
return pageBean;
}




dao层中
//总条数

@SuppressWarnings("all")

public int findCount() {

List<Object> list =(List<Object>) getSession().createQuery("select count(*) from User").list();

if(list!=null && list.size()>0){

Object obj = list.get(0);

Long log= (Long)obj;

int count = log.intValue();

return count;

}

return 0;

}





//反回list集合分页查询

@SuppressWarnings("all")

public List<User> findAll(int begin, int pageSize) {

/*//第一种方式

//得到工厂

SessionFactory sessionFactory = this.getHibernateTemplate().getSessionFactory();

Session session = sessionFactory.getCurrentSession();

Query query = session.createQuery("from User");

query.setFirstResult(begin);

query.setMaxResults(pageSize);

List<User> list = query.list();*/



//第二种、使用离线对象和hibernateTemplate实现

//创建离线对象 设置对哪个实体类操作

DetachedCriteria criteria = DetachedCriteria.forClass(User.class);

//调用模板方法



List<User> list = (List<User>)this.getHibernateTemplate().findByCriteria(criteria,begin,pageSize);



return list;

}


jsp页面
 <div class="header-info">

                            共<span class="info-number">[${pageBean .totalCount}]</span>条结果，

                            分成<span class="info-number">[${pageBean.totalPage}]</span>页显示，

                            当前第<span class="info-number">[${pageBean.currentPage}]</span>页.

           <c:if test="${pageBean.currentPage ne 1}">

           [<a href="${pageContext.request.contextPath }/user_listpage?currentPage=${pageBean.currentPage-1}">前一  页</a>]
   

        </c:if>

        <c:if test="${pageBean.currentPage ne pageBean.totalPage}">

           [<a href="${pageContext.request.contextPath }/user_listpage?currentPage=${pageBean.currentPage+1}">后一页</a>]   

    </c:if>     

 </div>