Method and apparatus for accessing database

Abstract

This invention discloses a kind of database access method and apparatus. The method comprises the following steps: a) creating the description file of database system connection parameter; b) creating the description file of database system access operation; c) reading the description file of database system connection parameter, initializing database connection pool; d) reading the description file of database system access operation, initializing database access operation object; e) acquiring database access operation object according to the database access claim; acquiring effective connection from the database connection pool; accessing database and returning result. The said apparatus comprises description module, analysis module and process module. By describing the connection parameter of database access and parameter of data access operation, this invention can reduce redundancy code, and increase system operation efficiency.

Description

technical field [0001] The present invention relates to data processing technology, more specifically to a method and device for realizing database access. Background technique [0002] With the development of society, a large amount of data needs to be stored. For the stored data, certain data processing methods can be applied according to the needs of different users. The database is a technology that meets this demand. Simply put, the database is Data is a collection of data stored in a way that can be persisted and manipulated. A database system consists of a database and its surrounding environment, including software, operating system, hardware, and users who use it. In order to enable the user to access the database, if the user needs to perform operations such as query, addition, deletion, and modification on the data in the database, the prior art implements database access through the following methods: first determine the connection parameters of the correspondin...

AI Technical Summary

Problems solved by technology

[0004] 1. There are a lot of redundant codes when accessing the database, occupying system resources, making the system run slowly and inefficient

Since accessing the database is implemented according to the process of obtaining the database connection, encapsulating SQL, executing SQL and returning the access result, when the parameters of the access operation of accessing the database change, it needs to be recoded, which will generate a lot of redundant code. Occupy system resources and reduce system operation efficiency;

[0005] 2. Accessing the database is inflexible and insecure

In the prior art, once the connection parameters of the database system are selected, they cannot be changed easily. For the high-level application system of database access, if the database user name and password parameters are defined as constants, then the users of the high-level application system all use the same user name and password. It is not safe, and if it is defined as a variable, the user must provide a user name and password every time it is used, which is very inflexible

[0006] 3. The database system developed by the existing technology is not easy to expand, which is not conducive to expanding new applications in the future

Since the future database development is mostly realized by applying object-oriented and layered technology, while the existing technology implements database access, high-level applications need to participate in the resource (database connection) scheduling of the persistence layer (database) (this should actually be done by the access Layer implementation), the high-level layer and the persistence layer are not transparent, the scalability is not good, and the development efficiency is low

Images