Configuration method and system based on SQL sentences of MyBatis

Abstract

The invention discloses a configuration method and system based on SQL sentences of Mybatis. The system includes a MyBatis framework, a core configuration file, a mapping configuration file and a database. The method includes a process that the MyBatis framework operates the database. The process includes the steps of introducing a MyBatis framework dependence base and a drive of the database in ajava project; programming the core configuration file; creating the mapping configuration file, wherein the mapping configuration file adopts the SQL sentences as parameters to be transmitted into the MyBatis framework, and the MyBatis framework carries out parameter parsing on the SQL sentences and executes an operation on the database; according to different types of databases, creating different SQL sentences through IDs, reading and executing the configured SQL sentences, and obtaining a result at last. The method and system solve the problem that during application of the MyBatis, complex configuration needs to be carried out in multiple parts when SQL is configured. The effects of shortening the development time and improving development flexibility and development efficiency are achieved.

Description

technical field [0001] The invention relates to the technical field of SQL processing of the MyBatis framework, in particular to a configuration method and a system of SQL statements based on MyBatis. Background technique [0002] MyBatis is a Java-based persistence layer framework that supports custom SQL, storage procedures, and advanced mapping. MyBAtis avoids almost all JDBC code and manually setting parameters and getting result sets. MyBAtis can use simple XML or annotations to configure and map native information, and map interfaces and Java POJOs to records in the database. [0003] In the process of using MyBAtis, every time you use a new SQL statement, you need to check whether there is a corresponding mapping file and the entity class corresponding to the data table. If not, you need to create it, and configure SQL and Related settings, the configuration process is very cumbersome. Contents of the invention [0004] The purpose of the present invention is to ...

AI Technical Summary

Problems solved by technology

[0004] The purpose of the present invention is to propose a configuration method and system for SQL statements based on MyBatis, use the SQL statement parameter analysis function of MyBatis to solve the problem of multiple cumbersome configurations when configuring SQL when using MyBatis, and realize shortened development Time, the effect of increasing development flexibility and improving development efficiency

Images