Cross-database access method and abstract data access method based on dynamic proxy

Abstract

The invention provides a cross-database access method and an abstract data access method based on a dynamic proxy. The cross-database access method based on the dynamic proxy includes: defining and configuring a plurality of data sources to form an abstract data source, and configuring the plurality of data sources through the abstract data source proxy; in the service that needs to access the database, annotating the alias of the database that the service needs to access before the service class name by the service annotation; when executing data access, the dynamic proxy intercepting the service method of accessing the database, obtaining the database alias injected into the object in the service annotation mode, and obtaining the database connection parameter from the configuration information according to the database alias; generating an instance of a database access object corresponding to the data source; obtaining the database access connection and passing the connection to a subsequent invocation method. In the method of the invention, the program does not need hard-coded database connection, and the parameters of the service component are connected with the database and decoupled by the recessive transmission parameter.

Description

technical field [0001] The invention relates to a database access method, in particular to a dynamic agent-based cross-database access method and an abstract data access method. Background technique [0002] In the process of software development, there will be more than one physical database for large-scale and complex projects, especially for real-time Internet services, the database is often divided vertically by business to improve the performance and throughput of the entire system, which must require The WEB platform can achieve effective, convenient and high-performance cross-database access for the same business service function; [0003] Different from the common single data instance solution, cross-database access requires the program to dynamically decide which database instance to store data in and which database to extract data from according to the current request and system status at runtime. Currently, the most commonly used The main scheme is: configure mul...

AI Technical Summary

Problems solved by technology

[0004] 1. The program is hard-coded, and the different data sources used in program development must be together with the specific code and cannot be separated

[0005] 2. It cannot dynamically switch data sources when it is running, and is not suitable for specific business scenarios that require dynamic switching of data sources

[0006] 3. Heterogeneous databases cannot be supported uniformly. For the same business service to access different types of databases, SQL statements cannot be unified. It is difficult for the same SQL statement to uniformly access different types of databases.

Images