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]	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.
[2]	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.
[3]	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.
[4]	Guanbo CHOU, Jie LIU, Yili DUO, Tie SUN. Research on Quantitative Emergency Management Capability of Chemical Tank Farm Based on PPRR [J]. Journal of Liaoning Petrochemical University, 2024, 44(4): 51-59.
[5]	Guangqing CAI, Yijiong HU, Chunpeng LI, Ye JI, Hongli WANG. Gasoline Molecular Composition Prediction Based on Autoencoder Algorithm [J]. Journal of Liaoning Petrochemical University, 2024, 44(2): 1-6.
[6]	Haifeng ZHANG, Guixin ZHANG, Yuexin HU, Xiangyan HAN, Yuanyuan HAN, Guiyan ZHAO. Effect of Relative Molecular Weight of MAM on the Structure and Properties of PLA/PBAT/MAM Blends [J]. Journal of Liaoning Petrochemical University, 2024, 44(1): 9-14.
[7]	Hao DU, Lihua LI, Cheng MA, Chao YANG, Chen WANG, Hong ZHANG. Study on High Temperature Plugging System of Bridge Sealing and Thermal Consolidation [J]. Journal of Liaoning Petrochemical University, 2023, 43(6): 17-21.
[8]	Chunyu ZHANG, Changfu LIU, Xiaodan ZHU, Xinli YU, Xingchen LUO, Tianhao LU, Bingjie LI. Milling Chatter Recognition Based on Dynamic and Wavelet Packet Decomposition [J]. Journal of Liaoning Petrochemical University, 2023, 43(6): 75-81.
[9]	Yanbin CAO, Ming LIU, Lushan WANG, Kun WANG, Wei CHU, Aiqing MA, Fei WANG. Laboratory Physical Simulation of Steam Flooding Heavy Oil Hydrothermal Cracking Upgrading Behavior [J]. Journal of Liaoning Petrochemical University, 2023, 43(5): 34-41.
[10]	Yien Du, Zhaodi Yang, Yumei Li. Synthesis and Photocatalytic Performance of TiO₂/Fe₂O₃Composites [J]. Journal of Liaoning Petrochemical University, 2023, 43(4): 1-7.
[11]	Zhen Zhou, Yunbao Zhang, Chengzhou Wang, Zhaohai Zhan, Xulin Zheng, Danfeng Chen. Quantitative Characterization of Numerical Simulation of "Weak Gel+Water⁃Based Microspheres" Combined Modulation [J]. Journal of Liaoning Petrochemical University, 2023, 43(4): 72-77.
[12]	Xingtong Wang, Cheng Feng, Shengyi Wu, Dingqi Xu, Weiqiang Wang, Shengnan Du. Experimental Study of Severe Slugging in Downward Riser [J]. Journal of Liaoning Petrochemical University, 2023, 43(4): 78-83.
[13]	Junru Zhang, Baoyin Lu, Jinquan Li, Yuning Zan, Wenguang Wang. Microstructure and High Temperature Mechanical Properties of In⁃Suit Nano⁃Particles Reinforced Al Matrix Composites [J]. Journal of Liaoning Petrochemical University, 2023, 43(2): 26-34.
[14]	Jianwei Wei, Huaijia Fu, Jiling Liang, Han He, Tingting Han, Yan Zhang, Jie Han. Inquiry Investigation about Solidification/Stabilization of Surplus Sludge Using Silicate Cement [J]. Journal of Liaoning Petrochemical University, 2023, 43(2): 7-12.
[15]	Yuanjie Liu, Qiang Liu. A Pipe Layout Sequence Optimization Method Based on Disassembly Complexity [J]. Journal of Liaoning Petrochemical University, 2023, 43(2): 86-91.

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