c31plandao.java

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

package com.je.ims.dao;


import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import java.util.*;
import com.je.ims.hibernate.*;



public class C31PlanDao extends HibernateDaoSupport {
	 public C31PlanDao() {
	   }
	 
	 public Plan getPlan(Long id)
	 {
	       
		 	Plan plan=new Plan();
	        getHibernateTemplate().load(plan,id);
	        return plan;
	 }
	 public void saveFile( Plan plan)
	 {
		 	getHibernateTemplate().saveOrUpdate(plan);
	 }
	 
	 public void deleteFile(Long fileId)
	 {
	       
		 Plan plan=new Plan( );
		 getHibernateTemplate().load(plan,fileId);
		 plan.setIsDelete(new Long(1));
		 getHibernateTemplate().saveOrUpdate(plan);
	        
	 }
	 public void setFinished(Long fileId)
	 {
	       
		 Plan plan=new Plan( );
		 getHibernateTemplate().load(plan,fileId);
		 plan.setIsFinish(new Long(0));
		 getHibernateTemplate().saveOrUpdate(plan);
	        
	 }
	 public void updatePlan(Plan plan)
	 {
		 getHibernateTemplate().update(plan);
	 }
	 public List getAll()
	 {
		 String hql="from Plan order by planId desc ";
		 List list=getHibernateTemplate().find(hql);
		 return list;
	 }
	 public List getAllByYear(Long lo)
	 {
		 
		 String hql="from Plan where  isDelete=0 and year="+lo;
		 List list=getHibernateTemplate().find(hql);
		 return list;
	 }
	 public List getByYear(Long year)
	 {
		
		 String hql="from Plan where year="+year+" and isDelete=0";
		 List list=getHibernateTemplate().find(hql);
		 return list;
	 }
	 

}