postdao.java

一个oa系统

package com.oa.db;

import java.util.List;

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


public class PostDAO extends HibernateDaoSupport{
	public String findPostById(int parecid){//通过id查询职位
		List list = null;
		String post = null;
		try {
			list = this.getHibernateTemplate().find("from Post where id="+parecid);
			if(list!=null&&list.size()!=0){
				Post vo = (Post)list.get(0);
				post = vo.getPost();
			}
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return post;
	}
	
	public List QueryPost() {//查询职位
		List list = null;
		try {
			list = this.getHibernateTemplate().find("from Post");	
			} catch (HibernateException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		    return list;
	}
}