infoboxdaoimp.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.InfoBox;
import net.javapassion.jaguey.dao.InfoBoxDao;

//版本: JagueyBBS 1.1
//功能: 论坛短信息数据操作实现
//作者: 赵程佳
//时间: 2006-02-09 17:05:44

public class InfoBoxDaoImp extends HibernateDaoSupport implements InfoBoxDao {

	//保存短信息
	public void saveInfoBox(InfoBox infoBox) throws DataAccessException {
		getHibernateTemplate().save(infoBox);
	}
	
	//删除短信息
	public void deleteInfoBox(InfoBox infoBox) throws DataAccessException {
		getHibernateTemplate().delete(infoBox);
	}
	
	//获取特定用户的短信息
	public List getInfoBoxByUserId(Long userId) throws DataAccessException {
		return getHibernateTemplate().find("from InfoBox as infoBox where infoBox.toUser=?", userId);
	}
	
	//通过主键获取短信息
	public InfoBox getInfoBoxById(String infoId) throws DataAccessException {
		return (InfoBox) getHibernateTemplate().get(InfoBox.class, infoId);
	}
	
	//通过用户与是否阅读获取短信息
	public List getInfoBoxByUserRead(Long userId, Integer readFlag) throws DataAccessException {
		Object para[]=new Object[]{userId, readFlag};
		return getHibernateTemplate().find("from InfoBox as infoBox where infoBox.toUser=? and infoBox.readFlag=?", para);
	}
	
	//获取类似主键中日期部分的短信息
	public List getInfoBoxByLikeId(String date) throws DataAccessException {
		return getHibernateTemplate().find("from InfoBox as infoBox where infoBox.infoId like '?%'", date);
	}
}