package?cn.itsource.crm.dao;

import?java.io.Serializable;
import?java.sql.SQLException;
import?java.util.Arrays;
import?java.util.List;
import?java.util.Map;

import?org.hibernate.HibernateException;
import?org.hibernate.Query;
import?org.hibernate.Session;
import?org.springframework.orm.hibernate3.HibernateCallback;
import?org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import?cn.itsource.crm.query.baseQuery;
import?cn.itsource.crm.utils.PageResult;

public?class?baseDao?extends?HibernateDaoSupport?{
	public?void?save（T?t）?{
		getHibernateTemplate（）.save（t）;
	}

	public?void?update（T?t）?{
		getHibernateTemplate（）.update（t）;
	}

	/**
	?*?
	?*?@param?Serializable
	?*????????????id:Hibernate主鍵類型只要實現Serializable接口就可以使用?LongString
	?*/
	public?void?delete（Class?entityClass?Serializable?id）?{
		T?t?=?get（entityClass?id）;
		if?（t?!=?null）
			getHibernateTemplate（）.delete（t）;
	}

	public?T?get（Class?entityClass?Serializable?id）?{
		return?getHibernateTemplate（）.get（entityClass?id）;
	}

	public?List?getAll（Class?entityClass）?{
		return?getHibernateTemplate（）.loadAll（entityClass）;
		//?return?getHibernateTemplate（）.find（“from?“?+?entityClass.getName（））;
	}

	public?PageResult?findPageResult（final?baseQuery?baseQuery）?{
		//?System.out.println（“hql:“?+?baseQuery.getHql（））;
		//?System.out.println（“countHql:“?+?baseQuery.getCountHql（））;
		//?System.out.println（“param:“?+?baseQuery.getParamList（））;

		//?獲取到原生Hibernate.Session對象做查詢
		//?單例是否對應一個請求
		//?getSession（）;//?單例
		//?getSessionFactory（）.openSession（）;//?多例
		//?getSessionFactory（）.getCurrentSession（）;//?單例
		//?上面獲取的session都必須自己關閉都不用

		//?下面都會自動關閉session.由spring關閉的
		//?getHibernateTemplate（）.executeFind（action）//?多例
		//?getHibernateTemplate（）.executeWithNewSession（action）//?多例

		/********************?必須使用Native的?*********************/
		//?getHibernateTemplate（）.executeWithNativeSession（action）//?單例

		//?1.count查詢
		Long?count?=?getHibernateTemplate（）.executeWithNativeSession（
				new?HibernateCallback（）?{
					//?由spring把session注入進來
					public?Long?doInHibernate（Session?session）
							throws?HibernateException?SQLException?{
						//?counthql
						Query?query?=?session.createQuery（baseQuery
								.getCountHql（））;
						//?加入條件
						builderParam（query?baseQuery.getParamList（））;
						return?（Long）?query.uniqueResult（）;
					}
				}）;
		if?（count.intValue（）?==?0）?{
			return?new?PageResult（）;
		}

		int?currentPage?=?baseQuery.getCurrentPage（）;
		int?pageSize?=?baseQuery.getPageSize（）;
		int?totalCount?=?count.intValue（）;
		final?PageResult?pageResult?=?new?PageResult（currentPage
				pageSize?totalCount）;
		//?2.*查詢
		List?rows?=?getHibernateTemplate（）.executeWithNativeSession（
				new?HibernateCallback>（）?{
					public?List?doInHibernate（Session?session）
							throws?HibernateException?SQLException?{
						//?hql
						Q

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????1023??2015-01-06?10:39??Crm-demo_ssh\.classpath

?????文件???????1041??2015-03-13?09:52??Crm-demo_ssh\.project

?????文件????????503??2015-01-06?10:12??Crm-demo_ssh\.settings\.jsdtscope

?????文件????????364??2015-01-06?10:12??Crm-demo_ssh\.settings\org.eclipse.jdt.core.prefs

?????文件????????631??2015-03-13?09:52??Crm-demo_ssh\.settings\org.eclipse.wst.common.component

?????文件????????345??2015-01-06?10:12??Crm-demo_ssh\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2015-01-06?10:12??Crm-demo_ssh\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2015-01-06?10:12??Crm-demo_ssh\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件?????521426??2015-10-16?14:18??Crm-demo_ssh\itsource_crm.sql

?????文件???????3743??2015-01-14?14:17??Crm-demo_ssh\resources\applicationContext-action.xml

?????文件???????1102??2015-01-06?10:43??Crm-demo_ssh\resources\applicationContext-dao.xml

?????文件???????2512??2015-01-14?14:17??Crm-demo_ssh\resources\applicationContext-service.xml

?????文件???????3372??2015-01-09?15:51??Crm-demo_ssh\resources\applicationContext.xml

?????文件????????378??2015-03-13?18:53??Crm-demo_ssh\resources\jdbc.properties

?????文件???????1941??2015-01-12?17:09??Crm-demo_ssh\resources\struts.xml

?????文件???????4419??2015-01-14?16:28??Crm-demo_ssh\src\cn\itsource\crm\dao\baseDao.java

?????文件????????388??2015-01-10?17:05??Crm-demo_ssh\src\cn\itsource\crm\domain\Cat.hbm.xml

?????文件????????310??2015-01-10?17:05??Crm-demo_ssh\src\cn\itsource\crm\domain\Cat.java

?????文件????????992??2015-01-12?15:48??Crm-demo_ssh\src\cn\itsource\crm\domain\Customer.hbm.xml

?????文件???????2655??2015-01-12?16:00??Crm-demo_ssh\src\cn\itsource\crm\domain\Customer.java

?????文件????????751??2015-01-14?14:18??Crm-demo_ssh\src\cn\itsource\crm\domain\CustomerTraceHistory.hbm.xml

?????文件???????1996??2015-01-14?09:05??Crm-demo_ssh\src\cn\itsource\crm\domain\CustomerTraceHistory.java

?????文件????????737??2015-01-14?14:18??Crm-demo_ssh\src\cn\itsource\crm\domain\CustomerTransferHistory.hbm.xml

?????文件???????1650??2015-01-14?09:05??Crm-demo_ssh\src\cn\itsource\crm\domain\CustomerTransferHistory.java

?????文件????????744??2015-01-09?09:21??Crm-demo_ssh\src\cn\itsource\crm\domain\Department.hbm.xml

?????文件???????1545??2015-01-09?15:18??Crm-demo_ssh\src\cn\itsource\crm\domain\Department.java

?????文件????????932??2015-01-12?11:10??Crm-demo_ssh\src\cn\itsource\crm\domain\Employee.hbm.xml

?????文件???????3061??2015-01-12?10:49??Crm-demo_ssh\src\cn\itsource\crm\domain\Employee.java

?????文件????????451??2015-01-10?11:16??Crm-demo_ssh\src\cn\itsource\crm\domain\Permission.hbm.xml

?????文件????????826??2015-01-10?11:15??Crm-demo_ssh\src\cn\itsource\crm\domain\Permission.java

............此處省略673個文件信息