c421mgritemdao.java

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

package com.je.ims.dao;

import java.util.List;

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

public class c421MgrItemDao extends HibernateDaoSupport {
	public List getMgrItem(Long year,Long month,String orgid)
    {
		Long yea=new Long(year.intValue()+1911);
	 	String condition = "where mgritem.id.mgrOrgPk =mgrorg.mgrOrgPk and mgrorg.year="+yea+" and mgrorg.month="+month+" and mgrorg.orgId='"+orgid+"'";
		List c = getHibernateTemplate().find("select  mgritem from  MgrItem mgritem,MgrOrg mgrorg "+condition); 
		return c;
    	   
    	  
    }

}