Dao hibernate 共用

package ;

import java.io.Serializable;
import java.util.List;
import javax.annotation.PostConstruct;
import javax.annotation.Resource;
import org.hibernate.SessionFactory;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import org.springframework.stereotype.Repository;


@Repository
public class SystemBaseDAO extends HibernateDaoSupport implements ISystemBaseDAO {

	@Resource
	private SessionFactory mySessionFactory;
	
//	private static final Log log = LogFactory.getLog(SystemBaseDAO.class);

	@PostConstruct
	public void InjectedSessionFactory() {
		super.setSessionFactory(mySessionFactory);
	}
	
	@Override
	public int save(Object record) {
//		log.info("new record save:"+record.getClass().getSimpleName()+":"+record.toString());
		return (int) getHibernateTemplate().save(record);
	}

	public void _save(Object record) {
//		log.info("new record save:"+record.getClass().getSimpleName()+":"+record.toString());
		getHibernateTemplate().save(record);
	}

	@Override
	public void attachDirty(Object record, Object old) {
//		log.info("record update:"+record.getClass().getSimpleName()+":"+record.toString());
		getHibernateTemplate().saveOrUpdate(record);
	}

	@Override
	public void delete(Object record) {
		getHibernateTemplate().delete(record);
	}

	@Override
	public Object findById(Class<?> clz, Object id) {
		Object record;
		try {
			record = getHibernateTemplate().get(clz.getName(), Integer.parseInt(id.toString()));
		} catch (Exception e) {
			record = getHibernateTemplate().get(clz.getName(), (Serializable) id);
		}
		return record;
	}

	@Override
	public Object findObjectByHql(String hql) {
		Object obj = null;
		List<?> list = getHibernateTemplate().find(hql);
		if(list != null && list.size() > 0){
			obj = list.get(0);
		}
		return obj;
	}

	@Override
	public List<?> findListByHql(String hql) {
		List<?> list = getHibernateTemplate().find(hql);
		return list;
	}

	@Override
	public List<?> findListByHql(String hql, int pageSize, int pageNo) {
		return getSession().createQuery(hql).setFirstResult((pageNo - 1) * pageSize).setMaxResults(pageSize).list();
	}

	@Override
	public int getTotal(String hql) {
		List<?> list = getSession().createQuery(hql).list();
		if(list != null){
			return list.size();
		}
		return 0;
	}

	@Override
	public List<?> findListBySql(String sql) {
		return getSession().createSQLQuery(sql).list();
	}
	
	/**
	 * 查找表最大序列号
	 */
	public int getIndex(String hql){
		int _id = 0;
		try{
			_id = (Integer)findObjectByHql(hql) + 1;
		}catch(NullPointerException e){
			_id = 1;
		}
		return _id;
	}
	
	public String getMaxIndex(String sql) {
		Object max = getSession().createSQLQuery(sql).uniqueResult();
		 if(max == null) {
			 max = "0";
		 }
		 return max.toString();
	}
	
}