package cfw.dao.impl;

import java.io.Serializable;
import java.lang.reflect.ParameterizedType;
import java.util.Iterator;
import java.util.List;
import java.util.Map;

import javax.annotation.Resource;

import org.apache.commons.lang.StringEscapeUtils;
import org.apache.poi.ss.formula.functions.T;
import org.hibernate.Query;
import org.hibernate.SessionFactory;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import cfw.dao.IBaseDao;

@SuppressWarnings("hiding")
public class BaseDao<T> extends HibernateDaoSupport implements IBaseDao<T>{
	@Resource(name = "sessionFactory")
	public void setSuperSessionFactory(SessionFactory sessionFactory) {
		super.setSessionFactory(sessionFactory);
	}
	

	private Class<T> clazz;
	@SuppressWarnings("unchecked")
	public BaseDao() {
		clazz =(Class<T>) ((ParameterizedType) getClass().getGenericSuperclass()).getActualTypeArguments()[0];
	}
	@Override
	public T findById(Serializable id) {
		return this.getHibernateTemplate().get(clazz, id);
	}
	@Override
	public void  update(T obj) {
		// TODO Auto-generated method stub
		this.getHibernateTemplate().update(obj);
	}
	@Override
	public void save(T obj) {
		this.getHibernateTemplate().saveOrUpdate(obj);
		
	}
	@SuppressWarnings("unchecked")
	@Override
	public T findObject(Map<String, Object> param) {
		final StringBuffer hsql = new StringBuffer();
		hsql.append("from " +  clazz.getSimpleName() + " where 1=1");
		if(param != null)
		{
			Iterator<String> it = param.keySet().iterator();		
			while(it.hasNext())
			{
				String field = it.next();
				Object value = param.get(field);
				if(value != null && !value.equals(""))
				{
					hsql.append(" and " + field + "='" + StringEscapeUtils.escapeSql(value.toString()) +"'");
				}else if (field != null && value == null) {
					hsql.append(" and " + field);
				}
			}

			List<T> result = (List<T>) getHibernateTemplate().execute(   
					new HibernateCallback<T>() {   
						public T doInHibernate(org.hibernate.Session session)   
						throws org.hibernate.HibernateException {   
							Query query = session.createQuery(hsql.toString()); 
							List<T> rows = query.list();   
							return (T) rows;   
						}   
					});  
			if (result !=null && result.size()>0) {
				return result.get(0);
			}
		}
		return null;
	}
}