【作者】 黄敏；

【导师】 肖世德；

【作者基本信息】 西南交通大学 ， 机械电子工程， 2008， 硕士

【摘要】 燃气设备行业是一个快速发展的行业,这是由于国家大力提倡清洁能源和国际化能源使用趋势决定的。近年来国家几个大型相关项目的实施为这个行业的发展推波助澜,西气东输、西电东送、中俄天燃气项目、东海油气项目使天燃气相关产业的升幅超过了大多数人的想象。调压器在燃气设备行业中具有举足轻重的地位,但是传统的调压器选型是通过纸质文件来进行进出口压力、流量和阀口等信息的查询,给工作带来了不便。针对这种情况,利用数据库技术来实现调压器的自动选型。目前基本的数据库访问技术主要有ODBC、DAO、RDO、JDBC和OLEDB/ADO,他们是不同时期出现并广泛使用的技术,很多技术现在仍很流行。本论文就这些基本的数据库访问技术作了比较研究,采用当前比较流行的ADO技术,利用VIUSAL C++语言设计实现。然后重点介绍了利用ADO技术来实现对ACCESS数据库的访问,以及利用动态链接库来实现EXCEL表格的查询过程。实践证明该系统比传统的选型过程更快,效率更高。更多还原

【Abstract】 Gas equipment industry is a rapidly growing industry in virtue of vigorously promoted use trends of state’s clean energy and international- ization energy. And the implementation of several large-scale projects such as Western China Gas and Electric Power Transported to the East, the Sino-Russian Gas and Eastern China Sea Oil accelerates the development of the industry. These make natural gas related to industry increases rapidly.Regulator hold the balance in Gas equipment industry, but traditional Selection of Gas Regulator just refer to papery file to get the information about inlet and outlt pressure, capacity, and caliber of valve, which bring in inconvenience. So in this circumstance, use Database technology to realize auto-selection of gas regulator.Current baic database access technique primarily contain ODBC, DAO, RDO, JDBC, OLE DB/ADO, they appear separately on different period and use broadly, some techniques are still very popular now. This paper has compared and researched these basic database access techniques, and the system is realized with Viusal C++ Language by adoption ADO database access technique, which is much popular. Then the most important introduction is ADO database access technique, which is used to access the database of ACCESS. At the same time, the system utilize DLL to realize the process of lookup information in EXCEL. And it has been proved that this system is much more faster than traditional selection of gas regulator, and also in efficiency.更多还原