毕 业 设 计（论 文）
题目：医院住院管理系统的设计与实现
I
摘 要
互联网发展至今，无论是其理论还是技术都已经成熟，而且它广泛参与在社
会中的方方面面。它让信息都可以通过网络传播，搭配信息管理工具可以很好地
为人们提供服务。针对医院住院信息管理混乱，出错率高，信息安全性差，劳动
强度大，费时费力等问题，采用医院住院管理系统可以有效管理，使信息管理能
够更加科学和规范。
医院住院管理系统在 Eclipse 环境中，使用 Java 语言 SSM 框架。系统可以
提供信息显示和相应服务，其管理员查看住院病人消费金额统计报表，管理医生
与护士的资料，管理床位，药品，医嘱以及住院消费。医生查询床位，管理病人，
管理医嘱，管理病人住院信息。护士查询医嘱，药品，病人以及病人住院信息，
管理病人住院消费信息。
总之，医院住院管理系统集中管理信息，有着保密性强，效率高，存储空间
大，成本低等诸多优点。它可以降低信息管理成本，实现信息管理计算机化。
关键词：医院住院管理系统；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
inpatient information, high error rate, poor information security, high labor intensity,
and time-consuming and laborious problems, the use of hospital inpatient
management system can effectively manage the information and make information
management more scientific and standardized.
The hospital inpatient management system uses 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. Its administrators can view statistical reports on the consumption amount of
inpatients, manage the information of doctors and nurses, manage beds, medicines,
medical advice and hospitalization consumption. Doctors inquire about beds, manage
patients, manage medical orders, and manage patient hospitalization information.
Nurses inquire about doctor's orders, medicines, patients, and patient hospitalization
information, and manage patient hospitalization consumption information.
In short, the hospital inpatient management system centrally manages
information and has many advantages such as strong confidentiality, high efficiency,
large storage space, and low cost.
Key Words：Hospital inpatient management 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 数据库设计 ...................................................................................................16
4.3.1 数据库概念设计 ................................................................................16
IV
4.3.2 数据库物理设计 ................................................................................19
第 5 章 系统实现......................................23
5.1 管理员功能实现 ...........................................................................................23
5.1.1 医生管理 ............................................................................................23
5.1.2 护士管理 ............................................................................................23
5.1.3 住院统计报表 ....................................................................................24
5.1.4 药品管理 ............................................................................................24
5.2 医生功能实现 ...............................................................................................25
5.2.1 医嘱管理 ............................................................................................25
5.2.2 病人信息管理 ....................................................................................25
5.2.3 添加住院信息 ....................................................................................26
5.3 护士功能实现 ...............................................................................................26
5.3.1 住院消费管理 ....................................................................................26
5.3.2 查询医嘱 ............................................................................................27
5.3.3 住院查询 ............................................................................................27
第 6 章 系统测试......................................29
6.1 功能测试 .......................................................................................................29
6.1.1 登录功能测试 ....................................................................................29
6.1.2 修改密码功能测试 ............................................................................30
6.2 测试结果 .......................................................................................................30
结 论...............................................31
致 谢...............................................32
参考文献.............................................33
