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

關(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 國(guó)內(nèi)外發(fā)展?fàn)顩r 1
1.3研究?jī)?nèi)容及目標(biāo) 3
1.3.1主要任務(wù) 3
1.3.2課題達(dá)到的目標(biāo) 3
第 2章  開(kāi)發(fā)方法及關(guān)鍵技術(shù)簡(jiǎn)介 5
2.1開(kāi)發(fā)工具與運(yùn)行環(huán)境 5
2.11開(kāi)發(fā)工具 5
2.12運(yùn)行環(huán)境 5
2.2主要技術(shù)介紹 6
2.2.1 JSP 6
2.22 SQL2000 7
第3章  系統(tǒng)總體設(shè)計(jì) 8
3.1 系統(tǒng)結(jié)構(gòu)圖 8
3.2 系統(tǒng)功能 9
3.3 主框架設(shè)置 10
3.4數(shù)據(jù)庫(kù)設(shè)計(jì) 11
3.4.1  數(shù)據(jù)庫(kù)概念設(shè)計(jì) 11
3.4.2數(shù)據(jù)庫(kù)表設(shè)計(jì) 13
3.42  使用JDBC-ODBC橋接器連接SQL SERVER 2000 17
3.43  JSP通過(guò)JavaBean訪問(wèn)數(shù)據(jù)庫(kù) 18
第4章 系統(tǒng)具體實(shí)現(xiàn) 20
4.1 系統(tǒng)功能分析 20
4.2 登陸界面與注冊(cè)界面的實(shí)現(xiàn) 20
4.3 主界面的實(shí)現(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  離開(kāi)社區(qū) 36
4.3.8  網(wǎng)絡(luò)版: 39
4.4管理員模塊的實(shí)現(xiàn) 39
第5章 結(jié)論 40
參考文獻(xiàn) 41
致謝 43