c12mgrcycledao.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 C12MgrCycleDAO extends HibernateDaoSupport {
	

	//新增或更新
	public void AddMgrCycle(MgrCycle mgrcycle)
	{
		getHibernateTemplate().save(mgrcycle);
	}
	
	//根据显示顺序删除
	public void DeleteMgrCycle(Long id)
	{
		 getHibernateTemplate().delete(GetById(id));
	}
	
	//获取所有记录的个数
	public int GetNumber()
	{
		return GetAll().size();
	}
	
	//获取所有的记录
	public List GetAll()
	{
		List list = getHibernateTemplate().find("from MgrCycle mgrcycle order by mgrcycle.showId");
		return list;
	}
	
	public List GetCheckBox()
	{
		List list = getHibernateTemplate().find("select mgrcycle.cycle from MgrCycle mgrcycle where mgrcycle.showId<21 order by mgrcycle.showId ");
		return list;
	}
	
	public List GetRadio()
	{
		List list = getHibernateTemplate().find("select mgrcycle.cycle from MgrCycle mgrcycle where mgrcycle.showId>20 order by mgrcycle.showId ");
		return list;
	}
	
	//通过显示顺序获取记录
	public MgrCycle GetById(Long id)
	{
		List L1 = getHibernateTemplate().find("from MgrCycle where showId="+id);
		
		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);
		}
	}
}