基于ADO技术实现多种数据源间SQL查询功能  

Realization of SQL Query Function among Multiple Data Sources Based on ADO Technique

作　　者：陈雪梅[1] 

机构地区：[1]中国科学技术大学,安徽合肥230027

出　　处：《计算机技术与发展》2007年第10期7-11,68,共6页Computer Technology and Development

摘　　要：以ADO技术为数据库编程的基础,通过ADO对象的数据访问接口,用Microsoft提供的通用数据连接文件(.udl)来建立和测试ADO连接属性,动态建立可视化的数据源设置。利用Visual C++搭建的应用框架,在多种数据源间实现结构化查询语言(SQL)查询的功能。用示例说明,ADO建立的应用程序对数据库的操作与数据库系统的类型无关,它使应用程序把SQL语言作为标准语言来存取各种数据,从而进一步说明ADO技术在数据库应用领域的灵活性和高兼容性。Based on ADO technique for database programming, the ADO link attribute is set up and tested via the data access interface of ADO object by using the universal data link （. udl） supplied by Microsoft,and a visualized data source configuration is dynamically built. The SQL （Structured Query Language） query function is realized by use of the application frame constructed by C ＋ ＋. An example is supplied to show that the operation of databases by the application program built up of ADO is irrelevant to the types of database systems. In the example, the SQL language is used as a standard language by the application program to store and fetch various data. Thus the flexibility and high compatibility of the ADO technique in the fields of database applications are shown.

关 键 词：ADO 数据库 对象 属性 UDL SQL 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论]