Supercharge Your Innovation With Domain-Expert AI Agents!

Method and device for generating SQL (Structured Query Language) statement and electronic equipment

A technology of statement and parameter information, applied in the database field, can solve the problems of low development efficiency and high development labor cost, and achieve the effect of reducing development cost, reducing development resources, and quickly generating

Pending Publication Date: 2021-09-28
QINGDAO HAIER TECH +1
View PDF14 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] When there are many business needs, a large amount of development resources need to be invested, the development labor cost is high, and the development efficiency is low

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
  • Method and device for generating SQL (Structured Query Language) statement and electronic equipment
  • Method and device for generating SQL (Structured Query Language) statement and electronic equipment
  • Method and device for generating SQL (Structured Query Language) statement and electronic equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0017] In order to understand the characteristics and technical content of the embodiments of the present disclosure in more detail, the implementation of the embodiments of the present disclosure will be described in detail below in conjunction with the accompanying drawings. The attached drawings are only for reference and description, and are not intended to limit the embodiments of the present disclosure. In the following technical description, for purposes of explanation, numerous details are set forth in order to provide a thorough understanding of the disclosed embodiments. However, one or more embodiments may be practiced without these details. In other instances, well-known structures and devices may be shown simplified in order to simplify the drawings.

[0018] The terms "first", "second" and the like in the description and claims of the embodiments of the present disclosure and the above drawings are used to distinguish similar objects, and are not necessarily 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
Login to View More

PUM

No PUM Login to View More

Abstract

The invention relates to the technical field of databases, and discloses a method for generating SQL statements, comprising: acquiring parameter information from a preset Excel file, the parameter information corresponding to a parameter name; and assigning the parameter information to a field corresponding to the parameter name in a preset SQL statement template to obtain a to-be-operated SQL statement. By adopting the method provided by the invention, the parameter information can be modified based on the business requirements, so that different parameter information is assigned to the fields corresponding to the parameter names in the preset SQL statement template, different SQL statements are obtained, developers do not need to construct the SQL statements for multiple times, the SQL statements can be quickly obtained, development resources are reduced, and the development cost is reduced. The invention further discloses a device for generating the SQL statement and the electronic equipment.

Description

technical field [0001] The present application relates to the technical field of databases, in particular to a method and device for generating SQL statements, and electronic equipment. Background technique [0002] Some existing business project management often involves the processing of database data, such as accessing data, querying data, and deleting data. These data processing logics need to be implemented through SQL (Structured Query Language, Structured Query Language) statements , and the implementation 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 implement the corresponding logic. [0003] In the process of implementing the embodiments of the present disclosure, it is found that at least the following problems exist in related technologies: [0004] When there are many business needs...

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
CPCG06F16/2445G06F16/2433
Inventor 刘超陈合王康
Owner QINGDAO HAIER TECH
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com