c88roletypedao.java

使用spring ,hibernate 框架的稽查管理系统

package com.je.ims.dao;

import java.util.List;

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

import com.je.ims.hibernate.Role;
import com.je.ims.hibernate.RoleType;

public class C88RoleTypeDAO extends HibernateDaoSupport{

	public C88RoleTypeDAO() {
		super();
	}

	public List GetAll(){
		String hql="from RoleType order by roleTypeId";
		List list=this.getHibernateTemplate().find(hql);
		return list;
	}
	 public String GetNameByID(Long ID)
	    {
	        List L1=getHibernateTemplate().find("select roleTypeName from RoleType where roleTypeId="+ID);
	        if (L1.size()>0)
	        	return (String)L1.get(0);
	        else return null;
	    }
	 public RoleType GetObjByID(Long ID)
	    {
	        List L1=getHibernateTemplate().find("from RoleType where roleTypeId="+ID);
	        if (L1.size()>0)
	        	return (RoleType)L1.get(0);
	        else return null;
	    }
//	8獲取沒有被刪除的角色
		public List getRole(){
			try{
				Long l=new Long(0);
				List list=getHibernateTemplate().find("from Role where isDelete="+l);
				return list;
			}
			catch(Exception e){
				System.out.println(e);
				return null;
			}
		}
//		5從資料庫中獲得角色成員
		public List getRoleMember(){
				List list=getHibernateTemplate().find("from RoleMember");
				return list;
		}
		
		public List getNodeId(String userId){
			List list=getHibernateTemplate().find("select role from RoleMember rm , Role role where rm.id.roleTypeId=role.id.roleTypeId and rm.id.roleId=role.id.roleId and rm.id.userId = '" + userId + "'");
			if (list.size()>0)
				return list;
			else 
				return null;
		}
		public Role getRole(Long roleTypeId,String roleId){
			Long l=new Long(0);
			List list = getHibernateTemplate().find("from Role as r where r.id.roleTypeId="+roleTypeId+" and r.id.roleId='"+roleId+"'"+"and r.isDelete="+l);
			Role role=new Role();
			if(list.size()>0){
				role=(Role)list.get(0);
				return role;
			}
			return role;
		}
}