I
医院预约挂号系统设计与实现
摘 要
随着行业规模的不断壮大，信息变得越来越多。同时计算机网络技术高速发展，网
络管理运用也变得越来越广泛。因此，建立一个 B/S 结构的医院预约挂号系统来管理医
生信息，会使管理工作系统化、规范化，也会提高医院形象，提高管理效率。
本医院预约挂号系统是针对目前医院预约挂号的实际需求，从实际工作出发，对过
去的医院预约挂号系统存在的问题进行分析，结合计算机系统的结构、概念、模型、原
理、方法，在计算机各种优势的情况下，采用目前最流行的 B/S 结构和 eclipse 编辑器、
MySQL 数据库设计并实现的 。本医院预约挂号系统主要包括登录模块、科室信息管理
模块、医生信息管理模块、门诊收费管理模块、和退出模块等多个模块。它帮助医院预
约挂号实现了信息化、网络化，通过测试，实现了系统设计目标，相比传统的管理模式，
本系统合理的利用了网络数据资源，有效的减少了医院预约挂号的经济投入，大大提高
了医院预约挂号的效率。
关键词：jsp；MySQL；医院预约挂号
II
ABSTRACT
With the growing size of the industry, information becomes more and more. At the same
time, the rapid development of computer network technology, network management has
become more and more extensive. Therefore, the establishment of a B / S structure of the
hospital appointment registration system to manage doctor information will make the
management work systematic and standardized, and will also improve the image of the
hospital and improve management efficiency.
This hospital appointment registration system is aimed at the actual needs of the current
hospital appointment registration system. From the actual work, the problems existing in the
past hospital appointment registration system are analyzed, and the structure, concept, model,
principle, and method of the computer system are combined. Under the various advantages of
the computer, the most popular B/S structure and eclipse editor, MySQL database design and
implementation. The hospital reservation registration system mainly includes registration
module, department information management module, doctor information management
module, outpatient charge management module, and exit module and many other modules. It
helps the hospital to register the appointment to realize the informatization, the network,
through the test, has realized the system design goal, compared with the traditional
management model, the system made reasonable use of the network data resources,
effectively reduced the hospital to register the registered economic investment. Has greatly
improved the efficiency of hospital appointment registration.
KEY WORDS：jsp; MySQL;Hospital appointment
III
目 录
摘 要 ...................................................................................................................................I
ABSTRACT ........................................................................................................................I
目 录...............................................................................................................................III
第 1 章 绪论.......................................................................................................................1
1.1 开发背景................................................................................................................1
1.2 开发意义................................................................................................................1
1.3 研究内容................................................................................................................1
第 2 章 主要技术和工具介绍...........................................................................................5
2.12.1 SSH 框架 .........................................................................................................5
2.1.1. Spring 框架 ................................................................................................5
2.1.2 SpringMVC..................................................................................................6
2.1.3.MyBatis........................................................................................................6
2.2 MySQL 数据库......................................................................................................6
2.3 eclipse 与 Tomcat 简介 .........................................................................................6
第 3 章 系统分析...............................................................................................................4
3.1 可行性分析............................................................................................................4
3.1.1 经济可行性..................................................................................................4
3.1.2 技术可行性..................................................................................................4
3.1.3 操作可行性..................................................................................................4
3.1.4 时间可行性.................................................................................................4
3.1.5 法律可行性.................................................................................................4
3.2 需求分析................................................................................................................4
3.3 业务流程分析........................................................................................................5
3.4 数据流程分析........................................................................................................6
IV
第 4 章 系统设计.............................................................................................................10
4.1 系统结构设计......................................................................................................10
4.2 功能模块设计......................................................................................................10
4.3 数据库设计..........................................................................................................11
4.3.1 E-R 图设计 ................................................................................................11
4.3.2 表设计........................................................................................................13
第 5 章 系统实现...........................................................................................................20
5.1 前台页面的实现..................................................................................................20
5.3 注册模块的实现..................................................................................................20
5.4 登录模块的实现..................................................................................................21
5.5 科室信息管理模块的实现..................................................................................22
5.6 医生信息管理模块的实现..................................................................................23
5.7 挂号信息管理模块的实现..................................................................................24
5.8 药品信息管理模块的实现..................................................................................25
5.9 病历信息管理模块的实现..................................................................................26
5.10 预约模块的实现................................................................................................27
第 6 章 系统测试...........................................................................................................30
6.1 程序测试基本概念.............................................................................................30
6.2 程序测试具体内容.............................................................................................30
6.2.1 测试的重要性及目的...............................................................................30
6.2.2 测试的步骤...............................................................................................30
6.2.3 测试的主要内容.......................................................................................31
6.3 系统的优点.........................................................................................................32
第 7 章 总结...................................................................................................................33
致 谢...............................................................................................................................34
