毕 业 设 计（论 文）
题目：医院在线挂号预约系统的设计与实现
I
摘 要
互联网发展至今，无论是其理论还是技术都已经成熟，而且它广泛参与在社
会中的方方面面。它让信息都可以通过网络传播，搭配信息管理工具可以很好地
为人们提供服务。针对医院挂号信息管理混乱，出错率高，信息安全性差，劳动
强度大，费时费力等问题，采用医院在线挂号预约系统可以有效管理，使信息管
理能够更加科学和规范。
医院在线挂号预约系统在 Eclipse 环境中，使用 Java 语言进行编码，使用
Mysql 创建数据表保存本系统产生的数据。系统可以提供信息显示和相应服务，
其管理员除了管理医生，科室和用户外，也能管理用户预约挂号信息，下载用户
病例，发布健康资讯，管理客服聊天信息。医生管理本人的坐诊信息，审核预约
挂号，管理用户就诊病例。用户在前台查看医生坐诊，对医生预约挂号，评价并
收藏医生，查看健康资讯，联系客服，用户在后台支付挂号价格，下载病例。
总之，医院在线挂号预约系统集中管理信息，有着保密性强，效率高，存储
空间大，成本低等诸多优点。它可以降低信息管理成本，实现信息管理计算机化。
关键词：医院在线挂号预约系统；Java 语言；Mysql
II
Abstract
Since the development of the Internet, both its theory and technology have
matured, and it has been widely involved in all aspects of society. It allows
information to be disseminated through the Internet, and it can serve people well with
information management tools. In view of the chaotic management of hospital
registration information, high error rate, poor information security, high labor
intensity, and time-consuming and laborious problems, the use of the hospital online
registration appointment system can be effectively managed, and information
management can be more scientific and standardized.
The hospital online registration appointment system uses the Java language for
coding in the Eclipse environment, and uses Mysql to create a data table to save the
data generated by the system. The system can provide information display and
corresponding services. In addition to managing doctors, departments and users, the
administrator can also manage user appointment registration information, download
user cases, publish health information, and manage customer service chat information.
Doctors manage their own consultation information, review appointments, and
manage user cases. The user checks the doctor's consultation at the front desk, makes
an appointment with the doctor, evaluates and saves the doctor, checks health
information, and contacts the customer service. The user pays the registration price in
the background and downloads the case.
In short, the hospital online registration and appointment system centrally
manages information, which has many advantages such as strong confidentiality, high
efficiency, large storage space, and low cost. It can reduce the cost of information
management and realize the computerization of information management.
Key Words ： Hospital online registration and appointment system; Java language;
Mysql
III
目 录
第 1 章 绪论...........................................1
1.1 课题背景 .........................................................................................................1
1.2 课题意义 .........................................................................................................1
1.3 研究内容 .........................................................................................................2
第 2 章 开发环境与技术.................................3
2.1 MYSQL 数据库 ...............................................................................................3
2.2 JSP 技术 ...........................................................................................................3
2.3 SSM 框架 .........................................................................................................4
第 3 章 系统分析.......................................5
3.1 可行性分析 .....................................................................................................5
3.1.1 技术可行性 ..........................................................................................5
3.1.2 经济可行性 ..........................................................................................5
3.1.3 操作可行性 ..........................................................................................5
3.2 系统流程 .........................................................................................................6
3.2.1 操作流程 ..............................................................................................6
3.2.2 登录流程 ..............................................................................................6
3.2.3 删除信息流程 ......................................................................................7
3.2.4 添加信息流程 ......................................................................................8
3.3 性能需求 .........................................................................................................8
3.4 功能需求 .........................................................................................................9
第 4 章 系统设计......................................13
4.1 设计原则 .......................................................................................................13
4.2 功能结构设计 ...............................................................................................13
4.3 数据库设计 ...................................................................................................15
4.3.1 数据库概念设计 ................................................................................15
IV
4.3.2 数据库物理设计 ................................................................................19
第 5 章 系统实现......................................24
5.1 管理员功能实现 ...........................................................................................24
5.1.1 医生管理 ............................................................................................24
5.1.2 用户管理 ............................................................................................24
5.1.3 健康资讯管理 ....................................................................................25
5.1.4 客服管理 ............................................................................................25
5.2 医生功能实现 ...............................................................................................26
5.2.1 医生坐诊管理 ....................................................................................26
5.2.2 预约挂号管理 ....................................................................................26
5.2.3 用户病例管理 ....................................................................................27
5.3 用户功能实现 ...............................................................................................27
5.3.1 医生坐诊 ............................................................................................27
5.3.2 预约挂号 ............................................................................................28
5.3.3 联系客服 ............................................................................................29
第 6 章 系统测试......................................30
6.1 功能测试 .......................................................................................................30
6.1.1 登录功能测试 ....................................................................................30
6.1.2 修改密码功能测试 ............................................................................31
6.2 测试结果 .......................................................................................................31
结 论...............................................32
致 谢...............................................33
参考文献.............................................34
