c87agentdao.java

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

package com.je.ims.dao;

import java.util.HashSet;
import java.util.List;
import java.util.Set;

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

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

public class C87AgentDAO extends HibernateDaoSupport {
	public List getAgentByUserId(String userid,String roleid,Long roletypeid){
		String hql="from Agent where id.userId=? and id.roleId=? and id.roleTypeId=?";
		List list=getHibernateTemplate().find(hql,new Object[]{userid,roleid,roletypeid});
		return list;
	}
	public List getAgentByPk(String userid,String roleid,Long roletypeid)
	{
		String hql="from Agent where id.userId=? and id.roleId=? and id.roleTypeId=?";
		List list=getHibernateTemplate().find(hql,new Object[]{userid,roleid,roletypeid});
		return list;
	}
	public void delAgent(String userid,String roleid,String agentid,Long roletypeid)
	{
		String hql="from Agent where id.userId=? and id.roleId=? and id.agentId=? and id.roleTypeId=?";
		List list=getHibernateTemplate().find(hql,new Object[]{userid,roleid,agentid,roletypeid});
	if(list.size()>0)getHibernateTemplate().deleteAll(list);
		}
	public List getRoleByAgent(String userid)
	{		
		Set set=new HashSet();
		String hql="from Agent where id.userId=?";
		List list=getHibernateTemplate().find(hql,userid);
		for(int i=0;i<list.size();i++)
		{
			Agent agent=(Agent)list.get(i);
			set.add(agent.getId().getRoleId());
		}
		Object[] role=set.toArray();
		list.clear();
		for(int j=0;j<role.length;j++)
			list.add(role[j]);
		return list;
	}
	public Agent getAgentByPk(String userid,String roleid,String agentid,Long roletypeid)
	{
        Agent agent=null;
		String hql="from Agent where id.userId=? and id.roleId=? and id.agentId=? and id.roleTypeId=?";
     List list=getHibernateTemplate().find(hql,new Object[]{userid,roleid,agentid,roletypeid});
	 agent=(Agent)list.get(0);
	 return agent;
	}
   public void saveAgent(Agent agent){
	   getHibernateTemplate().saveOrUpdate(agent);
   }
   public List getRolesByUserid(String userid)
   {
	   String hql="from RoleMember where id.userId=?";
	  List list=getHibernateTemplate().find(hql,userid);
	  return list;
   }
   public long getAgentByRoleType(Long roletypeid)
   {
	   String hql="from RoleType where roleTypeId=?";
	   List list=getHibernateTemplate().find(hql,roletypeid);
	   Long isAgent=((RoleType)list.get(0)).getIsAgent();
	   return isAgent.longValue();
   }
   public String getRoleName(String roleid)
   {
	   String rolename=null;
	   String hql="from Role where id.roleId=?";
	   List list=getHibernateTemplate().find(hql,roleid);
       if(list.size()>0){
    	   Role role=(Role)list.get(0);
    	  rolename=role.getRoleName();
       }
return rolename;
   }
   public List getRoleByUserid(String userid)
   {
	   String hql="from Agent where id.userId=?";
	   List list=getHibernateTemplate().find(hql,userid);
	   return list;
   }
   public Role getRoleByPk(Long roletypeid,String roleid)
   {
	   String hql="from Role where id.roleTypeId=? and id.roleId=?";
	   List list=getHibernateTemplate().find(hql,new Object[]{roletypeid,roleid});
	   Role role=null;
	   if(list!=null&&list.size()>0)
	   role=(Role)list.get(0);
	   return role;
   }
   public List getRoleByUserId(String userid)
   {
	   String hql="from Role where userId=?";
	   List list=null;
	   list=getHibernateTemplate().find(hql,userid);
       return list;
   }
}