package?com.hongshee.ejforum.data;

/**
?*?
title:?SqlAdapter.java

?*?
Description:?Standard?sql?stamement?wrapper

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

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

public?abstract?class?SqlAdapter?
{
????protected?SqlAdapter（）{}

????/**
?????*?Do?initialization?according?to?different?database
?????*?@param?none
?????*?@return?none
?????*?@throws?Exception
?????*?@since?1.0
?????*/
????public?abstract?void?init（）?throws?Exception;

????/**
?????*?Append?paging?statement?to?query?sql
?????*?@param
?????*??????sqlBuf?-?Original?query?sql
?????*??????pageNo?-?page?number
?????*??????pageRows?-?each?page?size
?????*??????totalCount?-?total?result?count
?????*?@return?
?????*??????Paging?query?sql?
?????*?@throws?none
?????*?@since?1.0
?????*/
????public?abstract?String?getPageQuerySql（StringBuilder?sqlBuf
???????????????????????????????????????????int?pageNo?int?pageRows?int?totalCount）;

????/**
?????*?Get?paging?statement?query?parameters
?????*?@param
?????*??????pageNo?-?page?number
?????*??????pageRows?-?each?page?size
?????*??????totalCount?-?total?result?count
?????*?@return?
?????*??????An?int[2]?result?array?which?has?following?meaning:
?????*??????result[0]?-?1st?page?parameter?relative?to?getPageQuerySql?function?
?????*??????result[1]?-?2nd?page?parameter?relative?to?getPageQuerySql?function?
?????*?@throws?none
?????*?@since?1.0
?????*/
????protected?abstract?int[]?getPageQueryParams（int?pageNo?int?pageRows?int?totalCount）;
????
????//?Group
????public?String?Group_Insert?=?
????????“insert?into?ejf_group（groupIDgroupNamegroupTypeminCredits“?+
????????“starsrightscreateTime）?values（??????NOW（））“;
????
????public?String?Group_Update?=?
????????“update?ejf_group?set?groupName=?minCredits=?stars=?“?+
????????“updateTime=NOW（）?where?groupID=?“;
????
????public?String?Group_ModRights?=?
????????“update?ejf_group?set?rights=?updateTime=NOW（）?where?groupID=?“;
????
????public?String?Group_Delete?=?
????????“delete?from?ejf_group?where?groupID=?“;
????
????public?String?Group_RemoveMembers?=?
????????“delete?from?ejf_group?where?groupType=‘M‘“;
????
????public?String?Group_SelectAll?=?
????????“select?*?from?ejf_group?order?by?groupType?DESCminCredits?ASCstars?DESC“;
????
????//?User
????public?String?User_Insert?=?
????????“insert?into?ejf_user（userIDnicknamepwdemailicqwebpagegenderbirthcity“?+
????????“remoteIPbriefisMailPubgroupIDcreditsstatelastVisitedcreateTime）?“?+
????????“values（???????????????NOW（）NOW（））“;
????
????public?String?User_Update?=?
????????“update?ejf_user?set?nickname=?email=?icq=?webpage=?gender=?birth=?“?+?
????????“city=?isMailPub=?updateTime=NOW（）?where?userID=?“;
????
????public?String?User_ModSpecInfo?=?
????????“update?ejf_user?set?avatar=?brief=?updateTime=NOW（）?“?+?
????????“where?userID=?“;
????
????public?Strin

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

?????文件???????7171??2008-04-26?17:50??基于Java?Web的論壇系統\ejforum\admin\basic\access.jsp

?????文件???????8322??2008-07-04?21:07??基于Java?Web的論壇系統\ejforum\admin\basic\baseinfo.jsp

?????文件???????4018??2008-04-26?17:50??基于Java?Web的論壇系統\ejforum\admin\basic\censor.jsp

?????文件???????5768??2008-04-26?17:51??基于Java?Web的論壇系統\ejforum\admin\basic\config.jsp

?????文件???????5592??2008-04-26?17:51??基于Java?Web的論壇系統\ejforum\admin\basic\credit_rule.jsp

?????文件??????12840??2008-08-08?16:54??基于Java?Web的論壇系統\ejforum\admin\basic\display.jsp

?????文件??????12535??2008-08-05?22:04??基于Java?Web的論壇系統\ejforum\admin\basic\functions.jsp

?????文件???????3367??2008-04-26?17:51??基于Java?Web的論壇系統\ejforum\admin\basic\seo.jsp

?????文件???????4163??2008-05-05?10:31??基于Java?Web的論壇系統\ejforum\admin\basic\ui_styles.jsp

?????文件???????1859??2008-04-26?17:49??基于Java?Web的論壇系統\ejforum\admin\error.jsp

?????文件???????3967??2008-04-26?17:52??基于Java?Web的論壇系統\ejforum\admin\forums\attach_list.jsp

?????文件???????5752??2008-04-26?17:52??基于Java?Web的論壇系統\ejforum\admin\forums\attach_query.jsp

?????文件???????4410??2008-04-26?17:52??基于Java?Web的論壇系統\ejforum\admin\forums\forum_add.jsp

?????文件???????4693??2008-04-26?17:52??基于Java?Web的論壇系統\ejforum\admin\forums\forum_copy.jsp

?????文件???????6786??2008-04-26?17:52??基于Java?Web的論壇系統\ejforum\admin\forums\forum_edit.jsp

?????文件??????16088??2008-08-06?16:36??基于Java?Web的論壇系統\ejforum\admin\forums\forum_info.jsp

?????文件???????5191??2008-04-26?17:53??基于Java?Web的論壇系統\ejforum\admin\forums\forum_merge.jsp

?????文件???????3436??2008-04-26?17:53??基于Java?Web的論壇系統\ejforum\admin\forums\forum_moderator.jsp

?????文件???????5536??2008-07-04?11:34??基于Java?Web的論壇系統\ejforum\admin\forums\log_censor.jsp

?????文件???????5600??2008-07-21?15:23??基于Java?Web的論壇系統\ejforum\admin\forums\log_report.jsp

?????文件???????4823??2008-08-07?23:15??基于Java?Web的論壇系統\ejforum\admin\forums\post_delete.jsp

?????文件???????6390??2008-08-07?23:14??基于Java?Web的論壇系統\ejforum\admin\forums\post_list.jsp

?????文件???????3386??2008-04-26?17:53??基于Java?Web的論壇系統\ejforum\admin\forums\section_edit.jsp

?????文件???????6814??2008-08-07?18:15??基于Java?Web的論壇系統\ejforum\admin\forums\topic_admin.jsp

?????文件???????8912??2008-08-07?22:33??基于Java?Web的論壇系統\ejforum\admin\forums\topic_list.jsp

?????文件???????4317??2008-04-26?17:53??基于Java?Web的論壇系統\ejforum\admin\forums\trash_admin.jsp

?????文件???????7106??2008-08-07?20:42??基于Java?Web的論壇系統\ejforum\admin\forums\trash_list.jsp

?????文件???????2535??2008-08-09?18:05??基于Java?Web的論壇系統\ejforum\admin\header.jsp

?????文件???????7438??2008-04-26?17:50??基于Java?Web的論壇系統\ejforum\admin\home.jsp

?????文件?????????85??2007-11-09?18:17??基于Java?Web的論壇系統\ejforum\admin\images\check_right.gif

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