c33planareadao.java

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

package com.je.ims.dao;

import java.util.List;

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

import com.je.ims.hibernate.Plan;
import com.je.ims.hibernate.PlanArea;

public class c33PlanAreaDao extends HibernateDaoSupport {
	 public List getArea(Long year,Long month)
	    {
		 Long yea=new Long(year.longValue()+1911);
		 	String condition = "where planarea.year =area.year and planarea.areaPk = area.areaPk and planarea.year="+yea+" and planarea.month="+month+" order by area.showId";
			List c = getHibernateTemplate().find("select  planarea from PlanArea planarea,Area area "+condition); 
			return c;
	    	   
	    	  
	    }
	 public PlanArea getArea(Long year,Long month,Long areapk){
		 Long yea=new Long(year.intValue()+1911);
	    	
	    	List L1=getHibernateTemplate().find("from PlanArea c where c.year="+yea+"and c.month="+month+"and c.areaPk="+areapk);
	        if (L1.size()>0) return ((PlanArea)L1.get(0));
	            else return null;
		 
	 }
	 

}