【正文】 1 / 46單位代碼 10 學(xué)　　號 082501168 分 類 號 TP315 密 級 畢 業(yè) 設(shè) 計 說 明 書電視機(jī)銷售庫存管理系統(tǒng)的設(shè)計與實現(xiàn)院 (系 )名 稱 xxx專 業(yè) 　 名 稱 計 算 機(jī) 科 學(xué) 與 技 術(shù)學(xué) 生 　 姓 名 xxx指 導(dǎo) 　 教 師 xxx2022 年 5 月 15 日I / 46電視銷售庫存管理系統(tǒng)的設(shè)計與實現(xiàn)摘 要本系統(tǒng)采用當(dāng)今廣泛使用的 B/S 模式結(jié)構(gòu)，利用 MyEclipse 作為開發(fā)工具，采用功能強大的 SQL Server數(shù)據(jù)庫作為后臺支持。設(shè)計開發(fā)了庫存管理系統(tǒng)。本文首先介紹了庫存管理的起源和發(fā)展，并對開發(fā)工具進(jìn)行了介紹。從系統(tǒng)設(shè)計的目標(biāo)、系統(tǒng)結(jié)構(gòu)的總體設(shè)計、軟硬件環(huán)境、系統(tǒng)功能結(jié)構(gòu)等幾方面闡述了基于 B/S模式電視庫存系統(tǒng)的設(shè)計，提出了基于 B/S結(jié)構(gòu)的庫存系統(tǒng)的總體框架和功能結(jié)構(gòu)。最后，詳細(xì)說明了系統(tǒng)功能模塊設(shè)計和數(shù)據(jù)庫的設(shè)計及實現(xiàn)的過程。在該系統(tǒng)的設(shè)計中，成功實現(xiàn)了電視入庫、電視出庫、出庫入庫分類查詢總計、金額匯總、錄入單位管理的功能。經(jīng)過測試，達(dá)到了設(shè)計目的，實現(xiàn)了預(yù)定的功能需求。關(guān)鍵詞：MyEclipse ，SQL Server，管理II / 46The Design and Implementation of the television stock Management Systems Author : Wang jingwen Tutor : zhao wenanAbstractThe system uses today39。s widespread use of B / S model structure, using MyEclipse as a development tool, using a powerful SQL Server database as the backoffice support. The design and development of the inventory management system. This paper first introduces the origins and development of inventory management, and development tools were introduced. Elaborated based on B / S mode TV inventory system design, the overall framework of inventory system based on B / S structure and functional aspects of system design goals, the overall design of the system architecture, hardware and software environment, system, functional structure, structures. Finally, the detailed description of the system function module design and database design and implementation process.In the design of the system, the successful implementation of TV storage, TV out of the library, the input unit management functions. Tested to achieve the design purpose, to achieve the intended functional requirements.Key words: MyEclipse , SQL Server ,ManagementIII / 46目 錄1 緒論 .........................................................................................................................................1 課題的提出 ...............................................................................................................1 課題研發(fā)的必要性 ....................................................................................................2 課題研究的意義 ........................................................................................................2 課題設(shè)計目標(biāo) ............................................................................................................32 系統(tǒng)技術(shù)方法研究 ..................................................................................................................5 SPRING 框架 ...............................................................................................................5 SPRING 框架的 MVC 實現(xiàn)—— SPRINGMVC ...........................................................6 HIBERNATE 框架 ........................................................................................................7 AJAX 技術(shù) .................................................................................................................8 JSP 語言 ..................................................................................................................83 總體設(shè)計 ...............................................................................................................................11 系統(tǒng)通用結(jié)構(gòu) ..........................................................................................................11 系統(tǒng)平臺環(huán)境： ......................................................................................................12 硬件平臺： ...................................................................................................12 軟件平臺： ...................................................................................................12 系統(tǒng)架構(gòu)：B/S 架構(gòu) ...............................................................................................13 編程語言：JAVA ...................................................................................................13 服務(wù)器軟件：JBOSS ..............................................................................................14 系統(tǒng)開發(fā)工具：MYECLIPSE ...................................................................................14 數(shù)據(jù)庫軟件：SQLSERVER .....................................................................................15 系統(tǒng)功能結(jié)構(gòu)圖 ......................................................................................................16 管理員登錄流程 ......................................................................................................17 具體功能模塊圖 ....................................................................................................18 電視入庫管理模塊功能圖 .........................................................................18IV / 46 電視出庫管理功能模塊圖 .........................................................................18 商品收支管理功能模塊圖 .........................................................................194 系統(tǒng)設(shè)計 ...............................................................................................................................20 系統(tǒng)的體系結(jié)構(gòu) ......................................................................................................20 ER 圖 ......................................................................................................................21 管理員的實體關(guān)系圖 ...................................................................................21 庫存表實體關(guān)系圖 .......................................................................................21 電視出庫表的實體關(guān)系圖 ...........................................................................22 操作記錄實體關(guān)系圖 ...................................................................................22 數(shù)據(jù)表 ......................................................................................................................22