煤矿设备管理信息系统的设计与实现
摘要
设备信息管理已成为现代企业管理的一个重要组成部分,尤其是对于拥有设备多价值大的煤炭企业,设备信息管理意义更显深远。然而,我国煤炭企业长期采用物、帐、卡手工模式来实现设备信息的管理,造成数据采集周期长、过程繁琐、出错率高,不能准确及时地反映设备现状,从而给企业的经营生产带来不利影响。因此,建设煤矿设备管理信息系统,设计合理的信息采集流程和灵活高效的查询统计功能,保证数据完整准确,提高人员工作效率是本文研究的主要目的。
在具体分析安家岭煤矿设备管理需求的基础上,参考现代设备管理的先进理论,设计并实现了煤矿设备管理信息系统。
首先,在对设备管理业务进行详细调研的基础上,分析了企业设备管理的现状和用户需求,对系统所需的功能及业务实现流程进行了总体设计,给出了系统功能树和流程图,并作了相应解释。
其次,详细规划并阐述系统各功能模块所包含的子模块及其实现流程。设计了系统实体关系图以及数据字典,并简要介绍了系统采用的企业级数据产品SQL SERVER 2000。
然后,结合本系统的分布特点和运行要求,提出采用基于J2EE的三层式Web应用体系结构,并对该结构体系及实现它所要求的关键技术,如JSP,EJB,JDBC,Structs等作了较详细的介绍。在这个基础上,搭建了本系统的开发运行环境。
最后,本文详细阐述了煤矿设备管理信息系统的实现。列举了系统实现的难点以及相应的解决办法,包括通过采用原始纸质单据电子化处理,分三级查阅的方法,解决既保存原始纸质材料作为第一参考资料,又能避免翻阅档案的繁琐和不及时的难题,以及通过定义角色并赋予角色权限,然后将角色指派到用户的方法,达到既实行严格的权限管理,又能适应用户工作职责不断变化的要求。本文还结合运行界面和相应代码介绍了系统典型功能的实现过程。
所开发完成的煤矿设备管理信息系统具有如下特点:基于J2EE的三层式结构,不受平台限制,易扩展,易维护;普通用户通过浏览器访问系统,方便易学,适合广大矿区员工;原始单据电子化管理,既保护了原始单据又方便查阅;人性化流程设计,缩短了办公周期,提高了工作效率。
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.
在具体分析安家岭煤矿设备管理需求的基础上,参考现代设备管理的先进理论,设计并实现了煤矿设备管理信息系统。
首先,在对设备管理业务进行详细调研的基础上,分析了企业设备管理的现状和用户需求,对系统所需的功能及业务实现流程进行了总体设计,给出了系统功能树和流程图,并作了相应解释。
其次,详细规划并阐述系统各功能模块所包含的子模块及其实现流程。设计了系统实体关系图以及数据字典,并简要介绍了系统采用的企业级数据产品SQL SERVER 2000。
然后,结合本系统的分布特点和运行要求,提出采用基于J2EE的三层式Web应用体系结构,并对该结构体系及实现它所要求的关键技术,如JSP,EJB,JDBC,Structs等作了较详细的介绍。在这个基础上,搭建了本系统的开发运行环境。
最后,本文详细阐述了煤矿设备管理信息系统的实现。列举了系统实现的难点以及相应的解决办法,包括通过采用原始纸质单据电子化处理,分三级查阅的方法,解决既保存原始纸质材料作为第一参考资料,又能避免翻阅档案的繁琐和不及时的难题,以及通过定义角色并赋予角色权限,然后将角色指派到用户的方法,达到既实行严格的权限管理,又能适应用户工作职责不断变化的要求。本文还结合运行界面和相应代码介绍了系统典型功能的实现过程。
所开发完成的煤矿设备管理信息系统具有如下特点:基于J2EE的三层式结构,不受平台限制,易扩展,易维护;普通用户通过浏览器访问系统,方便易学,适合广大矿区员工;原始单据电子化管理,既保护了原始单据又方便查阅;人性化流程设计,缩短了办公周期,提高了工作效率。
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.
引文
[1]徐扬光主编,设备工程与管理,上海,华东理工大学出版社,1999,21-26
[2]李德源,杨华龙编著,现代设备经济管理,北京,人民交通出版社,2000,3-6
[3]刘林祥,工业企业设备管理,北京,清华大学出版社,1992,17-19
[4]俞明楠,王东华,蒋贵善等,生产运作与管理,大连理工大学出版社,1998,132-137
[5]史国庆,兖矿集团综机设备管理模式研究,[学位论文],山东科技大学,2004
[6]高峰,运河煤矿设备管理研究,[学位论文],山东科技大学,2006
[7]马清海,曾凡臣,关于国有煤矿设备管理的几点探讨,北方经贸,2001,3,204-205
[8]王军,黑岱沟露天矿设备管理与状态维修,[学位论文],辽宁工程技术大学,2004
[9]王善发,基于J2EE的镇雄县教育局勤工俭学管理信息系统,[学位论文],四川大学,2005
[10]许杰,基于J2EE的客户信息处理技术的研究与设计,[学位论文],哈尔滨工程大学,2005
[11](美)巴里什(Greg Banish)著,林琪,英宇译.J2EE Web应用高级编程,北京,清华大学出版社,2002.91-95
[12]haul等著,张志伟等译,J2EE构建企业系统,清华大学出版社,2001,6,35-38
[13]T.Weber.WLS J2EE体系结构简介
[14]杨绍方编著,深入掌握J2EE编程技术,北京,科学出版社,2002,9
[15]邱旭东,基于JSP的国家体育总局信访系统的构建和实现,[学位论文],北京邮电大学,2006
[16](美)伍特卡(Mark Wutka)著,程显华等译,JSP和Servlet程序设计使用专辑,北京:机械上业出版社,2002,90-95
[17]图拉川(Pravin V.Tulachan)著;肖国尊,马擎予译,EJB 2.0组件开发指南,清华大学出版社,2002,33-39
[18]刘方,基于B/S的设备管理信息系统,[学位论文],西北工业大学,2006
[19]URL:http://www.knowsky.com/4144.html JSP/Servlet构建三层管理信息系统
[20]URL:http://www.91dd.com J2EE完全参考手-J2EE概述
[21]徐春华,陈和平,基于J2EE的设备管理系统的设计与实现,机电一体化,2003, 3,14-16
[22]王飞龙,石英,基于Web Service的公文协同审批系统模型设计,厦门大学学报(自然科学版),2004,43(增刊),327-331
[23]刘启原,刘怡,数据库与信息系统的安全,北京,科学出版社,2000
[24]王鹏,董群,数据技术极其应用,北京,人民邮电出版社,2000
[25]王承君,Web数据库技术应用教程,北京,中国水利水电出版社,2005
[26]王玮,JDBC编程技术,电脑学习,2001,5,32-33
[27]黄明,梁旭,JSP信息系统设计与开发实例,北京,机械工业出版社,2004
[28](美)Karl Avedal等著,黎文等译,JSP编程指南,北京,电子工业出版社,2001
[29]SUN Microsystem Corporation Java 2 Platform Enterprise Edition.http://iava.sun.com/j2ee.2003/2005-01-21
[30]Emmanuel Cecchet,JulieNlarguerite,Willy Zwaenepoel.Performance and Scalability of EJB Applications,ACM SIGPLAN Votices,2002,37(11),246-261
[31]严金妹,基于J2EE的在线购书系统设计与实现,福建电脑,2006,1,19
[32]刘媛春,罗云翔.基于JSP的动态网页技术.成都信息工程学院学报.2005,20(4),399
[33]Junk K,OberhauserRAn object-oriented invocation layer for the Java MessageService,On The Move to Meaningful Internet Systems,2003,57-69
[34]Mark Johnson,Designing Enterprise Applications with the J2EE,Addison-WesleyLongrnan,Incorporated 2002
[35]郭静,基于JSP的通用信息发布管理系统,重庆工学院学报,2005,19(11),59
[36](美)J.福克纳(Jayson Falkner),(美)B.加尔布雷恩(Ben Galbrain),(美)R.艾拉克(Romin}rani)著,司光亚,牛红译,JSP Web编程指南,北京,电子工业出版社,2002
[37]朱顺泉,姜灵敏,管理信息系统理论与实务,北京,人民邮电出版社,2001
[38]朱远明,周国荣,基于计算机网络的矿山企业信息化管理,中南工业大学学报(自然科学版),2003,34(增1),76-78
[39]李保文,设备管理新思维新模式,机械工业出版社,1999,167-190
[40]李保文,国外设备管理模式及发展趋势,设备维修与管理,2000,7,16-18
[41]赵涛,设备管理理论体系与发展趋势,工业工程,2001,6,17-18.
[2]李德源,杨华龙编著,现代设备经济管理,北京,人民交通出版社,2000,3-6
[3]刘林祥,工业企业设备管理,北京,清华大学出版社,1992,17-19
[4]俞明楠,王东华,蒋贵善等,生产运作与管理,大连理工大学出版社,1998,132-137
[5]史国庆,兖矿集团综机设备管理模式研究,[学位论文],山东科技大学,2004
[6]高峰,运河煤矿设备管理研究,[学位论文],山东科技大学,2006
[7]马清海,曾凡臣,关于国有煤矿设备管理的几点探讨,北方经贸,2001,3,204-205
[8]王军,黑岱沟露天矿设备管理与状态维修,[学位论文],辽宁工程技术大学,2004
[9]王善发,基于J2EE的镇雄县教育局勤工俭学管理信息系统,[学位论文],四川大学,2005
[10]许杰,基于J2EE的客户信息处理技术的研究与设计,[学位论文],哈尔滨工程大学,2005
[11](美)巴里什(Greg Banish)著,林琪,英宇译.J2EE Web应用高级编程,北京,清华大学出版社,2002.91-95
[12]haul等著,张志伟等译,J2EE构建企业系统,清华大学出版社,2001,6,35-38
[13]T.Weber.WLS J2EE体系结构简介
[14]杨绍方编著,深入掌握J2EE编程技术,北京,科学出版社,2002,9
[15]邱旭东,基于JSP的国家体育总局信访系统的构建和实现,[学位论文],北京邮电大学,2006
[16](美)伍特卡(Mark Wutka)著,程显华等译,JSP和Servlet程序设计使用专辑,北京:机械上业出版社,2002,90-95
[17]图拉川(Pravin V.Tulachan)著;肖国尊,马擎予译,EJB 2.0组件开发指南,清华大学出版社,2002,33-39
[18]刘方,基于B/S的设备管理信息系统,[学位论文],西北工业大学,2006
[19]URL:http://www.knowsky.com/4144.html JSP/Servlet构建三层管理信息系统
[20]URL:http://www.91dd.com J2EE完全参考手-J2EE概述
[21]徐春华,陈和平,基于J2EE的设备管理系统的设计与实现,机电一体化,2003, 3,14-16
[22]王飞龙,石英,基于Web Service的公文协同审批系统模型设计,厦门大学学报(自然科学版),2004,43(增刊),327-331
[23]刘启原,刘怡,数据库与信息系统的安全,北京,科学出版社,2000
[24]王鹏,董群,数据技术极其应用,北京,人民邮电出版社,2000
[25]王承君,Web数据库技术应用教程,北京,中国水利水电出版社,2005
[26]王玮,JDBC编程技术,电脑学习,2001,5,32-33
[27]黄明,梁旭,JSP信息系统设计与开发实例,北京,机械工业出版社,2004
[28](美)Karl Avedal等著,黎文等译,JSP编程指南,北京,电子工业出版社,2001
[29]SUN Microsystem Corporation Java 2 Platform Enterprise Edition.http://iava.sun.com/j2ee.2003/2005-01-21
[30]Emmanuel Cecchet,JulieNlarguerite,Willy Zwaenepoel.Performance and Scalability of EJB Applications,ACM SIGPLAN Votices,2002,37(11),246-261
[31]严金妹,基于J2EE的在线购书系统设计与实现,福建电脑,2006,1,19
[32]刘媛春,罗云翔.基于JSP的动态网页技术.成都信息工程学院学报.2005,20(4),399
[33]Junk K,OberhauserRAn object-oriented invocation layer for the Java MessageService,On The Move to Meaningful Internet Systems,2003,57-69
[34]Mark Johnson,Designing Enterprise Applications with the J2EE,Addison-WesleyLongrnan,Incorporated 2002
[35]郭静,基于JSP的通用信息发布管理系统,重庆工学院学报,2005,19(11),59
[36](美)J.福克纳(Jayson Falkner),(美)B.加尔布雷恩(Ben Galbrain),(美)R.艾拉克(Romin}rani)著,司光亚,牛红译,JSP Web编程指南,北京,电子工业出版社,2002
[37]朱顺泉,姜灵敏,管理信息系统理论与实务,北京,人民邮电出版社,2001
[38]朱远明,周国荣,基于计算机网络的矿山企业信息化管理,中南工业大学学报(自然科学版),2003,34(增1),76-78
[39]李保文,设备管理新思维新模式,机械工业出版社,1999,167-190
[40]李保文,国外设备管理模式及发展趋势,设备维修与管理,2000,7,16-18
[41]赵涛,设备管理理论体系与发展趋势,工业工程,2001,6,17-18.