Supercharge Your Innovation With Domain-Expert AI Agents!

Query method based on SQL splicing through annotation adding on request parameters

A technology for requesting parameters and query methods, which is applied in electrical digital data processing, special data processing applications, and creating/generating source code. The effect of low risk, high development efficiency and convenient business development

Pending Publication Date: 2020-10-16
广州云徙科技有限公司
View PDF0 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The code shown above is lengthy, because it cannot be fully automatically generated according to the front-end parameters into SQL conditions, it is not easy to write, and it is difficult to do grammar checks, resulting in a large amount of manual spelling development, low development efficiency, and easy spelling mistakes that cause loopholes and other shortcomings
For example, writing less conditional connection keywords and leads to SQL syntax errors, coupled with if judgments, resulting in non-targeted tests that cannot test this vulnerability

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
  • Query method based on SQL splicing through annotation adding on request parameters
  • Query method based on SQL splicing through annotation adding on request parameters
  • Query method based on SQL splicing through annotation adding on request parameters

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0022] The present invention will be further described below in conjunction with drawings and embodiments.

[0023] This technical solution needs to define an annotation that simplifies the writing of WHERE conditions; use the defined annotations on the request parameters to achieve the effect of configuring the WHERE conditions; pass the request parameters through the annotation analysis engine to generate SQLWHERE condition results. Use that result to make a SQL query. Only the first step (defining a comment that simplifies the writing of the WHERE condition) needs to be involved in business development to achieve the purpose of simplifying business development. The core of this technical solution is the method of using annotations on request parameters. This enables business developers to only focus on the query conditions required by the business, and does not need to pay attention to specific SQL splicing statements. The specific process is as follows:

[0024] see fi...

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 query method based on SQL splicing through annotation adding on request parameters. The query method comprises the steps of: S1, defining annotations on the basis of a writing principle of a simplified WHERE condition; S2, adding defined annotations to request parameters, and setting database fields and condition operations corresponding to the query conditions; S3, inputting the request parameters with the annotations and query input values into an annotation analysis engine which then acquires the WHRER conditions from the annotations of the request parameters; andS4, performing SQL query by using the WHRER conditions. According to the query method, writing specification annotations of simplified WHERE conditions are defined, and the defined annotations are used on the request parameters to achieve the effect of configuring the WHERE condition and realize the packaging of the bottom layer, therefore, the business development is more convenient, the development efficiency is higher, and the risk of bug generation is lower.

Description

technical field [0001] The invention relates to the technical field of software development information, in particular to a query method based on adding annotations to request parameters and splicing them into SQL. Background technique [0002] Structured Query Language (Structured Query Language), referred to as SQL, is a special-purpose programming language, a database query and programming language, used to access data and query, update and manage relational database systems. Structured Query Language is a high-level non-procedural programming language that allows users to work on high-level data structures. It does not require the user to specify the data storage method, nor does it require the user to understand the specific data storage method, so different database systems with completely different underlying structures can use the same structured query language as the interface for data input and management. Structured query language statements can be nested, which ...

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): G06F8/33G06F16/242
CPCG06F8/33G06F16/2433
Inventor 李楠叶亮钦黃凌壮
Owner 广州云徙科技有限公司
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