【導讀】字，并嚴格執(zhí)行。個外文字符，譯出漢字不得少于3000，于第四周交給指導老師審閱。字以上，包括綜述、系統(tǒng)總體設計、系統(tǒng)實現(xiàn)、性能分析、結論等。能力而且可以獨立完成小中型項目的設計與開發(fā)。學?，F(xiàn)有設備和環(huán)境可以提供給學。生實習和上機，而且具有專業(yè)老師可以指導學生。[1][M].北京:清華大學出版社.[7]錢雪忠.數(shù)據(jù)庫管理及應用[M].北京.北京郵電大學出版社.[9]趙強.J2EE應用開發(fā)[M].北京:電子工業(yè)出版社.[10]狄祥義.JSP實用教程[M].北京:清華大學出版社.

　　

【正文】 Hospital for the provision of lifesaving sites, requires not only the hospital with a superb medical skills, but also for enthusiastic, thoughtful, and convenient medical services, fast information query. As treatment of the most important one patient treatment, it is the work of the hospital a higher demand on the one hand to coordinate the anizational structure, make it run smooth, efficient, on the other hand patients and their families may be raised at any time advisory services, and hospitals to do it if someone would anize some waste, many hospitals often are not given for this contradiction better treatment. Thus, the traditional method is not only inefficient, timeconsuming, expensive, but did not provide good information for patients consulting services, which will affect the hospital39。s reputation in the minds of the people. The system for doctors in the hospital inpatient and patient information, doctors and patients to achieve a simple interaction, thus easing the pressure on hospitals, more superior resources into the treatment of these patients. Key words： Small hospitals Information Query Simple interactive 目 錄 1 前 言 .................................................................................................................... 0 開發(fā)背景 ............................................................................................................. 0 國內外研究現(xiàn)狀 ................................................................................................. 0 系統(tǒng)設計目標 ..................................................................................................... 1 研究的意義 ......................................................................................................... 1 2 系統(tǒng)開發(fā)所采用的技術 ........................................................................................ 2 JSP 技術 .............................................................................................................. 2 開發(fā)環(huán)境 .................................................................................... 3 SQL Server 2020............................................................................................... 3 Tomcat................................................................................................................. 4 Dreamweaver 8................................................................................................... 5 3 醫(yī)院病房管理系統(tǒng)需求分析 ............................................................................... 6 需求分析 ............................................................................................................. 6 可行性分析 ......................................................................................................... 7 系統(tǒng)功能分析 ..................................................................................................... 7 系統(tǒng)界面需求 ................................................................................................... 10 4 概要設計 .................................................................................................................. 11 概述 ................................................................................................................... 11 功能分析 ........................................................................................................... 11 數(shù)據(jù)庫設計 ....................................................................................................... 12 數(shù)據(jù)庫的基本概念 ................................................................................ 12 系統(tǒng) ER 圖 ....................................................................................................... 14 ER 方法 ................................................................................................. 14 系統(tǒng) ER 圖 ............................................................................................ 14 數(shù)據(jù)庫概念結構設計 ....................................................................................... 14 數(shù)據(jù)庫邏輯結構設計 ....................................................................................... 16 數(shù)據(jù)庫邏輯結構設計定義 .................................................................... 16 數(shù)據(jù)庫邏輯結構設計步驟 .................................................................... 17 數(shù)據(jù)庫邏輯結構設計 ............................................................................ 17 5 系統(tǒng)詳細設計與實現(xiàn) ........................................................................................... 19 詳細設計 ........................................................................................................... 19 登錄 ................................................................................................................... 19 功能說明 ................................................................................................ 19 功能截圖 ................................................................................................ 19 實現(xiàn)代碼 ................................................................................................ 19 患者病案查詢 ................................................................................................... 21 功能說明 ................................................................................................ 21 功能截 圖 ................................................................................................ 21 實現(xiàn)代碼 ................................................................................................ 21 醫(yī)生注冊 ........................................................................................................... 22 功能說明 ................................................................................................ 22 功能截圖