dao.java

?

package com.team.base;

import java.util.List;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
import com.team.hibernate.HibernateSessionFactory;
public class Dao {
	public BaseVO load(BaseVO baseVO){
		// TODO Auto-generated method stub
		Session session = null;
		Transaction tx = null;
		try {
			HibernateSessionFactory.setConfigFile("hibernate1.cfg.xml");
			session = HibernateSessionFactory.getSession();
			tx = session.beginTransaction();
			baseVO = (BaseVO) session.get(baseVO.getClass(), baseVO.getID());
			baseVO.getID();
			return baseVO;
		} catch (HibernateException he) {
			he.printStackTrace();
		} finally {
			if (tx != null) {
				tx.commit();
			}
			if (session != null) {
				session.close();
			}
		}
		return null;
	}

	/**
	 * 删除一个对象
	 */
	public boolean remove(BaseVO baseVO) {
		// TODO Auto-generated method stub
		Session session = null;
		Transaction tx = null;
		boolean flag = false;
		try {
			session = HibernateSessionFactory.getSession();
			tx = session.beginTransaction();
			baseVO = (BaseVO) session.load(baseVO.getClass(), baseVO.getID());
			session.delete(baseVO);
			flag = true;
		} catch (HibernateException he) {
			he.printStackTrace();
		} finally {
			if (tx != null) {
				tx.commit();
			}
			if (session != null) {
				session.close();
			}
		}
		return flag;
	}

	/**
	 * 根据sql语句删除一个对象
	 * 
	 */
	public boolean remove(String hql){
		// TODO Auto-generated method stub
		Session session = null;
		Transaction tx = null;
		boolean flag = false;
		try {
			session = HibernateSessionFactory.getSession();
			tx = session.beginTransaction();
			Query query = session.createQuery(hql);
			int i=query.executeUpdate();
			if(i>0){
				flag=true;
			}
		} catch (HibernateException he) {
			he.printStackTrace();
		} finally {
			if (tx != null) {
				tx.commit();
			}
			if (session != null) {
				session.close();
			}
		}
		return flag;
	}

	/**
	 * 保存一个对象
	 */
	public void save(BaseVO baseVO) {
		// TODO Auto-generated method stub
		Session session = null;
		Transaction tx = null;
		try {
			session = HibernateSessionFactory.getSession();
			tx = session.beginTransaction();
			session.save(baseVO);
		} catch (HibernateException he) {
			he.printStackTrace();
			tx.rollback();
		} finally {
			if (tx != null) {
				tx.commit();
			}

			if (session != null) {
				session.close();
			}
		}

	}

	/**
	 * 更新一个对象
	 */
	public void update(BaseVO baseVO){
		// TODO Auto-generated method stub
		Session session = null;
		Transaction tx = null;
		try {
			session = HibernateSessionFactory.getSession();
			tx = session.beginTransaction();
			session.update(baseVO);
		} catch (HibernateException he) {
			he.printStackTrace();
		} finally {
			if (tx != null) {
				tx.commit();
			}
			if (session != null) {
				session.close();
			}
		}
	}
	public List excetueQuery(String hql) {
		// TODO 自动生成方法存根
		Session session = null;
		Transaction tx = null;
		List list = null;
		try {
			session = HibernateSessionFactory.getSession();
			tx = session.beginTransaction();
			Query query = session.createQuery(hql);
			list = query.list();
		} catch (HibernateException he) {
			he.printStackTrace();
		} finally {
			if (tx != null)
				tx.commit();

			if (session != null)
				session.close();
		}

		return list;
	}
}