超市进销存管理系统论文

摘要I摘要超市的日常管理工作往往是很复杂，很繁琐的，再加上管理的货物种类繁多，因此超市管理必须实现计算机化。超市进销存管理系统是用计算机对超市货物的库存和货物的进出进行管理的一种计算机应用技术,在计算机还未普及之前超市的库存管理都是由工作人员手工书写的方式来操作的，那样很容易出现差错而造成不必要的损失。现在一般的超市都采用计算机进行智能化管理,用计算机作为管理工具可以帮助管理员进行更有效、更快捷的超市库存管理工作。超市进销存管理系统是典型的管理信息系统(MIS),其开发主要包括后台数据库的建立和维护以及前端应用系统的开发两个方面。对于前者要求建立起数据一致性和完整性强、数据安全性好的数据库。而对于后者则要求应用系统功能完备、易使用等特点。超市进销存管理系统要实现的功能非常多，最重要的是对货物的管理，包括货物的买入（进货）、货物的卖出（销货）、货物的存储（库存）。本系统采用Java语言和SQLServer2005数据库进行开发。利用Java语言进行设计，基本实现了对货物的管理工作，另外添加了一些很人性化的操作提示，例如用户可以通过点击帮助图标去查看帮助文档，里面附有详细的图表及文字说明。利用SQLServer2005做后台数据库，不为数据量大所困，精密的权限控制，确保核心数据的万无一失。关键词：进销存管理；库存；MIS；数据库AbstractIIAbstractThedailymanagementworkofsupermarketisoftenverycomplex,verytedious,plusmanagementcategoriesofgoodsisnumerous,thereforethesupermarketmanagementmustrealizecomputerized.Thesupermarketpurchase-sell-stockmanagementsystemisatechnologywithcomputertomanagegoods,beforecomputerhasnotbeenpopulartheinventorymanagementisoperatedbystaffmanualinwritingway,it'seasytogowrongandcancauseunnecessarylosses.Nowthegeneralsupermarketsusecomputertomanage,byusingthecomputerasamanagementtoolcanhelpadministratorsmoreeffectivelyandmoreefficienttomanagethedailyworkofsupermarket.Supermarketpurchase-sell-stockmanagementsystemisthetypicalinformationmanagementsystem(MIS),itsdevelopmentmainlyincludesthesettingandmaintenanceofdatabaseandtheprogrammingofthefrontendapplication.Theformerrequiredestablishdataconsistencyandintegrality,datasecuritygoodstorehouse.Forthelatterrequiresacompletefunctionofapplicationprogram,easytouse,etc.Supermarketpurchase-sell-stockmanagementsystemcanrealizealotofthefunctions,themostimportantofitisthemanagementofgoods,includinggoodspurchase(stock),goodssell(sales),cargostorage(stock).Supermarketpurchase-sell-stockmanagementsystemmainlyusetheJAVAlanguageandSQLServer2005database,firstdesignthesystemusetheJAVAlanguage,basicallyachievedthemanagementofgoodsandalsoachievedotherfunctions,forexamplethehelpdocument.UseSQLServer2005databasetooperationthedata,notforrapidandstableoperationoflargeamountofdata,precisiontrappedaccesscontrol,ensurethesafeofthecoredata.Keywords:purchase-sell-stockmanagemant；stock；MIS；database目录III目录1绪论......................................................................................................................................11.1研究背景.......................................................................................................................11.2研究意义.......................................................................................................................11.3可行性研究...................................................................................................................22开发软件（技术）简介......................................................................................................32.1Java语言简介................................................................................................................32.2J2SE技术介绍...............................................................................................................32.3工厂模式介绍...............................................................................................................32.4JDBC简介.....................................................................................................................32.5开发环境及环境配置...................................................................................................42.5.1系统环境及Java环境配置...................................................................................42.5.2C/S简介...................................................................................................................42.5.3Eclipse简介.............................................................................................................52.5.4数据库开发工具选择及配置.................................................................................52.5.5对性能的一般规定.................................................................................................62.5.6其他专门要求.........................................................................................................62.5.7对安全性的要求.....................................................................................................72.5.8运行环境规定.........................................................................................................73系统分析..............................................................................................................................83.1系统整体功能分析.......................................................................................................83.2系统开发的特点...........................................................................................................83.3系统需求分析...............................................................................................................94数据库设计........................................................................................................................114.1数据库的引入.............................................................................................................114