package?com.dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;

import?com.utils.DatabaseUtil;

/**
?*?數據庫管理！
?*?
?*?@author?Administrator
?*
?*/
public?class?baseDao?{
	//?聲明Connection對象屬性！
	private?Connection?conn?=?null;

	/**
	?*?帶參構造方法！
	?*?
	?*?@param?conn
	?*/
	public?baseDao（Connection?conn）?{
		//?通過構造方法的形式給Connection賦值！
		this.conn?=?conn;
	}

	/**
	?*?增！刪！改！操作??！
	?*?
	?*?@param?sql
	?*?@param?parms
	?*?@return
	?*/
	protected?int?excuteUpdate（String?sql?object[]?parms）?{
		//?聲明PreparedStatement對象！
		PreparedStatement?pstms?=?null;
		//?聲明變量接受受影響行數！
		int?result?=?-1;
		try?{
			//?執行SQL語句！
			pstms?=?conn.prepareStatement（sql）;
			//?判斷返回值結果是否為空！
			if?（parms?!=?null）?{
				//?循環遍歷object數組！
				for?（int?i?=?0;?i?					//?循環為SQL語句賦值！
					pstms.setobject（i?+?1?parms[i]）;
				}
				//?調用增刪改方法！
				result?=?pstms.executeUpdate（）;

			}
		}?catch?（Exception?e）?{
			System.err.println（e.getMessage（））;
		}?finally?{
			//?關閉資源！
			DatabaseUtil.closeAll（null?pstms?null）;
		}
		return?result;
	}

	/**
	?*?查詢操作！
	?*?
	?*?@param?sql
	?*?@param?parms
	?*?@return
	?*/
	protected?ResultSet?excuteQuery（String?sql?object[]?parms）?{
		//?聲明PreparedStatement對象！
		PreparedStatement?pstms?=?null;
		//?聲明ResultSet對象用于返回查詢到的結果集！
		ResultSet?result?=?null;
		try?{
			//?執行SQL語句！
			pstms?=?conn.prepareStatement（sql）;
			//?判斷返回值結果是否為空！
			if?（parms?!=?null）?{
				//?循環遍歷object數組！
				for?（int?i?=?0;?i?					//?循環為SQL語句賦值！
					pstms.setobject（i?+?1?parms[i]）;
				}
			}
			//?調用查詢方法！
			result?=?pstms.executeQuery（）;
		}?catch?（Exception?e）?{
			System.err.println（e.getMessage（））;
		}
		return?result;
	}
}

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

?????文件????????819??2018-06-23?21:50??易買網\EasyBuy\.classpath

?????文件????????907??2018-06-23?21:50??易買網\EasyBuy\.project

?????文件????????567??2018-06-23?21:50??易買網\EasyBuy\.settings\.jsdtscope

?????文件????????139??2018-06-25?22:21??易買網\EasyBuy\.settings\org.eclipse.core.resources.prefs

?????文件????????364??2018-06-23?21:50??易買網\EasyBuy\.settings\org.eclipse.jdt.core.prefs

?????文件????????553??2018-06-23?21:50??易買網\EasyBuy\.settings\org.eclipse.wst.common.component

?????文件????????345??2018-06-23?21:50??易買網\EasyBuy\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2018-06-23?21:50??易買網\EasyBuy\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2018-06-23?21:50??易買網\EasyBuy\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????1959??2018-06-28?13:31??易買網\EasyBuy\build\classes\com\dao\baseDao.class

?????文件????????475??2018-06-28?13:31??易買網\EasyBuy\build\classes\com\dao\EasybuyCollectDao.class

?????文件????????666??2018-06-28?13:31??易買網\EasyBuy\build\classes\com\dao\EasybuyOrderDao.class

?????文件????????443??2018-06-28?13:31??易買網\EasyBuy\build\classes\com\dao\EasybuyUserAddressDao.class

?????文件????????775??2018-06-28?13:31??易買網\EasyBuy\build\classes\com\dao\EasybuyUserDao.class

?????文件???????4053??2018-06-28?13:31??易買網\EasyBuy\build\classes\com\dao\impl\EasybuyCollectDaoImpl.class

?????文件???????4001??2018-06-28?13:31??易買網\EasyBuy\build\classes\com\dao\impl\EasybuyOrderDaoImpl.class

?????文件???????4573??2018-06-28?13:31??易買網\EasyBuy\build\classes\com\dao\impl\EasybuyUserAddressDaoImpl.class

?????文件???????8284??2018-06-28?13:31??易買網\EasyBuy\build\classes\com\dao\impl\EasybuyUserDaoImpl.class

?????文件???????3340??2018-06-28?13:31??易買網\EasyBuy\build\classes\com\dao\impl\NewsDaoImpl.class

?????文件???????4357??2018-06-28?13:31??易買網\EasyBuy\build\classes\com\dao\impl\OrderDaoImpl.class

?????文件???????2099??2018-06-28?13:31??易買網\EasyBuy\build\classes\com\dao\impl\OrderDetailDaoImpl.class

?????文件???????9311??2018-06-28?13:31??易買網\EasyBuy\build\classes\com\dao\impl\ProductCategoryDaoImpl.class

?????文件??????16906??2018-06-28?13:31??易買網\EasyBuy\build\classes\com\dao\impl\ProductDaoImpl.class

?????文件????????331??2018-06-28?13:31??易買網\EasyBuy\build\classes\com\dao\NewsDao.class

?????文件????????371??2018-06-28?13:31??易買網\EasyBuy\build\classes\com\dao\OrderDao.class

?????文件????????231??2018-06-28?13:31??易買網\EasyBuy\build\classes\com\dao\OrderDetailDao.class

?????文件???????1074??2018-06-28?13:31??易買網\EasyBuy\build\classes\com\dao\ProductCategoryDao.class

?????文件???????1596??2018-06-28?13:31??易買網\EasyBuy\build\classes\com\dao\ProductDao.class

?????文件???????1739??2018-06-28?13:31??易買網\EasyBuy\build\classes\com\entity\DetailProduct.class

?????文件???????1426??2018-06-28?13:31??易買網\EasyBuy\build\classes\com\entity\EasybuyCollect.class

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