Intelligent query method and its applicationbased on character string parsing
Guoyou Shi · Journal of Dalian Maritime University · 2005
According to an unsure but grammatical SQL sentence, this paper introduced a method of universal intelligent querying with character string parsing technique for the querying functions of most database applications which are finite or are ordered by the needs of user at that time. This method can dynamically calculate all field names, field alias and relevant field type, therefore form an auto-adaptive querying interface, and then create a new SQL sentence according to the user's settings, subsequently the querying results in accordance with the former SQL are showed on a universal querying window. Taking navigation-dispatch system for an example, intelligent querying function is implemented using DELPHI7 and ORACLE9i and some source code is presented. Experiments show that this method is very effective and the implementation code can be reused.