大学本科毕业论文（设计）
宠物商城网站的设计与实现
学 院（系）：
专 业：
学 号：
学 生 姓 名：
入 学 年 度：
指 导 教 师：
完 成 日 期：
I
摘 要
传统信息的管理大部分依赖于管理人员的手工登记与管理，然而，随着近些年信
息技术的迅猛发展，让许多比较老套的信息管理模式进行了更新迭代，商品信息因为
其管理内容繁杂，管理数量繁多导致手工进行处理不能满足广大用户的需求，因此就
应运而生出相应的宠物商城网站。
本宠物商城网站分为管理员还有用户两个权限，管理员可以管理用户的基本信息
内容，可以管理汽车信息以及汽车的租赁信息，能够与用户进行相互交流等操作，用
户可以查看商品信息，可以查看公告以及查看管理员回复信息等操作。
该宠物商城网站采用的是 WEB 应用程序开发中最受欢迎的 B/S 三层结构模式，
使用占用空间小但功能齐全的 MySQL 数据库进行数据的存储操作，系统开发技术使
用到了 JSP 技术。该宠物商城网站能够解决许多传统手工操作的难题，比如数据查询
耽误时间长，数据管理步骤繁琐等问题。总的来说，宠物商城网站性能稳定，功能较
全，投入运行使用性价比很高。
关键词：宠物商城网站；MySQL 数据库；SSM 技术
II
Abstract
Most of the management of traditional car rental information relies on the manual
registration and management of managers. However, with the rapid development of
information technology in recent years, many old-fashioned information management
models have been iterated and updated, and car rental information is because of its The
management content is complicated, and the large number of managements leads to
manual processing that cannot meet the needs of the majority of car rental users. Therefore,
the corresponding car rental management system should be born.
The car rental management system is divided into two functions: the administrator
and the user. The administrator can manage the basic information content of the user, can
manage the car information and the rental information of the car, and can communicate
with the user, etc., and the user can view the car information. You can rent a car online,
you can leave a message online, and view the administrator's reply information.
The car rental management system adopts the most popular B/S three-layer structure
mode in WEB application development, and uses a small but full-featured MySQL
database for data storage operations. The system development technology uses JSP
technology. The car rental management system can solve many traditional manual
operation problems, such as long delays in data query and cumbersome data management
steps. In general, the car rental management system has stable performance and
full-featured functions.
Key Words：Car rental management system; MySQL database; SSM technology
III
目 录
摘 要 ................................................................................................................................I
Abstract ................................................................................................................................II
目 录 .............................................................................................................................III
第一章 课题背景及研究内容............................................................................................1
1.1 课题背景.................................................................................................................1
1.2 开发目的和意义.....................................................................................................1
1.3 论文研究内容.........................................................................................................1
第二章 相关技术..................................................................................................................3
2.1 B/S 结构...................................................................................................................3
2.2 MySQL 数据库........................................................................................................3
第三章 系统分析..................................................................................................................5
3.1 可行性分析..............................................................................................................5
3.1.1 时间可行性...................................................................................................5
3.1.2 经济可行性..................................................................................................5
3.1.3 操作可行性..................................................................................................5
3.1.4 技术可行性..................................................................................................5
3.1.5 法律可行性..................................................................................................5
3.2 系统流程分析.........................................................................................................6
3.3 系统功能需求分析..................................................................................................7
3.4 系统非功能需求分析.............................................................................................7
第四章 系统设计..................................................................................................................9
4.1 总体功能.................................................................................................................9
4.2 系统模块设计.........................................................................................................9
4.3 数据库设计...........................................................................................................10
4.3.1 数据库设计................................................................................................10
4.3.2 数据库 E-R 图...........................................................................................10
4.3.3 数据库表设计............................................................................................11
第五章 系统实现................................................................................................................12
5.1 管理员功能模块的实现.......................................................................................12
5.1.1 商品列表....................................................................................................12
5.1.2 公告信息管理............................................................................................12
5.1.3 百科类型管理............................................................................................12
第六章 系统测试................................................................................................................14
6.1 软件测试................................................................................................................14
6.2 测试环境................................................................................................................14
6.3 测试用例...............................................................................................................14
6.3.1 用户登录测试............................................................................................14
6.4.2 添加百科类型测试....................................................................................15
6.5 测试结果................................................................................................................15
结 论..................................................................................................................................16
参考文献..............................................................................................................................17
