摘要
为了改善公路隧道围岩云分级系统中传统的数据管理方法,将MySQL数据库引入到云分级系统的设计中。该系统采用关系型数据库,运用E-R模型进行概念结构设计,具体描述了4个实体以及实体间的一对一、一对多等关系,进而在Wamp这个集成开发环境中能够实现MySQL数据库的储存、修改和删除等功能,并利用PHP技术方便快捷地建立了动态交互的Web系统,实现了利用Web浏览器访问MySQL数据库。结合实例用MySQL数据库实现了公路隧道围岩云分级系统的数据管理,以及能够通过Web网页快速查询数据库中的基本信息、围岩级别和施工方法等。实例表明,MySQL作为数据的管理和传输手段,在公路隧道围岩云分级系统数据管理中取得了良好的效果,加快了云分级系统开发的速度,印证了MySQL数据库是公路隧道围岩云分级系统开发的基础和保障。
To improve the traditional data management method of surrounding rock cloud classification system of highway tunnels,the MySQL is introduces database into the design of the cloud grading system.The system uses a relational database,E-R modeltodesign conceptual structure,and describes four specific entities and one-to-one,one-to-many relationship between entities.So that it is realized to store,modify and delete MySQL database in the integrated development environment of Wamp,and convenient to use PHP technology to establish a dynamic interactive Web system,and implemented using a Web browser to access the MySQL database.With an example,this paper achieved using MySQL database to manage the data of surrounding rock cloud classification system of highway tunnels and quering related information,surrounding rock level and construction methodsquickly through Web pages.The example shows that using MySQL to manage and transport data has achieved good results in the data management in the surrounding rock cloud classification system of highway tunnels,accelerated the development of cloud classification system,and verified that MySQL database is the foundation and guarantee for the development of surrounding rock cloud classification system of highway tunnels.
引文
[1]郝玉强,赵东平.山岭隧道洞口施工技术优化探讨[A].中国土木工程学会第十五届年暨隧道及地下工程分会第十七届年会论文集[C].成都:中铁西南科学研究院有限公司,2012:56-60.HAO Yu-qiang,ZHAO Dong-ping.Discussion on optimization of construction technology for mountain tunnel[A].Proceedings of the 17th Annual Meeting of the 15th Annual eeting of the China Civil Engineering Society and the Tunnel and Underground Engineering Branch[C].Chengdu:China Railway Southwest Research Institute Co LTD,2012:56-60.
[2]陈凡安.公路隧道围岩分级专家系统研究[D].成都:重庆大学,2013.CHENG Fan-an.Research on road tunnel surrounding rock classification expert system[D].Chengdu:Chongqing University,2013.
[3]李汪石.公路隧道围岩云分级系统的开发与应用[D].长沙:长沙理工大学,2017.LI Wang-shi.Development and application of cloud computing system of road tunnel surrounding rock Classification[D].Changsha:Changsha University of Science and Technology,2017.
[4]查焕奕.基于ResNet模型的隧道围岩云分级系统开发[D].长沙:长沙理工大学,2018.ZHA Huan-yi.Development of classification system of tunnel surrounding rock cloud based on ResNet model[D].Changsha:Changsha University of Science and Technology,2018.
[5]罗启强.基于PHP+MySQL的高校教务管理系统的设计与实现[D].长春:吉林大学,2016.LUO Qi-qiang.Design and implementation of college educational administration management system based on PHP+MYSQL[D].Changchun:Jilin University,2016.
[6]李荣国,王见.MySQL数据库在自动测试系统中的应用[J].计算机应用,2011,31(S2):169-171,175.LI Rong-guo,WANG Jian.Application of MySQLdatabase in automatic test systems[J].Journal of Computer Applications,2011,31(S2):169-171,175.
[7]张永梅.MySQL数据库技术在公民健康信息管理系统中的应用[D].西安:西安电子科技大学,2010.ZHANG Yong-mei.The application of MySQL database technology in citizen’s health information Management System[D].Xi′an:Xidian University,2010.
[8]王飞飞.MySQL数据库应用从入门到精通[M].北京:中国铁道出版社,2014:44-56.WANG Fei-fei.MySQL database application from entry to mastery[M].Beijing:China Railway Publishing House,2014:44-56.
[9]杨利荣,李伟.基于PHP语言系统的计算机辅助教学系统开发实现[J].自动化与仪器仪表,2016(6):251-253.YANG Li-rong,LI Wei.Development and implementation of computer assisted instruction system based on PHP language[J].Automation and Instrumentation,2016(6):251-253.
[10]戴明儒,陆启军.基于PHP技术的电子相册系统分析与设计[J].计算机光盘软件与应用,2013,16(22):281-283.DAI Ming-ru,LU Qi-jun.Analysis and design of electronic photo album system based on PHP technology[J].Computer CD Software and Applications,2013,16(22):281-283.
[11]邓民.基于MySQL的诗歌翻译语料库系统数据库设计[J].计算机技术与发展,2015,25(10):179-182.DENG Ming.Database design on poetry translation corpus system based on MySQL[J].Computer Technology and Development,2015,25(10):179-182.
[12]邱均平,邹菲.基于PHP技术的电子商务WEB数据库开发[J].情报科学,2003(9):970-973.QIU Jun-ping,ZOU Fei.Apllication of web database based on PHP in e-business[J].Information Science,2013(9):970-973.