c84teamdao.java

来自「使用spring ,hibernate 框架的稽查管理系统」· Java 代码 · 共 135 行

package com.je.ims.dao;

import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.HibernateCallback;

import com.je.ims.hibernate.Team;
import com.je.ims.hibernate.TeamArea;
import com.je.ims.hibernate.TeamAreaId;

public class C84TeamDAO extends CommonDAO{

//	检查year和teamId,如果存在返回true，不存在返回false
	public boolean check(Long year,String teamId) {
		
		String hql="from Team where year = " + year +" and teamId = '"+teamId+"'";
		
    	List list=getHibernateTemplate().find(hql);
    	
    	if(list.size()>0)
    		return true;
    	else
    		return false;
     		
    }
	
	public void delete(Long tpk) {
		
		final Team t=GetObjById(tpk);
		final Long year=GetYearByID(tpk);
		
		String hql="from TeamArea where id.teamPk = "+tpk;
		final List L1=(List)getHibernateTemplate().find(hql);
		
		getHibernateTemplate().execute(new HibernateCallback() { 

			public Object doInHibernate(Session session) throws HibernateException {
				
				for(int i=0;i<L1.size();i++)
					session.delete(L1.get(i));
				session.delete(t);
				return null;
			}      }); 
		
	}
	
	public void insert(Team team) {
			
		getHibernateTemplate().save(team);
	}

	public Team Find(Long year,Long showId) {
		String hql="from Team where year = "+year+"and showId = "+showId;
		List list=this.getHibernateTemplate().find(hql);
		if(list.size()>0)
			return (Team)list.get(0);
		else return null;
	}
	
	public List GetAll() {
		
		List list = getHibernateTemplate().find("from Team order by showId");
		return list;
	}
	
	public List GetAll(Long l) {
		String hql="from Team where year = "+l+" order by showId";
		List list=this.getHibernateTemplate().find(hql);
		return list;
	}
	
	public String GetNameByID(Long ID){
		
		List L1=getHibernateTemplate().find("select teamName from Team where teamPk="+ID);
        if (L1.size()>0)
        	return (String)L1.get(0);
        else return null;
		   
	}
	
	public Long GetYearByID(Long ID){
		
		List L1=getHibernateTemplate().find("select year from Team where teamPk="+ID);
        if (L1.size()>0)
        	return (Long)L1.get(0);
        else return null;
		   
	}
	
	public Team GetObjById(Long pk){
		
		List L1=getHibernateTemplate().find("from Team where teamPk="+pk);
        if (L1.size()>0)
        	return (Team)L1.get(0);
        else return null;
	}

//  返回记录， start为记录开始的位置，size为记录的长度
    public Object[] getCount(int start, int size){

    	List list=GetAll();
    	
		Team[] app = new Team[size];
		
		for (int i=0;i<size;i++)
		{
			app[i]=new Team();
			app[i]=(Team)list.get(i+start);
		}
		return app;
    }

		
    public int GetSize() {
    	
		List list=GetAll();
		return list.size();
		
	}

	public void update(Team team1) {
		getHibernateTemplate().update(team1);
	}

	public Object[] getCount(int start, int count, List l) {
		
		return null;
	}



}