colltopicdaoimp.java

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

package net.javapassion.jaguey.dao.imp;

import java.util.List;
import org.springframework.dao.DataAccessException;
import org.springframework.orm.hibernate.support.HibernateDaoSupport;
import net.javapassion.jaguey.domain.CollTopic;
import net.javapassion.jaguey.dao.CollTopicDao;

//版本: JagueyBBS 1.1
//功能: 论坛帖子收藏数据操作实现
//作者: 赵程佳
//时间: 2006-02-09 15:44:46

public class CollTopicDaoImp extends HibernateDaoSupport implements CollTopicDao {

	//保存帖子收藏
	public void saveCollTopic(CollTopic collTopic) throws DataAccessException {
		getHibernateTemplate().saveOrUpdate(collTopic);
	}
	
	//删除帖子收藏
	public void deleteCollTopic(CollTopic collTopic) throws DataAccessException {
		getHibernateTemplate().delete(collTopic);
	}
	
	//通过主键收藏编号获取收藏帖子
	public CollTopic getCollTopicById(String collId) throws DataAccessException {
		return (CollTopic) getHibernateTemplate().get(CollTopic.class, collId);
	}
	
	//获取特定用户的收藏帖子
	public List getCollTopicByUser(Long userId) throws DataAccessException {
		return getHibernateTemplate().find("from CollTopic as collTopic where collTopic.collUser=?", userId);
	}
	
	//获取特定帖子被收藏的次数
	public int getCollCountByTopicId(String topicId) throws DataAccessException {
		List count = getHibernateTemplate().find("from CollTopic as collTopic where collTopic.collTopicId=?", topicId);
		return count.size();
	}
	
	//获取类似主键中日期部分的收藏帖子
	public List getCollTopicLikeId(String date) throws DataAccessException {
		return getHibernateTemplate().find("from CollTopic as collTopic where collTopic.collId like '?%'", date);
	}
}