Database access method and device

Abstract

The invention discloses a database access method and device, and relates to the technical field of computers. The method is applied to a database access device adopting a front-end and rear-end separated micro-service architecture, and comprises the following steps: after receiving a database access request of a front-end page, packaging page data carried by the request into a first entity object,and transmitting the first entity object to a service layer; analyzing the first entity object, and dynamically generating an SQL statement according to an analysis result; packaging the SQL statement into a second entity object, and transmitting the second entity object to a data persistence layer; and analyzing the SQL statement from the second entity object and executing the SQL statement to realize access to a database. Through the above steps, the SQL can be dynamically generated in the memory based on the page request, the SQL statement is completely decoupled from the back-end configuration file, and the server restarting frequency caused by demand change is effectively reduced.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a database access method and device. Background technique [0002] At present, the development of business systems in various fields requires access to databases. A more common scenario is that users access the database through the front-end page. For example, the user performs query, update, delete or add operations on data in the database based on the data items on the front-end page. [0003] The existing technical scheme for database access is: the developer writes the SQL statement in advance according to the data item of the front-end page, and saves the SQL statement in the configuration file of the persistence layer framework (such as Mybatis); After the access request, use the SQL statement in the configuration file of the persistence layer framework to realize the access operation to the database table. [0004] In the process of realizing the present invention, th...

AI Technical Summary

Problems solved by technology

[0004] In the process of realizing the present invention, the inventor found that there are at least the following problems in the prior art: in the existing technical solution for database access, the front-end page data items and the SQL in the persistence layer framework configuration file have not been decoupled. Or when product personnel put forward new requirements and need to add query conditions or query results, the developers need to modify the SQL statements in the front-end page and the configuration file at the same time, the development workload is huge, and the development efficiency is low; moreover, the existing database access In the technical solution, after each modification of the SQL statement in the backend configuration file, the backend server needs to be restarted to deploy the backend service, which not only brings a lot of inconvenience to system deployment and maintenance, but also easily causes online modification errors, Increase project development, testing, and maintenance costs

Images