c12referencedao.java

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

package com.je.ims.dao;

import java.util.List;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import com.je.ims.hibernate.Reference;

public class C12ReferenceDAO extends HibernateDaoSupport{
	
//	删除所有记录，做实验用
	public void Delete(){
		getHibernateTemplate().deleteAll(getHibernateTemplate().loadAll(Reference.class));
	}
	public void insert(Reference r){
	    	getHibernateTemplate().save(r);
	    }

	public List getNodeId2(Long year, String tree, String parentId) {
		List L1=this.getHibernateTemplate().find
		("select nodeId2 from Reference where year =? and ab = ? and nodeId = ? and isDelete = 0",new Object[] {year,tree,parentId});
		return L1;
	}
	public List getObj(Long currentYear, String tree, String nodeId ) {
		List L1=this.getHibernateTemplate().find
		("from Reference where year =? and ab =? and nodeId =? and isDelete = 0 ",new Object[] {currentYear,tree,nodeId});
		return L1;
	}
	public Reference getObj(Long currentYear, String tree, String nodeId ,String nodeId2) {
		List ref=(List) this.getHibernateTemplate().find
		("from Reference where year =? and ab =? and nodeId =? and nodeId2 =? ",new Object[] {currentYear,tree,nodeId,nodeId2});
		if(ref.size()>0)
			return (Reference) ref.get(0);
		else
			return null;
	}
	/*
	public Reference getObj(Long currentYear, String tree, String nodeId ,String nodeId2,String refType) {
		Reference ref=(Reference) this.getHibernateTemplate().find
		("from Reference where year =? and ab =? and nodeId =? and nodeId2 =? and refType = ? ",new Object[] {currentYear,tree,nodeId,nodeId2,refType});
		return ref;
	}*/
	
	public void deleteAll(Long currentYear, String tree, String nodeId ) {
	    List L1=getObj(currentYear,tree,nodeId );
	    for(int i=0;i<L1.size();i++){
	    	Reference ref=(Reference) L1.get(i);
	    	ref.setIsDelete(new Long(1));
	    	getHibernateTemplate().update(ref);
	    }
	}
	
	public void update(Reference ref) {
		getHibernateTemplate().update(ref);
	}

	//如果存在，返回true;不存在，返回false
	public boolean Check(Long currentYear, String tree, String nodeId, String nodeId2) {
		List L1=this.getHibernateTemplate().find
		("from Reference where year =? and ab =? and nodeId =? and nodeId2 = ?",new Object[] {currentYear,tree,nodeId2,nodeId});
		if (L1.size()>0)
			return true;
		else 
			return false;
	}
    
	public boolean CheckIs(Long currentYear, String tree, String nodeId, String nodeId2,String refType) {
		List L1=this.getHibernateTemplate().find
		("from Reference where year =? and ab =? and nodeId =? and nodeId2 = ? and refType = ?",new Object[] {currentYear,tree,nodeId2,nodeId, refType});
		if (L1.size()>0)
			return true;
		else 
			return false;
	}
}