package?com.hongshee.ejforum.data;

/**
?*?
title:?EntityDAO.java

?*?
Description:?base?class?of?all?data?access?object

?*?
Copyright:?Hongshee?Software?（c）?2007

?*?@author?jackie?du
?*?@version?1.0
?*/

import?java.util.ArrayList;
import?java.util.HashMap;
//import?java.util.Map;
import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.ResultSetmetaData;
import?java.sql.SQLException;

import?com.hongshee.common.util.DBManager;
import?com.hongshee.ejforum.common.AppContext;
//import?com.hongshee.ejforum.util.PageUtils;

public?abstract?class?EntityDAO?
{
????protected?DBManager?dbManager?=?DBManager.getInstance（）;
????SqlAdapter?adapter?=?AppContext.getInstance（）.getSqlAdapter（）;
????String?adapterName?=?adapter.getClass（）.getName（）;
????
????/**
?????*?Execute?an?update?statement
?????*?@param?
?????*??????sql?-?sql?statement?to?execute
?????*??????paramList?-?Parameter?value?list
?????*?@return?none
?????*?@throws?SQLException
?????*?@since?1.0
?????*/
????public?void?execUpdateSql（String?sql?ArrayListject>?paramList）?
????????????????????????????????????????????????throws?SQLException
????{
????????Connection?conn?=?null;
????????try
????????{
????????????conn?=?dbManager.getConnection（）;
????????????execUpdateSql（sql?paramList?conn）;
????????}
????????finally
????????{
????????????dbManager.closeConnection（conn）;
????????}
????}
????
????/**
?????*?Execute?an?update?statement
?????*?@param?
?????*??????sql?-?sql?statement?to?execute
?????*??????paramList?-?Parameter?value?list
?????*??????conn?-?DB?connection
?????*?@return?none
?????*?@throws?SQLException
?????*?@since?1.0
?????*/
????protected?void?execUpdateSql（String?sql?ArrayListject>?paramList?
?????????????????????????????????Connection?conn）?throws?SQLException
????{
????????PreparedStatement?pstmtUpdate?=?null;
????????try
????????{
????????????pstmtUpdate?=?conn.prepareStatement（sql）;
????????????if?（paramList?!=?null）
????????????{
????????????????for?（int?i=0;?i????????????????{
????????????????????pstmtUpdate.setobject（i+1?paramList.get（i））;
????????????????}
????????????}
????????????pstmtUpdate.executeUpdate（）;
????????}
????????finally
????????{
????????????dbManager.closePStatement（pstmtUpdate）;
????????}
????}

????/**
?????*?Execute?an?select?statement
?????*?@param?
?????*??????sql?-?sql?statement?to?execute
?????*??????paramList?-?Parameter?value?list
?????*?@return?Result?list?-?ArrayList
?????*?@throws?SQLException
?????*?@since?1.0
?????*/
????public?ArrayList?execSelectSql（String?sql?ArrayListject>?paramList）
????????????????????????????????????????????????????????????????throws?SQLException
????{
????????Connection?conn?=?null;
????????try
????????{
????????????conn?=?dbManager.getConnection（）;
????????????return?execSelectSql（sql?paramList?co

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2009-03-24?23:52??ejforum-2.3\ejforum\
?????目錄???????????0??2009-01-16?16:42??ejforum-2.3\ejforum\admin\
?????目錄???????????0??2009-01-16?17:18??ejforum-2.3\ejforum\admin\basic\
?????文件????????7153??2009-01-21?11:42??ejforum-2.3\ejforum\admin\basic\access.jsp
?????文件????????8423??2009-03-20?13:14??ejforum-2.3\ejforum\admin\basic\baseinfo.jsp
?????文件????????4032??2009-01-08?21:36??ejforum-2.3\ejforum\admin\basic\censor.jsp
?????文件????????5756??2009-05-18?21:49??ejforum-2.3\ejforum\admin\basic\config.jsp
?????文件????????5582??2009-02-08?09:24??ejforum-2.3\ejforum\admin\basic\credit_rule.jsp
?????文件???????13334??2009-01-16?17:18??ejforum-2.3\ejforum\admin\basic\display.jsp
?????文件???????13130??2009-01-08?21:38??ejforum-2.3\ejforum\admin\basic\functions.jsp
?????文件????????3367??2008-04-26?17:51??ejforum-2.3\ejforum\admin\basic\seo.jsp
?????文件????????3275??2009-01-13?00:53??ejforum-2.3\ejforum\admin\basic\showcolor.htm
?????文件????????6451??2009-01-16?21:17??ejforum-2.3\ejforum\admin\basic\style_info.jsp
?????文件????????4400??2009-01-16?16:41??ejforum-2.3\ejforum\admin\basic\ui_styles.jsp
?????文件????????1859??2008-04-26?17:49??ejforum-2.3\ejforum\admin\error.jsp
?????目錄???????????0??2009-01-08?21:38??ejforum-2.3\ejforum\admin\forums\
?????文件????????3967??2008-04-26?17:52??ejforum-2.3\ejforum\admin\forums\attach_list.jsp
?????文件????????5752??2008-04-26?17:52??ejforum-2.3\ejforum\admin\forums\attach_query.jsp
?????文件????????4410??2008-04-26?17:52??ejforum-2.3\ejforum\admin\forums\forum_add.jsp
?????文件????????4693??2008-04-26?17:52??ejforum-2.3\ejforum\admin\forums\forum_copy.jsp
?????文件????????6786??2008-04-26?17:52??ejforum-2.3\ejforum\admin\forums\forum_edit.jsp
?????文件???????16134??2009-01-08?21:38??ejforum-2.3\ejforum\admin\forums\forum_info.jsp
?????文件????????5191??2008-04-26?17:53??ejforum-2.3\ejforum\admin\forums\forum_merge.jsp
?????文件????????3436??2008-04-26?17:53??ejforum-2.3\ejforum\admin\forums\forum_moderator.jsp
?????文件????????5536??2008-07-04?11:34??ejforum-2.3\ejforum\admin\forums\log_censor.jsp
?????文件????????5600??2008-07-21?15:23??ejforum-2.3\ejforum\admin\forums\log_report.jsp
?????文件????????4823??2008-08-07?23:15??ejforum-2.3\ejforum\admin\forums\post_delete.jsp
?????文件????????6390??2008-08-07?23:14??ejforum-2.3\ejforum\admin\forums\post_list.jsp
?????文件????????3386??2008-04-26?17:53??ejforum-2.3\ejforum\admin\forums\section_edit.jsp
?????文件????????6814??2008-08-07?18:15??ejforum-2.3\ejforum\admin\forums\topic_admin.jsp
?????文件????????8912??2008-08-07?22:33??ejforum-2.3\ejforum\admin\forums\topic_list.jsp
............此處省略374個文件信息