摘要: 通用动态查询能够根据需要在程序运行过程中动态创建查询语句和查询命令,其实现路径有3种:利用用户数据字典、利用系统表与系统数据库和利用OLE DB数据供给程序等。文章对这3种方法的原理进行了详细研究,对其利弊进行了分析比较,并给出了具体实现。
关键词:
通用动态查询,
数据字典,
系统表,
OLE DB,
数据库
Abstract: The universal dynamic query can create query statement and command in the process of running program dynamically according to requirement. There are three implementation methods: utilizing user data dictionary, utilizing system tables, and utilizing the OLE DB data providers or services providers to implement the universal dynamic query. This paper studies the details of their principles and implementations, in additions, analyses and compares their advantages and disadvantages.
中图分类号:
何珍文,吴冲龙,张夏林,汪新庆. 数据库应用程序中通用动态查询实现方法研究[J]. , 2002, 28(11): 100-.
HE Zhenwen, WU Chonglong, ZHANG Xialin, WANG Xinqing. Study on the Implementation Methods of Universal Dynamic Query in Database Applications[J]. , 2002, 28(11): 100-.