单位代码10学号082501168分类号TP315密级毕业设计说明书电视机销售库存管理系统的设计与实现院(系)名称xxx专业名称计算机科学与技术学生姓名xxx指导教师xxx2012年5月15日黄河科技学院毕业设计说明书第I页电视销售库存管理系统的设计与实现摘要本系统采用当今广泛使用的B/S模式结构,利用MyEclipse作为开发工具,采用功能强大的SQLServer数据库作为后台支持。设计开发了库存管理系统。本文首先介绍了库存管理的起源和发展,并对开发工具进行了介绍。从系统设计的目标、系统结构的总体设计、软硬件环境、系统功能结构等几方面阐述了基于B/S模式电视库存系统的设计,提出了基于B/S结构的库存系统的总体框架和功能结构。最后,详细说明了系统功能模块设计和数据库的设计及实现的过程。在该系统的设计中,成功实现了电视入库、电视出库、出库入库分类查询总计、金额汇总、录入单位管理的功能。经过测试,达到了设计目的,实现了预定的功能需求。关键词:MyEclipse,SQLServer,管理黄河科技学院毕业设计说明书第II页TheDesignandImplementationofthetelevisionstockManagementSystemsAuthor:WangjingwenTutor:zhaowenanAbstractThesystemusestoday'swidespreaduseofB/Smodelstructure,usingMyEclipseasadevelopmenttool,usingapowerfulSQLServerdatabaseastheback-officesupport.Thedesignanddevelopmentoftheinventorymanagementsystem.Thispaperfirstintroducestheoriginsanddevelopmentofinventorymanagement,anddevelopmenttoolswereintroduced.ElaboratedbasedonB/SmodeTVinventorysystemdesign,theoverallframeworkofinventorysystembasedonB/Sstructureandfunctionalaspectsofsystemdesigngoals,theoveralldesignofthesystemarchitecture,hardwareandsoftwareenvironment,system,functionalstructure,structures.Finally,thedetaileddescriptionofthesystemfunctionmoduledesignanddatabasedesignandimplementationprocess.Inthedesignofthesystem,thesuccessfulimplementationofTVstorage,TVoutofthelibrary,theinputunitmanagementfunctions.Testedtoachievethedesignpurpose,toachievetheintendedfunctionalrequirements.Keywords:MyEclipse,SQLServer,Management黄河科技学院毕业设计说明书第III页目录1绪论........................................................................................................................................11.1课题的提出...............................................................................................................11.2课题研发的必要性...................................................................................................21.3课题研究的意义.......................................................................................................21.4课题设计目标...........................................................................................................32系统技术方法研究.................................................................................................................52.1SPRING框架...............................................................................................................52.2SPRING框架的MVC实现——SPRINGMVC...........................................................62.3HIBERNATE框架........................................................................................................72.4AJAX技术................................................................................................................82.4.1JSP语言.................................................................................................................83总体设计..............................................................................................................................113.1系统通用结构.........................................................................................................113.2系统平台环境:.....................................................................................................123.2.1硬件平台:..................................................................................................123.2.2软件平台:..................................................................................................123.3系统架构:B/S架构..............................................................................................133.4编程语言:JAVA....................................................................................................133.5服务器软件:JBOSS..............................................................................................143.6系统开发工具:MYECLIPSE..................................................................................143.7数据库软件:SQLSERVER.....................................................................................153.8系统功能结构图.....................................................................................................163.9管理员登录流程.....................................................................................................17黄河科技学院毕业设计说明书第IV页3.10具体功能模块图...................................................................................................183.10.1电视入库管理模块功能图........................................................................183.10.2电视出库管理功能模块图........................................................................183.10.3商品收支管理功能模块图........................................................................194系统设计..............................................................................................................................204.1系统的体系结构.....................................................................................................204.2E-R图......................................................................................................................214.2.1管理员的实体关系图..................................................................................214.2.2库存表实