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

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2011-09-15?16:36??bbs\
?????文件?????????539??2011-09-08?12:56??bbs\.classpath
?????文件???????????4??2011-09-08?12:56??bbs\.cvsignore
?????文件?????????438??2011-09-08?12:56??bbs\.project
?????文件?????????353??2011-09-08?12:56??bbs\.tomcatplugin
?????目錄???????????0??2011-09-15?16:36??bbs\log\
?????文件???????????8??2011-09-08?12:56??bbs\log\Logfile.1
?????文件?????????237??2011-09-08?12:56??bbs\log\Snapshot.1
?????文件???????????4??2011-09-08?12:56??bbs\log\Version_Number
?????目錄???????????0??2011-09-15?16:36??bbs\web\
?????目錄???????????0??2011-09-15?16:36??bbs\WEB-INF\
?????文件???????????7??2011-09-08?12:56??bbs\WEB-INF\.cvsignore
?????目錄???????????0??2011-09-15?16:36??bbs\WEB-INF\classes\
?????目錄???????????0??2011-09-15?16:36??bbs\WEB-INF\classes\twm\
?????文件????????9863??2011-09-08?12:56??bbs\WEB-INF\classes\twm\bbs.class
?????文件????????1842??2011-09-08?12:56??bbs\WEB-INF\classes\twm\bbsadmin.class
?????文件????????6176??2011-09-08?12:56??bbs\WEB-INF\classes\twm\bbsboard.class
?????文件?????????960??2011-09-08?12:56??bbs\WEB-INF\classes\twm\bbscom.class
?????文件????????2044??2011-09-08?12:56??bbs\WEB-INF\classes\twm\bbsreg.class
?????文件????????6956??2011-09-08?12:56??bbs\WEB-INF\classes\twm\bbsuser.class
?????目錄???????????0??2011-09-08?12:56??bbs\WEB-INF\lib\
?????目錄???????????0??2011-09-15?16:36??bbs\WEB-INF\src\
?????目錄???????????0??2011-09-15?16:36??bbs\WEB-INF\src\twm\
?????文件???????12228??2011-09-08?12:56??bbs\WEB-INF\src\twm\bbs.java
?????文件????????1394??2011-09-08?12:56??bbs\WEB-INF\src\twm\bbsadmin.java
?????文件????????6723??2011-09-08?12:56??bbs\WEB-INF\src\twm\bbsboard.java
?????文件????????1335??2011-09-08?12:56??bbs\WEB-INF\src\twm\bbscom.java
?????文件????????1612??2011-09-08?12:56??bbs\WEB-INF\src\twm\bbsreg.java
?????文件????????7669??2011-09-08?12:56??bbs\WEB-INF\src\twm\bbsuser.java
?????目錄???????????0??2011-09-15?16:36??bbs\web\css\
?????文件????????1336??2011-09-08?12:56??bbs\web\css\bbs01.css
............此處省略132個文件信息