userinfodaoimp.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.UserInfo;
import net.javapassion.jaguey.dao.UserInfoDao;

//版本: JagueyBBS 1.1
//功能: 论坛用户数据操作实现
//作者: 赵程佳
//时间: 2006-02-09 19:43:17

public class UserInfoDaoImp extends HibernateDaoSupport implements UserInfoDao {

	//保存用户
	public void saveUserInfo(UserInfo userInfo) throws DataAccessException {
		getHibernateTemplate().saveOrUpdate(userInfo);
	}
	
	//删除用户
	public void deleteUserInfo(UserInfo userInfo) throws DataAccessException {
		getHibernateTemplate().delete(userInfo);
	}
	
	//获取所有用户
	public List getUserInfos() throws DataAccessException {
		return getHibernateTemplate().find("from UserInfo");
	}
	
	//获取某页的用户
	public List getUserInfos(final int pageSize, final int pageNumber) throws DataAccessException {
		return getHibernateTemplate().executeFind(new HibernateCallback() {
			public Object doInHibernate(Session s) throws HibernateException {
				Query query = s.createQuery("from UserInfo");
			    query.setMaxResults(pageSize);
			    query.setFirstResult(pageSize * pageNumber);
			    List list = query.list();
			    return list;
			}
		});
	}
	
	//通过主键编号获取用户
	public UserInfo getUserInfoById(Long userId) throws DataAccessException {
		return (UserInfo) getHibernateTemplate().get(UserInfo.class, userId);
	}
	
	//获取特定角色下的用户
	public List getUserInfoByRole(Integer roleId) throws DataAccessException {
		return getHibernateTemplate().find("from UserInfo as userInfo where userInfo.userRole.roleId=?", roleId);
	}
	
	//获取类似用户名称的用户
	public List getUserInfoByLikeName(String userName) throws DataAccessException {
		return getHibernateTemplate().find("from UserInfo as userInfo where userInfo.userName like '%?%'", userName);
	}
	
	//获取最后一个用户
	public UserInfo getUserInfoLast() throws DataAccessException {
		return (UserInfo) getHibernateTemplate().find("from UserInfo as userInfo order by userInfo.userId desc");
	}
	
	//通过名称获取用户
	public UserInfo getUserInfoByName(String userName) throws DataAccessException {
		return (UserInfo) getHibernateTemplate().find("from UserInfo as userInfo where userInfo.userName=?", userName);
	}
}