c2enactemntdao.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.Enactemnt;


public class C2EnactemntDAO extends CommonDAO {
	Enactemnt rule=new Enactemnt();
	public void setrule(Enactemnt r)
	{
		this.rule=r;
	}
	public Enactemnt getrule()
	{
		return rule;
	}
	public List find() {
		//Wise user=new Wise();
		String hql="from Enactemnt where isDelete=0 order by uploadDate desc";
	    List list=getHibernateTemplate().find(hql);
		return list;   
	}	
		public C2EnactemntDAO(){		
		}
		public List getRule() throws SQLException
		{
			String hql="from Enactemnt where isDelete=0";
			List list=getHibernateTemplate().find(hql);
               return list;
		}  
		public List showRule(Long temp) throws SQLException
		{
			String hql="from Enactemnt where enactemntId="+temp;
			List list=getHibernateTemplate().find(hql);
               return list;
		}  
		public void updateRule(Long temp)
		{
	
			String hql="from Enactemnt where enactemntId="+temp;
			List list=getHibernateTemplate().find(hql);
			Enactemnt e=new Enactemnt();
			Iterator t=list.iterator();
			e=(Enactemnt)t.next();
			e.setIsDelete(new Long(1));
			getHibernateTemplate().saveOrUpdate(e);

		}  
		public void update(Long temp,String string)
		{
	
			String hql="from Enactemnt where enactemntId="+temp;
			List list=getHibernateTemplate().find(hql);
			Enactemnt e=new Enactemnt();
			Iterator t=list.iterator();
			e=(Enactemnt)t.next();
			e.setFileDoc(string);
			getHibernateTemplate().saveOrUpdate(e);

		}  
		public String showdoc(Long temp)
		{
	
			String hql="from Enactemnt where enactemntId="+temp;
			List list=getHibernateTemplate().find(hql);
			Enactemnt e=new Enactemnt();
			Iterator t=list.iterator();
			e=(Enactemnt)t.next();
			String str=e.getFileDoc();
	return str;

		}  
		
		public void insertRule(Enactemnt rule) { 
	        getHibernateTemplate().save(rule); 
	    } 

		public void saveRule(Enactemnt rule) { 
	        getHibernateTemplate().saveOrUpdate(rule); 
	    } 
		public Enactemnt getByID(String ID)
	    {
	        java.util.List L1=getHibernateTemplate().find("from Enactemnt where EnactemntId=?",ID);
	        if (L1.size()>0)
	        	return (Enactemnt)L1.get(0);
	        else return null;
	    }
		public List getAll() {

			String hql="from Enactemnt where isDelete=0 order by uploadDate desc";
			List list=this.getHibernateTemplate().find(hql);
			return list;
		}
//	  返回所有记录的size   
	    public int getSize() {
	    	
	    	List list=getAll();
	    	return list.size();
		}
	    public Date getDate(){
	    	Date date=new Date();
	    	int year1=date.getYear();
	    	int year2=year1-1911;
	    	date.setYear(year2);
	    	return date;
	    }
		public Object[] getCount(int start, int size) {
			List list=getAll();
			
			Enactemnt[] app = new Enactemnt[size];
			
			for (int i=0;i<size;i++)
			{
				app[i]=new Enactemnt();
				app[i]=(Enactemnt)list.get(i+start);
			}
			return app;
		}
		public Object[] getCount(int start, int count, List l) {
			// TODO Auto-generated method stub
			return null;
		}
}