数据库系统综合查询方法研究

探讨了一种基于动态查询语句的综合查询设计方法，力求简化查询操作、提高查询灵活性．详细阐述了查询原理以及实现过程，通过对SQL语言的语法、使用方法以及综合查询窗体设计思路和功能的分析，使实现方法更加简洁和清晰．在查询语句中依据用户需求添加各种逻辑关系的控制，生成多争件自由组合、顺序任意的、动态SQL查询语句，从而满足用户各种查询需要，实现真正意义上的综合查询．最后结合Delphi开发的物资智能配栽系统中多条件查询的实例，给出综合查询有关功能实现的具体代码．

Research on Comprehensive Query Method in Database System

A method of designing comprehensive query mode was presented based on dynamic query sentence.It can make the query operation much simply and flexibly.Query principle and realization process were explained.By means of analyzing the grammar,usage of SQL,the designing thinking and function of comprehensive query,the readers can have a clear cognition for the realization of the method.According to the users' demands,the control of logic relation can be appended,the dynamic SQL query sentence that the multicondition assembly freely and the order arrange discretionarily can be created.Therefore,the query demands can be realized and the comprehensive query can be achieved.At last,combining with the multicondition query example of material intelligentized loading system developed by Delphi,the code about the function realization of comprehensive query was provided.