SQL lightweight persistent layer framework and configuration method

Abstract

The invention discloses an SQL lightweight persistent layer framework and a configuration method. The SQL lightweight persistent layer framework comprises a database initialization module, a request receiving module, an object analysis module, an object construction module and a result return module. The configuration method comprises the steps of loading database configuration and initializing adatabase connection pool; receiving a called service request, wherein the request comprises an SQL object resource code; analyzing an SQL service object according to the SQL object resource code; constructing an SQL execution object capable of responding to the service result according to the SQL service object; and returning a processing result according to the executable SQL object. Entity classes corresponding to the database tables do not need to be compiled any more in service logic implementation; after the program is published, the name of the field of the database table is modified, the SQL in the XML configuration file is directly modified without compiling the program again for publishing, the troubles of program modification, editing and re-publishing caused by database table modification are solved, and the maintainability is improved.

Description

technical field [0001] The invention relates to an interaction technology between JAVA application software and a database, in particular to an SQL lightweight persistence layer framework and a configuration method. Background technique [0002] Database access technology has always been the most commonly used technology in the field of application software. It is a middleware technology between business and data. Its framework is large and small, including open source community framework, personal contribution framework, commercial application software, etc. Its purpose is to realize the mutual relationship mapping between the memory model and the database table relational model , encapsulating the unchanging parts that are not strongly related to the actual business, avoiding the huge amount of development brought about by developers directly using JDBC code to access the database, and directly realizing the access and storage of business data with the database through it....

AI Technical Summary

Problems solved by technology

Every time an entity class is added and modified, the code is cumbersome and repetitive, which consumes a lot of time and cost for developers

[0005] 2. After the program is released, simply modify the database table, the program must modify the entity class information, and then recompile and release

If the name of the database table field is modified after the program is released, the attribute of the entity class must be modified, and then recompiled and released, resulting in poor maintainability

Images