package?com.pc.basic;

import?java.io.Serializable;
import?java.util.Iterator;
import?java.util.List;

import?javax.annotation.Resource;

import?org.hibernate.Query;
import?org.hibernate.SessionFactory;
import?org.hibernate.classic.Session;
import?org.springframework.transaction.annotation.Transactional;

//配置注解@Transactional用處是讓spring的事務管理器接管該Service的事務
@Transactional
public?abstract?class?BasicService?implements?BasicServiceInter?{
	//?當給某個屬性增加了@Resource后，spring會啟用byName的方式注入屬性值
	@Resource
	private?SessionFactory?sessionFactory;
	
	@Override
	public?object?executeUniqueQuery（String?hql?object[]?parameters）?{
		//?TODO?Auto-generated?method?stub
		Query?query?=?this.sessionFactory.getCurrentSession（）.createQuery（hql）;
		
		//?給?賦值
		if（parameters?!=?null?&&?parameters.length?>?0）?{
			for（int?i?=?0;?i?				query.setParameter（i?parameters[i]）;
			}
		}
		return?query.uniqueResult（）;
	}

	public?void?setSessionFactory（SessionFactory?sessionFactory）?{
		this.sessionFactory?=?sessionFactory;
	}

	@Override
	public?object?findById（Class?clazz?Serializable?id）?{
		//?TODO?Auto-generated?method?stub
		return?this.sessionFactory.getCurrentSession（）.load（clazz?id）;
	}

	@Override
	public?List?executeQuery（String?hql?object[]?parameters）?{
		//?TODO?Auto-generated?method?stub
		Query?query?=?this.sessionFactory.getCurrentSession（）.createQuery（hql）;
		
		//?注入?
		if（parameters?!=?null?&&?parameters.length?>?0）?{
			for（int?i?=?0;?i?				query.setParameter（i?parameters[i]）;
			}
		}
		
		return?query.list（）;
	}

	@Override
	public?List?executeQueryByPage（String?hql?object[]?parameters
			int?pageNow?int?pageSize）?{
		//?TODO?Auto-generated?method?stub
		Query?query?=?this.sessionFactory.getCurrentSession（）.createQuery（hql）;
		
		//?注入?
		if（parameters?!=?null?&&?parameters.length?>?0）?{
			for（int?i?=?0;?i?				query.setParameter（i?parameters[i]）;
			}
		}
		
		//?分頁
		//?設置起始記錄
		query.setFirstResult（（pageNow?-?1）?*?pageSize）;
		//?設置每頁記錄數
		query.setMaxResults（pageSize）;
		
		return?query.list（）;
	}

	@Override
	public?void?add（object?object）?{
		//?TODO?Auto-generated?method?stub
		this.sessionFactory.getCurrentSession（）.save（object）;
	}

	@Override
	public?void?executeUpdate（String?hql?object[]?parameters）?{
		Query?query?=?this.sessionFactory.getCurrentSession（）.createQuery（hql）;
		//?注入?
		if（parameters?!=?null?&&?parameters.length?>?0）?{
			for（int?i?=?0;?i?				query.setParameter（i?parameters[i]）;
			}
		}
	}
	
	@Override
	public?int?queryPageCount（String?hql?object[]?parameters?int?pageSize）?{
		//?獲取rowCount
		int?pageRow?=?Integer.parseInt（this.executeUniqueQuery（hql?parameters）.toString（））;
		//?分頁總頁數算法，pageSize?-?1相當于最大余數
		return?（pageRow?+?pageSize?-?1）?/?pageSize;
	}

	@Override
	public?void?deleteById（Class?clazzS

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2016-02-25?20:54??MySSH\
?????文件????????4205??2016-02-27?15:40??MySSH\.classpath
?????目錄???????????0??2016-02-29?20:53??MySSH\.myeclipse\
?????文件?????????288??2016-02-25?20:54??MySSH\.mymetadata
?????文件????????1748??2016-02-27?15:02??MySSH\.project
?????目錄???????????0??2016-02-25?20:54??MySSH\.settings\
?????文件?????????665??2016-02-28?22:08??MySSH\.settings\.jsdtscope
?????文件?????????364??2016-02-25?20:54??MySSH\.settings\org.eclipse.jdt.core.prefs
?????文件?????????453??2016-02-25?20:54??MySSH\.settings\org.eclipse.wst.common.component
?????文件?????????252??2016-02-25?20:54??MySSH\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2016-02-28?22:08??MySSH\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2016-02-28?22:08??MySSH\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2016-02-28?21:01??MySSH\WebRoot\
?????目錄???????????0??2016-02-25?20:54??MySSH\WebRoot\meta-INF\
?????文件??????????36??2016-02-25?20:54??MySSH\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2016-02-29?19:18??MySSH\WebRoot\WEB-INF\
?????文件????????1291??2016-02-28?14:59??MySSH\WebRoot\WEB-INF\addEmployeeUI.jsp
?????目錄???????????0??2016-02-28?21:18??MySSH\WebRoot\WEB-INF\classes\
?????文件????????4472??2016-02-28?15:56??MySSH\WebRoot\WEB-INF\classes\applicationContext.xml
?????目錄???????????0??2016-02-28?21:18??MySSH\WebRoot\WEB-INF\classes\com\
?????目錄???????????0??2016-02-28?21:18??MySSH\WebRoot\WEB-INF\classes\com\pc\
?????目錄???????????0??2016-02-28?21:18??MySSH\WebRoot\WEB-INF\classes\com\pc\basic\
?????文件????????3517??2016-02-29?19:50??MySSH\WebRoot\WEB-INF\classes\com\pc\basic\BasicService.class
?????文件?????????725??2016-02-29?19:49??MySSH\WebRoot\WEB-INF\classes\com\pc\basic\BasicServiceInter.class
?????目錄???????????0??2016-02-28?21:18??MySSH\WebRoot\WEB-INF\classes\com\pc\domain\
?????文件????????1474??2016-02-28?21:18??MySSH\WebRoot\WEB-INF\classes\com\pc\domain\Department.class
?????文件?????????719??2016-02-27?20:07??MySSH\WebRoot\WEB-INF\classes\com\pc\domain\Department.hbm.xml
?????文件????????2437??2016-02-28?21:18??MySSH\WebRoot\WEB-INF\classes\com\pc\domain\Employee.class
?????文件????????1407??2016-02-27?21:15??MySSH\WebRoot\WEB-INF\classes\com\pc\domain\Employee.hbm.xml
?????目錄???????????0??2016-02-28?21:18??MySSH\WebRoot\WEB-INF\classes\com\pc\service\
?????目錄???????????0??2016-02-28?21:18??MySSH\WebRoot\WEB-INF\classes\com\pc\service\imp\
............此處省略108個文件信息