摘 要
随着计算机的广泛应用，人们已经对网络不再感到陌生。在科技飞速发展的今天，电脑信息技术与各行各业进行了有效的结合。人们在网上可以进行网上购物，网上交友，电子商务，网络营效等等。面对强大的网络功能，必须在某方面要有一个健全的系统才能使网络发挥的淋漓尽致。在这个平台上，论坛提供了一个全新的人类沟通新方式。
论坛使用ASP进行开发，数据库采用Access。系统主要实现了用户在论坛中对帖子的发表和回复，以及管理员对用户信息和后台的管理。描述了电子论坛系统的设计与实现。首先对系统的需求进行了分析，建立系统工作流程图，设计系统数据库，对数据库结构进行了详细分析。然后划分系统功能模块，最后详细描述了各个功能模块实现的方法，并给出相应代码。
关键词：电子论坛系统，ASP，Access
Abstract
With the wide application of the computer, people have already no longer felt strange the network. Today, science and technology is developed at full speed, computer information technology and all trades and professions have carried on effective combination. People can carry on the online shopping , matchmaker , e-commerce on the net, camp's result of the network ,etc.. In the face of the strong network function , we must have a sound network function system .
Forum for development using ASP, database using Access. System is mainly to achieve a user posts in the forum for the publication and reply, and the administrator of the management of user information and background. Describes the electronic systemdesign and implementation forums. First, the system needs analysis, create a system of work flow, design database, the database structure in detail. System function and then divided into modules, and finally a detailed description of each functional module approach, and give the corresponding code.
Key words: BBS, ASP, Access
目 录
第1章引言 ................................................. 1
1.1课题背景 ........................................... 1 1.2国内外研究现状 ..................................... 1 1.3课题的研究意义 ..................................... 1 第2章 系统分析 ........................................... 3
2.1相关术语解释 ...................................... 3 2.2 ACCESS数据库 ..................................... 4 2.3系统需求分析 ...................................... 4
2.3.1 用户功能 .................................... 4 2.3.2 统计功能 .................................... 5 2.3.3 帖子功能 .................................... 5 2.3.4 版面功能 .................................... 6 2.3.5 其他功能 .................................... 6 2.4统功能描述 ........................................ 7
2.4.1 主要功能 .................................... 7 2.4.2 论坛扩展功能 ............................... 11
第3章 系统设计 .......................................... 12
3.1 功能模块 ......................................... 12 3.2 数据库设计 ....................................... 15
3.2.1 建立数据表间的关系 ......................... 15 3.2.2 数据表结构的详细设计 ....................... 16
第4章 系统详细设计 ...................................... 21
4.1 用户模块 ......................................... 21
4.1.1 用户登录 ................................... 21 4.1.2 用户注册 ................................... 22 4.1.3 与其他用户联系 ............................. 24
4.2 帖子模块 ......................................... 25
4.2.1发布/删除/修改帖子模块...................... 25 4.2.2 帖子浏览模块 ............................... 27 4.2.3 帖子搜索模块 ............................... 29 4.2.4 其它功能 ................................... 30 4.3 管理员模块 ....................................... 31
4.3.1 用户管理 ................................... 31 4.3.2 版面管理 ................................... 33 4.3.3 帖子管理 ................................... 34 4.3.4 数据库备份和恢复 ........................... 36
结 论 .................................................... 38 致 谢 .................................................... 39 参考文献 .................................................. 40 附录 设计系统部分源代码 .................................. 42
Contents
Chapter 1 Introduction ..................................................................... 1
1.1 Subject background .............................................................. 1 1.2 Research status..................................................................... 1 1.3 Research signifcance ............................................................ 1 Chapter 2 System Analysis ............................................................... 3
2.1 Explanation of related terms ................................................. 3 2.2 ACCESS database ................................................................. 4 2.3 System requirements analysis ............................................... 4
2.3.1 User features ............................................................... 4 2.3.2 Statistcal functions...................................................... 5 2.3.3 Post function ............................................................... 5 2.3.4 Layout features ........................................................... 6 2.3.5 Other features ............................................................. 6 2.4 Systemfunctional description ................................................ 7
2.4.1 Main function ............................................................. 7 2.4.2 Forum extensions ...................................................... 11
Chapter 3 System Design ................................................................ 12
3.1 Function module ................................................................. 12 3.2 Database desgn ................................................................... 15
3.2.1 Establish the relationship between databasetablie ...... 15 3.2.2 Detailed design data sheet bodies .............................. 16
Chapter 4 Detailed Of The System ................................................. 21
4.1 User module ....................................................................... 21
4.1.1 User login ................................................................. 21 4.1.2 User up ..................................................................... 22