mgrcycledao.java

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

package com.je.ims.dao;


import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import org.springframework.orm.hibernate3.*;
import java.util.*;
import org.hibernate.*;

import com.je.ims.hibernate.MgrCycle;

public class MgrCycleDAO extends HibernateDaoSupport {
	

	//新增或更新
	public void AddMgrCycle(MgrCycle mgrcycle)
	{
		getHibernateTemplate().save(mgrcycle);
	}
	
	public void UpateMgrCycle(MgrCycle mgrcycle){
		getHibernateTemplate().update(mgrcycle);
	}
	//根据显示顺序删除
	public void DeleteMgrCycle(String cycle)
	{
		 getHibernateTemplate().delete(this.GetByCycle(cycle));
	}
	
	//获取所有记录的个数
	public int GetNumber()
	{
		return GetAll().size();
	}
	
	//获取所有的记录
	public List GetAll()
	{
	//	MgrCycle temp = new MgrCycle();
		List list = getHibernateTemplate().find("from MgrCycle mgrcycle order by mgrcycle.showId");
	/*	for(int i=0;i<list.size();i++){
			temp = (MgrCycle)list.get(i);
		//	System.out.println(temp.getCycle()+","+temp.getShowId());
			temp.setShowId(new Long(i));
		//	System.out.println(i);
		//	System.out.println(temp.getCycle()+","+temp.getShowId());
			getHibernateTemplate().update(temp);
		}*/
		return list;
	}
	
	//通过显示顺序获取记录
	public MgrCycle GetByCycle(String cycle)
	{
		
		List L1 = getHibernateTemplate().find("from MgrCycle where cycle=?",new Object[] {cycle});
		
		if(L1.size()>0)
			return (MgrCycle)L1.get(0);
		else
		{
			return null;
		}
	}
	
	//下移
/*	public void Down(long id)
	{
		MgrCycle mgr1,mgr2;
		mgr1 = new MgrCycle();
		mgr2 = new MgrCycle();
		mgr1=GetById(new Long(id));
		mgr2=GetById(new Long(id+1));
		if(mgr1!=null&&mgr2!=null){
			mgr1.setShowId(new Long(id+1));
			mgr2.setShowId(new Long(id));
			getHibernateTemplate().update(mgr1);
			getHibernateTemplate().update(mgr2);
		}
	}
	
	//上移
	public void Up(long id)
	{
		MgrCycle mgr1,mgr2;
		mgr1 = new MgrCycle();
		mgr2 = new MgrCycle();
		mgr1=GetById(new Long(id));
		mgr2=GetById(new Long(id-1));
		if(mgr1!=null&&mgr2!=null){
			mgr1.setShowId(new Long(id-1));
			mgr2.setShowId(new Long(id));
			getHibernateTemplate().update(mgr1);
			getHibernateTemplate().update(mgr2);
		}
	}*/
}