areadao.java

一个oa系统

package com.oa.db;

import java.util.List;

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

public class AreaDAO extends HibernateDaoSupport{
	public List query(){
	    List list = null;
		try {   
	        list=this.getHibernateTemplate().find("from Area");
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	    	return list;
    }
	
	public String findColumnById(String parecid){//通过id查询
		List list = null;
		String area = "";
		try {
			list = this.getHibernateTemplate().find("from Area where areaid=?",parecid);
			if(list!=null&&list.size()!=0){
				Area vo = (Area)list.get(0);
				area = vo.getAreaname();
			}
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return area;
	}

}