材料管理系统的设计与实现

^论文字数:12126,页数:33

摘  要
 随着信息技术在管理上越来越深入而广泛的应用，ERP系统的实施在技术上已逐渐成熟。ERP系统是一个不断发展的新型学科，企业要生存要发展，要高效率地把企业活动有机地组织起来，就必须加强企业管理，即加强对企业内部各种资源（人，财，物等）的有效管理，建立与自身特点相适应的ERP系统。
本文介绍了企业工厂业务人员在可以通过材料管理系统保证材料的正常及时管理，快速查询到仓库库存及相关料况，对材料的申请管理如：材料申请，材料替代，材料出库等。使得申请材料的过程更加清晰快捷。还可以迅速查询仓库呆滞料状况，以便及时处理，减少库存积压对资金的占用，提高资金营运力。使得仓管做帐简单，轻松，及时，准确。仓库资料可据领导需要以多种格式产生，美观大方，快捷灵活。
本文主要从企业的材料管理系统出发，应用软件工程的相关理论解决软件设计中遇到的问题。通过系统流程图总体概括出系统的基本操作过程，数据流图分析数据的流动走向。应用Java程序设计语言设计用户显示界面和内部逻辑。    Oracle EBS系统作为当今世界最领先的ERP产品，应用范围拓宽，将覆盖制造业以外的许多领域，向专业化软件方向发展。这将改变向用户提供适于所有用户的通用产品的状况，而针对具体的用户市场对软件预先“剪裁”推出针对特殊市场的软件产品。专业化软件不需要用户进行针对性的配置就可得到可用的菜单、模块和报表等，可以更快的启用，可得到更有针对性的服务。Oracle EBS结合现如今广泛流行的Java
程序设计语言和SQL语句，并根据每个企业自身的特点和业务需求进行设计，使企业的管理变得方便、全面，利用Oracle EBS开发此查询系统，更使得销售数据更全面的被展示，因此生产管理部门对生产环节当中的各个因素都会有相当全面的了解和分析，从而对企业生产更轻松的做出决策和控制。 

关键词：ERP产品；Oracle EBS系统；JAVA开发语言；SQL语句
Abstract
   Along with the information technology in the management of more and more depth and a wide range of applications, ERP system in the implementation of technology has gradually matured. ERP system is a continuous development of new disciplines, enterprise to survive is to develop and efficient business activities organized organically, to strengthen enterprise management, namely, to strengthen the enterprise internal various resources (people, money, the effective management of the content to wait), establish its own characteristics in line with ERP system.
 This paper introduces the salesman in the enterprise factory by material management system ensure that materials of normal timely management, rapid inquiry to the warehouse inventory and related material condition, such as: the material in road, has already please purchase, distribution quantity more comprehensive. Also can rapid inquires glazed material condition, to warehouse timely processing, reduce inventory of capital of the occupier, raise funds operating force. Make warehouse do his simple, easy, timely and accurate. Warehouse material can according to leaders need to multiple formats produced, beautiful generous, quick flexible.
 This article mainly from the corporate material management system, application software engineering based the related theory of solving problems encountered in the design of software. Through the system flowcharts overall generalizes the system of basic operation process, data flow diagram analysis data flow direction. Application of Java programming language design the user interface and internal logic display.
 Oracle EBS system as the world most advanced ERP products, application range widening, will cover many fields, beyond manufacturing to specialized software development. This will change to customers for all users of generic product of conditions, and according to specific user of the software market in advance for special clipping "launch" market software products. Specialized software does not require users to specific configuration can get usable menu, module and statements, much faster to enable, can get more specific services. Oracle EBS combination nowadays widespread Java
Programming languages and SQL statements, and according to the characteristics of each enterprise itself and business requirements for design, make enterprise management became convenient, comprehensive, use Oracle EBS exploit this inquiry system, more make sales data showing more comprehensive, so production management departments of the various factors of production link there will be quite a comprehensive understanding and analysis of enterprise production, thus more relaxed decision making and control. 
   Key words: ERP products； Oracle EBS system； JAVA ； SQL

目  录
序  言 1
第1章 概述 3
1.1材料管理系统的概况 3
1.2 问题定义 3
1.3 ^论文主要工作 3
第2章 系统开发工具及开发方法 5
2.1 系统开发工具 5
2.1.1 Java 5
2.1.2 UniEAP 5
2.1.3 Oracle 6
2.2 系统开发方法 6
第3章 系统分析 8
3.1 业务流程 8
3.2 系统流程 9
3.3 系统数据流 10
3.4 系统主要功能 11
第4章 系统设计 13
4.1 B/S结构模式的确定 13
4.2 系统功能模块设计和具体页面设计 14
4.3 实体关系（E-R图） 15
4.4 表结构 15
第5章 系统实现 18
5.1 三层模式 18
5.2 模块的具体实现 18
5.2.1 程序流程图 18
5.2.2 系统实现代码 19
5.2.3 系统界面 20
第6章 系统测试与开发心得 25
6.1 项目的三层架构 25
6.2 单元测试 25
6.3 系统测试 25
第7章 结论与建议 27
7.1 结论 27
7.2 建议 27
参考文献 28
致  谢 29

相关论文