c35mgritemdao.java

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

package com.je.ims.dao;

import java.util.List;

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

import com.je.ims.hibernate.MgrItem;
import com.je.ims.hibernate.MgrItemId;
import com.je.ims.hibernate.MgrKind;
import com.je.ims.hibernate.MgrOrg;

public class c35MgrItemDao extends HibernateDaoSupport {
	
	public List getMgrItem(Long year,Long month)
    {
		//Long yea=new Long(year.intValue()+1911);
	 	String condition = "where mgritem.id.mgrOrgPk =mgrorg.mgrOrgPk and mgrorg.year="+year+" and mgrorg.month="+month;
		List c = getHibernateTemplate().find("select  mgritem from  MgrItem mgritem,MgrOrg mgrorg "+condition); 
		return c;
    	   
    	  
    }
	public List getMgrItem()
    {
	 	
		List c = getHibernateTemplate().find("from MgrItem"); 
		return c;
    	   
    	  
    }
	public List getMgrItem(Long year,Long month,Long areapk,String orgid)
    {
		//Long yea=new Long(year.intValue()+1911);
	 	String condition = "where mgritem.id.mgrOrgPk =mgrorg.mgrOrgPk and mgrorg.year="+year+" and mgrorg.month="+month+" and mgrorg.areaPk="+areapk+" and mgrorg.orgId='"+orgid+"'";
		List c = getHibernateTemplate().find("select  mgritem from  MgrItem mgritem,MgrOrg mgrorg "+condition); 
		return c;
    	   
    	  
    }
	 public void saveMgrItem(Long mgrOrgPk,String itemId,String nodeName)
	    {
	    	MgrItem c1=new MgrItem();
	    	
	    	c1.setNodeName(nodeName);
	    	MgrItemId c2=new MgrItemId();
	    	c2.setItemId(itemId);
	    	c2.setMgrOrgPk(mgrOrgPk);
	    	c1.setId(c2);
	    	
	    	
	    	
	    	
	        getHibernateTemplate().saveOrUpdate(c1);
	    }
	 public MgrItem getMgrItem(Long mgrOrgPk,String itemId)
	    {
		 List L1=getHibernateTemplate().find("from MgrItem c where c.id.mgrOrgPk="+mgrOrgPk+"and c.id.itemId='"+itemId+"'");
	    	if(L1.size()>0){return (MgrItem)L1.get(0);}
	    	else return null;
	    }
}