c852logindao.java

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

package com.je.ims.dao;

import java.util.List;

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

import com.je.ims.hibernate.Menu;
import com.je.ims.hibernate.Role;
import com.je.ims.hibernate.RoleMember;

public class C852LoginDAO extends HibernateDaoSupport {
	public List getUserById(String userid)
	{
		String hql="from RoleMember where id.userId=?";
		List list=getHibernateTemplate().find(hql,userid);
		return list;
	}
	public List getMenuByRoleType(Long roletype)
	{
		String hql="from RoleTypeMenu where id.roleTypeId=?";
		List list=getHibernateTemplate().find(hql,roletype);
		return list;
	}
	public Menu getMenuByMenuId(String menuid)
	{
		String hql="from Menu where menuId=?";
		List list=getHibernateTemplate().find(hql,menuid);
		Menu menu=null;
		if(list.size()>0)
		menu=(Menu)list.get(0);
		return menu;
	}
	public Menu getMenuByMenuName(String menuname)
	{
		String hql="from Menu where menuName=?";
		List list=getHibernateTemplate().find(hql,menuname);
		Menu menu=null;
		if(list.size()>0)
		menu=(Menu)list.get(0);
		return menu;
	}
	public List getAgents(String userid)
	{
		String hql="from Agent where id.agentId=?";
		List list=getHibernateTemplate().find(hql,userid);
		return list;
	}
	public RoleMember getMember(String roleid,Long roletypeid,String userid)
	{
		String hql="from RoleMember where id.roleId=? and id.roleTypeId=? and id.userId=?";
		List list=getHibernateTemplate().find(hql,new Object[]{roleid,roletypeid,userid});
		if(list!=null&&list.size()!=0)
		{
			RoleMember member=(RoleMember)list.get(0);
			return member;
		}
		return null;
	}
	public Role getRole(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=(Role)list.get(0);
		return role;
	}
}