大学本科毕业论文（设计）
药店药品信息管理系统的设计与实现
学 院（系）： 信息科学与技术学院
专 业：
学 号：
学 生 姓 名：
入 学 年 度：
指 导 教 师： 毕嘉娜
完 成 日 期：
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
第五章 系统实现................................................................................................................14
5.1 管理员功能模块的实现.......................................................................................14
5.1.1 药品列表....................................................................................................14
5.1.2 供应商信息管理........................................................................................14
5.1.3 供应商类型管理........................................................................................15
第六章 系统测试................................................................................................................16
6.1 软件测试................................................................................................................16
6.2 测试环境................................................................................................................17
6.3 测试用例...............................................................................................................17
6.3.1 用户登录测试............................................................................................17
6.4.2 添加供应商类别测试................................................................................17
6.5 测试结果................................................................................................................17
结 论..................................................................................................................................18
参考文献..............................................................................................................................20
