SQL statement generation method and device and computer-readable storage medium

Abstract

The invention discloses a SQL statement generation method. The method comprises the following steps of when a SQL statement creation instruction of a structured query language sent by a client is received, generating and sending an SQL statement editing interface to the client for display; receiving a component selection instruction sent by a client end, determining a corresponding atomic statement, obtaining a code corresponding to the atomic statement and sending the code to the client end for displaying in a code area, and determining a statement parameter set for the atomic statement by auser based on an SQL statement editing interface; combining the code of the atomic statement with the statement parameters set in the cache area, and displaying the combined code synchronously in thecode area of the client side; repeatedly executing the above steps until an editing completion instruction sent by the client based on the SQL statement editing interface is received and generating the SQL statement according to the combined code in the cache area. The invention also provides an SQL statement generating device and a computer-readable storage medium. The invention improves the compiling efficiency of SQL statements.

Description

technical field [0001] The present invention relates to the field of computer technology, in particular to a SQL statement generation method, device and computer-readable storage medium. Background technique [0002] Some existing business project management often involves the processing of database data, such as accessing data, querying, updating and managing databases, etc. These data processing logics need to be executed through SQL (Structured Query Language) statements. Realization, and the realization of data processing logic mostly involves industry knowledge, which requires developers to understand business requirements. When there are new business requirements, it is necessary to rewrite the corresponding SQL statement to realize the corresponding logic, which requires not only specialized developers to manually When writing a large number of SQL statements, you will also face the phenomenon of compilation errors, which leads to low efficiency in writing SQL stateme...

AI Technical Summary

Problems solved by technology

[0002] Some existing business project management often involves the processing of database data, such as accessing data, querying, updating and managing databases, etc. These data processing logics need to be executed through SQL (Structured Query Language) statements. Realization, and the realization of data processing logic mostly involves industry knowledge, which requires developers to understand business requirements. When there are new business requirements, it is necessary to rewrite the corresponding SQL statement to realize the corresponding logic, which requires not only specialized developers to manually Write a large number of SQL statements, and you will also face the phenomenon of compilation errors, resulting in low efficiency in writing SQL statements

Images