topicdaoimp.java

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

package net.javapassion.jaguey.dao.imp;

import java.util.List;
import java.util.Date;
import java.util.ArrayList;
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.Topic;
import net.javapassion.jaguey.dao.TopicDao;

//版本: JagueyBBS 1.1
//功能: 论坛主题帖子数据操作实现
//作者: 赵程佳
//时间: 2006-02-09 19:06:09

public class TopicDaoImp extends HibernateDaoSupport implements TopicDao {

	//保存主题帖子
	public void saveTopic(Topic topic) throws DataAccessException {
		getHibernateTemplate().saveOrUpdate(topic);
	}
	
	//删除主题帖子
	public void deleteTopic(Topic topic) throws DataAccessException {
		getHibernateTemplate().delete(topic);
	}
	
	//获取特定论坛版面下的主题帖子并排序
	public List getTopicByBoard(String boardId) throws DataAccessException {
		return getHibernateTemplate().find("from Topic as topic where topic.board.boardId=? order by topic.orderId asc", boardId);
	}
	
	//通过主键编号获取主题帖子
	public Topic getTopicById(String topicId) throws DataAccessException {
		return (Topic) getHibernateTemplate().get(Topic.class, topicId);
	}
	
	//获取主题帖子总数量
	public int getTopicCount() throws DataAccessException {
		List count = getHibernateTemplate().find("from Topic");
		return count.size();
	}
	
	//获取特定日期发表的主题帖子
	public List getTopicByLikeApply(String date) throws DataAccessException {
		return getHibernateTemplate().find("from Topic as topic where topic.appearTime like '?%'", date);
	}
	
	//获取所有精华主题帖子
	public List getTopicByGood(Integer goodFlag) throws DataAccessException {
		return getHibernateTemplate().find("from Topic as topic where topic.goodFlag=?", goodFlag);
	}
	
	//获取特定日期时间发表的主题帖子
	public List getTopicByApply(Date date) throws DataAccessException {
		return getHibernateTemplate().find("from Topic as topic where topic.appearTime=?", date);
	}
	
	//获取特定用户发表的主题帖子
	public List getTopicByUser(String userName) throws DataAccessException {
		return getHibernateTemplate().find("from Topic as topic where topic.userName=?", userName);
	}
	
	//获取特定用户发表的精华主题帖子
	public List getGoodByUser(String userName) throws DataAccessException {
		return getHibernateTemplate().find("from Topic as topic where topic.userName=? and topic.goodFlag=1", userName);
	}
	
	//获取特定版面的精华或非精华主题帖子
	public List getTopicByBoardGood(String boardId, Integer goodFlag) throws DataAccessException {
		Object para[]=new Object[]{boardId, goodFlag};
		return getHibernateTemplate().find("from Topic as topic where topic.board.boardId=? and topic.goodFlag=?", para);
	}
	
	//获取特定版面的置顶主题帖子
	public List getTopByBoard(String boardId) throws DataAccessException {
		List result=new ArrayList();
	    List first=getHibernateTemplate().find("from Topic as topic where topic.topFlag=3");
	    List second=getHibernateTemplate().find("from Topic as topic inner join Board as board where topic.topFlag=2 and board.assort.assortId=(select board.assort.assortId where board.boardId=?)", boardId);
	    List third=getHibernateTemplate().find("from Topic as topic where topic.board.boardId=? and topic.topFlag=1", boardId);
	    result.addAll(first);//加入总置顶
	    result.addAll(second);//加入当前分区置顶
	    result.addAll(third);//加入当前版面置顶
	    return result;
	}
	
	//获取特定版面下某页的主题帖子
	public List getTopic(final String boardId, final int pageSize, final int pageNumber) throws DataAccessException {
		return getHibernateTemplate().executeFind(new HibernateCallback() {
			public Object doInHibernate(Session s) throws HibernateException {
				String hql = "from Topic as topic where topic.board.boardId=" + boardId + " and topic.topFlag=0 order by topic.orderId asc";
				Query query = s.createQuery(hql);
				query.setMaxResults(pageSize);
				query.setFirstResult(pageSize * pageNumber);
				List list = query.list();
				return list;
			}
		});
	}
	
	//获取类似主键中日期部分的主题帖子
	public List getTopicByLikeId(String date) throws DataAccessException {
		return getHibernateTemplate().find("from Topic as topic where topic.topicId like '?%'", date);
	}
}