搜索
四川大学锦江学院计算机学院第1页毕业论文（设计）题目超市库存管理系统系部计算机科学与技术专业学生姓名学号090512024指导教师叶晓鸣四川大学锦江学院计算机学院第2页超市库存管理系统计算机学院计算机科学与技术2009级（2）班【摘要】超市库存管理系统是典型的信息管理系统(MIS),其开发主要包括后台数据库的建立和维护以及前端应用程序的开发两个方面。对于前者要求建立起数据一致性和完整性强、数据安全性好的库。而对于后者则要求应用程序功能完备,易使用等特点。本系统主要完成对超市的管理，包括进货管理，销售管理，库存管理和员工管理四个方面。系统可以完成对各类信息的浏览、查询、添加、删除、修改等功能。系统的核心是销售、库存查询和进货管理三者之间的联系，每一个表的修改都将联动的影响其它的表，当完成销售或进货操作时系统会自动地完成相对应信息的修改。查询功能也是系统的核心之一，在系统中主要根据商品编号和商品名称等进行查询，其目的都是为了方便用户使用，以求更快的查找到各个物料和产品品质的基本信息。系统有完整的用户添加、删除和密码修改功能，系统采用MySql来设计数据库，并使用当前优秀的开发工具—MyEclipse，它有着最为灵活的数据库结构，对数据库应用有着良好的支持。论文主要介绍了本课题的开发背景，所要完成的功能和开发的过程。重点说明了系统的设计思想、难点技术和解决方案。【关键词】：数据库超市信息系统库存管理SupermarketStockManageSystem四川大学锦江学院计算机学院第3页AbstractThissystemchieflyaccomplishesthestockmanagementtothestorehouse,includesbeingputinstorage,goesoutthewarehouseandstocks,andstaff’sinformation,sixaspectssuchassupplier'sinformationaswellascryptogrammanagementetc.Whatthesystemcanaccomplishtovariouskindtheinformationglancesoverandthefunctionsuchasinquiresaboutads,deletesandmodificationetc.Thesystematicnucleusisputinstorage,stocksandgoesoutthecontactbetweenthewarehouse,andwhenaccomplishesbeingputinstorageorgoingoutawarehouse,thesystemcanaccomplishvoluntarilythemodificationofstocktoothertableofinfluencethatthemodificationofeverytableallwillbelinkgeedwhenoperating.Inquiringaboutthefunctionalsoisoneofsystematicnucleus,namelyhavingthewallscrollsparetoinquireaboutandinquiresaboutwithmanyconditionsinthesystem,alsohavingaccuratelythequerytoinquireaboutwithblurring,notonlythereistheconditionqueryofstaticstateinthesystem,alsohavingtheconditionqueryoftrendsformations,hispurposeallisusingforconvenientuser.Thesystemhascompleteusertoadd,deletesandtheciphermodificationfunction,andhasthereportformandprintsthefunction.TheAccess2000thatthesystemadoptedamongMicrosoftOfficecomesthedesigndatawarehouse,andusebeforeoneZorachdevelopmenttool-MyEclipse,ithasthemostnimbledatabasestructure,andtheapplicationhasthegoodsupporttothedatawarehouses.Thedevelopmentbackgroundofthisthesubject,courseoffunctionandthedevelopmentthatwillbeaccomplishedwerechieflyintroducedtothesis.Theemphaticexplanationfocalpointofsystemsdesign,designthoughtanddifficultpointtechnologyandsettlementscheme.Keywords:databasesupermarketinformationsystemStockmanage目录四川大学锦江学院计算机学院第4页第1章绪论................................................................................................61.1系统开发背景和选题意义.................................................................61.2国内外研究现状...............................................................................71.3研究思路和方法..............................................................................101.4研究框架和主要研究内容..............................................................10第2章系统相关技术概述.........................................................................112.1MySql简介........................................................................................112.2MyEclipse8.5简介...........................................................................112.3Struts2框架结构及工作原理...........................................................122.4Hibernate概述...................................................................................132.5Spring概述.......................................................................................132.6JSP技术.............................................................................................15第3章系统设计..........................................................................................163.1需求分析............................................................................................163.2系统分析.........................................................................................173.2系统资源需求...................................................................................183.3组织机构图.....................................................................................193.4业务流程图........................................................................................193.5数据流程图........................................................................................203.6功能模块的设计............................................................................223.7数据库设计........................................................................................233.7.1数据库设计..............................................................................233.7.2数据库表.................................................................................24第4章详细设计与实现...........................................................................294.1主界面模块设计...............................................................................294.2系统管理模块设计..........................................................................304.3交易管理模块设计..........................................................................344.3.1进货登记.................................................................................344.3.2销货登记.................................................................................354.3.3退货登记.......................................................