c84teamareadao.java

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

package com.je.ims.dao;

import java.util.List;

import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

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

public class C84TeamAreaDAO extends HibernateDaoSupport{

	public void insert(TeamArea teamArea) {
		getHibernateTemplate().save(teamArea);
		
	}
	
	public List GetAll(){
		List list =getHibernateTemplate().loadAll(TeamArea.class);
		return list;
	}

	public void delete(Long pk1, Long pk2) {
			
		TeamAreaId tId=new TeamAreaId(pk1,pk2);
		TeamArea teamArea=new TeamArea(tId);
		getHibernateTemplate().delete(teamArea);
		
	}
	
	public void deleteAll(Long tpk) {
		
		List list=getHibernateTemplate().find("from TeamArea where id.teamPk="+tpk);
		
		getHibernateTemplate().deleteAll(list);	
		
	}

	public List GetAreaByTeamPk(Long pk){
		
		List list=getHibernateTemplate().find("select id.areaPk from TeamArea where id.teamPk="+pk);
        return list;
        
	}

}