c6bulletindao.java

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

package com.je.ims.dao;

import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import org.springframework.orm.hibernate3.*;
import java.util.*;
import java.sql.Clob;
import java.text.*;

import com.je.ims.util.*;

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

public class C6BulletinDAO extends CommonDAO {
     
	//DateTimeFormat format=new DateTimeFormat("民國eee年MM月dd日");
	DateTimeFormat format=new DateTimeFormat();
	DateFormat df2=new SimpleDateFormat("yyyy-MM-dd");
	
	public Object[] getCount(int start, int size) {
        List list=getAll();
    	
    	Bulletin[] app = new Bulletin[size];
		
		for (int i=0;i<size;i++)
		{
			app[i]=new Bulletin();
			app[i]=(Bulletin)list.get(i+start);
		}
		return app;
	}
	
	public Object[] getCount(int start, int size,List l){

    	List list=l;
    	
    	Bulletin[] app = new Bulletin[size];
		
		for (int i=0;i<size;i++)
		{
			app[i]=new Bulletin();
			app[i]=(Bulletin)list.get(i+start);
		}
		return app;
    }
	public void saveBulletin(Bulletin bul){
		getHibernateTemplate().saveOrUpdate(bul);
		getHibernateTemplate().flush();
	}
		
	public void updateBulletin(String sid,Long year,String caption,String content,java.util.Date date1,java.util.Date date2,Long isLogin,Long isB,
			String userId,String userName,String userUnit,java.util.Date lastUpdate){
		int i=Integer.parseInt(sid);
		Long l=new Long(i);
		Bulletin bul=getBulletinByID(l);
		bul.setYear(year);
		bul.setCaption(caption);
		bul.setContent(Hibernate.createClob(content));
		bul.setDate1(date1);
		bul.setDate2(date2);
		bul.setIsLogin(isLogin);
		bul.setIsB(isB);
		bul.setUserId(userId);
		bul.setUserName(userName);
		bul.setUserUnit(userUnit);
		bul.setLastUpdate(lastUpdate);
		getHibernateTemplate().update(bul);
		getHibernateTemplate().flush(); //强制更新
		
	}
	
	public void saveBulletinUrlDao(Long bulletinId,String bulletinUrl,String urlDoc,Long isDelete){
		BulletinUrlId buId=new BulletinUrlId();
		buId.setBullentinId(bulletinId);
		buId.setUrl(bulletinUrl);
		BulletinUrl bu=new BulletinUrl();
		bu.setId(buId);
		bu.setUrlDoc(urlDoc);
		bu.setIsDelete(isDelete);
		getHibernateTemplate().saveOrUpdate(bu);
		getHibernateTemplate().flush();
		
	}
	
	public void updateBulletinUrlDao(BulletinUrl bulletinUrl,String urlDoc)
	{
		bulletinUrl.setUrlDoc(urlDoc);
		getHibernateTemplate().update(bulletinUrl);
		getHibernateTemplate().flush();
		
	}
	public void updateBulletinFileDao(BulletinFile bf,String fileDoc)
	{
		
		bf.setFileDoc(fileDoc);
		getHibernateTemplate().update(bf);
		getHibernateTemplate().flush();
		
	}
	
	public void saveBulletinFileDAO(Long bulletinId,Long fileId,String fileDoc,Long isDelete){
			BulletinFileId bfId=new BulletinFileId();
			bfId.setBullentinId(bulletinId);
			bfId.setFileId(fileId);
			BulletinFile bf=new BulletinFile();
			bf.setId(bfId);
			bf.setFileDoc(fileDoc);
			bf.setIsDelete(isDelete);
			getHibernateTemplate().saveOrUpdate(bf);
			getHibernateTemplate().flush();		
		}
	public void updateBulletinFileDAO(Long bulletinId,Long fileId,String fileDoc){
		BulletinFileId bfId=new BulletinFileId();
		bfId.setBullentinId(bulletinId);
		bfId.setFileId(fileId);
		BulletinFile bf=new BulletinFile();
		bf=this.getBulletinFileById(bfId);
		bf.setFileDoc(fileDoc);
		getHibernateTemplate().update(bf);
		getHibernateTemplate().flush();		
	}
		public BulletinFile getBulletinFile(Long bulletinId){
			List l=getHibernateTemplate().find("from BulletinFile c where c.id.bullentinId="+bulletinId);
			if(l.size()>0) return (BulletinFile)l.get(l.size()-1);
			else return null;
		}
	
	public BulletinUrl getBulletinUrl(Long bulletinId){
			List l=getHibernateTemplate().find("from BulletinUrl c where c.id.bullentinId="+bulletinId);
			if(l.size()>0) return (BulletinUrl)l.get(0);
			else return null;
		
		}
		
	public BulletinUrl getBulletinUrl(Long bulletinId,String url){
		
		List l=getHibernateTemplate().find("from BulletinUrl c where c.id.bullentinId="+bulletinId+"and c.id.url='"+url+"'");
		if(l.size()>0) return ((BulletinUrl)l.get(l.size()-1));
		else return null;

	}
	
	public List getAll() {
        	
	   String hql="from Bulletin where isDelete=0 order by lastUpdate desc";
	   List list=this.getHibernateTemplate().find(hql);
	   return list;
	}
	
    public int getSize() {
    	
    	List list=getAll();
    	return list.size();
	}
    
    public void delete(String sid){
		try{
			
			Bulletin bulletin=this.getBulletinByID(sid);
			//getHibernateTemplate().delete(bulletin);
			bulletin.setIsDelete(new Long(1));  //不是物理刪除
			this.getHibernateTemplate().update(bulletin);
			this.getHibernateTemplate().flush();
		}
		catch(Exception e){
			
		}
    }
  
    public void delBulletinFile(Long bulletinId,Long fileId){
    	BulletinFileId bfId=new BulletinFileId();
    	bfId.setBullentinId(bulletinId);
    	bfId.setFileId(fileId);
    	BulletinFile bf=this.getBulletinFileById(bfId);
    	bf.setIsDelete(new Long(1));
    	getHibernateTemplate().update(bf);
    	getHibernateTemplate().flush();
    	
    }
    
    public void delBulletinUrl(Long bulletinId,String url){
    	/*BulletinUrlId buId=new BulletinUrlId();
    	buId.setBullentinId(bulletinId);
    	buId.setUrl(url);*/
    	BulletinUrl bu=this.getBulletinUrl(bulletinId,url);
    	bu.setIsDelete(new Long(1));
    	this.getHibernateTemplate().update(bu);
    	this.getHibernateTemplate().flush();
    	//getHibernateTemplate().delete(bu);
    }
    
    public void delBulletinUrl(BulletinUrl bulletinUrl){
    	bulletinUrl.setIsDelete(new Long(1));
    	this.getHibernateTemplate().update(bulletinUrl);
    	this.getHibernateTemplate().flush();
    }
    
    public BulletinFile getBulletinFileById(BulletinFileId bfId){
    	try{
    		BulletinFile bf=(BulletinFile)getHibernateTemplate().get(BulletinFile.class,bfId);
    		return bf;
    	}catch(Exception e){}
    	return null; 
    }
    
    public BulletinFile getBulletinFileById(Long  bulletinId,Long fileId){
    	try{
    		BulletinFileId bfId=new BulletinFileId();
    		bfId.setBullentinId(bulletinId);
    		bfId.setFileId(fileId);
    		BulletinFile bf=(BulletinFile)getHibernateTemplate().get(BulletinFile.class,bfId);
    		return bf;
    	}catch(Exception e){}
    	return null; 
    }
    
    public List query(String caption,String content,String date1,String date2)
	{
    
    	String hql=null;
    	if(date1.equals("")&&date2.equals("")){
    		hql=" from Bulletin where caption like ? and content like ? order by lastUpdate desc";
    	}else if(date1.equals("")&&!date2.equals("")){
    		date2=df2.format(format.parsed(date2));
    		hql=" from Bulletin where caption like ? and content like ? and lastUpdate <= TO_DATE('"+date2+"','yyyy-mm-dd') order by lastUpdate desc";
    	}else if(!date1.equals("")&&date2.equals("")){
    
    		date1=df2.format(format.parsed(date1));
    		hql=" from Bulletin where caption like ? and content like ? and lastUpdate >= TO_DATE('"+date1+"','yyyy-mm-dd') order by lastUpdate desc";
    	}else if(caption.equals("")&&caption.equals("")&&date1.equals("")&&date2.equals("")){
    		hql="from Bulletin where isDelete=0 order by lastUpdate desc";
    	}else{ 	
    		date1=df2.format(format.parsed(date1));
    		date2=df2.format(format.parsed(date2));
		hql=" from Bulletin where caption like ? and content like ? and lastUpdate >= TO_DATE('"+date1+"','yyyy-mm-dd') and lastUpdate <= TO_DATE('"+date2+"','yyyy-mm-dd') order by lastUpdate desc";    
    	}
		List l=this.getHibernateTemplate().find(hql,new Object[] {"%"+caption+"%","%"+content+"%"});
	    return l;
	}
	
    
    public Bulletin getBulletinByID(String sid)
    {
		try{
			int i=Integer.parseInt(sid);
			Long l=new Long(i);
			Bulletin bulletin = (Bulletin) getHibernateTemplate().get(Bulletin.class, l);
			return bulletin;
		}
		catch(Exception e)
		{
			return null;
		}
    }
	public Bulletin getBulletinByID(Long l)
    {
		try{
			
			Bulletin bulletin = (Bulletin) getHibernateTemplate().get(Bulletin.class, l);
			
			
			return bulletin;
		}
		catch(Exception e)
		{
			return null;
		}
    }
	
	public String getContentByIdAsString(Long id){
		String s="";
		Bulletin bul=this.getBulletinByID(id);
		if(bul!=null){
			try{
				Clob clob=bul.getContent();
				s=clob.getSubString(1,(int)clob.length());
			}catch(Exception e){
				
			}
			
		}
		return s;
	}

	

}