Method of generating SQL statements, electronic device and readable storage medium

Abstract

The invention discloses a method of generating SQL statements, an electronic device and a readable storage medium. The method includes: receiving an SQL statement generation instruction sent by a user, and generating and displaying an SQL statement generation type selection interface; if an instruction of selecting generation of universal SQL statements by the user on the basis of the SQL statement generation type selection interface is received, generating and displaying a DDL (data definition language) statement parameter setting interface, and after basic information input by the user on the basis of the DDL statement parameter setting interface is received, generating DDL statements according to the basic information; and if an instruction of selecting generation of customized SQL statements by the user on the basis of the SQL statement generation type selection interface is received, generating and displaying a function change selection interface, and after a changed function selected by the user on the basis of the function change selection interface is received, determining SQL statement blocks, which correspond to the selected changed function, according to mapping relationships of preset function change items and SQL statement blocks. The method realizes automatic and accurate generation of the SQL statements.

Description

technical field [0001] The invention relates to the technical field of computers, in particular to a method for generating SQL statements, an electronic device and a readable storage medium. Background technique [0002] In the existing system development, SQL statements are generally manually written by developers. In addition to carefully understanding business logic knowledge and professional SQL knowledge, they also face the problem that the SQL statements written by themselves are not in compliance with specifications, business logic, error-prone and inefficient. Lower problem. Contents of the invention [0003] The main purpose of the present invention is to provide a method for generating SQL statements, an electronic device and a readable storage medium, aiming at automatically and accurately generating SQL statements. [0004] In order to achieve the above object, the present invention provides an electronic device, which includes a memory, a processor, and a sys...

AI Technical Summary

Problems solved by technology

[0002] In the existing system development, SQL statements are generally manually written by developers. In addition to carefully understanding business logic knowledge and professional SQL knowledge, they also face the problem that the SQL statements written by themselves are not in compliance with specifications, business logic, error-prone and inefficient. low problem

Images