thomeworkdao.java

持久层hibernate技术使用的一个例子

package cn.hope.front.pojo.dao;

import java.util.List;

import org.apache.log4j.Logger;

import net.sf.hibernate.HibernateException;
import cn.hope.front.pojo.THomework;
import cn.hope.front.pojo.base.BaseTHomeworkDAO;


public class THomeworkDAO extends BaseTHomeworkDAO {
	Logger log = Logger.getLogger(THomeworkDAO.class.getName());

	/**
	 * Default constructor.  Can be used in place of getInstance()
	 */
	public THomeworkDAO () {}
	/**************jinxl**************/
	/**
	 * 插入数据方法
	 * 
	 * @param tFile
	 * @return
	 * @throws HibernateException
	 */
	public Integer insert(THomework tHomework) throws HibernateException {
		try {
			initialize();// 初始化session
			return (Integer) this.save(tHomework);// 调用生成好的父类方法save(),返回被插入数据的主键
		} catch (HibernateException e) {
			log.error(e);
			e.printStackTrace();
			throw new HibernateException(e);
		} finally {
			closeCurrentThreadSessions();// 关闭当前session
		}
	}
	
	public void modify(THomework tHomework) throws HibernateException {
		try {
			initialize();
			this.update(tHomework);
		} catch (HibernateException e) {
			log.error(e);
			e.printStackTrace();
			throw new HibernateException(e);
		} finally {
			closeCurrentThreadSessions();
		}
	}
	
	public List searchAll() throws HibernateException {
		List list = null;
		String sqlStr = "select tHomework from THomework tHomework where tHomework.flag='0' ";
		try {
			initialize();
			list = this.getSession().find(sqlStr);
		} catch (HibernateException e) {
			log.error(e);
			e.printStackTrace();
			throw new HibernateException(e);
		} finally {
			closeCurrentThreadSessions();
		}
		return list;
	}

	public THomework searchByKey(Integer id) throws HibernateException {
		THomework tHomework = null;
		String sqlStr = "select tHomework from THomework tHomework where tHomework.flag='0' and tHomework.id='"
				+ id + "'";
		try {
			initialize();
			List list = this.getSession().find(sqlStr);
			if (list.size() > 0) {
				tHomework = (THomework) list.get(0);
			}
		} catch (HibernateException e) {
			log.error(e);
			e.printStackTrace();
			throw new HibernateException(e);
		} finally {
			closeCurrentThreadSessions();
		}
		return tHomework;
	}
	/*****************jinxl*******************/
}