目錄

第一章  概述 5
1.1  系統(tǒng)開發(fā)背景和意義 5
1.2  開發(fā)環(huán)境 5
第二章  需求分析 7
2.1  任務概述 7
2.2  功能需求 7
2.3  性能需求 7
2.4  數(shù)據(jù)描述(數(shù)據(jù)流圖+數(shù)據(jù)字典) 8
第三章  系統(tǒng)總體設計 14
3.1  業(yè)務流程 14
3.2  系統(tǒng)功能模塊圖 14
3.3  系統(tǒng)流程圖 16
第四章  詳細設計 18
4.1  程序流程圖 18
4.2  程序輸入輸出描述 23
4.2.1  用戶管理模塊 23
4.2.2  職員管理模塊 23
4.2.3  銷售管理模塊 23
4.2.4  進貨管理模塊 23
4.2.5  貨存轉(zhuǎn)移模塊 23
4.2.6  財務信息模塊 23
4.3  數(shù)據(jù)庫的設計 24
4.3.1  數(shù)據(jù)庫的概念結(jié)構(gòu)設計和ER圖 24
4.3.2  數(shù)據(jù)庫的邏輯設計 26
4.3.3  數(shù)據(jù)庫的物理設計 27
第五章  編碼實現(xiàn) 28
5.1  用戶登陸模塊 31
5.2  用戶管理模塊 32
5.3  銷售管理模塊 37
5.4  進貨管理模塊 39
5.5  職員管理模塊 43
5.6  壞貨轉(zhuǎn)移模塊 45
第六章  測試分析報告 47
6.1  什么是軟件測試 47
6.2　軟件測試的目的 47
6.3  測試計劃和要點 47
6.3.1  藥品以及藥品管理模塊測試要點 47
6.3.2  銷售管理測試要點 47
6.3.3  進貨管理測試要點 47
6.3.4  職工信息測試要點 46
6.4  部分測試圖 47
6.5  測試結(jié)論 49
總結(jié) 50
參考文獻 51
附錄：部分程序代碼 52

摘要
大家只要看了新聞,就可以了解到21世紀是信息的世紀，信息化正以極快的速度取代傳統(tǒng)的效率低下的人工作業(yè)。隨著小型計算機，微型計算機的成本的不斷下降，性能的不斷提升，使得計算機作為當今最重要的信息產(chǎn)品，成為人民大眾必不可缺的工具。計算機技術已經(jīng)廣泛應用于日常辦公，企業(yè)管理，文字處理、電子報表以及進行簡單的人事管理、財務管理等，大大提高了我們的工作效率，節(jié)省許多資源，使管理更加規(guī)范化，系統(tǒng)化，科學化。
目前隨著計算機技術的發(fā)展和普及,各行各業(yè)的管理機構(gòu)開始使用計算機處理大量信息。在我國藥品品種繁多，規(guī)模甚大，以往的手工記載、查詢操作容易出錯且工作效率低，已經(jīng)不能適應時代發(fā)展的要求，從管理的角度來看，對管理者會造成諸多的不便，還有可能疏忽一些細節(jié)，讓不法商家逃脫罪責。所以，市場迫切需要一款簡單實用的藥品管理系統(tǒng)。
經(jīng)過前期的調(diào)研，在反復的修改和綜合考量后，筆者覺定使用JAVA SWING技術，ECLIPSE J2SE 開發(fā)平臺，MYSQL5.0數(shù)據(jù)庫開發(fā)藥品管理系統(tǒng)。藥品管理系統(tǒng)的設計理念是，讓企業(yè)能夠擁有更高效的管理工具，使企業(yè)在21世紀異常激烈的競爭中脫穎而出。國外的管理系統(tǒng)有許多優(yōu)秀的經(jīng)驗，但是并不完全符合我國的國情，我國的最廣大藥品銷售的企業(yè)是分布在全國各地的中小型銷售企業(yè)。所以，此次開發(fā)的藥品管理系統(tǒng)功能乃是汲取了外國優(yōu)秀管理工具的優(yōu)秀功能，同時又創(chuàng)新了更符合我國用戶需求的功能的一個綜合信息管理系統(tǒng)。藥品管理系統(tǒng)分為五大模塊，分別為系統(tǒng)用戶模塊，職工信息管理模塊，進貨管理模塊，銷售管理模塊，庫存轉(zhuǎn)移管理模塊。該五大功能模塊設計合理，功能全面，同時界面友好，非常符合我國各大小型藥品銷售企業(yè)的管理需求。但由于時間倉促以及筆者找工作實習的原因，系統(tǒng)還不是很完善，和市場上一些成熟的產(chǎn)品比較仍然有不足之處。今后筆者將利用工作休息時間，學習新的技術和設計理念，對藥品管理系統(tǒng)進行深入的二次迭代開發(fā)，目標是在今后三個月使代碼更加規(guī)范，界面更加美觀，程序的可拓展性進一步增強，更加與市場接軌，然后發(fā)布到China Java World上開源供大家免費下載使用和學習。

關鍵詞：JAVA SWING、MYSQL5.0、JDBC、藥品管理管理系統(tǒng)、藥品管理
 
Abstract

If you see the news, they can understand the 21st century is the century of information, Information technology is with great speed instead of traditional inefficient artificially assignments. With small computer, microcomputer cost of declining, performance, makes the computer as the most important information product, become indispensable for the masses of tools. Computer technology has been widely used in daily office, enterprise management, word processing, spreadsheets and simple personnel management, financial management, and greatly improve our work efficiency, saving many resources, make management standardization, systematization, more scientific.      
Now with the development of computer technology and popularization of the management institution, tencent started using computer processing of information. In our country, the great variety of scale, past records, query operation manual and low working efficiency error-prone, already can not adapt to the development of The Times, from management point of view, the manager will cause many inconvenience, there may be some details, let the illegal businessmen to escape. Therefore, a simple and practical drug management system is very much in line with the needs of the market.
Through the research on the modification, and comprehensive considerations repeatedly, the author determined after use JAVA SWING technology, MYSQL5.0 ECLIPSE J2SE JAVA development platform, the drug administration system database development. Drug management system is designed, make enterprise can have more efficient management tools, enterprise in the 21st century the fierce competition. Foreign management system has many excellent experience, but not completely accord with the national condition of our country, China's vast drug sales enterprise is distributed in the small and medium-sized enterprises nationwide sales. Therefore, the development of medicine management system function is absorbed foreign outstanding management tools and excellent function, the innovation of our customers demand more accord with a comprehensive functions of information management system. Drug management system is divided into five modules, respectively, the worker system user information management module, stock management module, modules, stock transfer sales management module management module. The five function module design is reasonable, comprehensive functions, and friendly interface, very large pharmaceutical sales in conformity with the requirements of the enterprise management. But due to lack of time and the practice of the job, system is not perfect, and some mature products on the market is still has some shortcomings. Future work will use the rest time, learning new technology and design concept of drug administration system, further development iteration, the second goal in the next three months are more standard code, the interface of the program can be more beautiful, expanding further strengthens, more with market, and then released to the China open for World Java on learning and using free download.

Key words：Java Swing、Mysql5.5、JDBC、MedMgrSystem、Medicine sales&mgr