【正文】 1 / 46單位代碼 10 學(xué)　　號(hào) 082501168 分 類(lèi) 號(hào) TP315 密 級(jí) 畢 業(yè) 設(shè) 計(jì) 說(shuō) 明 書(shū)電視機(jī)銷(xiāo)售庫(kù)存管理系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn)院 (系 )名 稱(chēng) xxx專(zhuān) 業(yè) 　 名 稱(chēng) 計(jì) 算 機(jī) 科 學(xué) 與 技 術(shù)學(xué) 生 　 姓 名 xxx指 導(dǎo) 　 教 師 xxx2022 年 5 月 15 日I / 46電視銷(xiāo)售庫(kù)存管理系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn)摘 要本系統(tǒng)采用當(dāng)今廣泛使用的 B/S 模式結(jié)構(gòu)，利用 MyEclipse 作為開(kāi)發(fā)工具，采用功能強(qiáng)大的 SQL Server數(shù)據(jù)庫(kù)作為后臺(tái)支持。設(shè)計(jì)開(kāi)發(fā)了庫(kù)存管理系統(tǒng)。本文首先介紹了庫(kù)存管理的起源和發(fā)展，并對(duì)開(kāi)發(fā)工具進(jìn)行了介紹。從系統(tǒng)設(shè)計(jì)的目標(biāo)、系統(tǒng)結(jié)構(gòu)的總體設(shè)計(jì)、軟硬件環(huán)境、系統(tǒng)功能結(jié)構(gòu)等幾方面闡述了基于 B/S模式電視庫(kù)存系統(tǒng)的設(shè)計(jì)，提出了基于 B/S結(jié)構(gòu)的庫(kù)存系統(tǒng)的總體框架和功能結(jié)構(gòu)。最后，詳細(xì)說(shuō)明了系統(tǒng)功能模塊設(shè)計(jì)和數(shù)據(jù)庫(kù)的設(shè)計(jì)及實(shí)現(xiàn)的過(guò)程。在該系統(tǒng)的設(shè)計(jì)中，成功實(shí)現(xiàn)了電視入庫(kù)、電視出庫(kù)、出庫(kù)入庫(kù)分類(lèi)查詢(xún)總計(jì)、金額匯總、錄入單位管理的功能。經(jīng)過(guò)測(cè)試，達(dá)到了設(shè)計(jì)目的，實(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è)計(jì)目標(biāo) ............................................................................................................32 系統(tǒng)技術(shù)方法研究 ..................................................................................................................5 SPRING 框架 ...............................................................................................................5 SPRING 框架的 MVC 實(shí)現(xiàn)—— SPRINGMVC ...........................................................6 HIBERNATE 框架 ........................................................................................................7 AJAX 技術(shù) .................................................................................................................8 JSP 語(yǔ)言 ..................................................................................................................83 總體設(shè)計(jì) ...............................................................................................................................11 系統(tǒng)通用結(jié)構(gòu) ..........................................................................................................11 系統(tǒng)平臺(tái)環(huán)境： ......................................................................................................12 硬件平臺(tái)： ...................................................................................................12 軟件平臺(tái)： ...................................................................................................12 系統(tǒng)架構(gòu)：B/S 架構(gòu) ...............................................................................................13 編程語(yǔ)言：JAVA ...................................................................................................13 服務(wù)器軟件：JBOSS ..............................................................................................14 系統(tǒng)開(kāi)發(fā)工具：MYECLIPSE ...................................................................................14 數(shù)據(jù)庫(kù)軟件：SQLSERVER .....................................................................................15 系統(tǒng)功能結(jié)構(gòu)圖 ......................................................................................................16 管理員登錄流程 ......................................................................................................17 具體功能模塊圖 ....................................................................................................18 電視入庫(kù)管理模塊功能圖 .........................................................................18IV / 46 電視出庫(kù)管理功能模塊圖 .........................................................................18 商品收支管理功能模塊圖 .........................................................................194 系統(tǒng)設(shè)計(jì) ...............................................................................................................................20 系統(tǒng)的體系結(jié)構(gòu) ......................................................................................................20 ER 圖 ......................................................................................................................21 管理員的實(shí)體關(guān)系圖 ...................................................................................21 庫(kù)存表實(shí)體關(guān)系圖 .......................................................................................21 電視出庫(kù)表的實(shí)體關(guān)系圖 ...........................................................................22 操作記錄實(shí)體關(guān)系圖 ...................................................................................22 數(shù)據(jù)表 ......................................................................................................................22