c33planorgdao.java

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

package com.je.ims.dao;

import java.util.List;

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

import com.je.ims.hibernate.PlanOrg;

public class c33PlanOrgDao extends HibernateDaoSupport {
	
	 public List getOrg(Long year,Long month)
	    {
		 Long yea=new Long(year.longValue()+1911);
		 	String condition = "where  planorg.id.planAreaId = planarea.planAreaId and planarea.year="+yea+" and planarea.month="+month+" order by planorg.showId";
			List c = getHibernateTemplate().find("select planorg from PlanOrg planorg,PlanArea planarea "+condition); 
			return c;
	    	   
	    	  
	    }
	 
	 public List getOrg(Long year,Long month,Long areapk)
	    {
		 Long yea=new Long(year.longValue()+1911);
		 	String condition = "where  planorg.id.planAreaId = planarea.planAreaId and planarea.year="+yea+" and planarea.month="+month+" and planarea.areaPk="+areapk+" order by planorg.showId";
			List c = getHibernateTemplate().find("select planorg from PlanOrg planorg,PlanArea planarea "+condition); 
			return c;
	    	   
	    	  
	    }
	 public PlanOrg getOrg(Long year,Long month,Long areapk,String orgid)
	    {
		 Long yea=new Long(year.longValue()+1911);
		 	String condition = "where  planorg.id.planAreaId = planarea.planAreaId and planarea.year="+yea+" and planarea.month="+month+" and planarea.areaPk="+areapk+" and planorg.id.orgId='"+orgid+"' order by planorg.showId";
			List c = getHibernateTemplate().find("select planorg from PlanOrg planorg,PlanArea planarea "+condition); 
			if(c.size()>0)
				return (PlanOrg)c.get(0);
			else
			return null;
	    	   
	    	  
	    }
}