c432advicedealdao.java

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

package com.je.ims.dao;


import java.sql.SQLException;
import java.util.*;

import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import com.je.ims.dao.CommonDAO;
import com.je.ims.hibernate.AdviceDeal;
import com.je.ims.hibernate.AdviceDealId;



public class C432advicedealDao extends CommonDAO {
	
	public void insertRule(Long notionid,Long founditem,Long item,Long version,String recent,String content,String attachment) { 
		AdviceDealId adi=new AdviceDealId();
		adi.setFoundItem(founditem);
		adi.setItem(item);
		adi.setNotionId(notionid);
		adi.setVersion(version);
		AdviceDeal ad=new AdviceDeal();
		ad.setId(adi);
		ad.setAttachment(attachment);
		ad.setContent(content);
		ad.setRecent(recent);
        getHibernateTemplate().saveOrUpdate(ad);
        System.out.println("cha ru le");
    }
	public void update(Long notionid,Long founditem,Long item,Long version,String recent,String content,String attachment) { 
		List list=getHibernateTemplate().find("from AdviceDeal c where c.id.notionId="+notionid+"and c.id.foundItem="+founditem+"and c.id.item="+item);
		System.out.println("geng xin le");
		AdviceDeal e=new AdviceDeal();
		Iterator t=list.iterator();
		e=(AdviceDeal)t.next();		
		AdviceDealId adi=new AdviceDealId();
		adi.setFoundItem(founditem);
		adi.setItem(item);
		adi.setNotionId(notionid);
		adi.setVersion(version);		
		e.setId(adi);
		e.setAttachment(attachment);
		e.setContent(content);
		e.setRecent(recent);
		System.out.println("e.attachement"+e.getAttachment());
        getHibernateTemplate().saveOrUpdate(e);
    }
	public boolean exist(Long notionid,Long founditem,Long item)
	
	{
		List list=getHibernateTemplate().find("from AdviceDeal c where c.id.notionId="+notionid+"and c.id.foundItem="+founditem+"and c.id.item="+item);
		if(list.size()!=0)		
			return true;		
		else 
			return false;
	}
	public boolean set(Long notionid)
	
	{
		List list=getHibernateTemplate().find("from AdviceDeal c where c.id.notionId="+notionid);
		if(list.size()==0)		
			return true;		
		else
		{
			for(int i=0;i<list.size();i++)
			{
				System.out.println("xunhuan le");
				Iterator it=list.iterator();
				AdviceDeal rule=(AdviceDeal)it.next();
			    rule.setRecent("n");
			    System.out.println(rule.getAttachment());
			    System.out.println(rule.getRecent());
			    getHibernateTemplate().saveOrUpdate(rule);
			}
					}
		return false;
	}
	public Object[] getCount(int start, int count) {
		// TODO Auto-generated method stub
		return null;
	}

	public Object[] getCount(int start, int count, List l) {
		// TODO Auto-generated method stub
		return null;
	}
	
}