package?com.shortRent.dao;

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

import?org.hibernate.Query;
import?org.hibernate.Session;
import?org.hibernate.Transaction;

import?com.shortRent.util.HibernateUtil;

public?class?baseDAO?{
	/**
	?*?@param?obj
	?*????????????添加數據
	?*?@return
	?*/
	public?static?boolean?add（object?obj）?{
		Session?session?=?null;
		Transaction?tran?=?null;
		boolean?result?=?false;
		try?{
			session?=?HibernateUtil.getSession（）;
			tran?=?session.beginTransaction（）;
			session.save（obj）;
			tran.commit（）;
			result?=?true;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
			if?（tran?!=?null）?{
				//?事物回滾
				tran.rollback（）;
			}
		}?finally?{
			if?（session?!=?null）?{
				//?關閉session
				session.close（）;
			}
		}
		return?result;
	}

	/**
	?*?@return?更新數據?參數為修改的主鍵id對象
	?*/
	public?static?boolean?update（object?object）?{
		Session?session?=?null;
		Transaction?tran?=?null;
		boolean?result?=?false;
		try?{
			session?=?HibernateUtil.getSession（）;
			tran?=?session.beginTransaction（）;
			session.update（object）;
			tran.commit（）;
			result?=?true;
		}?catch?（Exception?e）?{
			if?（tran?!=?null）?{
				//?事物回滾
				tran.rollback（）;
			}
		}?finally?{
			if?（session?!=?null）?{
				//?關閉session
				session.close（）;
			}
		}
		return?result;
	}

	/**
	?*?@param?c
	?*?@param?obj
	?*????????????查詢一條數據根據主鍵的id號
	?*?@return
	?*/
	public?static?object?get（Class?c?Serializable?id）?{
		Session?session?=?null;
		object?object?=?null;
		try?{
			session?=?HibernateUtil.getSession（）;
			object?=?session.get（c?id）;
		}?catch?（Exception?e）?{
		}?finally?{
			if?（session?!=?null）?{
				//?關閉session
				session.close（）;
			}
		}
		return?object;
	}

	/**
	?*?@param?obj
	?*?@return?刪除數據
	?*/
	public?static?boolean?delete（object?obj）?{
		Session?session?=?null;
		Transaction?tran?=?null;
		boolean?result?=?false;
		try?{
			session?=?HibernateUtil.getSession（）;
			tran?=?session.beginTransaction（）;
			session.delete（obj）;
			tran.commit（）;
			result?=?true;
		}?catch?（Exception?e）?{
			if?（tran?!=?null）?{
				//?事物回滾
				tran.rollback（）;
			}
		}?finally?{
			if?（session?!=?null）?{
				//?關閉session
				session.close（）;
			}
		}
		return?result;
	}

	/**
	?*?@param?
	?*????????????查詢多條記錄
	?*?@param?sql
	?*????????????sql語句
	?*?@param?param
	?*????????????參數數組
	?*?@return
	?*/
	@SuppressWarnings（“unchecked“）
	public?static??List?query（String?sql?List?param）?{
		List?list?=?new?ArrayList（）;
		Session?session?=?null;
		try?{
			session?=?HibernateUtil.getSession（）;
			Query?query?=?session.createQuery（sql）;
			if?（param?!=?null）?{
				for?（int?i?=?0;?i?					query.setParameter（i?param.get（i））;
				}
			}
			list?=?query.list（）;
		}?catch?（Exception?e）?{
		}?finally?{
			if?（session?!=?null）?{
				session.close（）;
			}
		}
		retur

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-10-11?09:14??ShortRent\
?????文件?????????191??2016-06-13?10:07??說明.txt
?????文件????????2197??2013-03-13?08:36??ShortRent\.classpath
?????目錄???????????0??2013-03-14?17:33??ShortRent\.myeclipse\
?????文件?????????301??2013-03-13?08:36??ShortRent\.mymetadata
?????文件????????1752??2013-03-13?08:36??ShortRent\.project
?????目錄???????????0??2013-03-14?18:40??ShortRent\.settings\
?????文件?????????500??2013-03-13?08:36??ShortRent\.settings\.jsdtscope
?????文件????????1040??2013-03-13?08:36??ShortRent\.settings\com.genuitec.eclipse.j2eedt.core.prefs
?????文件?????????274??2013-03-14?14:52??ShortRent\.settings\org.eclipse.core.resources.prefs
?????文件?????????395??2013-03-13?08:36??ShortRent\.settings\org.eclipse.jdt.core.prefs
?????文件?????????465??2013-03-13?08:36??ShortRent\.settings\org.eclipse.wst.common.component
?????文件?????????252??2013-03-13?08:36??ShortRent\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2013-03-13?08:36??ShortRent\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2013-03-13?08:36??ShortRent\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2013-03-14?18:40??ShortRent\data\
?????目錄???????????0??2013-03-14?17:33??ShortRent\data\sql\
?????目錄???????????0??2013-03-14?18:40??ShortRent\lib\
?????目錄???????????0??2013-03-14?17:33??ShortRent\lib\struts\
?????目錄???????????0??2013-03-14?18:40??ShortRent\src\
?????目錄???????????0??2013-03-14?18:40??ShortRent\src\com\
?????目錄???????????0??2013-03-14?18:40??ShortRent\src\com\shortRent\
?????目錄???????????0??2013-03-14?18:40??ShortRent\src\com\shortRent\dao\
?????文件????????5860??2013-03-13?08:36??ShortRent\src\com\shortRent\dao\baseDAO.java
?????目錄???????????0??2013-03-14?18:40??ShortRent\src\com\shortRent\model\
?????文件????????1306??2013-03-13?08:36??ShortRent\src\com\shortRent\model\ActTable.hbm.xml
?????文件????????1225??2013-03-13?08:36??ShortRent\src\com\shortRent\model\ActTable.java
?????文件?????????950??2013-03-13?08:36??ShortRent\src\com\shortRent\model\Admin.hbm.xml
?????文件?????????969??2013-03-13?08:36??ShortRent\src\com\shortRent\model\Admin.java
?????文件?????????813??2013-03-13?16:51??ShortRent\src\com\shortRent\model\AreaType.hbm.xml
?????文件?????????673??2013-03-13?08:36??ShortRent\src\com\shortRent\model\AreaType.java
............此處省略244個文件信息