【正文】 安徽工業(yè)大學(xué)工商學(xué)院 畢業(yè)設(shè)計(jì)（論文）說(shuō)明書(shū) I 摘要 加多寶進(jìn)銷存系統(tǒng)是在研究了 B/S 運(yùn)作的的基礎(chǔ)之上，結(jié)合了開(kāi)發(fā)人員能力所研制開(kāi)發(fā)的一套進(jìn)銷存系統(tǒng)，這套系統(tǒng)將用戶設(shè)定為主管，倉(cāng)管，工人。即此用戶并不負(fù)責(zé)生產(chǎn)以及組裝，而僅涉及到對(duì)商品的進(jìn)貨，對(duì)商品的庫(kù)存，以及最終對(duì)商品的銷售，這套系統(tǒng)的開(kāi)發(fā)旨在提高加多寶員工的工作效率。 本文從加多寶進(jìn)銷存管理現(xiàn)狀為背景，說(shuō)明了進(jìn)銷存管理在企業(yè)中的重要性，運(yùn)用在專業(yè)課中學(xué)習(xí)到的信息管理系統(tǒng)開(kāi)發(fā)的理論與技術(shù)知識(shí)，分析它的業(yè)務(wù)流程、數(shù)據(jù)流程，采用比較流行的 java 語(yǔ)言， Windows MySQL， ， Tomcat 為開(kāi)發(fā)環(huán)境，本系統(tǒng)采用 B/S結(jié)構(gòu)模型開(kāi)發(fā)的。 本系統(tǒng)的主要功能不僅僅是加多寶的進(jìn)貨，庫(kù)存，銷售等管理，還包括了加多寶員工的管理，加多寶產(chǎn)品的管理，加多寶客戶的管理以及加多寶庫(kù)位的管理。而且我們每個(gè)職位的用戶的權(quán)限也是不一樣的，這主要是考慮到每個(gè)崗位職責(zé)的不同而不同的。 關(guān)鍵詞 進(jìn)銷存系統(tǒng) MySQL B/S 安徽工業(yè)大學(xué)工商學(xué)院 畢業(yè)設(shè)計(jì)（論文）說(shuō)明書(shū) II Abstract JDB Invoicing system is on the basis of study of the B/S operation, bined withthe developers ability developed a Invoicing system, this system will users set tosupervisor, warehouse, workers. This user is not responsible for the productionand assembly, and pertains only to the purchase of goods, the goods inventory,and ultimately to the sale of goods, the development of this system in order to improve the efficiency of the staff. This paper from the Invoicing management situation as the background, explains the importance of inventory management in the enterprise, using the theory andtechnology of knowledge management information system to study inprofessional courses in business processes, data flow analysis, which, with the popular java language, Windows7, MySQL, , Tomcat for the development environment, develop the invoicing system, this system adopts B/S model development. The main function of this system is not only the purchase, inventory, salesmanagement, including the staff management, the product management, thecustomer management and management plus turbo locations. And we each position of the user is not the same, this is mainly on account of each job is different. Keywords:Enters sells saves system, MySQL, B/S 安徽工業(yè)大學(xué)工商學(xué)院 畢業(yè)設(shè)計(jì)（論文）說(shuō)明書(shū) IV 目 錄 前言 ........................................................................................................................................ 1 1 需求分析 ............................................................................................................................ 3 系統(tǒng)描述 ................................................................................................................ 3 功能需求 ................................................................................................................ 3 用戶登錄 ........................................................................................................ 3 員工管理 ...................................................................................................... 4 客戶管理 ...................................................................................................... 4 產(chǎn)品管理 ...................................................................................................... 4 加多寶進(jìn)貨管理 .......................................................................................... 4 加多寶銷售管理 .......................................................................................... 5 加多寶庫(kù)存管理 ........................................................................................... 5 加多寶庫(kù)位管理 .......................................................................................... 5 加多寶系統(tǒng)管理 .......................................................................................... 6 獻(xiàn)綜述和方案選擇 ......................................................................................................... 7 國(guó)內(nèi)外小型商店進(jìn)銷存的研究現(xiàn)狀 ....................................................................... 7 方案的選擇 ............................................................................................................ 8 B/S 結(jié)構(gòu)簡(jiǎn)介 ............................................................................................... 8 JDK 簡(jiǎn)介 ...................................................................................................... 8 MyEclipse 簡(jiǎn)介 ........................................................................................... 9 MySQL 簡(jiǎn)介 ................................................................................................... 9 3 加多寶進(jìn)銷存管理系統(tǒng)的設(shè)計(jì) ...................................................................................... 10 加多寶進(jìn)銷存總體設(shè)計(jì) ........................................................................................ 10 系統(tǒng)實(shí)體聯(lián)系圖 .......................................................................................... 10 實(shí)體 ER圖 ................................................................................................. 10 系統(tǒng)數(shù)據(jù)表設(shè)計(jì) ........................................................................................ 14 加多寶進(jìn)銷存系統(tǒng)功能模塊設(shè)計(jì) ........................................................................ 20 登錄模塊的詳細(xì)設(shè)計(jì) ................................................................................... 20 .2 客戶模塊的詳細(xì)設(shè)計(jì) ............................................................................... 20 產(chǎn)品模塊的詳細(xì)設(shè)計(jì) ................................................................................ 21 安徽工業(yè)大學(xué)工商學(xué)院 畢業(yè)設(shè)計(jì)（論文）說(shuō)明書(shū) V 加多寶進(jìn)貨模塊的詳細(xì)設(shè)計(jì) .................................................................... 22 加多寶銷售模塊的詳細(xì)設(shè)計(jì) ..................................................................... 24 加多寶庫(kù)存模塊的詳細(xì)設(shè)計(jì) ...................................................................... 26 加多寶進(jìn)銷存系統(tǒng)用戶界面設(shè)計(jì) ......................................................................... 27 用戶登錄 ..................................................................................................... 27 主管主頁(yè)面 ................................................................................................. 27 員工管理界面 .................................................................