onlinedaoimp.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.Online;
import net.javapassion.jaguey.dao.OnlineDao;

//版本: JagueyBBS 1.1
//功能: 论坛在线数据操作实现
//作者: 赵程佳
//时间: 2006-02-09 18:29:03

public class OnlineDaoImp extends HibernateDaoSupport implements OnlineDao {

	//保存在线
	public void saveOnline(Online online) throws DataAccessException {
		getHibernateTemplate().saveOrUpdate(online);
	}
	
	//删除在线
	public void deleteOnline(Online online) throws DataAccessException {
		getHibernateTemplate().delete(online);
	}
	
	//获取所有在线
	public List getOnlines() throws DataAccessException {
		return getHibernateTemplate().find("from Online");
	}
	
	//获取游客在线人数
	public int getFeOnlineCount() throws DataAccessException {
		List feList = getHibernateTemplate().find("from Online as online where online.userName=?", "游客");
		return feList.size();
	}
	
	//通过用户名获取在线
	public Online getOnlineByUser(String userName) throws DataAccessException {
		return (Online) getHibernateTemplate().find("from Online as online where online.userName=?", userName);
	}
	
	//通过主键获取在线
	public Online getOnlineById(String onlineId) throws DataAccessException {
		return (Online) getHibernateTemplate().get(Online.class, onlineId);
	}
	
	//获取类似主键中日期部分的在线
	public List getOnlineByLikeId(String date) throws DataAccessException {
		return getHibernateTemplate().find("from Online as online where online.onlineId like '?%'", date);
	}
}