Database operation method and device

Abstract

The invention provides a database operation method and device. The method comprises the following steps of: carrying out hypostatization processing on a database and converting into entity objects; generating a core Base DB type by using an operation method of packaging various entity objects; and operating the entity objects to execute corresponding database operation through calling the core Base DB type. Through the operation method of hypostatizing the database and packaging the entity objects, the entity objects are operated through packaging a core base, thus database operation is more transparent, and a programmer pays more attention to processing of data entity objects and service logic but not the problem of a database structure; the operation channels of the database is unified,and the reusability, the safety and the stability of the program are improved; after the environment of the database is changed, modifying connection parameters of the entire database searched by a software project is not needed, and all database operation can be modified by only modifying one code segment, thus, code maintenance and database function expansion are convenient.

Description

technical field [0001] The invention relates to the technical field of computer databases, in particular to a database operation method and device. Background technique [0002] Database (Database, DB) is a warehouse that organizes, stores and manages data according to the data structure. With the development of information technology and market, data management is no longer just storing and managing data, but has transformed into various data management methods required by users. [0003] With the widespread application of application development methods based on C / S (client / server architecture) and B / S (browser / server architecture), database operations have occupied more development cycles in technology development. The database operation during development has directly affected the performance, security and stability of the system. [0004] Such as figure 1 As shown, usually the operation steps of the database in application development are: [0005] 101. Directly ref...

AI Technical Summary

Problems solved by technology

[0011] 1) Programmers need to be familiar with and understand the complex ADO architecture, class structure, objects and methods. If programmers are not familiar with it, they will not be able to develop database-related programs;

[0012] 2) When developing database functions, most of the steps of operating the database are repeated, the code reusability is poor, and the code written is highly repetitive;

[0013] 3) When using ADO to operate the database, if you need to splice SQL statements, the code is difficult to maintain when the complexity of the statement is high, or you can only rely on writing views or stored procedures;

[0014] 4) A page can only allow one recordset (Recordset) to remain open;

[0015] 5) Programmers pay too much attention to the development of ADO and disperse the thinking of business logic;

[0016] 6) During the development process, it is easy to ignore the closing of the record set and the closing of the connection, and relying on the system to recycle resources will reduce system performance;

[0017] 7) The lengthy connection string has rules but it is difficult to memorize the splicing. The connection string is generally used only once in a project, and it is difficult to remember it if it is not commonly used. In practical applications, it is noticed that most programmers use the connection string in the search on the web;

[0018] 8) It is difficult to track all the executed database operation statements, because the executed database operations are spread all over the code segment of the project;

[0019] 9) It is difficult to manage database connection resources;

[0020] 10) The fault tolerance performance is poor, and the exceptions thrown by database operations are generally caused by coding habits, code styles, algorithms, and coding experience

Images