Design And Realization Of An Coal Mine Equipment MIS

Equipment information management has become an important component of the modern enterprise management . Especially for coal enterprises with more high-value equipments, equipment information management means more far-reaching significance. However, coal enterprises in our country, has been used to manager the equipment information by filling many card in order to ensure the equality of objects and account. It result in a long cycle of data acquisition, tedious process, the risk of errors, not accurate and timely reflection of the status of equipment so as to a adverse impact of the production and business of enterprises. Therefore, to develop a coal mine equipment Management Information System(MIS) with the reasonable design of information collection processes , the efficient and flexible statistical function , ensuring that data is complete and accurate and improving personnel efficiency is the main purpose of this paper.In this paper, on the base of detailed analysis the needs of Anjialing mine about equipment management ,adopting modern management theory, the author design and realization the coal mine equipment MIS.First, on the basis of the detailed investigation on equipment management business, the status quo in equipment management and user demand have been analyzed . The function of systems and business processes to achieve the system have been designed . A function tree and a flow charts were given with accordingly explained.Secondly, the author elaborated on the smaller function modules which was contained in every system module and implementation process. Furthermore, the author designed the system entities diagram and data dictionary , and gave a briefing on the enterprise-class data products- SQL SERVER 2000.Thirdly, with the reference of the characteristics of the MIS distribution and operating requirements, the three-tiered Web application architecture based on J2EE was selected. The author made a brief introduction to the structural system and its key technologies, such as JSP, EJB, JDBC, Structs, etc.Finally, the author described in detail the realization of mine equipment information management system. Two difficulties of the system realization and the corresponding solutions were cited. One is how to Persevere the original paper-based materials as a first reference, while avoid cumbersome and delayed. The solution is that a original paper-based material is trans formatted to a electronic one and setting up three levels to limit reading. The other is how to control user's permissions even if he can change his work every time. The solution is defining many roles , empowering the roles permissions, and then assigning the roles to users. In this paper, the interface and the corresponding code on the typical functions were given.The System has the following characteristics: Firstly, It based on the three-tier structure of J2EE without limitation platform, so it was extensible and easy maintenance. Secondly, ordinary users can access it through the browser which is easy to learn for the broad masses of mine workers. Thirdly, It management original documents by electronic technology to protect them and convenient inspection. The last, humane work-flow designing shortened the office cycle and improved work efficiency.