毕业设计成果
姓 名 ：
专 业 ：
类 别 ：
指 导 教 师 ：
提 交 日 期 ：
摘 要
近年来，随着 Internet 的迅速崛起，电子游戏产业发展迅猛，电子游戏正
以其独特的魅力吸引着众多的玩家，游戏作为一种特殊的创意文化产品形态，是
文化产业链中不可缺少的一环，所以此次毕业设计是制作一个简易的具有基本功
能的游戏网站。
本设计的开发是基于 B/S 结构，采用 JSP 程序设计语言及 SQL2005 数据库
进行开发游戏网站；首先阐述了游戏网站的开发，并对该系统进行了较详细的需
求分析；然后探讨了该系统需要实现的设计方案，该系统主要包括前台：用户注
册、用户登录、查询游戏、下载游戏、游戏新闻、游戏评分；后台：用户管理、
新闻管理、游戏管理、管理员帐号管理等功能模块，最后在测试与分析过程中，
该系统表现出了运行稳定、可靠和实用等特性，具有一定的实用价值。
关键词：游戏；网站；JSP；数据库
Abstract
In recent years, with the rapid rise of the Internet, electronic game industry, the
rapid development of electronic games is its unique charm to attract a large number of
players, the game as a special kind of creative and cultural product form, is an
indispensable part of the cultural industry chainring, so the graduation design is an
imitation of the 17173 and other gaming sites making a simple game site with basic
functions.
The development of this design is based on B / S structure, JSP programming
language and SQL2005 database development game site; paper first describes the
development of the game site, and more detailed needs analysis of the system; then
explore the system need to implement the design, the system including the front: user
registration, user login, query games, download games, game news, game;
background: user management, information management, game management, the
administrator account management, and finally test analysis process, the system
performance is stable, reliable and practical features, has a certain practical value.
Key words:
Game; website; JSP; database
目 录
总页数：页
1 引言 .......................................................................................................................................................1
1.1 课题背景.........................................................................................................................................1
1.2 本课题研究的意义.........................................................................................................................1
1.3 国内研究现状.................................................................................................................................1
1.4 主要研究内容.................................................................................................................................1
2 开发环境与相关技术...........................................................................................................................2
2.1 JSP 技术...........................................................................................................................................2
2.1.1 JAVA 简介 .............................................................2
2.1.2 JSP 简介 .............................................................2
2.1.3 SSH2 框架介绍 ........................................................3
2.2 MYECLIPSE 介绍 ..............................................................................................................................4
2.3 MYSQL 数据库...............................................................................................................................4
2.4 BROWSER/SERVER（B/S）结构......................................................................................................5
3 系统需求分析及设计...........................................................................................................................6
3.1 需求分析.........................................................................................................................................6
3.2 系统设计.........................................................................................................................................6
3.2.1 系统功能 .............................................................6
3.2.2 系统结构 .............................................................6
3.2.3 系统流程图 ...........................................................7
3.3 数据库设计.....................................................................................................................................8
3.3.1 数据库需求分析 ........................................................8
3.3.2 数据库的逻辑结构分析 ..................................................8
3.3.3 数据库物理表结构设计 ..................................................9
4 系统实现 .............................................................................................................................................13
4.1 系统首页.......................................................................................................................................13
4.2 具体模块实现...............................................................................................................................13
4.2.1 商品查看 .............................................................13
4.2.2 购物车 ...............................................................15
4.2.3 订单管理 .............................................................16
4.2.4 用户注册 .............................................................16
4.2.5 用户控件 .............................................................18
4.2.6 商品管理 .............................................................18
4.2.7 管理用户 .............................................................19
5 系统测试 .............................................................................................................................................21
5.1 前台测试.......................................................................................................................................21
5.2 后台测试.......................................................................................................................................21
5.3 测试分析 .......................................................................................................................................22
结 论 .................................................................................................................................................22
参考文献 .................................................................................................................................................23
致 谢 .................................................................................................................................................24
