c40dao.java

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

package com.je.ims.dao;

import java.util.List;

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

import com.je.ims.hibernate.Btree;
import com.je.ims.hibernate.Role;
import com.je.ims.hibernate.RoleId;

public class C40DAO extends HibernateDaoSupport {
public List GetAllByParent(String parentId,Long year)
{
	Btree btree = new Btree();
	List l = this.GetNodeByParent(parentId,year);
	int n = l.size();
	List ltemp;
	if (l.size()>0){
		for (int i=0;i<n;i++){
			btree = (Btree)l.get(i);
			ltemp = this.GetAllByParent(btree.getId().getNodeId(),year);
			l.addAll(ltemp);
			
		}
	}
	return l;
}
public List GetNodeByParent(String parentId,Long year){
	
	List l;
	if (!parentId.equals("root")){
		l = getHibernateTemplate().find("from Btree where parentId='"+parentId+"' and id.year="+year);
		return l;
	}
	else{
		String condition = "where btree.id.nodeId = sbtree.id.nodeId and btree.id.year = sbtree.id.year and btree.parentId='"+parentId+"' and btree.id.year="+year+" order by sbtree.showId";
		l = getHibernateTemplate().find("select new Btree(btree.id,btree.nodeName,btree.lvl,btree.parentId,btree.privilegeId) from Btree btree,ShowBtree sbtree "+condition);
		return l;
	}
}
public boolean IsNode(Btree btree){
	List l = getHibernateTemplate().find("from Btree where parentId='"+btree.getId().getNodeId()+"' and id.year="+btree.getId().getYear());
	if (l.size()>0)
	return true;
	return false;
}
public Role getRoleByPk(RoleId id)
{
	String hql="from Role where id.roleTypeId=? and id.roleId=?";
	List list=getHibernateTemplate().find(hql,new Object[]{id.getRoleTypeId(),id.getRoleId()});
	Role role=null;
	role=(Role)list.get(0);
	return role;
}
}