userinfodao.java

本平台是以web2.0为基本的标准

package com.afuer.hib.dao.orgModel.Dao;
import java.io.Serializable;
import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.dao.DataAccessException;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import com.afuer.hib.dao.orgModel.Idao.IUserInfoDao;
import com.afuer.hib.form.UserInfo;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
public class UserInfoDao extends HibernateDaoSupport implements IUserInfoDao {
	private static final Log log = LogFactory.getLog(UserInfoDao.class);
	public Serializable saveUserInfo(UserInfo userInfo) throws DataAccessException {
		     // TODO Auto-generated method stub
		     return getHibernateTemplate().save(userInfo);
	     }
	public void updateUserInfo(UserInfo userInfo) throws DataAccessException {
	     // TODO Auto-generated method stub
	      getHibernateTemplate().update(userInfo);
    }
	public List find(final Integer id) throws DataAccessException
	{
		return (List) this.getHibernateTemplate().execute(
				new HibernateCallback() {
					public Object doInHibernate(Session session) {
						Query query = session.createQuery("from UserInfo");
						return query.list();
					}
				});
	}
	public List findFreeUsers() throws DataAccessException
	{
		return (List) this.getHibernateTemplate().execute(
				new HibernateCallback() {
					public Object doInHibernate(Session session) {
						Query query = session.createQuery("from UserInfo where free_flag='0'");
						return query.list();
					}
				});
	}
	
	public List findAll() throws DataAccessException
	{
		return (List) this.getHibernateTemplate().execute(
				new HibernateCallback() {
					public Object doInHibernate(Session session) {
						Query query = session.createQuery("from UserInfo");
						return query.list();
					}
				});
	}

	public List find(UserInfo userInfo) throws DataAccessException {
		return find(userInfo.getId());
	  }
	
	public UserInfo get(final Integer id) throws DataAccessException {
		// TODO Auto-generated method stub
		return (UserInfo) this.getHibernateTemplate().execute(
				new HibernateCallback() {
					public Object doInHibernate(Session session) {
						UserInfo userinfo = (UserInfo)session
						.createQuery("from UserInfo where id="+id)
						.uniqueResult();
						return userinfo;
					}
				});
	}
	public UserInfo getUserInfo(final String loginname) throws DataAccessException {
		// TODO Auto-generated method stub
		return (UserInfo) this.getHibernateTemplate().execute(
				new HibernateCallback() {
					public Object doInHibernate(Session session) {
						UserInfo userinfo = (UserInfo)session
						.createQuery("from UserInfo where loginname='"+loginname+"'")
						.uniqueResult();
						return userinfo;
					}
				});
	}
	public void deleteUserInfo(final Integer id) throws DataAccessException {
		   // TODO Auto-generated method stub
		  log.warn("user delete.............................");
		this.getHibernateTemplate().execute(new HibernateCallback() {
			public Object doInHibernate(Session session) {
				Query query = session
						.createQuery("delete UserInfo where id =:Rid");
				query.setInteger("Rid", id.intValue());
				query.executeUpdate();
				return null;
			}
		});
	}
	  public Integer getAccounts(final String loginName,final String password)throws DataAccessException
	    {
	       return (Integer) this.getHibernateTemplate().execute(
					new HibernateCallback() {
						 public Object doInHibernate(Session session) {
							Query query = session.createQuery
							("select count(*) as b from UserInfo where" +
									" loginname='"+loginName+"' and password='"+password+"'");
							Integer count=(Integer)query.uniqueResult();
						     return count;
						}
					});
	    }
	

}