c32areadao.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;






public class C32AreaDao extends HibernateDaoSupport {
	
	
	 public C32AreaDao() {
	    }
	    
	 public Area getArea(Long id)
	    {
	       
		 Area c1=new Area();
	        getHibernateTemplate().load(c1,id);
	        return c1;
	    }
	 
	    public List getArea(String year)
	    {
	   
	    	   List L1=getHibernateTemplate().find("from Area c where c.year =? order by c.showId",year);
	    	   return L1;
	    	  
	    }
	    public Area getArea(String year,String area)
	    {
	    	Long l=new Long(Integer.parseInt(year));
	    	   List L1=getHibernateTemplate().find("from Area c where c.year=? and area=? order by c.showId",new Object[]{l,"北部地區"});
	    	   Area a=null;
	    	   a=(Area)L1.get(0);
	    	   return a;
	    	  
	    }
	    
	   // public Area getArea(String year,String area)
	   // {
	   
	    	//List L1=getHibernateTemplate().find("from Area c where c.year="+year+"and c.area="+area);
	     //   if (L1.size()>0) return ((Area)L1.get(0));
	          //  else return null;
	    	  
	   // }
	   
	    public void delArea(Long id)
	    {
	    	
	    	Area c1=new Area();
	    	c1=getArea(id);
	    	getHibernateTemplate().delete(c1);
	    }
	    
	    public void saveArea(Area c1)
	    {
	        getHibernateTemplate().saveOrUpdate(c1);
	    }
	    
	    
	    
	    
	    
	   
	  

}