搜索
摘要目前，超市行业是生活中非常常见的行业。在超市行业引入超市商品信息系统，是超市经营之中最热门的话题之一。随着超市规模的扩大，商品信息的增多，引入商品信息管理系统对超市中商品信息数据管理的效率高低、对提高超市的销售营业额及超市的正常运转都具有一定的辅助作用。超市商品信息系统设计是利用目前比较成熟的网络数据库的实现技术来对超市商品信息数据进行处理的。实现对商品信息的录入、查询、修改和维护以及根据商品信息生成商品采购单等功能。该系统基于B/S（浏览器/服务器）模式开发，开发工具采用Macromediadreamweaver8.0，数据库采用SQLSERVER2000，数据访问技术采用ADO。本文首先进行需求分析，进而进行模块划分与设计，最后对整个系统进行了详细的分析和设计，在设计与实现过程中，结合源代码具体的描述出整个项目的开发过程。关键字：超市管理；信息系统；浏览器；数据访问；商品信息；AbstractInnowadays,supermarketisacommonindustryinourlive.InjectingtheSupermarketMerchandiseInformationSystemintosupermarketindustryisbecomingoneoftheremarkableissuesinsupermarketmanagement.Withtheexpanseofsupermarketdimensionsandtheincreaseofmerchandiseinformation,injectingtheSupermarketMerchandiseInformationSystemwouldgivesomeextentassistantaffectionsontheefficiencyofmerchandiseinformationdatamanagementandimprovementofvenditionturnover,additionally,prosperousoperationofsupermarket.SupermarketMerchandiseInformationSystemDesign,whichdealswithmerchandiseinformationdataviarealizationtechnologyofmodernnetworkdatabase,isabletoaccomplishload,search,modificationandreparationofmerchandiseinformation,andtocreatethemerchandiseinformationbasedonthestockingbill.ThesystemisdevelopedonB/S(browser/server)model,usingthedevelopmenttoolsofMacromediadreamweaver8.0,databaseofSQLServer2000,andthedataaccesstechnologyofADO.TheauthorfirstlyanalysestheRequirementsAnalysis,thendesignsthemodules,andmakesadetailedanalysisanddesigneventually.Intheprocessofanalyseanddevelopment,theauthordescribesthesourcecodeofthewholeproject.Keywords：managementofsupermarket;informationsystem;browser;ADO（ActiveXDataObject）;informationofmerchandise；目录第一章绪论..............................................................................................................................1§1.1问题背景..........................................................................................................................1§1.2研究范围和技术要求.......................................................................................................1§1.2.1研究范围......................................................................................................................1§1.2.2技术要求......................................................................................................................2§1.3本课题在国内外的发展...................................................................................................2第二章系统分析及比较论证..................................................................................................4§2.1系统总体目标...................................................................................................................4§2.2需求分析...........................................................................................................................4§2.2.1性能分析........................................................................................................................4§2.2.2运行需求........................................................................................................................4§2.2.3功能需求........................................................................................................................4§2.2.4应用需求分析................................................................................................................5§2.3数据流程图.......................................................................................................................6§2.4系统功能模块划分...........................................................................................................7§2.5C/S和B/S的比较论证...................................................................................................10第三章数据库设计..............................................................................................................15§3.1数据库设计.....................................................................................................................15§3.1.1数据库设计理论基础..................................................................................................15§3.1.2系统E-R图的设计.....................................................................................................15§3.1.3E—R图向关系模型的转化.........................................................................................18§3.2设计局部数据库实体关系.............................................................................................19§3.3设计全局数据库实体关系.............................................................................................20第四章系统详细设计与实现................................................................................................22§4.1ADO访问数据库..........................................................................................................22§4.2登录/注销模块的实现及MD5加密的实现..................................................................23§4.3密码修改模块的实现.....................................................................................................24§4.4普通用户查询模块的实现.............................................................................................25§4.5商品录入模块的实现....