【正文】 健康藥店管理系統(tǒng)的設(shè)計與實現(xiàn) 畢 業(yè) 設(shè) 計 中 文 摘 要 隨著醫(yī)藥行業(yè)的發(fā)展，廣大農(nóng)村的中小型藥店也逐漸興起，但現(xiàn)代化科學技術(shù)使用相對較少的這些農(nóng)村藥店存在諸多經(jīng)營困難，如藥品信息的記錄，為了解決這些問題而設(shè)計了一個健康藥店管理系統(tǒng)。系統(tǒng)實現(xiàn)的功能為藥店中不同部門的員工提供相關(guān)服務，采購人員能夠查詢庫存人員制定的采購計劃并采購藥品，以及記錄藥品、代理商信息；銷售人員可以查詢藥品信息、銷售藥品并記錄顧客的消費信息；庫存人員主要是制定采購計劃和核實藥品的入庫情況；財務收支統(tǒng)計和藥品的訂價是財務人員的主要工 作。管理員管理藥店的全部人員，并可使用所有員工的工作系統(tǒng)，所有部門的員工相互協(xié)作共同完成藥店的經(jīng)營工作。 本系統(tǒng) 是采 用 Java 編程 語言， 并結(jié)合 Microsoft SQL Server 2020 數(shù)據(jù)庫開發(fā)的一套 藥店管理系統(tǒng)，該系統(tǒng)基于 C/S 體系結(jié)構(gòu)開發(fā) ， 它 為 軟件的運行提供穩(wěn)定的平臺。該藥店管理系統(tǒng)能為廣大農(nóng)村藥店的健康發(fā)展和農(nóng)村人們的方便購買藥品提供有效的幫助。 關(guān)鍵詞 藥店管理系統(tǒng) 中小型藥店 藥品信息 C/S 體系結(jié)構(gòu) 畢 業(yè) 設(shè) 計 外 文 摘 要 Title Design and Development of the Management System of the Health Drug Shop Abstract With the development of medicine industry, the middle and small drug shop in countryside are being prosperous, but those drug shops, using less modern science and technology, have many problems in running such as the record of drug information. In order to solve those problems, the management system of the health drug shop is designed. The function finished by the system offer reluctant service to worker in different department. Procurement staff can search the plan made by worker in reservation department, purchase drug and record the information of drug and agency。 Salesman can search drug information, sell drugs and store customer’s expenditure information。 the main work of worker in inventory department is to make purchasing plan and check if the drug is stored into inventory or not。 ining and expensing statistics and setting the drug sale price is finished by finance department’s worker。 the administer manage all the worker information and can use the system used by all workers. The workers in all departments coordinate to finish the work of the drug shop in running. Combined the database, Microsoft SQL Server 2020, this system is developed by Java programming language。 It is based on C/S architecture which provides stable running platform for the software. The management system of drug shop can offer effective help for the health development of drug shop in the countryside and provide convenience for people in village. Key words Management System of the Health Drug Shop Middle and Small Drug Shop Drug Information C/S Architecture 本科畢業(yè)設(shè)計 第 I 頁 共Ⅱ頁 目 錄 1 引言 ............................................................................................................................. 1 開發(fā)背景 .................................................................................................................. 1 農(nóng)村藥店的現(xiàn)狀 ...................................................................................................... 1 課題研究的目的和意義 .......................................................................................... 2 課題內(nèi)容和論文章節(jié)簡介 ...................................................................................... 2 2 使用工具及相關(guān)知識 ................................................................................................. 3 Java 語言 .................................................................................................................. 3 SQL Server 數(shù)據(jù)庫 .................................................................................................. 4 JDBC 數(shù)據(jù)庫鏈接技術(shù) ........................................................................................... 4 3 系統(tǒng)需求分析 ............................................................................................................. 5 系統(tǒng)功能分析 .......................................................................................................... 5 業(yè)務流程分析 .......................................................................................................... 7 運行環(huán)境要求 .......................................................................................................... 8 4 系統(tǒng)總體設(shè)計 ............................................................................................................. 9 系統(tǒng)模塊介紹 .......................................................................................................... 9 管理員模塊 ............................................................................................................ 10 庫存管理模塊 ........................................................................................................ 11 采購管理模塊 ........................................................................................................ 12 財務管理模塊 ........................................................................................................ 12 銷售管理模塊 ........................................................................................................ 13 5 數(shù)據(jù)庫設(shè)計 ............................................................................................................... 14 需求分析 ................................................................................................................ 14 概念結(jié)構(gòu)設(shè)計 ........................................................................................................ 14 邏輯結(jié)構(gòu)設(shè)計 ........................................................................................................ 16 6 詳細設(shè)計 ................................................................................................................... 24 本科畢業(yè)設(shè)計 第 II 頁 共Ⅱ頁 員工身份驗證模塊 ................................................................................................ 25 庫存功能模塊 ........................................................................................................ 26 采購功能模塊 ........................................................................................................ 29 銷售功能模塊 ........................................................................................................ 31 財務功能模塊 ...................................................................................