atreedao.java

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

package com.je.ims.dao;

import java.sql.SQLException;
import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.je.ims.hibernate.*;
public class ATreeDAO extends HibernateDaoSupport {
	
	//删除所有记录，做实验用
	public void Delete(){
		getHibernateTemplate().deleteAll(getHibernateTemplate().loadAll(Atree.class));
	}
	
	public ATreeDAO() {
		super();
	}
	
	//	新增
	public void AddAtree(Atree atree){
		getHibernateTemplate().save(atree);
	}
	
	// 更新
	public void UpdateAtree(Atree atree){
		getHibernateTemplate().update(atree);
	}
	
	//	 根据节点id,year寻找它同层所有子节点 
	public List GetNodeByParentSameLvl(String parentId,Long year){
		if (!parentId.equals("root")){
			Atree atree = this.GetByNodeId(parentId,year);
			Long lvl = atree.getLvl();
			List l = getHibernateTemplate().find("from Atree where parentId='"+parentId+"' and id.year="+year+" and lvl="+lvl);
			return l;
		}
		return null;
	}
	
	//	 根据节点id,year寻找它下一层所有子节点 
	public List GetNodeByParentNextLvl(String parentId,Long year){
		Long lvl;
		if(!parentId.equals("root"))
		{
			Atree atree = this.GetByNodeId(parentId,year);
			lvl = atree.getLvl();
			lvl = new Long(lvl.longValue()+1);
		}
		else
			lvl = new Long(1);
		List l = getHibernateTemplate().find("from Atree where parentId='"+parentId+"' and id.year="+year+" and lvl="+lvl);
		return l;
		
	}
	// 根据节点id,year寻找它所有子节点 
	public List GetNodeByParent(String parentId,Long year){
		
		List l = getHibernateTemplate().find("from Atree where parentId='"+parentId+"' and id.year="+year);
		return l;
	}
	
	// 判断一个节点时候有子节点,如果有返回true,否则返回false
	public boolean IsNode(Atree atree){
		List l = getHibernateTemplate().find("from Atree where parentId='"+atree.getId().getNodeId()+"' and id.year="+atree.getId().getYear());
		if (l.size()>0)
		return true;
		return false;
	}
	
	// 根据父节点Id来选出所有子节点信息
	public List GetAllByParent(String parentId,Long year){
	
		Atree atree = new Atree();
		List l = this.GetNodeByParent(parentId,year);
		int n = l.size();
		List ltemp;
		if (l.size()>0){
			for (int i=0;i<n;i++){
				atree = (Atree)l.get(i);
				ltemp = this.GetAllByParent(atree.getId().getNodeId(),year);
				l.addAll(ltemp);
			}
		}
		return l;
	}
	
	//   返回子节点中层别最大值
	public int GetTheLargeLvl(String parentId,Long year){
		List l = this.GetAllByParent(parentId,year);
		int lvl = 0;
		Atree atree;
		for (int i=0;i<l.size();i++){
			atree = (Atree)l.get(i);
			if (atree.getLvl().intValue()>lvl){
				lvl = atree.getLvl().intValue();
			}
		}
		return lvl;
	}
	
	//  设置字节点的层数
	public void SetChildLvl(String parentId,Long year,int sublvl){
		List l = this.GetAllByParent(parentId,year);
		//int lvl = 0;
		Long lvl;
		Atree atree;
		for (int i=0;i<l.size();i++){
			atree = (Atree)l.get(i);
			lvl = new Long(atree.getLvl().intValue()+sublvl);
			atree.setLvl(lvl);
			this.getHibernateTemplate().update(atree);
		}
	}
	
	//  设置字节点的privilegeId
	public void SetChildPrivilegeId(String parentId,Long year,String pid){
		List l = this.GetAllByParent(parentId,year);
		Atree atree;
		for (int i=0;i<l.size();i++){
			atree = (Atree)l.get(i);
			atree.setPrivilegeId(pid);
			this.getHibernateTemplate().update(atree);
		}
	}
	
	//	 根据父节点Id来选出所有子节点信息
	public List GetAllByParent(String[] parentId,Long year){
	
		List l = this.GetAllByParent("root",year);
		
		int n = parentId.length;
		List ltemp;
		if (l.size()>0){
			for (int i=0;i<n;i++){
				l.add(this.GetByNodeId(parentId[i],year));
				ltemp = this.GetAllByParent(parentId[i],year);
				l.addAll(ltemp);
			}
		}
		return l;
		
	}
	
	//根据id,year返回Atree对象
	public Atree GetByNodeId(String id,Long year){
		
		List l = getHibernateTemplate().find("from Atree where id.nodeId='"+id+"' and id.year="+year);
		if(l.size()!=1)
			return null;
		return (Atree)l.get(0);
	}
	
	//删除节点，同时要删除其所有子节点
	public void DeleteNode(final String id,final Long year){
		
		final List l = GetNodeByParent(id,year);
		getHibernateTemplate().execute(new HibernateCallback(){
			public Object doInHibernate(Session session) throws HibernateException { 
				for (int i =0;i<l.size();i++){
					DeleteNode(((Atree)l.get(i)).getId().getNodeId(),year);
				}
				getHibernateTemplate().delete(GetByNodeId(id,year));
					return null;      
			}
		});  
	}
	
	public List GetAllParent(Long year,String nodeId){
		List l = getHibernateTemplate().find("from Atree where lvl < 4 and id.year="+year);
		for (int i=0;i<l.size();i++){
			if (((Atree)l.get(i)).getId().getNodeId().equals(nodeId)){
				l.remove(i);
			}
		}
		return l;
	}
}