c1wisedao.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.Wise;

public class C1WiseDAO extends CommonDAO {
		public C1WiseDAO(){
			
		} 
		public void insertRule(Wise rule) { 
	        getHibernateTemplate().save(rule); 
	    }
		public List showRule(Long temp) throws SQLException
		{
			String hql="from Wise where wiseId="+temp;
			List list=getHibernateTemplate().find(hql);
               return list;
		}  
		public List find() {
			//Wise user=new Wise();
			String hql="from Wise where isDelete=0 order by uploadDate desc";
		    List list=getHibernateTemplate().find(hql);
			return list;   
		}	
		public Wise insert() {
			Wise user=new Wise();
			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 Wise 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 Wise where wiseId="+temp;
			List list=getHibernateTemplate().find(hql);
			Wise e=new Wise();
			Iterator t=list.iterator();
			e=(Wise)t.next();
			e.setIsDelete(new Long(1));
			getHibernateTemplate().saveOrUpdate(e);

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

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

public Object[] getCount(int start, int size) {
	List list=getAll();
	
	Wise[] app = new Wise[size];
	
	for (int i=0;i<size;i++)
	{
		app[i]=new Wise();
		app[i]=(Wise)list.get(i+start);
	}
	return app;
}
public Long getid(Long id)
{
	String hql="from Wise where isDelete=0";
	List list=getHibernateTemplate().find(hql);
	Iterator it=list.iterator();
	Wise rule=(Wise)it.next();
	Long pk=rule.getFileId();
	return pk;
	
	}
public List getRule() {
	String hql="from Wise where isDelete=0";
	List list=getHibernateTemplate().find(hql);
       return list;
}
public void saveRule(Wise rule) {
	getHibernateTemplate().saveOrUpdate(rule); 
	
}
public Object[] getCount(int start, int count, List l) {
	// TODO Auto-generated method stub
	return null;
}
}