CN107622070A - A kind of data base management method and device - Google Patents

Abstract

The invention discloses a kind of data base management method and device, this method includes：Defining database includes the action statement of increase, deletion, modification, lookup and storage；Action statement defined in foundation and correspondence database API mapping relations；The action statement is split as multiple parameters and database manipulation type according to the mapping relations；The value of multiple parameters is inputted respectively, and database API is called according to the value of the parameter and the database manipulation type.The invention has the beneficial effect that：By redefining data base manipulation statement and it being split, the efficiency that database writes program is improved.

Description

A database management method and device

technical field

The invention relates to the technical field of database management, in particular to a database management method and device.

Background technique

Usually, the operation of the database is to query or update the data in the database by calling the API (application programming interface) provided by the computer language to operate the database. Existing schemes for operating databases usually call APIs provided by computer languages for accessing databases to query or update databases and return results. Therefore, the existing scheme of calling the database API cannot reuse the code for operating the database. If it is a compiled language, it is inconvenient to debug the code. Every time the code is changed, the code must be recompiled, and the development efficiency is not high.

Contents of the invention

The technical problem to be solved by the present invention is to provide a database management method and device for the above-mentioned problem of low efficiency of database API calling in the prior art.

The technical solution adopted by the present invention to solve its technical problems is:

On the one hand, construct a database management method, including:

Define the operation statement including adding, deleting, modifying, searching and storing in the database;

Establish the mapping relationship between the defined operation statement and the corresponding database API;

Splitting the operation statement into multiple parameters and database operation types according to the mapping relationship;

Input multiple values of the parameters respectively, and call the database API according to the values of the parameters and the type of the database operation.

In the database management method of the present invention, the step of establishing the mapping relationship between the defined operation statement and the corresponding database API includes the following sub-steps:

Establish the mapping relationship between the defined operation statement and the corresponding database API;

Acquiring scripts corresponding to database management task items according to the mapping relationship;

The script is executed against the database to dynamically manipulate the database.

In the database management method of the present invention, the step of splitting the operation statement into multiple parameters and database operation types according to the mapping relationship includes the following sub-steps:

splitting the character string to be parsed according to the mapping relationship, so as to obtain an array of database operation statements;

The database operation statement array is traversed to split the operation statement into a plurality of parameters and database operation types.

In the database management method of the present invention, the step of inputting a plurality of values of the parameters respectively, and calling the database API according to the values of the parameters and the database operation type also includes:

Call the database API to query the database, and store the result returned by the database into a variable.

In the database management method of the present invention, the step of traversing the database operation statement array to split the operation statement into multiple parameters and database operation types includes the following steps:

S321. Detect whether there is an unprocessed operation statement, and if so, remove the next operation statement, wherein the database operation statement array includes a plurality of operation statements;

S322. Split the operation statement into multiple parameters and database operation types, and return to step S321 until the processing of multiple operation statements is completed.

In another aspect, a database management device is provided, including:

The definition unit is used to define the operation statements including adding, deleting, modifying, searching and storing in the database;

A mapping establishment unit, configured to establish a mapping relationship between the defined operation statement and the corresponding database API;

A splitting unit, configured to split the operation statement into multiple parameters and database operation types according to the mapping relationship;

The calling unit is used to respectively input the values of a plurality of parameters, and call the database API according to the values of the parameters and the type of the database operation.

In the database management device of the present invention, the mapping establishment unit includes:

A mapping establishment module, used to establish the mapping relationship between the defined operation statement and the corresponding database API;

A script acquiring module, configured to acquire scripts corresponding to database management task items according to the mapping relationship;

The script execution module is used to execute the script on the database to dynamically operate the database.

In the database management device of the present invention, the splitting unit includes:

A string splitting module, configured to split the character string to be parsed according to the mapping relationship, so as to obtain an array of database operation statements;

The array traversal module is used for traversing the database operation statement array to split the operation statement into multiple parameters and database operation types.

In the database management device according to the present invention, the calling unit is also used for:

Call the database API to query the database, and store the result returned by the database into a variable.

In the database management device of the present invention, the array traversal module includes:

The statement detection submodule is used to detect whether there is an unprocessed operation statement, and if it exists, then take the next operation statement, wherein the database operation statement array includes a plurality of operation statements;

The split sub-module is used to split the operation statement into multiple parameters and database operation types.

The database management method and device disclosed above have the following beneficial effects: by redefining database operation statements and splitting them, the efficiency of database programming is improved.

Description of drawings

Fig. 1 is a kind of database management method flowchart provided by the present invention;

Fig. 2 is a block diagram of a database management device provided by the present invention.

detailed description

In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

The invention provides a database management method and device. The purpose is to improve the efficiency of database programming by redefining database operation sentences and splitting them. The present invention specifically includes two parts, one part is a database operation statement, which is used to write dynamic statements for operating the database; the second part is an analysis engine, which parses the database operation statement, calls the database API, and returns the result.

Referring to Fig. 1, Fig. 1 is a flow chart of a database management method provided by the present invention, the database management method includes steps S1-S4:

S1. The definition database includes operation statements for adding, deleting, modifying, searching and storing; specifically, the defined operation statements are as follows:

1. GetData(tableName, columnNames, filterCondition, recordCount, resultVarName),

Query data from the database.

Parameter description: tableName: database table name. columnNames: A list of database fields. filterCondition: The filter condition of the query. recordCount: Set the number of records returned. resultVarName: The name of the variable that stores the database query results.

2. InsertData(tableName, idFieldName, idVarName, idType, fieldAndValueStr, resultVarName), insert data into the database.

Parameter description: tableName: database table name, idFieldName: primary key field name. idVarName: Primary key variable name, used to save the primary key value. idType: How the primary key value is generated. fieldAndValueStr: A string that combines the field and its corresponding value. resultVarName: The name of the variable that holds the insertion result.

3. UpdateData(tableName, fieldAndValueStr, updateCondition, resultVarName), change the database.

Parameter description: tableName: the name of the database table, fieldAndValueStr: the string that combines the field and the corresponding value. updateCondition: Change condition. resultVarName: The name of the variable that holds the result of the change.

4. DeleteData(tableName, deleteCondition, resultVarName), delete the data in the database.

Parameter description: tableName: database table name, deleteCondition: delete condition. resultVarName: The variable name to save the delete result.

5. ExecuteSql (outputVarType, outputVarName, sqlType, spNameOrSql, spOrSqlPara, resultVarName), execute SQL statement or stored procedure.

Parameter description: outputVarType: the variable type that stores the execution results of SQL statements or stored procedures. outputVarName: the name of the variable that stores the execution result of the SQL statement or stored procedure. sqlType: type, SQL or stored procedure. spNameOrSql: Stored procedure name or SQL statement. spOrSqlPara: The parameters of the stored procedure or SQL statement. resultVarName: The name of the variable that saves whether the execution is successful.

S2. Establish the mapping relationship between the defined operation statement and the corresponding database API; the step S2 includes substeps S21-S23:

S21. Establish a mapping relationship between the defined operation statement and the corresponding database API;

S22. Acquire scripts corresponding to database management task items according to the mapping relationship;

S23. Execute the script on the database to dynamically operate the database.

S3. Split the operation statement into multiple parameters and database operation types according to the mapping relationship; the step S3 includes substeps S31-S32:

S31. Split the character string to be parsed according to the mapping relationship, so as to obtain an array of database operation statements;

S32. Traverse the database operation statement array to split the operation statement into multiple parameters and database operation types. The step S32 includes sub-steps S321-S322:

S321. Detect whether there is an unprocessed operation statement, and if so, remove the next operation statement, wherein the database operation statement array includes a plurality of operation statements;

S322. Split the operation statement into multiple parameters and database operation types, and return to step S321 until the processing of multiple operation statements is completed.

S4. Input a plurality of values of the parameters respectively, and call the database API according to the values of the parameters and the type of the database operation. Call the database API to query the database, and store the result returned by the database into a variable. According to the type of database operation, such as InsertData or GetData, and the value of the parameter input by the user, call the corresponding database API, and use the returned result as the variable value.

In summary, the present invention first reads a character string that contains a dynamic database statement, splits the character string to obtain one or more database operation statements, processes each database operation statement in turn, and splits the database operation statement into one Database operation type and multiple parameters, and then call the API provided by the computer language to access the database and return the result.

Referring to Fig. 2, Fig. 2 is a block diagram of a database management device 100 provided by the present invention, the database management device 100 is implemented by setting corresponding programs in the system, the database management device 100 includes a definition unit 1, a mapping establishment unit 2, a demolition unit Sub-unit 3 and calling unit 4.

The definition unit 1 is used to define operation statements including addition, deletion, modification, search and storage in the database;

The mapping establishment unit 2 is used to establish the mapping relationship between the defined operation statement and the corresponding database API;

The splitting unit 3 is used to split the operation statement into multiple parameters and database operation types according to the mapping relationship;

The calling unit 4 is used to respectively input a plurality of values of the parameters, and call the database API according to the values of the parameters and the type of the database operation.

Preferably, the mapping establishment unit 2 includes:

A mapping establishment module, used to establish the mapping relationship between the defined operation statement and the corresponding database API;

A script acquiring module, configured to acquire scripts corresponding to database management task items according to the mapping relationship;

The script execution module is used to execute the script on the database to dynamically operate the database.

Preferably, the splitting unit 3 includes:

A string splitting module, configured to split the character string to be parsed according to the mapping relationship, so as to obtain an array of database operation statements;

The array traversal module is used for traversing the database operation statement array to split the operation statement into multiple parameters and database operation types.

Preferably, the calling unit 4 is also used for:

Call the database API to query the database, and store the result returned by the database into a variable.

Preferably, the array traversal module includes:

The statement detection submodule is used to detect whether there is an unprocessed operation statement, and if it exists, then take the next operation statement, wherein the database operation statement array includes a plurality of operation statements;

The split sub-module is used to split the operation statement into multiple parameters and database operation types.

Various operations of embodiments are provided herein. In one embodiment, the one or operations described may constitute one or computer-readable instructions stored on a computer-readable medium which, when executed by an electronic device, will cause the computing device to perform the operations described. The order in which some or all operations are described should not be construed to imply that these operations are necessarily order-dependent. Alternative orderings will be appreciated by those skilled in the art with the benefit of this description. Also, it should be understood that not all operations need to be present in every embodiment provided herein.

Also, the word "preferred" as used herein means serving as an example, instance or illustration. Any aspect or design described herein as "preferred" is not necessarily to be construed as advantageous over other aspects or designs. Rather, use of the word "preferably" is intended to present concepts in a concrete manner. As used in this application, the term "or" is intended to mean an inclusive "or" rather than an exclusive "or". That is, unless otherwise specified or clear from context, "X employs A or B" is meant to naturally include either of the permutations. That is, if X employs A; X employs B; or X employs both A and B, then "X employs A or B" is satisfied in any of the foregoing instances.

Moreover, although the disclosure has been shown and described with respect to one or an implementation, equivalent alterations and modifications will occur to others skilled in the art upon the reading and understanding of this specification and the annexed drawings. The present disclosure includes all such modifications and variations and is limited only by the scope of the appended claims. With particular regard to the various functions performed by the above-described components (eg, elements, resources, etc.), terminology used to describe such components is intended to correspond to Any component (unless otherwise indicated), even if not structurally equivalent to the disclosed structure that performs the function in the exemplary implementations of the present disclosure shown herein. Furthermore, although a particular feature of the present disclosure has been disclosed with respect to only one of several implementations, such feature may be combined with one or other features of other implementations as may be desirable and advantageous for a given or particular application. combination. Moreover, to the extent the terms "comprises", "has", "comprising" or variations thereof are used in the detailed description or the claims, such terms are intended to be encompassed in a manner similar to the term "comprising".

Each functional unit in the embodiment of the present invention may be integrated into one processing module, or each unit may physically exist separately, or two or more units may be integrated into one module. The above-mentioned integrated modules can be implemented in the form of hardware or in the form of software function modules. If the integrated modules are realized in the form of software function modules and sold or used as independent products, they can also be stored in a computer-readable storage medium. The storage medium mentioned above may be a read-only memory, a magnetic disk or an optical disk, and the like. Each of the above devices or systems may execute the storage method in the corresponding method embodiment.

In summary, although the present invention has been disclosed above with preferred embodiments, the above preferred embodiments are not intended to limit the present invention, and those of ordinary skill in the art can make various modifications without departing from the spirit and scope of the present invention. Therefore, the protection scope of the present invention shall be determined by the scope defined in the claims.

Claims (10)

1. A kind of 1. data base management method, it is characterised in that including：

   Defining database includes the action statement of increase, deletion, modification, lookup and storage；

   Action statement defined in foundation and correspondence database API mapping relations；

   The action statement is split as multiple parameters and database manipulation type according to the mapping relations；

   The value of multiple parameters is inputted respectively, and database is called according to the value of the parameter and the database manipulation type API。
2. 2. data base management method according to claim 1, it is characterised in that action statement defined in the foundation with The step of correspondence database API mapping relations, includes following sub-step：

   Action statement defined in foundation and correspondence database API mapping relations；

   According to the mapping relations, the script corresponding with database management tasks item is obtained；

   The script is performed to the database with dynamic operation database.
3. 3. data base management method according to claim 1, it is characterised in that described according to described in mapping relations general Action statement, which is split as the step of multiple parameters and database manipulation type, includes following sub-step：

   The character string to be parsed is split according to the mapping relations, so as to obtain data base manipulation statement array；

   The data base manipulation statement array is traveled through so that the action statement is split as into multiple parameters and database manipulation type.
4. 4. data base management method according to claim 1, it is characterised in that described to input multiple parameters respectively Value, also include according to the step of value of the parameter and database manipulation type calling database API：

   Database API inquiry databases are called, and database returning result is deposited to a variable.
5. 5. data base management method according to claim 3, it is characterised in that the traversal data base manipulation statement Array the step of the action statement is split as into multiple parameters and database manipulation type to comprise the following steps：

   S321, detect whether untreated action statement be present, if in the presence of, next action statement is taken, wherein, the data Storehouse action statement array includes multiple action statement；

   S322, the action statement is split as to multiple parameters and database manipulation type, return to step S321, until multiple institutes Action statement processing is stated to complete.
6. A kind of 6. data bank management device, it is characterised in that including：

   Definition unit, include increase, the action statement for deleting, changing, search and storing for defining database；

   Unit is established in mapping, for establishing defined action statement and correspondence database API mapping relations；

   Split cells, for the action statement to be split as into multiple parameters and database manipulation class according to the mapping relations Type；

   Call unit, for inputting the value of multiple parameters respectively, value and the database manipulation according to the parameter Type calls database API.
7. 7. data bank management device according to claim 6, it is characterised in that unit is established in the mapping to be included：

   Module is established in mapping, for establishing defined action statement and correspondence database API mapping relations；

   Script acquisition module, for according to the mapping relations, obtaining the script corresponding with database management tasks item；

   Script execution module, for performing the script to the database with dynamic operation database.
8. 8. data bank management device according to claim 6, it is characterised in that the split cells includes：

   Character string splits module, for splitting the character string to be parsed according to the mapping relations, so as to obtain database behaviour Make sentence array；

   Array spider module, for traveling through the data base manipulation statement array so that the action statement is split as into multiple parameters And database manipulation type.
9. 9. data bank management device according to claim 6, it is characterised in that the call unit is additionally operable to：

   Database API inquiry databases are called, and database returning result is deposited to a variable.
10. 10. data bank management device according to claim 8, it is characterised in that the array spider module includes：

    Sentence detection sub-module, for detecting whether untreated action statement be present, if in the presence of taking next operation language Sentence, wherein, the data base manipulation statement array includes multiple action statement；

    Submodule is split, for the action statement to be split as into multiple parameters and database manipulation type.