The Design of Inventory Dynamic Query System in Printing Enterprises


Article Preview

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 query 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 query 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.



Edited by:

Helen Zhang and David Jin




L. Jiang et al., "The Design of Inventory Dynamic Query System in Printing Enterprises", Advanced Materials Research, Vol. 459, pp. 628-631, 2012

Online since:

January 2012




[1] Wenliang Ma. Printing enterprise process reengineering research and implementation[D]. Masters thesis of Beijing University of post and telecommunications, (2010).

[2] Ruiqi Lu. Printing enterprise inventory management theory [D]. Masers thesis of Wuhan University (2004).

[3] Grover Varun. From Business Reengineering to Business Process Change Management: A lognitudinal Study of Trends and Practices. IEEE Trans. Eng. Manag, pp.36-45(1999).


[4] Jiangfeng Hu. Database and project-based training tutorial: based on SQL Server [M]. p.41. Science Press (2010).