package com.zhou.dao;

import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.zhou.services.HibernateSessionFactory;
public abstract class BaseImpl {

	protected Session session = HibernateSessionFactory.getSession();
	protected Transaction tran ;
	
	/**
	 * 添加數(shù)據(jù)方法
	 * @param o 需添加的實(shí)體
	 * @return  true 添加成功  false  添加失敗
	 */
	protected  boolean  insert(Object o)  {
		tran = session.getTransaction();
		try {
			tran.begin();
			session.save(o);
			tran.commit();
			return true;
		} catch (HibernateException e) {
			// TODO 自動(dòng)生成 catch 塊
			tran.rollback();
			e.printStackTrace();
		}
		return false;
	}
	
	/**
	 * 修改數(shù)據(jù)方法
	 * @param o 需添加的實(shí)體
	 * @return  true 添加成功  false  添加失敗
	 */
	protected  boolean  update(Object o) {
		tran = session.getTransaction();
		try {
			tran.begin();
			session.update(o);
			tran.commit();
			return true;
		} catch (HibernateException e) {
			// TODO 自動(dòng)生成 catch 塊
			tran.rollback();
			e.printStackTrace();
		}
		return false;
	}
	
	/**
	 * 刪除數(shù)據(jù)方法
	 * @param o 需添加的實(shí)體
	 * @return  true 添加成功  false  添加失敗
	 */
	protected  boolean  delete(Object o) {
		tran = session.getTransaction();
		try {
			tran.begin();
			session.delete(o);
			tran.commit();
			return true;
		} catch (HibernateException e) {
			// TODO 自動(dòng)生成 catch 塊
			tran.rollback();
			e.printStackTrace();
		}
		return false;
	}
	
	protected List getListByAttributer(String attributer,String attributerValue,String beanName) {
		String sql = "from "+beanName;
		if(attributer.length()!=0 && attributerValue.length()!=0) {
			sql = sql + " where "+attributer+"='"+attributerValue+"'";
		}
		return this.getList(sql);
	}
	
	protected Object getBeanById(String beanName,String idName,int id) {
		String sql = "from "+beanName+"  where "+idName+" = "+id;
		return this.getList(sql).get(0);
	}
	
	public List getList(String sql) {
		return session.createQuery(sql).list();
	}
	
}