摘    要
論壇系統(tǒng) BBS(Bullitin Board System)是互聯(lián)網(wǎng)上一種人與人之間交互的必備工具,特別是做網(wǎng)站必備,網(wǎng)上論壇提供一個信息交流的空間,人們可以通過論壇一起討論自己喜歡的話題,提出問題或者回答問題。用戶可以在論壇中發(fā)表對某個問題的看法闡述自己的觀點,跟別人討論對某個問題的看法,在Internet的發(fā)展中論壇的作用將是無法替代的。網(wǎng)絡(luò)化的今天，BBS對于一個企業(yè)來說也是必不可少的，通過BBS系統(tǒng)來和同事討論企業(yè)文化、企業(yè)管理、人文趣事等等各種和人們息息相關(guān)的話題。給企業(yè)愿意交流者提供一個互相交流的地方。
本系統(tǒng)的設(shè)計是基于JSP技術(shù),并且采用了JAVA語言作為后臺的編程語言,MyEclipse 作為開發(fā)工具,以TOMCAT為服務(wù)器,實現(xiàn)了網(wǎng)絡(luò)平臺的構(gòu)建,JSP 技術(shù)實現(xiàn)了動態(tài)網(wǎng)頁的制作,以確保系統(tǒng)的安全保密和易于維護。而后臺的數(shù)據(jù)庫則采用了SQL2000 管理整個系統(tǒng)的后臺數(shù)據(jù)。
本系統(tǒng)的一個重要特點是界面友好,操作簡單。這主要具有用戶的發(fā)表文章、回復(fù)文章、刪除文章與瀏覽文章功能和用戶的發(fā)表留言、用戶的重新登陸與離開社區(qū)的功能以及用戶發(fā)送電子郵件的、用戶修改信息、用戶的聊天、檢測瀏覽器支持的JAVA版本等功能。細節(jié)方面還考慮到帖子的題目過長時的處理；為了方便用戶瀏覽帖子，還使用了左右框架；回復(fù)帖子數(shù)量大于10的時候采用分頁顯示。

關(guān)鍵詞：BBS系統(tǒng)，JSP，SQL Server 2000，JAVA

 
Abstract
Forum system BBS (Bullitin Board System) is on the Internet between one kind of person and the human the interactive necessary tool, specially makes the website necessarily, on the net the forum provides a communication the space, the people may the topic which discusses together through the forum oneself likes, proposed the question or answers the question.The user may publish in the forum to some question view elaborated own viewpoint, with others discussion to some question view, the forum function will be is unable in the Internet development to substitute.Network today, BBS regarding an enterprise also is essential, comes and the colleague through the BBS system discusses the topic which the enterprise culture, the business management, the humanities amusing thing and so on each kind of and the people are closely linked.Wants the communicator to the enterprise to provide the place which exchanges mutually.
This system design is based on the JSP technology, and used the JAVA language to take the backstage the programming language, MyEclipse took the development kit, take TOMCAT as a server, realized the network platform construction, the JSP technology has realized the dynamic homepage manufacture, guaranteed the system the safe security and easy to maintain.But the backstage database used SQL2000 to manage the overall system the backstage data.
The important characteristic of this system is the contact surface is friendly and the operation is simple.This mainly has the user to publish the article, the reply article, the deletion article and the browsing article function and user's publication message, user's again debarkation with leaves the community the function as well as the user transmission email, the user revision information, the user chats, examines functions and so on JAVA edition which the browser supports.The detail aspect also considered the card the topic excessively is long when processing; For convenience user browsing card, but also has used about the frame; Reply card quantity is bigger than 10 times uses the minute page demonstration.

Key Words：BBS system ; JSP ;SQL Server 2000; JAVA
 
目    錄

摘    要 I
ABSTRACT II
目    錄 I
第 1 章 引    言 1
1.1 課題的研究目的和意義 1
1.2 國內(nèi)外發(fā)展狀況 1
1.3研究內(nèi)容及目標 3
1.3.1主要任務(wù) 3
1.3.2課題達到的目標 3
第 2章  開發(fā)方法及關(guān)鍵技術(shù)簡介 5
2.1開發(fā)工具與運行環(huán)境 5
2.11開發(fā)工具 5
2.12運行環(huán)境 5
2.2主要技術(shù)介紹 6
2.2.1 JSP 6
2.22 SQL2000 7
第3章  系統(tǒng)總體設(shè)計 8
3.1 系統(tǒng)結(jié)構(gòu)圖 8
3.2 系統(tǒng)功能 9
3.3 主框架設(shè)置 10
3.4數(shù)據(jù)庫設(shè)計 11
3.4.1  數(shù)據(jù)庫概念設(shè)計 11
3.4.2數(shù)據(jù)庫表設(shè)計 13
3.42  使用JDBC-ODBC橋接器連接SQL SERVER 2000 17
3.43  JSP通過JavaBean訪問數(shù)據(jù)庫 18
第4章 系統(tǒng)具體實現(xiàn) 20
4.1 系統(tǒng)功能分析 20
4.2 登陸界面與注冊界面的實現(xiàn) 20
4.3 主界面的實現(xiàn) 25
4.3.1  重新登陸 26
4.3.2 社區(qū)論壇 27
4.3.3  留言版 28
4.3.4  聊天室 32
4.3.5 電子郵件 34
4.3.6  修改信息 35
4.3.7  離開社區(qū) 36
4.3.8  網(wǎng)絡(luò)版: 39
4.4管理員模塊的實現(xiàn) 39
第5章 結(jié)論 40
參考文獻 41
致謝 43