Ibatis-based SQL script dynamic loading method

Abstract

The invention discloses an ibatis-based SQL script dynamic loading method. The method comprises the following steps of: a) configuring multiple independent SQL configuration files, and uniformly setting the cache regions of all the SQL configuration files; b) when a script calling party searches the SQL information, firstly, reading the SQL configuration information from the cache region, if the SQL script configuration information exists, starting a program to automatically load the corresponding SQL configuration file to the cache region, otherwise, searching the SQL configuration and updating the cache region; c) removing the file information from the SQL configuration file after loading; d) finally, reading corresponding SQL script information from the cache region, and returning the read SQL script information to the calling party. In the ibatis-based SQL script dynamic loading method provided by the invention, multiple independent SQL configuration files are configured and corresponding configuration files are loaded as needed, thus, a master control SQL configuration file is saved, which is easy for management and realizing modularized development, and improves system performance.

Description

technical field [0001] The invention relates to a method for dynamically loading SQL scripts, in particular to a method for dynamically loading SQL scripts based on ibatis. Background technique [0002] At present, the database access methods in the Java field are widely used, mainly hibernate and iBATIS, both of which are open source software. The word iBATIS comes from the combination of "internet" and "abatis", and is an open source project initiated by Clinton Begin in 2001. Initially focused on the development of cryptographic software, it is now a Java-based persistence layer framework. The persistence layer framework provided by iBATIS includes SQL Maps and Data Access Objects (DAO), and also provides a JPetStore instance developed using this framework. Compared with "one-stop" ORM solutions such as Hibernate and Apache OJB, ibatis is a "semi-automated" ORM implementation. The so-called "semi-automated" refers to the "full-automatic" ORM implementation that provide...

AI Technical Summary

Problems solved by technology

[0004] (1) There must be only one sqlmapConfig configuration file, which configures all sqlmap files that need to access the database, and there is a conflict between centralized management and modular development;

[0005] (2) During project development, multiple people jointly maintain this sqlmapConfig file, and code submission is likely to cause conflicts;

[0007] (4) Different databases cannot be automatically identified, and the sqlmap file corresponding to the database type is loaded

Images