印刷企业库存物料动态查询系统设计

良好的库存管理可以降低企业成本,减少库存损耗,为生产提供充足的物料。动态地查询和统计库存物料的期初、出入库、当前库存数量是印刷企业库存管理的重要内容。针对印刷企业的现状和实际需求,采用JSP+SQLServer 2000技术,设计了基于B/S模式的印刷企业库存物料动态查询系统,给出实现的方法和数据库表结构。利用该系统,企业的管理人员可以查找任何时段内的物料情况,及时了解当前物料的库存数量和使用情况,有效地安排企业的生产,并可以进行远程信息查询。

The Design of Inventory Item Dynamic Query System in Printing Enterprises

Good inventory management not only can reduce the costs of printing enterprises,but also can reduce inventory loss and give enough material for the enterprise production.It is an important part of inventory management for printing enterprise to get dynamic inquiry and statistics of beginning stocks,in stocks,out stocks and current stocks.In this paper,aiming at the present situation of printing enterprise inventory management and the current domestic printing enterprise actual requirement,we achieve the dynamic inquiry function on the printing enterprise material by using the JSP＋SQL Server 2000 technology,which is based on browser/server（B/S） mode,and we also give the method and database structure to do it.The function allows the enterprise managers quickly obtain the current material storage situation,plan the enterprise production through inquiring the materials situation in time,and do these in remote distance on line.