【正文】 flexible, practical and safety requirements, the pletion of the purchase, sales, inventory management, tracking and management of the whole process of information, including data on the operator and the system maintenance information to add , delete, query, statistics and so on. The pharmaceutical sales management system is in accordance with the needs of the pharmaceutical industry in a variety of wholesale, retail and distribution panies , sales, save aspects of the design , is the ideal tool for enterprise information management. The system uses MyEclipse as a development tool, using Mysql as the backend database . And the use of the JAVA development techniques , the use of MVC architecture of the system configuration. Reception use Swing technology background in the use of J2EE Hibernate and Spring lightweight frame. 【 Keywords】 Pharmaceutical sales management system 。以及采用了 JAVA 開(kāi)發(fā)技術(shù)，采用 MVC 架構(gòu)對(duì)系統(tǒng)進(jìn)行構(gòu)造。本醫(yī)藥銷售管理系統(tǒng)是按照各醫(yī) 藥行業(yè)中各種批發(fā)、零售及經(jīng)銷公司的進(jìn)、銷、存方面的需求進(jìn)行設(shè)計(jì)的，是企業(yè)信息化管理的理想工具。為解決這一問(wèn)題，開(kāi)發(fā)一個(gè)界面友好、易于操作的綜合軟件成為醫(yī)藥企業(yè)的首選。 i 摘 要 伴隨著計(jì)算機(jī)的普及和計(jì)算機(jī)科學(xué)技術(shù)的飛速發(fā)展，人們開(kāi)始越來(lái)越多地利用計(jì)算機(jī)解決實(shí)際問(wèn)題。醫(yī)藥各種信息的管理是醫(yī)藥行業(yè)管理中的重要部分，面對(duì)大量的藥品信息，采用人工處理將浪費(fèi)大量的時(shí)間、人力和物力，并且數(shù)據(jù)準(zhǔn)確性低，數(shù)據(jù)匯總速度慢。 本系統(tǒng)從操作簡(jiǎn)便、界面友好、靈活、實(shí)用、安全的要求出發(fā)，完成對(duì)進(jìn)貨、銷售、庫(kù)存管理全過(guò)程信息的跟蹤與管理，包括對(duì)操作員與系統(tǒng)數(shù)據(jù)的維護(hù)，信息的添加、刪除、查詢、統(tǒng)計(jì)等。 本系統(tǒng)采用 MyEclipse 作為開(kāi)發(fā)工具，采用 Mysql 作為后臺(tái)數(shù)據(jù)庫(kù)。前臺(tái)運(yùn)用 Swing 技術(shù)，后臺(tái)運(yùn)用 J2EE 中 Hibernate 和 Spring 輕量級(jí)的框架。 。 Swing. I 目 錄 第 1 章 緒 論 .............................................................................................................. 1 研究背景 .......................................................................................................... 1 國(guó)內(nèi)外 研究現(xiàn)狀 ............................................................................................... 1 前景意義 .......................................................................................................... 3 系統(tǒng)特征 .......................................................................................................... 3 論文組織結(jié)構(gòu) .................................................................................................. 4 第 2 章 系統(tǒng)相關(guān)技術(shù)基礎(chǔ) .......................................................................................... 5 簡(jiǎn)介 ........................................................................................... 5 Mysql 簡(jiǎn)介 ....................................................................................................... 5 SQL 語(yǔ)言 簡(jiǎn)介 .................................................................................................. 5 本章小結(jié) .......................................................................................................... 6 第 3 章 系統(tǒng)分析 .......................................................................................................... 7 可行性分析 ....................................................................................................... 7 技術(shù)可行性 ............................................................................................. 7 經(jīng)濟(jì)可行性 ............................................................................................. 7 操作可行性 ............................................................................................. 7 需求分析 ........................................................................................................... 7 系統(tǒng)的需求描述 ............................................................................................... 8 系統(tǒng)用例圖 ............................................................................................ 8 系統(tǒng)活動(dòng)圖 .......................................................................................... 11 本章小結(jié) ......................................................................................................... 13 第 4 章 概要設(shè)計(jì) ........................................................................................................ 14 項(xiàng)目規(guī)劃 ........................................................................................................ 14 系統(tǒng)功能結(jié)構(gòu)圖 ............................................................................................ 14 本章小結(jié) ........................................................................................................ 15 第 5 章 系統(tǒng)詳細(xì)設(shè)計(jì) ................................................................................................ 16 II 數(shù)據(jù)庫(kù)設(shè)計(jì) .................................................................................................... 16 數(shù)據(jù)項(xiàng)設(shè)計(jì) .......................................................................................... 16 數(shù)據(jù)庫(kù)的概念結(jié)構(gòu)設(shè)計(jì) ...................................................................... 16 邏輯結(jié)構(gòu)設(shè)計(jì) ................................................................................................ 19 數(shù)據(jù)庫(kù)模型圖 ...................................................................................... 19 數(shù)據(jù)表 .................................................................................................. 19 系統(tǒng)主框架布局與實(shí)現(xiàn) ................................................................................ 22 搭建環(huán)境 .............................................................................................. 22 登錄界面的設(shè)計(jì) ................................................................................... 23 主窗體設(shè)計(jì) .......................................................................................... 25 藥品模塊設(shè)計(jì) ...................................................................................... 28 藥品采購(gòu)模塊設(shè)計(jì) .............................................................................. 31 庫(kù)存模塊設(shè)計(jì) ...................................................................................... 34 銷售退款模塊設(shè) 計(jì) ............................................................................... 36 入庫(kù)明細(xì)查詢模塊設(shè)計(jì) ...................................................................... 40 用戶模塊設(shè)計(jì) ..................................................................................