I
动漫爱好者交流平台与实现
摘 要
本游戏论坛是针对目前游戏论坛管理的实际需求，从实际工作出发，对过去的游戏
论坛管理系统存在的问题进行分析，结合计算机系统的结构、概念、模型、原理、方法，
在计算机各种优势的情况下，采用目前最流行的 B/S 结构和 java 中流行的 MVC 三层设
计模式和 eclipse 编辑器、MySQL 数据库设计并实现的 。本游戏论坛管理系统主要包括
系统用户管理模块、公告文章管理模块、变幻图管理、视频类别管理、登录模块、和退
出模块等多个模块。它帮助游戏论坛管理实现了信息化、网络化，通过测试，实现了系
统设计目标，相比传统的管理模式，本系统合理的利用了游戏论坛管理数据资源，有效
的减少了游戏论坛管理的经济投入，大大提高了游戏论坛管理的效率。
关键词：游戏论坛；MVC 模式；MySQL 数据库
II
ABSTRACT
This game forum is aimed at the actual needs of the current game forum management.
From the actual work, the problems existing in the past game forum management system are
analyzed, and the structure, concept, model, principle, and method of the computer system are
combined with various advantages of the computer. Under the circumstances, Designed and
implemented using the most popular B/S structure and popular MVC three-layer design
pattern in Java and the clipse editor and MySQL database. This game forum management
system mainly includes system user management module, announcement article management
module, change map management, video category management, login module, and exit
module. It helps the game forum management to achieve informatization and networking.
Through testing, it has achieved the goal of system design. Compared with the traditional
management model, the system has reasonably used the game forum management data
resources and effectively reduced the economic investment in game forum management. Has
greatly improved the efficiency of game forum management.
key words：Game Forum; MVC mode; MySQL database
III
目 录
摘 要 ...................................................................................................................................I
ABSTRACT ........................................................................................................................I
目 录...............................................................................................................................III
第 1 章 绪论.......................................................................................................................1
1.1 开发背景................................................................................................................1
1.2 开发意义................................................................................................................1
1.3 研究内容................................................................................................................1
第 2 章 主要技术和工具介绍...........................................................................................1
2.1 JSP 语言.................................................................................................................1
2.2 MySQL 数据库......................................................................................................1
2.3 jsp 技术 ..................................................................................................................2
2.4ssm 简介 .................................................................................................................3
第 3 章 系统分析...............................................................................................................1
3.1 可行性分析............................................................................................................1
3.1.1 经济可行性..................................................................................................1
3.1.2 技术可行性..................................................................................................1
3.1.3 操作可行性..................................................................................................1
3.2 需求分析................................................................................................................1
3.3 业务流程分析........................................................................................................2
3.4 数据流程分析........................................................................................................3
第 4 章 系统设计...............................................................................................................5
4.1 系统结构设计........................................................................................................5
4.2 功能模块设计........................................................................................................5
4.3 数据库设计............................................................................................................6
IV
4.3.1 数据库设计概述..........................................................................................6
4.3.1 概念设计......................................................................................................6
4.3.2 表设计..........................................................................................................7
第 5 章 系统实现...........................................................................................................13
5.1 基本任务..............................................................................................................13
5.2 登录模块的实现..................................................................................................13
5.2.1 首页实现....................................................................................................13
5.2.2 管理员后台登录........................................................................................14
5.3 用户模块的实现..................................................................................................17
5.3.1 注册模块及登录的实现............................................................................17
5.2.2 留言模块的实现........................................................................................19
5.2.3 帖子模块的实现........................................................................................20
5.4 管理员模块的实现..............................................................................................22
5.4.1 用户管理模块的实现................................................................................22
5.4.2 公告文章管理模块的实现........................................................................24
5.4.3 视频类别管理模块的实现........................................................................26
5.4.5 视频信息管理模块的实现........................................................................27
第 6 章 系统测试...........................................................................................................29
6.1 测试目的..............................................................................................................29
6.2 测试概述..............................................................................................................29
6.3 单元测试..............................................................................................................29
6.3.1 注册测试....................................................................................................29
6.3.2 登录测试....................................................................................................30
6.4 集成测试..............................................................................................................31
第 7 章 总结...................................................................................................................32
