The Design And Implementation Of Tunnel Inspection And Maintenance Management System For The Fourteenth Railway Bureau Of China

In recent years,China has made breakthroughs in the construction of highways.The number of mileages is increasing,and the range of traffic is gradually widening.Highways occupy an important position in today's transportation system.The inspection and maintenance of highway tunnel account for a large proportion of the business system of the China Railway 14th Bureau.The bureau needs to invest more manpower and financial resources to maintain the tunnel facilities under its jurisdiction,and the various types of consumption costs are high.In addition,traditional tunnel maintenance systems also have the problems of low failure response capacity and insufficient timeliness of work processing.Therefore,China Railway 14th Bureau decides to carry out the development of a highway tunnel inspection and maintenance management system.Spring MVC framework,Oracle11g database are the main technical forms adopted in the system development process.MyBatis framework focuses on the data persistence business and references ORM form.Spring MVC framework separates components of common models.MyBatis+Spring MVC is also one of the most commonly used frameworks for software application development today.For the characteristics of complex system business data system and many parameter items,Oracle 11g database technology is used for the management.The main functions of the system achieved are statistical inquiry and maintenance plan management.Tunnel inspection data management is mainly directed to the management of basic data,historical data,and backup data.Each type of data includes multiple subordinated subcategories,such as civil construction data.Statistical inquiry is mainly directed to the processing of commonly used reports.The specific contents relate to tunnel accidents,highway tunnels,accidents over the years,dangerous tunnels,and so on.The commonly used processing functions include query,statistics,and export.Tunnel evaluation analysis implements setting of the weights,calculation of the evaluation results,output,and so on,and includes various evaluations such as routine evaluation.Maintenance plan management can perform maintenance rank,and the results of the maintenance can be sorted,and all inspection contents,such as daily inspection and fire protection facility inspection,can be managed and calculated.After the application of the system,the business data involved in the highway tunnel maintenance of China Railway 14th Bureau Tunnel has summarized and combed,and a relatively complete system has been established,the pertinence and rationality of related work have been guaranteed.The past problem of lack of response capacity and various potential safety problems in the highway tunnel maintenance system have been solved.The expenses and costs incurred during the work process can be systematically processed and counted,which has the effect of increasing revenue and reducing expenditure.