personroledaohibernateimpl.java

用JSF.Spring和Hibernate开发的一个办公用品管理系统的WEB应用。

package com.jsfabc.jsh.model.dao.hibernateImpl;


import java.util.Collection;
import java.util.List;


import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.springframework.dao.DataAccessException;

import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.jsfabc.jsh.model.dao.PersonRoleDao;

public class PersonRoleDaoHibernateImpl extends HibernateDaoSupport implements PersonRoleDao {
	
    public List findRoles() throws DataAccessException {
    	return (List)getHibernateTemplate().find("from Role");
    }

    public List findUserRoles(String personId) throws DataAccessException {
    	String hql="from PersonRole where personId=?";
    	
    	return (List)getHibernateTemplate().find(hql,personId);
    }

    public List findUserRolesForDel(String personId) throws DataAccessException {
    	String hql="from PersonRole where personId=? and personId<>'admin'";
    	
    	return (List)getHibernateTemplate().find(hql,personId);
    }    
    
    public void deleteUserRoles(Collection userRoles)throws DataAccessException{
    	getHibernateTemplate().deleteAll(userRoles);
    	
    }

    public void saveUserRoles(Collection userRoles)throws DataAccessException{
    	getHibernateTemplate().saveOrUpdateAll(userRoles);
    }
    
    public Integer findPersonRoles(final String personId){
		return (Integer)getHibernateTemplate().execute(
				new HibernateCallback(){
					public Object doInHibernate(Session session)throws HibernateException{
					   
						String sSql=" delete from personRole where personId=? ";
						int i=session.createSQLQuery(sSql).setString(0, personId).executeUpdate();
						return new Integer(i);
											
						
					}
				}
			,true);	
	}



    
}