學生論壇的設(shè)計與實現(xiàn)

摘要

 論壇也稱為BBS，BBS是Bulletin Board System的縮寫，意思是電子公告版，一種在Internet上常見的用于信息服務(wù)的Web系統(tǒng)，它的主要服務(wù)是用來幫助瀏覽者相互溝通、吸引用戶、服務(wù)用戶的。他起源于20世紀80年代初，最初只是用于發(fā)布公告信息和討論問題的在線交流平臺，后來隨技術(shù)的發(fā)展與網(wǎng)絡(luò)的普及功能越來越強大。由于得到了廣大網(wǎng)友的歡迎，越來越多的商業(yè)網(wǎng)站開始重視論壇，把論壇作為與用戶交流的平臺和在線技術(shù)支持與服務(wù)的平臺。論壇的功能是多種多樣的，現(xiàn)在流行的各種論壇插件讓這些功能更加的多元化，但論壇的基本功能依然是信息的發(fā)布與討論，在實現(xiàn)基本功能的同時也要豐富論壇的其他功能，如建立網(wǎng)友的榮譽系統(tǒng)，美化論壇的界面。按照論壇的基本功能，論壇的開發(fā)可以歸結(jié)為Web開發(fā)技術(shù)和數(shù)據(jù)庫應(yīng)用技術(shù)。目前主要的開發(fā)技術(shù)有ASP、ASP.NET、PHP、JSP等，本文主要采取ASP為開發(fā)技術(shù)，并使用了一些VBScript語言來實現(xiàn)論壇基本功能。目前常用的數(shù)據(jù)庫有MYSQL、Oracal等，在數(shù)據(jù)庫的選取上，為了簡化架設(shè)的實現(xiàn)，采取Microsoft公司的Access作為數(shù)據(jù)庫平臺，這樣在單機上架設(shè)一個簡單的論壇幾乎不需要安裝任何程序。本文設(shè)計的流程是從系統(tǒng)的需求分析開始，確定系統(tǒng)的流程與設(shè)計，到模塊的劃分，再到數(shù)據(jù)加結(jié)構(gòu)的設(shè)計，最后開始每個模塊的編程與開發(fā)。

關(guān)鍵字：論壇；Internet；JavaScript；ASP；數(shù)據(jù)庫

DESIGN AND IMPLEMENT OF STUDENTS' FORUM

Abstract

Forum, also called BBS, is short for Bulletin Board System. BBS is a web system that often seen on Internet for information service. Its main purpose is to help the viewer to communicate with each other, attract user and serve them. BBS was originating in the 1980's. At first it’s only an online flat roof that is used for delivers announcements and discusses problems. With technical developments and the popularity of Internet, its function becomes more and more powerful. Welcomed by large amount of net friends, more and more business websites pay regard to the BBS and make BBS an online communicate flat roof for delivers announcements and discusses problems. Forum combines many functions in one. Many kinds of plug-ins in the fashion help these functions to be more disparate, however, the main　function of BBS is to deliver announcements and discuss problems. Based on that, other　functions of BBS could be extended, for example, honor system of the net friends and sugar up the interface of the forum. Due to the main function of the BBS, developments of forum come down to developments in technology and application technology in database. Now we have ASP, ASP.NET, PHP, JSP and so on. This paper use ASP and some VBScript computer language to carry out the mainly function of the BBS. Databases like MYSQL and Oracal is popular now days. We choose Access produced by Microsoft Company. It is easy to span a simple forum, hardly any programs to install. The design flow of this paper starts with analyzing the needs of the system, by confirming the processes and designs of the system, dividing modules, then designs of date and structures, finally developments and programming of every module.

Key words：Forum；Internet；JavaScript；ASP；Database

目錄

第一章 系統(tǒng)功能的設(shè)計....................................................1
1.1 引言.................................................................1
1.2 需求分析.............................................................1
1.3 功能設(shè)計.............................................................3
1.4 擴展功能設(shè)計.........................................................5
第二章 系統(tǒng)架構(gòu)與數(shù)據(jù)庫設(shè)計..............................................7
　2.1 功能模塊的劃分.......................................................7
　2.2 數(shù)據(jù)庫設(shè)計..........................................................10
  2.2.1 需要建立的數(shù)據(jù)表.............................................10
  2.2.2 數(shù)據(jù)庫表結(jié)構(gòu)的詳細設(shè)計.......................................11
第三章　基本設(shè)計.........................................................23
　3.1 論壇首頁設(shè)計........................................................23
　3.2 數(shù)據(jù)庫連接函數(shù)......................................................24
第四章　模塊的實現(xiàn).......................................................26
　4.1 用戶模塊............................................................26
　　　4.1.1 用戶的登陸....................................................26
　　　4.1.2 用戶的注冊....................................................28
　　　4.1.2 瀏覽其他用戶信息..............................................31
　4.2 版面與公共信息模塊..................................................32
　　　4.2.1 版面的瀏覽....................................................32
　　　4.2.2 公共信息模塊..................................................33
　4.3 帖子模塊............................................................33
　　　4.3.1 發(fā)布、修改、刪除帖子..........................................33
　　　4.3.2 帖子的瀏覽....................................................36
　　　4.3.3 帖子搜索......................................................39
　4.4 管理人員模塊........................................................41
　　　4.4.1 系統(tǒng)參數(shù)設(shè)置..................................................41
　　　4.4.2 用戶授權(quán)......................................................42
　　　4.4.3 數(shù)據(jù)庫的備份與還原............................................42
第五章　論壇的架構(gòu).......................................................44
　5.1 安裝環(huán)境和參數(shù)設(shè)置..................................................44
　5.2 運行論壇............................................................45
第六章　結(jié)論.............................................................47
參考文獻.................................................................48
致謝.....................................................................49
附錄.....................................................................50
　附錄A ................................................................50
　附錄B ................................................................57