CN116226161A

CN116226161A - Method for improving efficiency of developing MyBatis

Info

Publication number: CN116226161A
Application number: CN202211588412.2A
Authority: CN
Inventors: 刘俊
Original assignee: Xinguomai Digital Culture Co ltd
Current assignee: Xinguomai Digital Culture Co ltd
Priority date: 2022-12-12
Filing date: 2022-12-12
Publication date: 2023-06-06

Abstract

The patent describes an IDE plug-in for SQL translation and optimization based on Java acquisition of MyBatis log, which is mainly divided into two parts: 1. based on the XML page which is currently active, an error correction module for detecting SQL sentences in XML, preventing risks such as SQL injection and the like from being generated in the sentences and carrying out corresponding prompt is provided. 2. The method has the advantages that custom notes are innovatively used, memory is saved, accurate and efficient processing is achieved, and SQL translation, detection and splicing are achieved. This patent is applicable to projects that require development using mybatis and that possess a significant amount of database development effort. The patent realizes the automatic detection of SQL and provides the capability of prompting the developer of SQL loopholes and automatically modifying basic problems. The method realizes the translation of SQL precompiled by Mybatis, helps developers compare the difference between the current SQL and the expected SQL, facilitates the use of the SQL when the database is queried, and does not need manual assembly.

Description

Method for improving efficiency of developing MyBatis

Technical Field

IT and software development.

Background

During daily development, in the encoding process, developers often cause defects to SQL codes due to incomplete run-up or misuse, so that bug is generated in the starting, compiling and running processes, and normal use of the program is affected. In the development process, mybatis or Mybatis Plus can not run immediately after being printed with a log, wild cards need to be copied out to be filled manually, and when complex sql is encountered, time is wasted to read again and write. Most of the existing solutions are to grasp related information by scanning keywords of a console, and the following problems exist in the mode:

and (3) a step of: inefficient processing of large output logs requires more memory.

And II: the problem of redundant warning can appear in current solution, extravagant resource.

Disclosure of Invention

The patent describes an IDE plug-in for SQL translation and optimization based on Java acquisition, which is different from the prior art, creatively uses custom annotations, saves memory, processes accurately and efficiently, and realizes SQL translation, detection and splicing.

Drawings

FIG. 1 is a schematic diagram of an error correction module.

FIG. 2 is a schematic diagram of a translation module.

Detailed Description

This patent describes a method to improve the efficiency of developing MyBatis, and the patent mainly includes two parts:

1. the error correction module, fig. 1, automatically checks the SQL grammar or the corresponding label of the currently active window by using the IDEA native instruction mechanism, acquires the corresponding SQL sentence after checking the keyword, judges the risk according to the grammar, prompts if the risk exists, and modifies the simple error.

The method comprises the following steps:

(1) writing MyInject inheritance injection, acquiring a window which is currently active, and scanning a current code segment according to the expansion of the window.

(2) Comments corresponding to errors are described by using the insactiondescriptions, and corresponding html (such as warning comments of SQL injection risk abnormality) is written and displayed on the corresponding SQL.

(3) And configuring a corresponding localInspec and Tion configuration item in the plugin.xml, and binding our myInspec class for custom code detection opening.

(4) Quick repair can be performed in the html of the partial warning, and basic CodeFix is realized by calling the visitNewExpress () through an Abstract BaseJavaCalInjectTool () method when detecting codes.

2. The translation module, FIG. 2, uses the internal intersector to intercept the custom annotation mode generated by mybatis, obtain parameters, and reassemble the corresponding parameters

The method comprises the following steps:

(1) and writing plug-in class to realize an internetwor interface so as to prepare for obtaining a configeration object subsequently.

(2) The part which needs to be filtered when the program runs is specified through the @ internets label, and the corresponding data is fetched.

The system comprises four processing modules of Executor, parameterHandler, resultSetHandler, statementHandler, an execution component corresponding to mybatis, a parameter processing module, a result set module and a JDBC operation module.

(3) And injecting a corresponding plug-in implementation class into the Mybatis configuration, allowing the user-defined annotation interceptor to intercept the Mybatis, and completing capturing and binding of the interceptor.

(4) Executor in IDEA is created (creating an IDEA self-contained output console) while adding dependencies to Plgin. Xml to point to this output.

(5) And re-assembling the obtained data and outputting the data in the created Console_Executor.

Claims

1. The patent describes an IDE plug-in for SQL translation and optimization based on Java acquisition, which is different from the prior art, creatively uses custom annotations, saves memory, processes accurately and efficiently, and realizes SQL translation, detection and splicing.

2. The patent mainly comprises two parts: the error correction module is used for automatically checking SQL grammar or corresponding labels of a currently active window by utilizing an IDEA original instrumentation mechanism, acquiring corresponding SQL sentences after checking keywords, judging risks according to the grammars, prompting if the risks exist, modifying the translation module for simple errors, intercepting a custom annotation mode generated by mybatis by using an internal interconnector, acquiring parameters, and re-assembling the corresponding parameters.

3. And scanning the code segment of the current active window by the custom instrumentation (1), and realizing intelligent error correction (2) according to the custom rule.

4. The JAVA-based language acquires SQL translation capability (3) and is characterized in that the translation capability is realized by custom JAVA class (4) through realizing an intersector interface.

5. The patent is developed according to claims 1 and 2 as a plug-in (5) to be put on a plug-in market for downloading by developers.