package?com.lovo.shop.dao;

import?java.sql.ResultSet;

import?com.lovo.shop.util.DBUtil;

/**
?*?@author?SUNYIJUN
?*?@version?1.0
?*?DAO的基礎(chǔ)類，包含數(shù)據(jù)庫工具對象，封裝執(zhí)行sql和關(guān)閉數(shù)據(jù)庫三個對象的方法。
?*/
public?class?baseDAO?{
	/**
	?*?數(shù)據(jù)庫工具對象
	?*/
	protected?DBUtil?db;
	/**
	?*?無參構(gòu)造方法。初始化數(shù)據(jù)庫工具對象。
	?*?@throws?Exception?數(shù)據(jù)庫連接錯誤。
	?*/
	public?baseDAO（）?throws?Exception{
		db?=?DBUtil.getDBUtilUsePool（）;
	}
	/**
	?*?執(zhí)行數(shù)據(jù)庫查詢語句。
	?*?@param?sql?查詢語句。
	?*?@return?查詢結(jié)果集。
	?*?@throws?Exception?查詢語句錯誤。
	?*/
	public?ResultSet?executeQuery（String?sql）?throws?Exception?{
		db.preparedStatement（sql）;
		ResultSet?rs?=?db.executeQuery（）;
		return?rs;
	}
	/**
	?*?執(zhí)行數(shù)據(jù)庫更新語句。
	?*?@param?sql?更新語句。
	?*?@return?更新數(shù)據(jù)條數(shù)。
	?*?@throws?Exception?更新語句錯誤。
	?*/
	public?int?executeUpdate（String?sql）?throws?Exception?{
		db.preparedStatement（sql）;
		return?db.executeUpdate（）;
	}
	/**
	?*?關(guān)閉結(jié)果集、預(yù)編譯和連接。
	?*?@throws?Exception?數(shù)據(jù)庫關(guān)閉異常。
	?*/
	public?void?close（）?throws?Exception{
		db.close（）;
	}
}

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

?????文件????????789??2010-02-26?14:11??bookshop\.classpath

?????文件????????297??2010-02-26?14:11??bookshop\.mymetadata

?????文件???????1414??2010-02-26?14:11??bookshop\.project

?????文件????????500??2010-02-26?14:11??bookshop\.settings\.jsdtscope

?????文件????????144??2010-02-26?14:12??bookshop\.settings\org.eclipse.core.resources.prefs

?????文件?????????49??2010-02-26?14:11??bookshop\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2010-02-26?14:11??bookshop\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????1291??2010-02-26?14:11??bookshop\src\com\lovo\shop\dao\baseDAO.java

?????文件??????35989??2010-02-26?14:11??bookshop\src\com\lovo\shop\dao\BookDAO.java

?????文件???????3382??2010-02-26?14:11??bookshop\src\com\lovo\shop\dao\CommentDAO.java

?????文件????????167??2010-02-26?14:11??bookshop\src\com\lovo\shop\dao\IbaseDAO.java

?????文件???????5950??2010-02-26?14:11??bookshop\src\com\lovo\shop\dao\IBookDAO.java

?????文件???????1592??2010-02-26?14:11??bookshop\src\com\lovo\shop\dao\ICommentDAO.java

?????文件????????470??2010-02-26?14:11??bookshop\src\com\lovo\shop\dao\IMinorTypeDAO.java

?????文件????????987??2010-02-26?14:11??bookshop\src\com\lovo\shop\dao\IOrderDAO.java

?????文件????????846??2010-02-26?14:11??bookshop\src\com\lovo\shop\dao\IOrderListDAO.java

?????文件????????399??2010-02-26?14:11??bookshop\src\com\lovo\shop\dao\IPrimaryTypeDAO.java

?????文件????????757??2010-02-26?14:11??bookshop\src\com\lovo\shop\dao\IUserDAO.java

?????文件???????1146??2010-02-26?14:11??bookshop\src\com\lovo\shop\dao\MinorTypeDAO.java

?????文件???????3240??2010-02-26?14:11??bookshop\src\com\lovo\shop\dao\OrderDAO.java

?????文件???????6048??2010-02-26?14:11??bookshop\src\com\lovo\shop\dao\OrderListDAO.java

?????文件????????867??2010-02-26?14:11??bookshop\src\com\lovo\shop\dao\PrimaryTypeDAO.java

?????文件???????2418??2010-02-26?14:11??bookshop\src\com\lovo\shop\dao\UserDAO.java

?????文件???????3774??2010-02-26?14:11??bookshop\src\com\lovo\shop\domain\BookBean.java

?????文件???????1752??2010-02-26?14:11??bookshop\src\com\lovo\shop\domain\CommentBean.java

?????文件????????879??2010-02-26?14:11??bookshop\src\com\lovo\shop\domain\MinorTypeBean.java

?????文件???????1304??2010-03-01?14:34??bookshop\src\com\lovo\shop\domain\OrderBean.java

?????文件???????3106??2010-02-26?14:11??bookshop\src\com\lovo\shop\domain\OrderListBean.java

?????文件????????623??2010-02-26?14:11??bookshop\src\com\lovo\shop\domain\PrimaryTypeBean.java

?????文件????????528??2010-02-26?14:11??bookshop\src\com\lovo\shop\domain\ShopCartBean.java

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