Method, electronic device and readable storage medium for generating sql statement

Abstract

A method and system for generating an SQL statement, an electronic apparatus and a readable storage medium, which realize automatic and accurate generation of an SQL statement. The method comprises: 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 choosing to generate a universal SQL statement by the user based on the SQL statement generation type selection interface is received, generating and displaying a DDL statement parameter setting interface, and after basic information input by the user based on the DDL statement parameter setting interface is received, generating a DDL statement according to the basic information; and if an instruction of choosing to generate a customized SQL statement by the user based on 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 based on the function change selection interface is received, determining, according to a pre-set mapping relationship between a function change item and an SQL statement block, an SQL statement block corresponding to the selected changed function.

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