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

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

Design of General Database Access Component Based on COM

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 was 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 and deleting data in database are realized. Also, querying basic information of table in database is achieved.