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

A statement and code generation technology, applied in the computer field, can solve problems such as manual writing, low efficiency of SQL statement writing, and compilation errors.

Pending Publication Date: 2019-03-08
CHINA PING AN LIFE INSURANCE CO LTD
View PDF7 Cites 13 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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 developer

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • SQL statement generation method and device and computer-readable storage medium
  • SQL statement generation method and device and computer-readable storage medium
  • SQL statement generation method and device and computer-readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0043] It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0044] The invention provides a method for generating SQL statements. refer to figure 1 As shown, it is a schematic flowchart of a method for generating SQL statements provided by an embodiment of the present invention. The method may be performed by a device, and the device may be implemented by software and / or hardware.

[0045] In this embodiment, the SQL statement generation method includes:

[0046] Step S10, when receiving the structured query language SQL statement creation instruction sent by the client, generate an SQL statement editing interface and send it to the client for display, wherein the SQL statement editing interface includes a code area and an editing component area.

[0047] In the embodiment of the present invention, the user can write SQL statements through the client or the web interface, and...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

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...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F16/242
Inventor 陈佳
Owner CHINA PING AN LIFE INSURANCE CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap