【Hibernate】Hibernate真分页实现_this.gethibernatetemplate().execute(是真分页吗-优快云博客

本文链接：https://blog.youkuaiyun.com/srk950606/article/details/74608018

本文介绍了一个使用SSH框架进行分页处理的方法。通过自定义PageHibernateCallback类与PageBean类，实现了对数据库查询结果的有效分页展示。文章详细展示了DAO层与ACTION层的实现方式，并提供了页面上的分页导航示例。

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

【前言】

这几乎是一个网站类项目逃不掉的技术点——分页，因为项目用的是ssh的框架，所以总结一下Hibernate的分页功能。

【正文】

先贴上两个引用的工具类PageBean和PageHibernateCallback：

package com.tgb.dmtOS.utils;
import java.sql.SQLException;
import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.HibernateCallback;

public class PageHibernateCallback<T> implements HibernateCallback<List<T>>{
	
	private String hql;
	private Object[] params;
	private int startIndex;
	private int pageSize;
	

	public PageHibernateCallback(String hql, Object[] params,
			int startIndex, int pageSize) {
		super();
		this.hql = hql;
		this.params = params;
		this.startIndex = startIndex;
		this.pageSize = pageSize;
	}



	public List<T> doInHibernate(Session session) throws HibernateException,
			SQLException {
		//1 ִ��hql���
		Query query = session.createQuery(hql);
		//2 ʵ�ʲ���
		if(params != null){
			for(int i = 0 ; i < params.length ; i ++){
				query.setParameter(i, params[i]);
			}
		}
		//3 ��ҳ
		query.setFirstResult(startIndex);
		query.setMaxResults(pageSize);
		
		return query.list();
	}

}

package com.tgb.dmtOS.utils;
import java.util.List;

import com.tgb.dmtOS.adminnews.vo.AdminNews;
//��ҳ��ķ�װ
public class PageBean<T> {
	private int page;    //��ǰҳ�� 
	private int totalCount;  //�ܼ�¼��
	private int totalPage;  //�ܵ�ҳ��
	private int limit;      //ÿҳ��ʾ��¼��
	private List<T> list;//ÿҳ��ʾ��ݵļ���
	public int getPage() {
		return page;
	}
	public void setPage(int page) {
		this.page = page;
	}
	public int getTotalCount() {
		return totalCount;
	}
	public void setTotalCount(int totalCount) {
		this.totalCount = totalCount;
	}
	public int getTotalPage() {
		return totalPage;
	}
	public void setTotalPage(int totalPage) {
		this.totalPage = totalPage;
	}
	public int getLimit() {
		return limit;
	}
	public void setLimit(int limit) {
		this.limit = limit;
	}
	public List<T> getList() {
		return list;
	}
	public void setList(List<T> list) {
		this.list = list;
	}
	
	
}

DAO层

	public List<Article> findByPage(int begin,int limit){
		String hql="from Article order by Time desc";
		List<Article> list=this.getHibernateTemplate().execute(new PageHibernateCallback<Article>(hql,null,begin,limit));
		if (list != null && !list.isEmpty()) {
			return list;
		}	
		return null;
	}

ACTION

	private Integer page;
		
	public void setPage(Integer page) {
		this.page = page;
	}

public String findAll(){
			List<Category> cList =categoryService.findAll();
			ActionContext.getContext().getValueStack().set("cList",cList);		
			PageBean<Article> pageBean = adminArticleService.findByPage(page); 
			ActionContext.getContext().getValueStack().set("pageBean", pageBean);
			return "findAll";
		}

页面：

		<tr align="center">
						<td colspan="4">
							第<s:property value="pageBean.page"/>/<s:property value="pageBean.totalPage"/>页						
							<s:if test="pageBean.page != 1">							
								<a href="${pageContext.request.contextPath }/adminArticle_findAll.action?page=1">首页</a>|
								<a href="${pageContext.request.contextPath }/adminArticle_findAll.action?page=<s:property value="pageBean.page-1"/>">上一页</a>|
								
							</s:if>
							<s:if test="pageBean.page != pageBean.totalPage">	
							<a href="${pageContext.request.contextPath }/adminArticle_findAll.action?page=<s:property value="pageBean.page+1"/>">下一页</a>|
							<a href="${pageContext.request.contextPath }/adminArticle_findAll.action?page=<s:property value="pageBean.totalPage"/>">尾页</a>
							</s:if>
						</td>
					</tr>