基于系统表的通用动态查询系统设计与实现  

Design and implementation of universal dynamic query system based on system table

作　　者：孙仁鹏[1] 

机构地区：[1]中国药科大学教务处,江苏南京210009

出　　处：《计算机工程与设计》2007年第23期5819-5821,共3页Computer Engineering and Design

摘　　要：介绍了开发C/S模式下的基于系统表的数据库信息通用动态查询系统的设计思路和实现。在深入研究系统表和SQL语法的基础上,将查询需求与查询软件相分离,使软件相对通用,与具体应用无关,与库结构变更无关。软件使用方便,查询需求变化无需修改软件,只需在数据库服务器端编写相关视图,节省了大部分情况下查询需求的开发成本和后续的维护成本。How to design and implement a database information universal dynamic query system based on system tables in C/S mode is introduced. On the foundation of deep research system tables and SQL syntax, makes query requirement and software apart, so that software is relatively universal, is independent of practice application, is independent of database schema alteration. Software use is convenient, query requirement changing does not require to modify it, only requires to modify or write related view in database serve, so it can reduces the costs of exploration and maintenance in most condition.

关 键 词：通用动态查询 系统表 用户数据字典 动态SQL 数据库对象 动态界面 

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