煤矿事故管理系统的设计与开发

为解决煤矿事故信息处理效率低、出错率高以及查找、更新和维护困难等诸多问题,笔者在大量煤矿事故案例资料的基础上,结合煤矿事故特点,运用数据库技术,设计开发出煤矿事故案例管理系统,并在开发过程中选用V isual Basic 6.0为前台开发工具,SQL Server 2000数据库管理系统为后台数据库,ADO技术为V isual Basic 6.0与SQL Server 2000的数据接口。通过对煤矿事故的特征信息进行分析,将其分为事故矿井的自然状况和事故后果及事故性质两个部分,并建立4个数据表。设计与开发的系统包括用户管理模块、信息管理模块和信息查询模块,具有数据维护功能、数据查询功能、数据输出功能。该系统的应用有利于煤矿事故案例信息的充分利用及煤矿企业信息化水平的提高。

Design and Development of Coalmine Accident Management System

To solve the problems in information handling of coalmine accidents such as low efficiency,high error rates and difficulties in data query,data update and data maintenance,a coal mine accidents management system was developed with database technology on the basis of many coalmine accident cases and their traits.In this development,Visual Basic 6.0 was selected as the developing tool,SQL Server 2000 as background database and ADO(ActiveX data object) as the interface between Visual Basic 6.0 and SQL Server 2000.By analyzing the characteristic information of coalmine accidents,they were classified to be mine natural conditions and accident consequences,and 4 data tables were established.The system included user management module,information management module and information query module,which performed the functions of data maintenance,data query and data output.The application of this system is favorable to the full use of coalmine accidents information and the improvement of coalmine information level.