摘  要

看病难和看病贵已经成为了许多患者的共同感受，医患矛盾已经成为一种尖锐的矛盾。有点患者在医院等候几个小时，再看病是很平常的事情。大医院医生的门诊号、住院床位、CT检查等都是稀缺资源，特别是对于医疗设备先进、医疗水平较高、就诊量大的大型综合医院，门诊拥挤是一种常见的现象，也是困扰医院就诊效率及医院形象的难题。

医院医院预约系统主要服务于大型医院。本次开发设计以现实生活中的大型医院网上挂号为主要依据和背景，在对此流程中的挂号、选择主任医师系统进行深入调查后，力争开发出一个实用性强、功能齐全、页面清晰的医院医院预约系统系统。建立医院自身的在线医院预约系统，能够良好的和本医院己有的HIS系统绑定，也就避免了患者在第三方合作网站上挂号后还要在医院重新排号的情况，并且使患者治疗和数据分析更方便，这也是相当一部分医院的需求也是短期的信息化改革的目标。本文的研究是如何建立一个适合医院自身状况的在线挂号系统。

本系统采用JavaWeb的SSM框架开发，Mysql数据库，实现科室及专家预览、预约挂号、等操作。希望通过本软件平台，使医院医院预约系统更加便利和快捷。

关键词：医院预约系统；JavaWeb；MySQL；B/S结构

Abstract

Difficult and expensive to see a doctor has become the common feeling of many patients, the contradiction between doctors and patients has become a sharp contradiction. It's common for some patients to wait a few hours in the hospital. Doctor's outpatient number, inpatient bed, CT examination and so on are scarce resources, especially for large general hospitals with advanced medical equipment, high medical level and large number of visits, outpatient congestion is a common phenomenon, and it is also a difficult problem that puzzles the efficiency and image of hospitals.

Hospital reservation registration system mainly serves large hospitals. This development design takes the real life large hospital online registration as the main basis and the background, after the registration in this process, selects the chief physician system to carry on the thorough investigation, strives to develop a hospital hospital appointment system which has the practicability, the function is complete, the page is clear. Establish the hospital's own online booking registration system, can be well bound to the hospital's own HIS system, that is to avoid patients registered on the third-party cooperation website after the re-numbering in the hospital, and make patient treatment and data analysis more convenient, this is a considerable part  Hospital demand is also the goal of short-term information reform. This paper studies how to establish an online registration system suitable for the hospital's own condition.

This system uses the JavaWeb SSM frame development, Mysql the database, realizes the department and the expert preview, the reservation registration, and so on operation. hope to make the hospital reservation system more convenient and fast through this software platform.

Keywords: hospital reservation system; JavaWeb;MySQL;B/S structure

目  录

摘  要I

AbstractII

1. 绪论1

1.1 选题背景1

1.2 国内外研究综述1

1.3 研究方法及内容2

1.3.1研究方法2

1.3.2研究主要内容3

2. 系统技术4

2.1 B/S结构4

2.1.1 什么是B/S结构4

2.1.2 B/S架构软件的优势与劣势4

2.2 Java的介绍5

2.3 SSM框架5

2.4 MySql简介9

3. 系统分析10

3.1 医院预约系统开发的可行性分析10

3.1.1 管理上的可行性10

3.1.2 技术上的可行性10

3.1.3 经济上的可行性10

3.2 医院预约系统的业务流程分析11

3.2.1 HIS业务流程图11

3.2.2 用户注册登录业务流程图12

3.2.3 预约挂号业务流程图12

3.2.4 医生处理预约挂号业务流程图13

3.3 医院预约系统的数据流程分析14

3.3.1 顶层数据流程图14

3.3.2 一级数据流图14

3.3.3 预约挂号数据流图15

3.3.4 医生管理数据流图16

3.4 系统数据字典17

4. 系统设计20

4.1 系统的平台设计20

4.2 系统的总体功能结构设计20

4.2.1 功能结构图20

4.2.2 主要模块说明书22

4.3 各类编号的代码设计25

4.3.1 医生编号的代码模型25

4.3.3 挂号单编号的代码模型27

4.4 数据库设计27

4.4.1 系统E-R图设计27

4.4.2 数据表设计30

4.5 系统安全设计33

4.5.1 网络安全33

4.5.2 数据安全33

5. 系统实现34

5.1 数据库的连接34

5.2 系统实现37

5.2.1 系统登陆37

5.2.2 注册38

5.2.3 首页39

5.2.4 医生管理39

5.2.5 科室管理41

5.2.6 挂号预约42

5.2.7 用户管理43

5.2.8角色管理44

5.2.9菜单管理44

6系统测试45

6.1单元测试45

6.2功能测试46

6.3性能测试46

总  结48

致  谢49

参考文献50