c454dao.java

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

package com.je.ims.dao;

import java.util.List;
import java.util.*;

import com.je.ims.hibernate.PraetorAdvice;
import com.je.ims.hibernate.*;

public class C454DAO extends CommonDAO {

	public Object[] getCount(int start, int size) {
        List list=getAll();
    	
    	PraetorAdvice[] app = new PraetorAdvice[size];
		
		for (int i=0;i<size;i++)
		{
			app[i]=new PraetorAdvice();
			app[i]=(PraetorAdvice)list.get(i+start);
		}
		return app;
	}
	
	public Object[] getCount(int start, int size,List l){

    	List list=l;
    	
    	PraetorAdvice[] app = new PraetorAdvice[size];
		
		for (int i=0;i<size;i++)
		{
			app[i]=new PraetorAdvice();
			app[i]=(PraetorAdvice)list.get(i+start);
		}
		return app;
    }
	
	public List getAll() {
    	
		   String hql="from PraetorAdvice";
		   List list=this.getHibernateTemplate().find(hql);
		   return list;
	}
	
	public List queryPraetorAdvice(String year,String month){		 
		// int i=new Integer(year).intValue();
		 //int i=Integer.parseInt(year);
		 Long i=new Long(year);
		 long m=i.longValue();
		 long tempYear=m+1911;
		 Long yearL=new Long(tempYear);
		 Long monthL=new Long(month);
		// Long yearL=new Long(2006);
		 //Long monthL=new Long(01);
		 String hql="from PraetorAdvice where year="+yearL+"and month="+monthL;
		 List l=this.getHibernateTemplate().find(hql);
		 return l;
	}
	
	public PraetorAdvice getPraetorAdvice(String sid){
		try{
		Long l=new Long(sid);
		PraetorAdvice praetorAdvice=(PraetorAdvice)this.getHibernateTemplate().get(PraetorAdvice.class,l);
		return praetorAdvice;
		
	}catch(Exception e){
		return null;
	}
	}
	
	public List getAdviceDetails(Long praetorAdviceId){
		List l=getHibernateTemplate().find("from AdviceDetails c where c.id.adviceDetailsId="+praetorAdviceId);
		return l;
	}
	
	public AdviceDetails getAdviceDetails(Long adviceDetailsId,String praetorName,String adviceTitle){
		List l=this.getHibernateTemplate().find("from AdviceDetails c.id.adviceDetailsId="+adviceDetailsId+"and praetorName="+praetorName);
		AdviceDetails adviceDetails=(AdviceDetails)l.get(0);
		return adviceDetails;
	}
	public List getPraetorName(Long adviceDetailsId){
		List l=this.getHibernateTemplate().find("select distinct praetorName from AdviceDetails c.id.adviceDetailsId="+adviceDetailsId);
		return l;	
	}
	
	public List getAdviceTitle(Long adviceDetailsId,String praetorName ){
		List l=this.getHibernateTemplate().find("select distinct adviceTitle from AdviceDetails c.id.adviceDetailsId="+adviceDetailsId+"and praetorName="+praetorName);
		return l;
	}
	
	public List getDealConditions(Long adviceDetailsId,String praetorName,String adviceTitle){
		List l=this.getHibernateTemplate().find("select dealCondition from AdviceDetails c.id.adviceDetailsId="+adviceDetailsId+"and c.id.adviceTitle="+adviceTitle+"and praetorName="+praetorName);
		return l;
	}
	
	public List getArrangements(Long adviceDetailsId,String praetorName,String adviceTitle){
		List l=this.getHibernateTemplate().find("select arrangement from AdviceDetails c.id.adviceDetailsId="+adviceDetailsId+"and c.id.adviceTitle="+adviceTitle+"and praetorName="+praetorName);
		return l;
	}
	

	
	
	public void savePraetorAdvice(Long year,Long month,Date fillDate,String editorName,String editorId,String editorDn,
			String viseDirectorName,String viseDirectorId,String viseDirectorDn){
		PraetorAdvice praetorAdvice=new PraetorAdvice();
		praetorAdvice.setFileId("223546");
		praetorAdvice.setTitle("095年9月長官意見");
		praetorAdvice.setYear(year);
		praetorAdvice.setMonth(month);
		praetorAdvice.setFillDate(fillDate);
		praetorAdvice.setEditorName(editorName);
		praetorAdvice.setEditorId(editorId);
		praetorAdvice.setEditorDn(editorDn);
		praetorAdvice.setVersion(new Long(1));
		praetorAdvice.setEditState(new Long(2));
		praetorAdvice.setViseDirectorName(viseDirectorName);
		praetorAdvice.setViseDirectorId(viseDirectorId);
		praetorAdvice.setViseDirectorDn(viseDirectorDn);
		/*PraetorAdvice praetorAdvice=new PraetorAdvice("123456","095年9月長官意見",year,month,new Long(2),new Long(1),
				fillDate,editorName,editorId,editorDn,viseDirectorName,viseDirectorId,viseDirectorDn);*/
		this.getHibernateTemplate().saveOrUpdate(praetorAdvice);
		this.getHibernateTemplate().flush();
	}
	
	public void saveAdviceDetails(){
		AdviceDetailsId adid=new AdviceDetailsId();
		adid.setAdviceDetailsId(new Long(1));
		adid.setPraetorId("111");
		adid.setAdviceTitle("關於學校食堂的問題");
		adid.setDealCondition("請抓緊改善食堂的伙食！");
		AdviceDetails ad=new AdviceDetails();
		ad.setId(adid);
		ad.setReplyDate(new Date());
		ad.setPraetorName("Jackie");
		ad.setStyle(new Long(1));
		ad.setAdviceContents("請抓緊改善食堂的伙食！");
		ad.setArrangement("準備後天召開后勤會議，商討關於食堂的問題！");
		this.getHibernateTemplate().saveOrUpdate(ad);
		this.getHibernateTemplate().flush();
		
	}

}