revertdaoimp.java

jaguey,网上的一个朋友给我的

package net.javapassion.jaguey.dao.imp;

import java.util.List;
import org.springframework.dao.DataAccessException;
import org.springframework.orm.hibernate.HibernateCallback;
import org.springframework.orm.hibernate.support.HibernateDaoSupport;
import net.sf.hibernate.Query;
import net.sf.hibernate.Session;
import net.sf.hibernate.HibernateException;
import net.javapassion.jaguey.domain.Revert;
import net.javapassion.jaguey.dao.RevertDao;

//版本: JagueyBBS 1.1
//功能: 论坛回复帖子数据操作实现
//作者: 赵程佳
//时间: 2006-02-09 18:39:47

public class RevertDaoImp extends HibernateDaoSupport implements RevertDao {

	//保存回复帖子
	public void saveRevert(Revert revert) throws DataAccessException {
		getHibernateTemplate().saveOrUpdate(revert);
	}
	
	//删除回复帖子
	public void deleteRevert(Revert revert) throws DataAccessException {
		getHibernateTemplate().delete(revert);
	}
	
	//通过主键获取回复帖子
	public Revert getRevertById(String revertId) throws DataAccessException {
		return (Revert) getHibernateTemplate().get(Revert.class, revertId);
	}
	
	//获取所有回复帖子
	public List getReverts() {
		return getHibernateTemplate().find("from Revert");
	}
	
	//获取特定主题下的回复帖子
	public List getRevertByTopicId(String topicId) throws DataAccessException {
		return getHibernateTemplate().find("from Revert as revert where revert.topic.topicId=? order by revert.orderId asc", topicId);
	}
	
	//获取特定用户发表的回复帖子
	public List getRevertByUsername(String userName) throws DataAccessException {
		return getHibernateTemplate().find("from Revert as revert where revert.userName=?", userName);
	}
	
	//获取特定主题下某页的回复帖子
	public List getRevert(final String topicId, final int pageSize, final int pageNumber) throws DataAccessException {
	    return getHibernateTemplate().executeFind(new HibernateCallback() {
	    	public Object doInHibernate(Session s) throws HibernateException {
	    		String hql = "from Revert as revert where revert.topic.topicId=" + topicId + " order by revert.orderId asc";
	    		Query query = s.createQuery(hql);
	    		query.setMaxResults(pageSize);
	    		query.setFirstResult(pageSize * pageNumber);
	    		List list = query.list();
	    		return list;
	    	}
	    });
	}
	
	//获取类似主键中日期部分的回复帖子
	public List getRevertByLikeId(String date) throws DataAccessException {
		return getHibernateTemplate().find("from Revert as revert where revert.revertId like '?%'");
	}
	
	//获取特定日期发表的回复帖子
	public List getRevertByLikeApply(String date) throws DataAccessException {
		return getHibernateTemplate().find("from Revert as revert where revert.appearTime like '?%'");
	}
}