【正文】 濟(jì)南大學(xué)畢業(yè)設(shè)計(jì) I 摘 要 在如今電腦技術(shù)飛速豐富發(fā)展的時(shí)代，互聯(lián)網(wǎng)普及到人們的生活當(dāng)中去，涉及到生產(chǎn)生活等非常多的方面，當(dāng)今的人們已經(jīng)離不開(kāi)電腦技術(shù)帶來(lái)的便利。醫(yī)院也不例外，為了改變醫(yī)院從前的對(duì)藥品進(jìn)行管理的方式，此篇設(shè)計(jì)論文將會(huì)具體分析研究如何開(kāi)發(fā)一個(gè)便利的藥品管理系統(tǒng)。 此篇文章將會(huì)以技術(shù)角度為視角，來(lái)對(duì)藥品的管理進(jìn)行分析。本設(shè)計(jì)將會(huì)應(yīng)用JSP 語(yǔ)言完成開(kāi)發(fā)。利用 Myeclipse、 Tomcat 工具，然后用 oracle 數(shù)據(jù)庫(kù)來(lái)進(jìn)行后臺(tái)數(shù)據(jù)的操作，以此來(lái)完成設(shè)計(jì)。本設(shè)計(jì)的功能模塊具體包括 :管理員的登陸模塊 ，藥品信息的管理模塊，對(duì)藥品庫(kù)存的統(tǒng)計(jì)和管理，對(duì)藥品進(jìn)貨也就是入庫(kù)存的管理，以及藥品出貨也就是出庫(kù)存的管理和統(tǒng)計(jì)。 本系統(tǒng)將會(huì)基于 JSP+Servlet+JavaBean 的 MVC+DAO 三層架構(gòu)開(kāi)發(fā)模式， jsp 作為視圖層（ View）， servlet 作為控制器層（ Controller）， javabean 作為模型層（ Model）實(shí)現(xiàn)業(yè)務(wù)邏輯處理和數(shù)據(jù)訪問(wèn)操作，運(yùn)用軟件工程的具體步驟模塊化進(jìn)行設(shè)計(jì)。并在經(jīng)過(guò)測(cè)試后，能夠完成這項(xiàng)設(shè)計(jì)的基本功能模塊。 關(guān)鍵詞 ： 藥品管理系統(tǒng)； JSP； MVC+DAO 模式 濟(jì)南大學(xué)畢業(yè)設(shè)計(jì) II ABSTRACT In today39。s puter technology rapid development of the times, the popularity of the Inter into people39。s life, related to the production and living very much, the people cannot do without the convenience of puter technology. The hospital is no exception, in order to change the old management mode of the drug of the, a detailed analysis of the design of this thesis will be how to develop a convenient drug management system. This article will take the technical point of view as the angle of view, to the management of drug analysis. This design will be used JSP language development. We have designed an electronic trading system based on JSP platform and MVC framework. The design of the function modules including: landing module the administrator management module, drug information, statistics and management of drug stock, for drug purchase is the inventory management, as well as drug delivery is the inventory management and statistics. The system will be JSP+Servlet+JavaBean MVC+DAO three layer architecture based development model, JSP as view layer (View), servlet as the controller layer (Controller), JavaBean (Model) as the model layer implements the business logic processing and data access operations, the use of the specific steps of software engineering to design module. Some tests show that the system can effectively realize the functions of a emercial system. Key words: Drug management system。 JSP。 MVC+DAO model 濟(jì)南大學(xué)畢業(yè)設(shè)計(jì) 目 錄 摘 要 ................................................................................................................................ I ABSTRACT ..........................................................................................................................II 1 前 言 ........................................................................................................................... 1 引言 ............................................................................................................................. 1 國(guó)內(nèi)外研究現(xiàn)狀 ......................................................................................................... 1 選題意義 ..................................................................................................................... 1 論文主要工作 ............................................................................................................. 2 2 系統(tǒng)需求分析 ................................................................................................................... 3 系統(tǒng)可行性分析 ......................................................................................................... 3 經(jīng)濟(jì)可行性分析 .................................................................................................. 3 操作可行性分析 .................................................................................................. 3 數(shù)據(jù)流圖 .............................................................................................................. 3 系統(tǒng)的綜 合要求 ......................................................................................................... 4 系統(tǒng)功能需求 ...................................................................................................... 4 系統(tǒng)性能需求分析 .............................................................................................. 5 安全性和實(shí)用性需求分析 .................................................................................. 5 出錯(cuò)處理需求分析 .............................................................................................. 5 系統(tǒng)所用技術(shù)分析 ..................................................................................................... 5 JSP 技術(shù)概述 ........................................................................................................ 5 MVC+DAO 模式概述 .......................................................................................... 5 SQL 語(yǔ)句概述 ....................................................................................................... 6 開(kāi)發(fā)平臺(tái)軟件分析 ..................................................................................................... 6 MyEclipse 平臺(tái)簡(jiǎn)介 ............................................................................................. 6 Oracle 數(shù)據(jù)庫(kù)簡(jiǎn)介 .............................................................................................. 6 本章小結(jié) ..................................................................................................................... 6 3 系統(tǒng)總體架構(gòu)設(shè)計(jì) ........................................................................................................... 7 系統(tǒng)運(yùn)行環(huán)境 ............................................................................................................. 7 設(shè)計(jì)策略 ..................................................................................................................... 7 系統(tǒng)架構(gòu) ..................................................................................................................... 8 本章小結(jié) ..................................................................................................................... 9 4 系統(tǒng)數(shù)據(jù)庫(kù)設(shè)計(jì)及詳細(xì)設(shè)計(jì) ......................................................................................... 10 數(shù)據(jù)庫(kù)設(shè)計(jì) .......................................................