超市管理信息系统设计与实现

I毕业论文(设计)题目：超市管理信息系统设计与实现学生姓名：学号：200516030102专业班级：计算机信管05201班指导教师：完成时间：2008年6月II摘要超市管理信息系统是典型的信息管理系统(MIS),其开发主要包括后台数据库的建立和维护以及前端应用程序的开发两个方面。本系统使用MICROSOFT公司的VISUALBASIC开发工具,主要完成对超市的管理，包括进货管理，销售管理，库存管理和员工管理四个方面。系统可以完成对各类信息的浏览、查询、添加、删除、修改等功能。系统的核心是销售、库存查询和进货管理三者之间的联系，每一个表的修改都将联动的影响其它的表，当完成销售或进货操作时系统会自动地完成相对应信息的修改。系统有完整的用户添加、删除和密码修改功能，系统采用MicrosoftOffice中的Access2000来设计数据库，它有着最为灵活的数据库结构，对数据库应用有着良好的支持。论文主要介绍了本课题的开发背景，所要完成的功能和开发的过程。重点地说明了系统设计的重点、设计思想、难点技术和解决方案。关键字：控件、窗体、数据库，visualbasic语言，超市，商品IIIABSTRACTThesupermarketmanagementinformationsystemisthetypicalinformationmanagementsystem(MIS),Itsdevelopmentmainlyincludesthebackenddatabasetheestablishmentandthesafeguardingaswellasfrontendtheapplicationprogramdevelopmenttwoaspects.ThissystemuseMICROSOFTCorporationVISUALBASICdevelopmentkit,mainlycompletestothesupermarketcontrol,includingstockswithgoodsthecontrol,thesalescontrol,thestockmanagementandthestaffcontrolsfouraspects.Thesystemmaycompletetoeachcategoryoffunctionandsooninformationbrowse,inquiry,increase,deletion,modification.Thesystemcoreisthesale,thestockinquiresandstockswithgoodscontrolsthreebetweentherelation,eachtablemodificationalllinkageinfluenceothertables,whencompletesthesaleorstockswithgoodstheoperationthesystemtobeableautomatedlytocompletecorrespondstheinformationthemodification.Thesystemhastheintegritytheusertoadd,thedeletionandthepasswordmodificationfunction,thesystemusesinMicrosoftOfficeAccess2,000todesignthedatabase,ithasthemostflexibledatabasestructure,hasthegoodsupporttothedatabaseapplication.Thepapermainlyintroducedthistopicdevelopmentbackground,mustcompletefunctionanddevelopmentprocess.Keyexplanationsystemdesignkeypoint,designthought,difficulttechnologyandsolution.Keyword:widget,forms,thedata-base,visualbasiclanguage,theWarehousemanagement,menchandise.IV目录摘要.......................................................................................................IIABSTRACT.................................................................................................III目录......................................................................................................IV引言.........................................................................................................1第一章系统需求分析............................................................................21.1开发背景..................................................................................................................21.2系统分析..................................................................................................................31.3系统可行性分析......................................................................................................41.4系统开发环境与运行环境......................................................................................61.5系统开发应用的关键技术及软件说明..................................................................6第二章系统功能设计............................................................................102.1系统功能...............................................................................................................102.2程序流程图和E-R图设计...................................................................................10第三章系统数据库设计........................................................................133.1数据库的概念........................................................................................................133.2创建数据库文件....................................................................................................143.3怎样创建一个数据表............................................................................................153.4VB连接ACCESS2000数据库............................................................................16V3.5数据库设计............................................................................................................17第四章详细设计..................................................................................20系统功能的详细设计与实现......................................................................................204.1窗体设计................................................................................................................204.2主界面设计............................................................................................................224.3交易管理单元设计................................................................................................224.4进货、销货统计管理单元设计............................................................................374.5查看数据表单元设计............................................................................................424.6系统管理单元设计................................................................................................44第五章系统测试与设计要点..............................................................465.1本次毕业设计的重点、难点、与创新点.........................................................465.2测试实例的选择研究.........................................................................................465.3测试环境..........................................................................................