conferencedao.java

一个oa系统

package com.oa.db;

import java.util.List;

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

public class ConferenceDao extends HibernateDaoSupport {

	/**
	 * 查询所以的会议记录
	 * 
	 * @return list
	 */
	public List findAll() {
		List list = null;
		try {  
			list = (List) this.getHibernateTemplate().find("from Conference order by id DESC");
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}

	/**
	 * 添加新的会议记录
	 * 
	 * @param conference
	 */
	public void addConference(Conference conference) {
		try {  
			this.getHibernateTemplate().save(conference);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	/**
	 * 根据会议id查询会议记录
	 * 
	 * @param id
	 * @return list
	 */
	public List findById(int id) {
		 List list = null;
			try {  
				list = (List) this.getHibernateTemplate().find("from Conference where id=?", id);
			} catch (HibernateException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			return list;
	}
	
	/**
	 * 更新会议记录
	 * 
	 * @param conference
	 */
	public void updateConference(Conference conference) {
		try { 
			this.getHibernateTemplate().update(conference);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	/**
 	* 根据id删除会议记录
 	* 
 	* @param id
 	*/
	public void deleteConference(int id) {
		 List list = null;
			try {  
				list = (List) this.getHibernateTemplate().find("from Conference where id=?", id);
				Conference conference = (Conference) list.get(0);
				this.getHibernateTemplate().delete(conference);
			} catch (HibernateException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
	}
}