c35planareadao.java

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

package com.je.ims.dao;

import java.util.List;

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

public class c35PlanAreaDao extends HibernateDaoSupport {
	 public List getArea(Long year,Long month)
	    {
		 
		 	String condition = "where planarea.year =area.year and planarea.areaPk = area.areaPk and planarea.year="+year+" and planarea.month="+month+" order by area.showId";
			List c = getHibernateTemplate().find("select  planarea from PlanArea planarea,Area area "+condition); 
			return c;
	    	   
	    	  
	    }

}