基于WEB的智能仓库管理系统

毕业设计报告(论文)题目:基于web的智能仓库管理系统基于web的智能仓库管理系统摘要本系统主要完成对仓库的库存管理，包括入库、出库、库存，员工信息，供应商信息以及密码管理等六个方面。系统可以完成对各类信息的浏览、查询、添加、删除、修改、报表等功能。本系统由四大模块构成，分别是：系统设置，单据填开，库存查询，报表导出。其中系统设置包括：管理员的增加，修改，删除，以及权限管理；仓库内货物的基本资料的增加，修改，删除；工人，客户等的基本资料的增加，修改，删除。单据填开模块包括：出库单，入库单，派工单，等单据的填开及作废操作。库存查询系统包括：库存情况的查询，各项明细的查询，工人工资的查询，以及按月，按季度，按年的报表导出功能。该系统是对仓库的智能管理，并进行相应的采购管理、入库管理、出库管理、报表管理等一些仓库方面的管理。关键字：数据库SQL语言MyEclipse数据库组件仓库管理东南大学毕业设计报告ⅡIntelligentDatabaseSystemAbstractThesystemmainlyreferstowarehousingmanagement,whichincludesthefollowingfields:stockinandout,inventory,staffdata,suppliersdataandpasswordmanagement.Italsooffersthefunctionsasdatabrowse,adding,deleting,modificationandreport,etc.Itcontains3modules,systemmanagement,receiptsmanagementandinventoryquery.Systemmanagementmoduleisusedtoconductoperateradding,modification,deletingandauthoirtiesassignment,inaddition,inventory,staffandcustomerdataadding,modificationanddeleting;thesecondpartreferstostockinandout,receiptsfill-inandcancellation;thelastmodulecontendstowarehousingquery,staffsalaryquery,monthly,quarterly,yearlyreportqueryandexport.Asstatedpreviously,thesystemisanintelligentwarehousingmanagementsolution,whichincludes:purchasingmanagement,stockinandoutmanagement,reportmanagement,etc.Keywords:database；SQL；Eclipse；Databasemodule；Databasemanagement东南大学毕业设计报告Ⅲ目录第一章前言.....................................................11.1背景情况介绍.................................................11.2系统整体设计................................................2第二章系统的总体设计...............................................32.1模块........................................................32.1.1模块划分...............................................32.1.2功能概述...............................................32.2实现技术....................................................62.2.1jsp-extjs..............................................62.2.2javabean及Hibernate...................................62.2.3Struts2、MVC和Spring..................................72.2.4数据库MySQL...........................................102.2.5开发工具MyEclipse7.1..................................12第三章系统分析....................................................133.1可行性分析.................................................133.1.1技术可行性............................................133.1.2运行可行性............................................133.2系统流程分析...............................................143.2.1操作员登记（Operator表）.............................143.2.2系统登陆..............................................143.2.3原料类型设置（material表等）.........................153.2.4原料（成品）入库（materialturnover表等）.............153.2.5原料（成品）出库（materialturnover表等）.............153.2.6派工单（working表等）................................163.2.7单据作废..............................................163.2.8明细查询..............................................163.2.9报表导出..............................................17第四章算法描述....................................................18东南大学毕业设计报告Ⅶ4.1数据结构...................................................184.1.1表结构设计............................................184.1.3程序结构图............................................204.2系统流程图.................................................224.2.1原料入库..............................................224.2.2原料出库..............................................224.2.3成品入库..............................................234.2.4成品出库..............................................234.2.5派工单................................................244.3部分实现算法...............................................244.3.1权限算法..............................................244.3.2分页算法..............................................244.3.3验证算法..............................................254.3.4预警算法..............................................254.4算法分析...................................................254.4.1正确性................................................254.4.2可读性................................................254.4.3健壮性................................................254.4.4效率与低存储量需求....................................25第五章系统实现....................................................265.1前台jsp-extjs..............................................265.1.1设计与实现思路........................................265.1.2实现部分..............................................275.1.3代码部分..............................................305.2javabean及Hibernate......................................325.2.1设计思路..............................................325.2.2实现部分..............................................325.2.3代码部分..............................................335.3Struts2、MVC和Spring.....................................35东南大学毕业设计报告Ⅶ5.3.1设计与实现思路........................................355.3.2代码部分..............................................355.4数据库MySQL...............................................395.4.1设计及实现思路........................................395.4.2代码部分..............................................395.5开发工具MyEclipse7.1......................................395.5.1工具选择..............................................395.5.2界面截图....