Design of General Database Access Component Based on COM

Abstract

Abstract:

COM technique is a prevailing component technology at present .By analyzing the characteristics of COM and database technique, the design and implementation method of general database access component based on COM technique was given. Advanced ADO technology was adopted to connect various kinds of database and accomplish basic database access operation.Utilizing ATL technology as the developing tool of COM , a component of server in -process, i.e .general database access component , was designed and developed , which w as tested and applied by developing application program of client end with Visual C ++ MFC .Various kinds of database , such as Access , SQL Server , etc .were used as background database.Database was accessed through ODBC interface or directly through various kinds of special database engines .The basic operation functions of querying , adding an ddeleting data in database are realized .Also , querying basic information of table in database is achieved .

Key words: COM , Software reuse , Database access , ADO

摘要： COM 技术是目前流行的组件技术, 通过分析COM 技术及数据库技术的特点, 给出了基于COM 技术的通用数据库存取组件的设计和实现方法。采用当前先进的ADO 技术进行各种数据库的连接和数据库存取的基本操作, 以ATL 技术作为COM 的开发工具, 设计和开发一进程内服务器组件——— 通用数据库存取组件;以VC ++ MFC 开发客户端应用程序, 并测试和应用该组件。采用ACCESS 、SQL SERVER 等各种类型数据库作为后台数据库, 通过ODBC 接口访问数据库或者直接通过各种专门数据库引擎访问相应的数据库文件, 实现了对数据库中数据进行查询、添加和删除等基本操作, 也实现了对数据库中表的基本信息进行查询的功能。

关键词: COM , 软件复用, 数据库存取, ADO

JIANG Jun -yin,HOU Li -gang. Design of General Database Access Component Based on COM[J]. Journal of Liaoning Petrochemical University, 2005, 25(1): 75-77.

姜军银, 侯立刚. 基于COM 技术的通用数据库存取组件的设计[J]. 辽宁石油化工大学学报, 2005, 25(1): 75-77.

[1]	Junying HU, Weiwei SHI, Dongyun HAN, Yating LIU, Bin WANG, Shubin XIA. Preparation of Aromatic Green Rubber Filling Oil by Multistage Extraction [J]. Journal of Liaoning Petrochemical University, 2025, 45(4): 1-7.
[2]	Hai XING, Xiaohua WANG, Ningning LIU. Adsorptive Removal of Congo Red by PVDF/MIL⁃53(Fe) Composite Membrane from Aqueous Solution [J]. Journal of Liaoning Petrochemical University, 2025, 45(4): 19-26.
[3]	Hailin MA, Zhiping FAN, Bo WANG, Siyu WANG, Chengjie SUN. Research Progress on Combined Remediation Technologies and Applications for Petroleum⁃Contaminated Soils [J]. Journal of Liaoning Petrochemical University, 2025, 45(3): 18-25.
[4]	Xinxin ZHOU, Ruixin BAO, Xiangguang SUN, Yuanzhong QIN. Fault Diagnosis of Centrifugal Compressor Based on Ontology [J]. Journal of Liaoning Petrochemical University, 2025, 45(3): 72-81.
[5]	Ming BAN, Pengwei TIAN, Jiangtao CAO. The Design of Multi⁃Channel Flame Intelligent Monitoring System Based on B/S Architecture [J]. Journal of Liaoning Petrochemical University, 2025, 45(2): 83-89.
[6]	Zhen XUE, Jianhua QIAN, Zenghua ZHAO. Mechanical Properties of Graphene/Polypropylene Composites [J]. Journal of Liaoning Petrochemical University, 2025, 45(1): 27-32.
[7]	Bin SUN, Xiaoyu LI, Peng CHEN, Zhaolong LIAN, Caifeng WANG. Research Progress on Interfacial Properties of Carbon Fiber Composites Modified by Porous Materials [J]. Journal of Liaoning Petrochemical University, 2025, 45(1): 33-40.
[8]	Yeqiang JIANG, Guiyang MA, Xiangchun JIANG, Zhuo LIANG, Lufei YU. Numerical Simulation Study on Leakage and Diffusion of Hydrogen⁃Doped Natural Gas Pipelines in the Comprehensive Pipe Gallery [J]. Journal of Liaoning Petrochemical University, 2025, 45(1): 59-64.
[9]	Engao TANG, Lezhong LI, Wensheng ZHOU, Gongchang WANG, Zenghua ZHANG, Yi JIN, Erlong YANG. Adaptability Analysis of Synergistic Enhanced Oil Recovery Techniques Through Chemical Flooding and Infill Well Patterns in Offshore Oilfields [J]. Journal of Liaoning Petrochemical University, 2025, 45(1): 65-73.
[10]	Dong ZHANG, Guiyang MA. Effect of Anion Non⁃Ion Complex System on Emulsification Property of Heavy Oil [J]. Journal of Liaoning Petrochemical University, 2024, 44(6): 17-22.
[11]	Jinxiang LIU, Zhe LI, Jingbin HAO, Song GE, Qiuxia WANG, Wei ZHENG, Xiangguo LU, Jianhong YANG. Study on Microscopic Mechanism of Heavy Oil High Viscosity in Typical Heavy Oil Reservoirs in Bohai Sea [J]. Journal of Liaoning Petrochemical University, 2024, 44(6): 65-72.
[12]	Zhaoxuan LI, Ting YU, Ming WANG, Jun CHEN, Jin LIU, Huan CHENG. The Latest Advancements in Technology for Intelligent Drilling and Completion Equipment Research [J]. Journal of Liaoning Petrochemical University, 2024, 44(6): 73-80.
[13]	Wenfei WAN, Guiyang MA, Chunyang ZANG, Di AO. Synergistic Effect of SDBS and APG1214 on Heavy Oil [J]. Journal of Liaoning Petrochemical University, 2024, 44(5): 15-21.
[14]	Wenxin JIANG, Guangxiang ZHANG, Ke YANG, Guiyan ZHAO. Preparation and Properties of Fully Biodegradable High Impact PLA/PBAT Composites [J]. Journal of Liaoning Petrochemical University, 2024, 44(5): 31-37.
[15]	Xinghua ZHANG, Pengbo NI, Haosheng WU, Yuan SUN, Shibin LIU, Sai YIN. Application of Formation Pressure Monitoring While Drilling Technology in Deep and Ultra⁃Deep Formation [J]. Journal of Liaoning Petrochemical University, 2024, 44(5): 61-65.

Design of General Database Access Component Based on COM

基于COM 技术的通用数据库存取组件的设计

PDF

Knowledge

Abstract

Cite this article

share this article

References

Related Articles 15

Recommended Articles

Metrics