nsrolehibernatedao.java

一个成熟的论坛

package com.singnet.dao.hibernate;

import java.util.List;

import com.singnet.bean.NsRole;
import com.singnet.dao.INsRoleDAO;

public class NsRoleHibernateDAO extends BaseHibernateDAO implements INsRoleDAO
{

	public List findAllRoles(String userID)
	{
		// TODO Auto-generated method stub
		String hql = "from NsRole r where r.roleUserid=?";		
		return getHibernateTemplate().find(hql, userID);
	}

	public List findUserIDsByRole(int roleType)
	{
		// TODO Auto-generated method stub
		String roleName = getRoleName(roleType);
		if(roleName == null) return null;
		String hql = "from NsRole r where r." + roleName + "=?";
		
		return getHibernateTemplate().find(hql, new Integer(NsRole.ROLE_ENABLE));
	}
	
	private String getRoleName(int roleType) 
	{
		if(NsRole.ROLE_ADMIN == roleType) 
			return NsRole.PROP_ROLE_ADMIN;
		else if(NsRole.ROLE_MODERATOR == roleType) 
			return NsRole.PROP_ROLE_MODERATOR;
		else if(NsRole.ROLE_SUPERADMIN == roleType)
			return NsRole.PROP_ROLE_SUPERADMIN;
		
		return null;
		
	}

}