c1samplingdao.java

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

package com.je.ims.dao;



import java.sql.SQLException;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

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

import com.je.ims.hibernate.Sampling;

public class C1SamplingDAO extends CommonDAO {
		public C1SamplingDAO(){
			
		} 
		public void insertRule(Sampling rule) { 
	        getHibernateTemplate().save(rule); 
	    }
		public List showRule(Long temp) throws SQLException
		{
			String hql="from Sampling where samplingId="+temp;
			List list=getHibernateTemplate().find(hql);
               return list;
		}  
		public List find() {
			//Wise user=new Wise();
			String hql="from Sampling where isDelete=0 order by uploadDate desc";
		    List list=getHibernateTemplate().find(hql);
			return list;   
		}	
		public Sampling insert() {
			Sampling user=new Sampling();
			user.setFileDoc("111");
			user.setFileId(new Long(1));
			user.setIsDelete(new Long(0));
			user.setUploadDate(new Date());
			//user.setYear(new Long(95));
			getHibernateTemplate().saveOrUpdate(user);
			return user;   
		}
		public List getAll() {

			String hql="from Sampling 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 void updateRule(Long temp)
		{
	
			String hql="from Sampling where samplingId="+temp;
			List list=getHibernateTemplate().find(hql);
			Sampling e=new Sampling();
			Iterator t=list.iterator();
			e=(Sampling)t.next();
			e.setIsDelete(new Long(1));
			getHibernateTemplate().saveOrUpdate(e);

		}  
		public String showdoc(Long temp)
		{
	
			String hql="from Sampling where samplingId="+temp;
			List list=getHibernateTemplate().find(hql);
			Sampling e=new Sampling();
			Iterator t=list.iterator();
			e=(Sampling)t.next();
		    String str=e.getFileDoc();
		    return str;
		}  
		public void update(Long temp,String str)
		{
	
			String hql="from Sampling where samplingId="+temp;
			List list=getHibernateTemplate().find(hql);
			Sampling e=new Sampling();
			Iterator t=list.iterator();
			e=(Sampling)t.next();
			e.setFileDoc(str);
			getHibernateTemplate().saveOrUpdate(e);

		}  

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

public List getRule() {
	String hql="from Sampling where isDelete=0";
	List list=getHibernateTemplate().find(hql);
       return list;
}
public void saveRule(Sampling rule) {
	getHibernateTemplate().saveOrUpdate(rule); 
	
}
public Object[] getCount(int start, int count, List l) {
	// TODO Auto-generated method stub
	return null;
}
}