Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method for detecting legality of SQL statement, storage medium and terminal equipment

A legality and statement technology, applied in the computer field, can solve problems such as inability to detect and verify the legality of SQL statements

Pending Publication Date: 2021-11-19
SHENZHEN HUASHENG SOFTWARE TECH CO LTD +1
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The technical problem to be solved by the present invention is to provide a method for detecting the legality of SQL statements, a storage medium and a terminal device for the deficiencies in the prior art, so as to solve the problem that Mybatis cannot detect and verify the legality of SQL statements in the prior art

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 for detecting legality of SQL statement, storage medium and terminal equipment
  • Method for detecting legality of SQL statement, storage medium and terminal equipment
  • Method for detecting legality of SQL statement, storage medium and terminal equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0039] The present invention provides a method for detecting the legality of SQL statements, storage media and terminal equipment. In order to make the purpose, technical solutions and effects of the present invention clearer and clearer, the present invention will be further described in detail below with reference to the accompanying drawings and examples. It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0040] Those skilled in the art will understand that unless otherwise stated, the singular forms "a", "an", "said" and "the" used herein may also include plural forms. It should be further understood that the word "comprising" used in the description of the present invention refers to the presence of said features, integers, steps, operations, elements and / or components, but does not exclude the presence or addition of one or more other features, Integers, steps, operati...

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 method for detecting legality of SQL statements, a storage medium and terminal equipment. The method comprises the following steps: preprocessing a plurality of SQL statements corresponding to an application program to obtain a plurality of complete SQL statements corresponding to the application program; analyzing each complete SQL statement in the plurality of complete SQL statements to obtain an element set corresponding to the complete SQL statements; calling a preset legality rule to carry out legality rule detection on each element set in the element set set; and if each element set in the element set passes the legality rule detection, judging that the SQL statement corresponding to the element set is legal. Therefore, according to the method and the device, the complete SQL statement of the application program is obtained, and the preset legality rule is called to carry out legality rule detection on the complete SQL statement, so that the legality of the SQL statement of the current application program is determined.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a method for detecting the legality of an SQL statement, a computer-readable storage medium and a terminal device. Background technique [0002] Mybatis is widely used as a common database persistence layer technology. In the database application software developed using Mybatis technology, the code structure of the software is designed as follows: each module function is associated with the corresponding database operation program unit (ie, the Mapped Statement interface), and contains one or more SQL statements (Structured QueryLanguage, structured Query Language) XML file, and the Java program interface Mapper is paired with the XML file. An XML file contains several, dozens, or even more SQL statements, and at the same time, each SQL statement generates different SQL statements due to the different values ​​of the passed parameters (that is, different conditions). [0003...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F11/36
CPCG06F11/3604
Inventor 王兴春
Owner SHENZHEN HUASHENG SOFTWARE TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

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