c33btreedao.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;

public class c33BtreeDao extends HibernateDaoSupport {
	
	 public List getBtree1(Long year)
	    {
		 	Long yea=new Long(year.longValue()+1911);
	    	List L1=getHibernateTemplate().find("from Btree c where c.id.year="+yea+"and c.lvl=1");
	    	
	        return L1;
	    	  
	    }
	 public Btree getBtree(Long year,String nodeId)
	    {
		 	Long yea=new Long(year.longValue()+1911);
	    	List L1=getHibernateTemplate().find("from Btree c where c.id.year="+yea+"and c.id.nodeId='"+nodeId+"'");
	    	if(L1.size()>0){
	    		Btree btree=(Btree)L1.get(0);
	    		return btree;
	    	}
	    	else
	        return null;
	    	  
	    }
	 
	
		
		// 根据node,year寻找下一层子节点
		public List GetNodeByParent(String parentId,Long year,Long lvl){
			Long yea=new Long(year.longValue()+1911);
			List l;
			
			 l = getHibernateTemplate().find("from Btree c where c.parentId='"+parentId+"' and c.id.year="+yea+" and c.lvl="+lvl);
			return l;	
		
			
		}
		
		
		
			
		
		
		
//		 根据节点id,year寻找它同层所有子节点 
		
		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 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(),btree.getId().getYear());
					l.addAll(ltemp);
				}
			}
			return l;
		}
//		 根据node,year寻找下一层子节点
		public List GetNodeByParent(String parentId,Long year){
			
			List l;
			
				l = getHibernateTemplate().find("from Btree c where c.parentId='"+parentId+"' and c.id.year="+year);
				return l;
			
			
		} 

}