【正文】 基于 J2EE 的醫(yī)療門診查詢系統(tǒng)分析與設計 基于 J2EE 的醫(yī)療門診查詢系統(tǒng)分析與設計 摘要 隨著計算機技術的發(fā)展和進步，計算機應用已經(jīng)涉及到人們生活的各個方面。醫(yī)療門診查詢預約系統(tǒng)是通過分析一個醫(yī)院門診系統(tǒng)，把數(shù)據(jù)庫， Servlet， Bean， JSP 整合在一起，從而實現(xiàn)一個從信息收集，處理到查詢的完整的處理方案。該系統(tǒng)集合了患者管理，醫(yī)生管理，以及病歷管理的綜合性應用軟件。在該系統(tǒng)中，患者可以不用在醫(yī)院里面排很長的隊伍掛號，只要在門診系統(tǒng)的頁面上選擇自己喜歡的醫(yī)生進行預約看病。這樣不僅方便了患者，也方便了醫(yī)生更容易查閱病歷和患者資料。更進一步方 便了醫(yī)院的門診管理，符合信息化時代的軟件應用潮流。 本系統(tǒng)是基于 J2EE 的設計方案，使用表示層，邏輯層和數(shù)據(jù)層三層模式。使用 B/S模式，大大減低了服務端的數(shù)據(jù)處理任務。提供了高性能的處理速度，降低數(shù)據(jù)庫的運行時的開銷。使用 MS SQL Server 2020 作為數(shù)據(jù)庫， Tomcat 作為 JSP 容器。數(shù)據(jù)庫層使用 JDBC 與底層數(shù)據(jù)庫進行交互，邏輯層封裝在 Java 類中，表示層由 JSP 實現(xiàn)。 關鍵詞： B\S 模式； JSP； Enterprise JavaBean；三層模式； JDBC 基于 J2EE 的醫(yī)療門診查詢系統(tǒng)分析與設計 THE ANALYSE AND DESIGN OF HOSPITAL CLINIC APPOINTMENT AND QUERY SYSTEM Abstract With the development of puter technology, the puter application has referring to all the sides of human39。s life. The hospital clinic appointment and query system gets across analyzed a Hospital39。s Clinic System, use the Database, Servlet, JavaBean and JSP to realize a project of gathering information, management and query. The system is an allaround application software including patient management, doctor management, history management and log file management. Using this system, the patient couldn39。t queue up at the hospital to register. That39。s really wasted so much time for patient. The patient can choose a doctor who his like. In this way, the patient felt convenience, and the doctor check the history and patient information easily. The hospital clinic system became very convenience. The system is based on the J2EE design project, use three layer mode: the express layer, the logic layer and the database layer. It is use the B/S mode (browse/server). It reduced so much data disposal task at server, provided high performance, reduced many spending on the database. This system use the MS SQL Server as a database, Tomcat as be a container, use the JDBC driver to connect with database at data layer. The logic layer is encapsulation in Java class files. The JSP achieved the express layer. Key Words： B\S mode； JSP； Enterprise JavaBean； three layer mode； JDBC 基于 J2EE 的醫(yī)療門診查詢系統(tǒng)分析與設計 目 錄 第一章 緒 論 ...................................................................................................................... 1 引 言 ............................................................................................................................ 1 概 述 ............................................................................................................................ 2 J2EE 概述 ...................................................................................................................... 3 第二章 系統(tǒng)運行必要的環(huán)境 .............................................................................................. 7 JSP 運行環(huán)境的要求 .................................................................................................... 7 對硬件條件和操作系統(tǒng)的要求 ...................................................................... 7 對軟件環(huán)境的要求 .......................................................................................... 7 安裝和配置 JDK .......................................................................................................... 8 安裝和配置 Tomcat ..................................................................................................... 9 Microsoft SQL Server 的配置 .................................................................................... 11 第三章 系統(tǒng)分析與設計 .................................................................................................... 13 系統(tǒng)功能分析 ............................................................................................................ 13 系統(tǒng)設計思想 ............................................................................................................ 14 數(shù)據(jù)庫層 邏輯層 表示層三層結(jié)構(gòu) ............................................................ 14 角色模塊設計 設計模式 .............................................................................. 14 與數(shù)據(jù)庫的連接 ............................................................................................ 14 日志記錄 ........................................................................................................ 15 系統(tǒng)模塊分析 ............................................................................................................ 15 業(yè)務流程 .................................................................................................................... 16 第四章 系統(tǒng)實現(xiàn)與詳細設計 .............................................................................................. 17 數(shù)據(jù)庫設計 ................................................................................................................ 17 設計 思路 ........................................................................................................ 17 表的設計 ........................................................................................................ 18 表關系圖 ........................................................................................................ 22 邏輯層的設計 .......................................................................................................... 23 邏輯層包結(jié)構(gòu)設計 ........................................................................................ 23 基于 J2EE 的醫(yī)療門診查詢系統(tǒng)分析與設計 與數(shù)據(jù)庫建立連接類 DBConnection ........................................................... 25 用戶角色類 .................................................................................................... 27 表達層設計 ................................................................................................................ 28 表達層設計概述 ............................................................................................ 28 表達層設計中使用的幾大 JSP 對象 ...........................................