CN108121542B - MyBatis-based SQL statement configuration method and system - Google Patents

Abstract

A configuration method and a system of SQL statements based on MyBatis comprise a MyBatis framework, a core configuration file, a mapping configuration file and a database, and comprise a process that the MyBatis framework operates the database: step A: introducing a MyBatis framework dependency library and a database driver into a java project; and B: compiling the core configuration file; and C: creating a mapping configuration file, transmitting the SQL sentence serving as a parameter into a MyBatis framework by the mapping configuration file, and performing parameter analysis on the SQL sentence and executing operation on a database by the MyBatis framework; step D: according to different types of databases, SQL sentences are formulated through IDs, the configured SQL sentences are read and executed, and finally results are obtained. The invention solves the problem that when MyBatis is used, multiple complicated configurations are needed when SQL is configured, and realizes the effects of shortening development time, increasing development flexibility and improving development efficiency.

Description

MyBatis-based SQL statement configuration method and system

Technical Field

The invention relates to the technical field of SQL processing of MyBatis frameworks, in particular to a method and a system for configuring an SQL statement based on MyBatis.

Background

MyBatis is a java-based persistent layer framework that supports customized SQL, storage procedures, and advanced mapping. MyBAtis avoids almost all JDBC code and manual setting of parameters and acquisition of result sets. MyBAtis can use simple XML or annotations to configure and map the native information, mapping the interfaces and java's pojs to records in the database.

In the process of using MyBAtis, each time a new SQL statement is used, whether a corresponding mapping file and an entity class corresponding to a data table exist or not needs to be checked, if not, the mapping file and the entity class need to be created, and SQL and related settings are configured in the corresponding file, so that the configuration process is very complicated.

Disclosure of Invention

The invention aims to provide a method and a system for configuring SQL sentences based on MyBatis, which solve the problem that a plurality of complex configurations are required when the SQL is configured when MyBatis is used by using an SQL sentence parameter analysis function of the MyBatis, and achieve the effects of shortening development time, increasing development flexibility and improving development efficiency.

In order to achieve the purpose, the invention adopts the following technical scheme:

a configuration method of SQL statements based on MyBatis comprises a MyBatis framework, a core configuration file, a mapping configuration file and a database, and comprises the process that the MyBatis framework operates the database:

step A: introducing the MyBatis framework dependency library and the drive of the database into a java project;

and B: writing the core configuration file;

and C: creating the mapping configuration file, wherein the mapping configuration file transmits SQL sentences serving as parameters into the MyBatis framework, and the MyBatis framework performs parameter analysis on the SQL sentences and executes operation on the database;

step D: and formulating SQL sentences through IDs according to the databases of different types, reading the configured SQL sentences and executing the sentences, and finally obtaining results.

Preferably, the method comprises the parsing process of the MyBatis framework on the SQL statement:

step C1: the mapping configuration file transmits SQL sentences serving as parameters into the MyBatis framework;

step C2: the MyBatis framework judges the SQL sentence transmitted in and judges the type of the SQL sentence;

step C3: if the type of the SQL statement as the parameter is the query type, returning a list, wherein each element on the list is a map object; if the type of the SQL statement as the parameter is the modification type, directly returning the number of the affected records.

Preferably, the core configuration file is an XML file for configuring global information, and includes a user name, a password, a link of the database, and drive information selected by the database.

Preferably, the mapping configuration file is an XML file configuring the ORM mapping relationship and the SQL statement.

A system of a MyBatis-based SQL statement configuration method comprises a MyBatis framework, a core configuration file, a mapping configuration file and a database, wherein the MyBatis framework is used for carrying out a database operation module for configuring the database;

introducing the MyBatis framework dependency library and the drive of the database into a java project;

writing the core configuration file;

creating the mapping configuration file, wherein the mapping configuration file transmits SQL sentences serving as parameters into the MyBatis framework, and the MyBatis framework performs parameter analysis on the SQL sentences and executes operation on the database;

and formulating SQL sentences through IDs according to the databases of different types, reading the configured SQL sentences and executing the sentences, and finally obtaining results.

Preferably, the system comprises an analysis module of the mybatis framework for the SQL statement, and the analysis module is used for analyzing the SQL statement;

the mapping configuration file transmits SQL sentences serving as parameters into the MyBatis framework;

the MyBatis framework judges the SQL sentence transmitted in and judges the type of the SQL sentence;

if the type of the SQL statement as the parameter is the query type, returning a list, wherein each element on the list is a map object; if the type of the SQL statement as the parameter is the modification type, directly returning the number of the affected records.

Compared with the prior art, the method reduces the steps of establishing the class object corresponding to the database table structure to realize the ORM mapping, and also has the mapping file configuration different from the prior art, wherein the configuration mapping file generally corresponds to one table (or class object) and one file. In which SQL statements and other related settings that need to be executed are configured. In the process of using MyBatis, each time a new SQL statement is used, whether an entity class corresponding to a corresponding mapping file and a corresponding data table exists or not needs to be checked, and if the entity class does not exist, the entity class needs to be created. At present, multiple configurations are not needed, SQL sentences are input into the MyBatis framework as parameters, the parameter analysis function of the MyBatis framework is utilized to automatically select and configure, development time is shortened, development efficiency is improved, the trouble of configuring entity classes is avoided, the entity classes do not need to be modified when a data table structure is adjusted, and flexibility is provided for project maintenance.

Drawings

FIG. 1 is a flow chart of the operation of the MyBatis framework database of the present invention;

FIG. 2 is a flow chart of the present invention for parsing SQL statement by the MyBatis framework.

Wherein: MyBatis framework 1, core configuration file 2, mapping configuration file 3 and database 4.

Detailed Description

The technical scheme of the invention is further explained by the specific implementation mode in combination with the attached drawings.

A configuration method of a MyBatis-based SQL statement, includes a MyBatis framework 1, a core configuration file 2, a mapping configuration file 3, and a database 4, and includes a process of the MyBatis framework 1 operating the database 4, as shown in fig. 1:

step A: introducing the MyBatis framework 1 dependency library and the drive of the database 4 into a java project;

and B: writing the core configuration file 2;

and C: creating the mapping configuration file 3, wherein the mapping configuration file 3 transmits SQL statements serving as parameters into the MyBatis framework 1, and the MyBatis framework 1 performs parameter analysis on the SQL statements and executes operation on the database 4;

step D: according to the databases 4 of different types, SQL sentences are formulated through IDs, the configured SQL sentences are read and executed, and finally results are obtained.

Preferably, as shown in fig. 2, the method includes a parsing process of the MyBatis framework 1 on the SQL statement:

step C1: the mapping configuration file 3 transmits SQL sentences serving as parameters into the MyBatis framework 1;

step C2: the MyBatis framework 1 judges the transmitted SQL statement and judges the type of the SQL statement;

step C3: if the type of the SQL statement as the parameter is the query type, returning a list, wherein each element on the list is a map object; if the type of the SQL statement as the parameter is the modification type, directly returning the number of the affected records.

Preferably, the core configuration file 2 is an XML file configured with global information, and includes a user name, a password, a link of the database, and drive information selected by the database.

Preferably, the mapping configuration file 3 is an XML file for configuring the ORM mapping relationship and the SQL statement.

A system of a MyBatis-based SQL statement configuration method comprises a MyBatis framework 1, a core configuration file 2, a mapping configuration file 3 and a database 4, wherein the MyBatis framework 1 is used for carrying out an operation module of the database 4 and is used for configuring the database 4;

introducing the MyBatis framework 1 dependency library and the drive of the database 4 into a java project;

writing the core configuration file 2;

creating the mapping configuration file 3, wherein the mapping configuration file 3 transmits SQL statements serving as parameters into the MyBatis framework 1, and the MyBatis framework 1 performs parameter analysis on the SQL statements and executes operation on the database 4;

according to the databases 4 of different types, SQL sentences are formulated through IDs, the configured SQL sentences are read and executed, and finally results are obtained.

Preferably, the system comprises an analysis module of the mybatis framework 1 for the SQL statement, and the analysis module is used for analyzing the SQL statement;

the mapping configuration file 3 transmits SQL sentences serving as parameters into the MyBatis framework 1;

the MyBatis framework 1 judges the transmitted SQL statement and judges the type of the SQL statement;

if the type of the SQL statement as the parameter is the query type, returning a list, wherein each element on the list is a map object; if the type of the SQL statement as the parameter is the modification type, directly returning the number of the affected records.

The technical principle of the present invention is described above in connection with specific embodiments. The description is made for the purpose of illustrating the principles of the invention and should not be construed in any way as limiting the scope of the invention. Based on the explanations herein, those skilled in the art will be able to conceive of other embodiments of the present invention without inventive effort, which would fall within the scope of the present invention.

Claims (2)

1. A configuration method of SQL sentences based on MyBatis, the method is executed by a configuration system of SQL sentences based on MyBatis, the system includes MyBatis frame, core configuration file, mapping configuration file and database, characterized in that: the core configuration file is an XML file for configuring global information and comprises a user name, a password and a link of a database and drive information selected by the database;

the MyBatis framework is used for operating the database, and the method comprises the following steps:

step A: introducing a MyBatis framework dependency library and a driver of the database into a java project;

and B: writing the core configuration file;

and C: creating the mapping configuration file, wherein the mapping configuration file transmits SQL sentences serving as parameters into the MyBatis framework, and the MyBatis framework judges the transmitted SQL sentences and judges the type of the SQL sentences;

if the type of the SQL statement as the parameter is the query type, returning a list, wherein each element on the list is a map object; if the type of the SQL statement as the parameter is a modification type, directly returning the number of the influenced records;

step D: and formulating SQL sentences through IDs according to the databases of different types, reading the configured SQL sentences and executing the sentences, and finally obtaining results.

2. The method of claim 1, wherein the method comprises the following steps:

the mapping configuration file is an XML file for configuring an ORM mapping relation and an SQL statement.

Images