userorgdao.java

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

package com.afuer.hib.dao.orgModel.Dao;

import java.io.Serializable;
import java.util.ArrayList;
import java.util.Iterator;
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.IUserorgDao;
import com.afuer.hib.form.UserInfo;
import com.afuer.hib.form.Userorg;

public class UserorgDao extends HibernateDaoSupport implements IUserorgDao{

	public Serializable saveOrgUserInfo(Userorg uo) throws DataAccessException {
		// TODO Auto-generated method stub
		return this.getHibernateTemplate().save(uo);
	}

	public List find(UserInfo userInfo) throws DataAccessException {
		// TODO Auto-generated method stub
		return null;
	}

	public List findUsersByOrgId(final Integer orgid) throws DataAccessException {
		// TODO Auto-generated method stub
		return (List) this.getHibernateTemplate().execute(
				new HibernateCallback() {
					public Object doInHibernate(Session session) {
						Query query = session.createQuery("from Userorg where managertype='0' and orgid="+orgid);
						return query.list();
					}
				});
	}
	public void delOrgUser(final Integer orgid,final Integer userid)throws DataAccessException
	
	{
		this.getHibernateTemplate().execute(new HibernateCallback() {
			public Object doInHibernate(Session session) {
				Query query = session
						.createQuery("delete Userorg  where orgid="+orgid+" and userid="+userid);
				
				query.executeUpdate();
				
				return null;
			}
		});
	}
	
	public List findUserInfoByOrgId(final Integer orgid) throws DataAccessException {
		// TODO Auto-generated method stub
		  List orgList=findUsersByOrgId(orgid);
		  List temp=new ArrayList();
		  Iterator it=orgList.iterator();
		    while(it.hasNext())
		    {
		    	System.err.println("lalaolal");
		    	Userorg uo=(Userorg)it.next();
		    	final Integer id=uo.getUserid();
		    	UserInfo ui= (UserInfo) this.getHibernateTemplate().execute(
		 				new HibernateCallback() {
		 					public Object doInHibernate(Session session) {
		 						UserInfo userinfo = (UserInfo)session
		 						.createQuery("from UserInfo where id="+id)
		 						.uniqueResult();
		 						return userinfo;
		 					}
		 				});
		    	temp.add(ui);
		    }
		return   temp;
		
	}

}