Sql automatic execution method and system for database sql statement automatic generation tool

The present invention provides a sql automatic execution method for a database sql statement automatic generation tool. The method comprises that: the sql query statement automatic generation tool isinterconnected with the database; table structure information of a to-be-queried table and function i...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: LIN YINFENG, WU YOUYING, FANG CHAO, CAI SHIPING
Format: Patent
Sprache:chi ; eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:The present invention provides a sql automatic execution method for a database sql statement automatic generation tool. The method comprises that: the sql query statement automatic generation tool isinterconnected with the database; table structure information of a to-be-queried table and function information of all supported built-in functions are obtained from the database; the database sql statement automatic generation tool reads the table structure information and the function information, and uses the random algorithm to generate sql query statements; the database sql statement automatic generation tool calls an interface function connected with the database to automatically execute the sql query statements, and outputs the generated log in the execution process to a log file in real time; and after executing the sql query statements, the execution results are automatically counted and output. The present invention also provides a system corresponding to the method. The advantages of the technical schem