摘要                                                 

近年来，伴随我国基础建设事业的快速发展，桥梁作为基建项目的重中之重更是蓬勃发展。但发展伴随着的相关隐患也渐渐出现，出现了许多由于检测维修工作不到位导致的桥梁损坏甚至坍塌的事件，由于原有中国公路桥梁管理系统前期只能使用Excel表进行最简单的重复录入，将桥梁所有信息都存储在网站服务器，后期分派至各桥梁养护维修项目的检测人员只能通过网站实现简单远程浏览，但主要功能依旧局限在桥梁基本信息的查询上，有效的桥梁检测流程确定，养护维修方案制定，养护费用分析预测等功能都未能实现。监管者因此往往未能及时对桥梁所产生的安全隐患及病害做出迅速准确的应对。若有高效便捷的桥梁检测管理系统，也许就能防范于未然。

论文选题来源于“桥梁检测管理系统软件开发”项目。针对该项目中单一信息查询，没有相应行之有效的检测流程，维修方案等问题，汇总后设计基本信息、检测评估、养护维修与系统管理模块等四大模块，相对应的解决了该公司前期预期所有问题，形成了流程化、高效快捷的业务处理流程。

本文通过对现有项目背景和技术的分析，主要工作内容如下：

1.框架设定：对桥梁检测管理系统的数据流进行规范和分析，在此基础上选择合适的框架和设计模式。

2．需求设计分析：分析并规范桥梁检测管理的具体业务流程，对于桥梁检测管理系统的系统总体需求进行分析，对具体业务模块进行细化，针对各个功能模块进行需求分析，获得细化业务功能需求以及需保证的系统非功能性指标。

3.模块设计：设计桥梁检测管理系统的系统构架，规划设计系统的四大功能模块，并对模块内的功能重点难点进行逐一分析。

4.细节设计：针对系统内数据库庞大、查询工作复杂等问题，采用Nginx反向代理与负载均衡进行请求响应与业务分发。针对系统内多样化的数据导出与文件生成，设计使用JPA数据持久层与Apache POI进行文件与数据的准确导出。

5.系统实现：对桥梁检测管理系统进行整体架构的完善和各模块的内功能点的具体实现，包括进行四大功能模块具体功能实现，并解决现有数据库与新增数据库一致性问题。

6.测试评估：根据形成的需求分析进行测试用例设计，测试系统主要四大功能模块的主要功能并评估系统性能。预计完成上述功能可以为桥梁检测提供信息化、智能化的全方位优化管理与控制。

经过实际测试证明，桥梁检测管理系统实现了需求中的各类桥梁基本信息录入与查询、检测评估报告生成、养护维修方案生成、后期相关报表生成并管理及复杂权限管理等功能，极大简化了检测人员和信息整合人员的工作，达到了前期需求的预期。

 

关键字:  桥梁， 病害， 自动生成报告， 离线地图

ABSTRACT

In recent years, with the rapid development of China's infrastructure construction . Bridge construction become the most important thing for infrastructure projects. But related problems arising with development also emerge. There have been many incidents of bridge damage or even collapse due to insufficient inspection and maintenance work. Because of the original Chinese highway and bridge management system can only use Excel tables for the simplest repeated entry and to store all bridge information on the web server. The inspection person who assigned to each bridge maintenance project can only use simple remote browsing through the website. But the main function is still limited to the query of the basic information of the bridge. Functions such as bridge inspection determination, maintenance and repair plan formulation, and maintenance cost analysis and prediction have not been realized. As a result, regulators often fail to respond quickly and accurately to the safety problems and diseases. If there is an efficient and convenient bridge detection management system, may be able to prevent the disease before it happens.

 

The topic of this thesis is selected from the project of "Bridge Detection Management System Software Development".With the problems of single information query in this project, no corresponding effective detection process and maintenance plan,after the summary,design the four major modules as basic information module, detection and evaluation module, maintenance and repair module and system management module.Solved all the early stage issues expected by the company, formed a streamlined, efficient and efficient process.

                                          

This article analyzes the background and technology of existing project, proposed vthe main tasks are as follows:

 

1.Framework setting: standardize and analyze the data flow of the bridge inspection management system, and select an appropriate framework and design mode.

 

2.Business process: Analyze and standardize the specific business processes of bridge inspection management. Based on the analysis of the functional requirements of the bridge monitoring and management system, the detailed analysis and arrangement of the logical business are used to obtain detailed business function requirements and guarantee system performance indicators.

 

3.Module design: design the software structure of the bridge inspection management system, define the basic information module, inspection and evaluation module, maintenance and repair module and system management module, and perform system analysis.

 

4.Detail design: Aimed the problems of huge database and complex query work in the system,use Nginx reverse proxy and load balance for request response and service distribution. Aimed the diverse data export and file generation, use JPA data persistence layer and Apache POI to accurately export files and data.

 

5.System implementation: design and analyze the overall function of the bridge detection and management system and the functional modules, including the basic information module, the detection and evaluation module, the maintenance and repair module, and the system management module, and resolve the data type consistency between the existing database and the newly added database.

 

6.Test evaluation: test the main functions of the four major functional modules and evaluate the system performance. The completion of the above functions can provide information-based and intelligent all-round optimized management and control for bridge inspection.

 

The actual test proves that the system realizes the functions of entering and querying the basic information of various bridges, the generation of inspection and evaluation reports, the generation of maintenance and repair plans, the generation and management of related reports and the management of complex permissions, which greatly simplifies the work of the inspectors and information integrators,accomplish the expectations of the previous requirements.

 

Keywords: bridges, diseases, automatic report generation, offline maps

 

[1] 祁德秀. 公路梁桥病害原因分析及加固技术研究[D].西安.长安大学,2016.

[2] Shi-Zhi Chen,Gang Wu,De-Cheng Feng. Damage detection of highway bridges based on long-gauge strain response under stochastic traffic flow[J]. Mechanical Systems and Signal Processing,2019,127.

[3] 许凯泉,雷袁欧忆.关于公路桥梁检测质量控制及检测技术的应用分析[J].中国水运,2019(11):112-113.

[4] 储一鸣.在役桥梁检测技术应用及发展趋势[J].山西建筑,2018,45(11):130-131.

[5] 罗伦英. 桥梁管理系统研究与应用[D].湖南大学,2010.

[6] 李博,麻竹倩.中美桥梁检测体系对比研究[J].上海建设科技,2016(01):58-61
.
[7] 孟利波,唐光武.基于云平台的中小桥梁监测系统架构方案研究[J].公路交通技术,2013(04):106-109.

[8] 石德菊. 中小桥梁群运营期结构状态监测系统研究[D].重庆交通大学,2015.

[9] Long Zhang. Course Reform and Practice of Linux Operating System Based on the Whole Process Case[C]. Institute of Management Science and Industrial Engineering.Proceedings of 2019 International Conference on Education,E-Learning and Economic Research(IC3ER 2019).Institute of Management Science and Industrial Engineering:计算机科学与电子技术国际学会(Computer Science and Electronic Technology International Society),2019:147-151.

[10] 叶伟. 城市住宅小区智能化系统规划设计与实现[D].电子科技大学,2011
.
[11] 郭大伟,张伟,姜晓艳.一种基于Nginx的UDP反向代理服务器数据转发策略[J].北京信息科技大学学报(自然科学版),2019,34(06):87-91.

[12] 郝红岩. 基于MVC模式的Web框架的应用研究[D].武汉理工大学,2013.

[13] 陈小乔. 基于MVC架构的污水处理管理系统的设计与实现[D].华中科技大学,2018.

[14] 高庆洋. 基于Spring Boot的科技成果转化信息服务系统设计与实现[D].吉林大学,2017.

[15] 肖露. Spring框架研究与应用[D].长沙理工大学,2011.

[16] Hatma Suryotrisongko,Dedy Puji Jayanto,Aris Tjahyanto. Design and Development of Backend Application for Public Complaint Systems Using Microservice Spring Boot[J]. Procedia Computer Science,2017,124.

[17] 席东东. 工程合同管理系统的设计与实现[D].西安电子科技大学,2017.

[18] 温立辉.JPA在数据持久化层的应用与原理探析[J].科技资讯,2019,17(06):5+7.

[19] Anonymous. Microsoft Corp.; Microsoft and Sourcesense Partner to Contribute to Open Source, Apache POI to Support Ecma Office Open XML File Formats[J]. Computer Technology Journal,2008.

[20] 洪珏. 基于BS的渔业从业人员数据分析与管理系统[D].浙江工业大学,2018.

[21] 申强,张臣.关于《公路桥梁技术状况评定标准》的研究[J].中国公路,2011(21):92-94.

[22] 仓智.《公路桥梁技术状况评定标准》(JTG/T H21—2011)解读[J].山西交通科技,2012(05):34-36.

[23] 吴圣贤. 《公路桥梁技术状况评定标准》应用研究及系统研发[D].合肥工业大学,2016.

[24] 袁永顺.浅谈桥梁日常养护病害检查[J].青海交通科技,2010(02):65-67.

[25] 战成波,张良,刘福生.桥梁现场常见病害及检查[J].黑龙江交通科技,2007(08):66-67.

[26] 邱书洋. Redis缓存技术研究及应用[D]. 2016

[27] 熊慧中,李中铭,王海涛,于文学.基于《公路桥梁技术状况评定标准》的桥梁评定管理系统开发[J].公路工程,2014,39(03):214-218.

[28] 王毅.国内主流云平台的机器学习功能浅析[J].科技传播,2019,11(12):93-94+115.

[29] Francesco Adalberto Bianchi,Alessandro Margara,Mauro Pezze. A Survey of Recent Trends in Testing Concurrent Software Systems[J]. IEEE Transactions on Software Engineering,2018,44(8).

[30] 赖歆.浅谈信息化系统中的性能测试[J].信息通信,2018(08):145-147.

[31] Dina Mahmoud Mohamed Mansour,Ibrahim Mahdi Moustafa,Ayman Hussein Khalil,Hisham Arafat Mahdi. An assessment model for identifying maintenance priorities strategy for bridges[J]. Ain Shams Engineering Journal,2019,10(4).

[32] 尹常青.基于BIM技术在市政道路设计中的应用[J].交通世界,2018(36):46-47.