c84areadao.java

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

package com.je.ims.dao;


import java.util.List;

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

import com.je.ims.hibernate.Area;

public class C84AreaDAO extends HibernateDaoSupport{

	//返回当年度为l时的Area对象
	public List GetAll(Long l) {
		String hql="from Area where year = "+l+" order by showId";
		List list=this.getHibernateTemplate().find(hql);
		return list;
	}
	//返回全部对象
	public List GetAll() {
		String hql="from Arear order by showId";
		List list=this.getHibernateTemplate().find(hql);
		return list;
	}

	public String GetNameByID(Long ID){
		
		List L1=getHibernateTemplate().find("select area from Area where areaPk="+ID);
        if (L1.size()>0)
        	return (String)L1.get(0);
        else return null;
		   
	}
	
	public Area GetObjById(Long pk){
		
		List L1=getHibernateTemplate().find("from Area where areaPk="+pk);
        if (L1.size()>0)
        	return (Area)L1.get(0);
        else return null;
	}

}