c32mgrareaorgdao.java

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

package com.je.ims.dao;


import java.util.List;

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

import com.je.ims.hibernate.Area;
import com.je.ims.hibernate.MgrAreaOrg;
import com.je.ims.hibernate.MgrAreaOrgId;








public class C32MgrAreaOrgDao extends HibernateDaoSupport {
	
	 public C32MgrAreaOrgDao() {
	    }
	    
	
	 
	    public List getMgrAreaOrg(String year)
	    {
	   
	    	   List L1=getHibernateTemplate().find("from MgrAreaOrg c where c.id.year=? ",year);
	    	   return L1;
	    	  
	    }
	    public List getMgrAreaOrg(Long areapk)
	    {
	   
	    	   List L1=getHibernateTemplate().find("from MgrAreaOrg c where c.id.areaPk=? ",areapk);
	    	   return L1;
	    	  
	    }
	    public List getMgrAreaOrg(Long areapk,String orgId)
	    {
	   
	    	   List L1=getHibernateTemplate().find("from MgrAreaOrg c where c.id.areaPk=? and c.id.orgId=?",new Object[]{areapk,orgId});
	    	   return L1;
	    	  
	    }
	    public void deleteMgrAreaOrg(Long areaPk)
	    {
	    	List c1=getMgrAreaOrg(areaPk);
	    	getHibernateTemplate().deleteAll(c1);
	    }
	    
	    public void saveMgrAreaOrg(Long areaPk,String orgId,Long year,String orgName)
	    {
	    	MgrAreaOrgId c2=new MgrAreaOrgId();
	    	c2.setAreaPk(areaPk);
	    	c2.setOrgId(orgId);
	    	c2.setYear(year);
	    	MgrAreaOrg c1=new MgrAreaOrg();
	    	c1.setOrgName(orgName);
	    	c1.setId(c2);
	        getHibernateTemplate().saveOrUpdate(c1);
	    }
	    public MgrAreaOrg getMgrAreaOrg(Long areaPk,String orgId,Long year)
	    {
	   
	    	List L1=getHibernateTemplate().find("from MgrAreaOrg c where c.id.areaPk="+areaPk+"and c.id.orgId='"+orgId+"'and c.id.year="+year);
	    	
	        if (L1.size()>0) return ((MgrAreaOrg)L1.get(0));
	            else return null;
	    	  
	    }
	    
	    public void deleteMgrAreaOrg(Long areaPk,String orgId,Long year)
	    {
	    	MgrAreaOrg c1=getMgrAreaOrg(areaPk,orgId,year);
	    	getHibernateTemplate().delete(c1);
	    }
	    
	    
	    
	    
	    
	   
	  

}