c32planareadao.java

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

package com.je.ims.dao;

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

public class C32PlanAreaDao extends HibernateDaoSupport {
	
	
	 public C32PlanAreaDao() {
	    }
	    
	 public PlanArea getPlanArea(int id)
	    {
	       
		 PlanArea c1=new PlanArea();
	        getHibernateTemplate().load(c1,new Long(id));
	        return c1;
	    }
	 
	    public List getPlanArea(Long year,Long month)
	    {
	   
	    	   List L1=getHibernateTemplate().find("from PlanArea c where c.year="+year+" and PlanArea c.month="+month);
	    	   return L1;
	    	  
	    }
	    public List getPlanArea(Long year,Long month,String area)
	    {
	   
	    	   List L1=getHibernateTemplate().find("from PlanArea c where c.year=? and c.month=? and c.area=?",new Object[]{year,month,area});
	    	   //PlanArea p=null;
	    	 // if(L1.size()==0)return null;
	    	 // else return (PlanArea)L1.get(0);
	    	  return L1;
	    	  
	    }
	    
	    public List getPlanArea(Long year)
	    {
	   
	    	   List L1=getHibernateTemplate().find("from PlanArea c where c.year=?",year);
	    	   return L1;
	    	  
	    }
	   
	    public void delPlanArea(int id)
	    {
	    	
	    	PlanArea c1=new PlanArea();
	    	c1=this.getPlanArea(id);
	    	getHibernateTemplate().delete(c1);
	    }
	    
	    public void saveArea(PlanArea c1)
	    {
	        getHibernateTemplate().saveOrUpdate(c1);
	    }
	    public void updateArea(PlanArea c1)
	    {
	        getHibernateTemplate().update(c1);
	    }
	    
	    
	    
	    
	    
	   
	  

}