c35btreedao.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 c35BtreeDao extends HibernateDaoSupport {
	
	 public List getBtree1(Long year)
	    {
	    	List L1=getHibernateTemplate().find("from Btree c where c.id.year="+year+"and c.lvl=1");
	    	
	        return L1;
	    	  
	    }
	 public Btree getBtree(Long year,String nodeId)
	    {
	    	List L1=getHibernateTemplate().find("from Btree c where c.id.year="+year+"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){
			
			List l;
			
			 l = getHibernateTemplate().find("from Btree c where c.parentId='"+parentId+"' and c.id.year="+year+" 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;
		}

}