package?twm;
import?java.io.PrintStream;//??????????????????
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?twm.bbsreg;
import?twm.bbsuser;


public?class?bbs
{

????bbsreg?dbconn;
????bbsuser?bbsuser;
????ResultSet?rs;
????String?strSQL;
????boolean?yesorno;
????
????int?i;
????int?bbsid;
????int?parentid;
????int?boardid;
????int?child;
????int?bbshits;
????int?bbslength;
????String?username;
????String?useremail;
????String?userip;
????String?expression;
????String?usersign;
????String?bbstopic;
????String?bbscontent;
????String?bbshot;

????public?bbs（）//????????????????????????
????{
????????dbconn?=?new?bbsreg（）;
????????bbsuser?=?new?bbsuser（）;
????????
????????rs?=?null;
????????bbsid?=?0;
????????parentid?=?0;
????????boardid?=?0;
????????child?=?0;
????????username?=?““;
????????useremail?=?““;
????????userip?=?““;
????????expression?=?““;
????????usersign?=?““;
????????bbstopic?=?““;
????????bbscontent?=?““;
????????bbshits?=?0;
????????bbslength?=?0;
????????bbshot?=?““;
????}

????public?void?addNewBbs（）
????{
????????strSQL?=?“INSERT?INTO?bbs（parentidboardidchildusernameuseremailuseripexpressionusersignbbstopicbbscontentbbshitslength）?VALUES（“?+?parentid?+?““?+?boardid?+?““?+?child?+?“‘“?+?username?+?“‘‘“?+?useremail?+?“‘‘“?+?userip?+?“‘‘“?+?expression?+?“‘‘“?+?usersign?+?“‘‘“?+?bbstopic?+?“‘‘“?+?bbscontent?+?“‘“?+?bbshits?+?““?+?bbslength?+?“）“;
????????dbconn.executeUpdate（strSQL）;
????}

????public?void?changeBbsChild（int?j?int?k）
????{
????????strSQL?=?“update?bbs?set?child=child+“?+?k?+?“?where?bbsid=“?+?j;
????????dbconn.executeUpdate（strSQL）;
????}

????public?void?changeBbsHits（int?j?int?k）
????{
????????strSQL?=?“update?bbs?set?bbshits=bbshits+“?+?k?+?“?where?bbsid=“?+?j;
????????dbconn.executeUpdate（strSQL）;
????}

????public?void?delBbs（int?j）
????{
????????rs?=?null;
????????if（getBbsInfo（j））
????????{
????????????if（parentid?==?0）
????????????{
????????????????strSQL?=?“delete?from?bbs?where?parentid=“?+?bbsid;
????????????????dbconn.executeUpdate（strSQL）;
????????????????strSQL?=?“update?board?set?boardtopics=boardtopics-1?where?boardid=“?+?boardid;
????????????????dbconn.executeUpdate（strSQL）;
????????????}?else
????????????{
????????????????strSQL?=?“update?bbs?set?child=child-1?where?bbsid=“?+?parentid;
????????????????dbconn.executeUpdate（strSQL）;
????????????}
????????????bbsuser.changeUserClass（username?-3）;
????????????strSQL?=?“delete?from?bbs?where?bbsid=“?+?bbsid;
????????????dbconn.executeUpdate（strSQL）;
????????}
????}
????public?int?countBbs（）
????{
????????strSQL?=?“SELECT?COUNT（*）?AS?aa?FROM?bbs“;
????????i?=?0;
????????try
????????{
????????????rs?=?dbconn.executeQuery（strSQL）;
????????????if（rs.next（））
????????????????i?=?rs.getInt（“aa“）;
????????????rs.close（）;
????????}
????????catch（SQLException?sqlexception）
????????{
????????????System.err.println（“aq

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????????539??2006-06-29?10:17??JSP-論壇管理系統(tǒng)\bbs\.classpath

?????文件??????????4??2006-06-29?10:17??JSP-論壇管理系統(tǒng)\bbs\.cvsignore

?????文件????????438??2006-06-29?10:17??JSP-論壇管理系統(tǒng)\bbs\.project

?????文件????????353??2006-06-29?10:17??JSP-論壇管理系統(tǒng)\bbs\.tomcatplugin

?????文件??????????8??2006-06-29?10:50??JSP-論壇管理系統(tǒng)\bbs\log\Logfile.1

?????文件????????237??2006-06-29?10:50??JSP-論壇管理系統(tǒng)\bbs\log\Snapshot.1

?????文件??????????4??2006-06-29?10:50??JSP-論壇管理系統(tǒng)\bbs\log\Version_Number

?????文件???????1336??2006-07-04?08:39??JSP-論壇管理系統(tǒng)\bbs\web\css\bbs01.css

?????文件????????555??2000-10-11?13:58??JSP-論壇管理系統(tǒng)\bbs\web\css\bbs03.css

?????文件?????397312??2006-07-21?14:46??JSP-論壇管理系統(tǒng)\bbs\web\db\bbs01.mdb

?????文件???????3764??2006-07-05?12:06??JSP-論壇管理系統(tǒng)\bbs\web\js\menu.js

?????文件???????3206??2006-07-10?17:22??JSP-論壇管理系統(tǒng)\bbs\web\jsp\about.jsp

?????文件????????913??2006-07-10?17:25??JSP-論壇管理系統(tǒng)\bbs\web\jsp\addfav.jsp

?????文件???????3567??2006-07-14?09:16??JSP-論壇管理系統(tǒng)\bbs\web\jsp\adminlog.jsp

?????文件???????9636??2006-07-11?09:08??JSP-論壇管理系統(tǒng)\bbs\web\jsp\bbsadd.jsp

?????文件??????12814??2006-07-11?14:06??JSP-論壇管理系統(tǒng)\bbs\web\jsp\bbsaddre.jsp

?????文件??????11608??2006-07-19?15:48??JSP-論壇管理系統(tǒng)\bbs\web\jsp\bbslist.jsp

?????文件??????18254??2006-07-14?10:23??JSP-論壇管理系統(tǒng)\bbs\web\jsp\boardmanager.jsp

?????文件????????557??2006-07-10?12:12??JSP-論壇管理系統(tǒng)\bbs\web\jsp\checklogin.jsp

?????文件???????1090??2006-07-11?11:33??JSP-論壇管理系統(tǒng)\bbs\web\jsp\chklogin.jsp

?????文件????????688??2006-07-03?16:17??JSP-論壇管理系統(tǒng)\bbs\web\jsp\delete.jsp

?????文件???????2323??2006-07-11?15:04??JSP-論壇管理系統(tǒng)\bbs\web\jsp\emaillist.jsp

?????文件???????2770??2006-07-07?14:14??JSP-論壇管理系統(tǒng)\bbs\web\jsp\grxx.jsp

?????文件???????2530??2006-07-07?13:51??JSP-論壇管理系統(tǒng)\bbs\web\jsp\guanli.jsp

?????文件?????????45??2006-07-07?17:20??JSP-論壇管理系統(tǒng)\bbs\web\jsp\help.jsp

?????文件????????511??2000-07-10?21:34??JSP-論壇管理系統(tǒng)\bbs\web\jsp\images\001.gif

?????文件????????515??2000-07-10?21:34??JSP-論壇管理系統(tǒng)\bbs\web\jsp\images\002.gif

?????文件????????527??2000-07-10?21:33??JSP-論壇管理系統(tǒng)\bbs\web\jsp\images\003.gif

?????文件????????522??2000-07-10?21:33??JSP-論壇管理系統(tǒng)\bbs\web\jsp\images\004.gif

?????文件????????540??2000-07-10?21:33??JSP-論壇管理系統(tǒng)\bbs\web\jsp\images\005.gif

............此處省略136個(gè)文件信息