【正文】 i 摘 要 伴隨著計(jì)算機(jī)的普及和計(jì)算機(jī)科學(xué)技術(shù)的飛速發(fā)展，人們開始越來越多地利用計(jì)算機(jī)解決實(shí)際問題。醫(yī)藥各種信息的管理是醫(yī)藥行業(yè)管理中的重要部分，面對大量的藥品信息，采用人工處理將浪費(fèi)大量的時(shí)間、人力和物力，并且數(shù)據(jù)準(zhǔn)確性低，數(shù)據(jù)匯總速度慢。為解決這一問題，開發(fā)一個(gè)界面友好、易于操作的綜合軟件成為醫(yī)藥企業(yè)的首選。 本系統(tǒng)從操作簡便、界面友好、靈活、實(shí)用、安全的要求出發(fā)，完成對進(jìn)貨、銷售、庫存管理全過程信息的跟蹤與管理，包括對操作員與系統(tǒng)數(shù)據(jù)的維護(hù)，信息的添加、刪除、查詢、統(tǒng)計(jì)等。本醫(yī)藥銷售管理系統(tǒng)是按照各醫(yī) 藥行業(yè)中各種批發(fā)、零售及經(jīng)銷公司的進(jìn)、銷、存方面的需求進(jìn)行設(shè)計(jì)的，是企業(yè)信息化管理的理想工具。 本系統(tǒng)采用 MyEclipse 作為開發(fā)工具，采用 Mysql 作為后臺數(shù)據(jù)庫。以及采用了 JAVA 開發(fā)技術(shù)，采用 MVC 架構(gòu)對系統(tǒng)進(jìn)行構(gòu)造。前臺運(yùn)用 Swing 技術(shù)，后臺運(yùn)用 J2EE 中 Hibernate 和 Spring 輕量級的框架。 【關(guān)鍵詞】醫(yī)藥銷售管理系統(tǒng)； ； Mysql； Swing. ii Abstract Along with the rapid development of puter technology and puter science popularization , more and more people began to use puters to solve practical problems. Medical management of a variety of information management in the pharmaceutical industry is an important part of the face of a large number of drug information , the use of manual processing will waste a lot of time, manpower and material resources , and low data accuracy , data collection and slow. To solve this problem , the development of a userfriendly, easy to operate integrated software of choice for pharmaceutical panies . The system from a simple, userfriendly, 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 。 。 Mysql。 Swing. I 目 錄 第 1 章 緒 論 .............................................................................................................. 1 研究背景 .......................................................................................................... 1 國內(nèi)外 研究現(xiàn)狀 ............................................................................................... 1 前景意義 .......................................................................................................... 3 系統(tǒng)特征 .......................................................................................................... 3 論文組織結(jié)構(gòu) .................................................................................................. 4 第 2 章 系統(tǒng)相關(guān)技術(shù)基礎(chǔ) .......................................................................................... 5 簡介 ........................................................................................... 5 Mysql 簡介 ....................................................................................................... 5 SQL 語言 簡介 .................................................................................................. 5 本章小結(jié) .......................................................................................................... 6 第 3 章 系統(tǒng)分析 .......................................................................................................... 7 可行性分析 ....................................................................................................... 7 技術(shù)可行性 ............................................................................................. 7 經(jīng)濟(jì)可行性 ............................................................................................. 7 操作可行性 ............................................................................................. 7 需求分析 ........................................................................................................... 7 系統(tǒng)的需求描述 ............................................................................................... 8 系統(tǒng)用例圖 ............................................................................................ 8 系統(tǒ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ù)庫設(shè)計(jì) .................................................................................................... 16 數(shù)據(jù)項(xiàng)設(shè)計(jì) .......................................................................................... 16 數(shù)據(jù)庫的概念結(jié)構(gòu)設(shè)計(jì) ...................................................................... 16 邏輯結(jié)構(gòu)設(shè)計(jì) ................................................................................................ 19 數(shù)據(jù)庫模型圖 ...................................................................................... 19 數(shù)據(jù)表 .................................................................................................. 19 系統(tǒng)主框架布局與實(shí)現(xiàn) ................................................................................ 22 搭建環(huán)境 .............................................................................................. 22