Research on Comprehensive Query Method in Database System
MU Tong-na · Journal of China University of Mining and Technology · 2006
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.