CN112015831A - Method, device and equipment for operating relational database based on C language - Google Patents

Abstract

The embodiment of the invention provides a method, a device and equipment for operating a relational database based on C language. The method comprises the following steps: creating a database table of a relational database and a corresponding C language data structure body; determining a mapping structure between the database table and the C language data structure, and adding the mapping structure into the C language data structure; acquiring an operation instruction of a user, and calling a preset operation interface according to the operation instruction; generating an SQL statement according to a Structured Query Language (SQL) grammar rule and the operation instruction through the preset operation interface; and performing corresponding operation processing on the relational database according to the SQL statement. According to the method provided by the embodiment of the invention, the mapping structure body between the database table and the C language data structure body and the preset operation interface are adopted, so that the operation is simplified, and the workload is reduced.

Description

Method, device and device for operating relational database based on C language

technical field

The invention relates to the technical field of databases, in particular to a method, device and device for operating a relational database based on C language.

Background technique

A relational database refers to a database that uses a relational model to organize data, storing data in the form of rows and columns for easy understanding by users. Usually, a Structured Query Language (SQL) is used to perform operations such as adding, deleting, modifying, and querying a relational database.

Taking a small and lightweight SQLite database as an example, any operation on it based on C language needs to be implemented by writing corresponding SQL statements, and even corresponding functions and data structures need to be written for processing and outputting the operation results. This method is not only cumbersome to operate, but also greatly increases the workload of the staff.

Since C language is neither an object-oriented language nor a dynamic language, there is no effective solution to the problems of cumbersome operation and heavy workload in the existing operation method of relational database based on C language.

SUMMARY OF THE INVENTION

Embodiments of the present invention provide a method, device and device for operating a relational database based on C language, so as to solve the problems of complicated operation and heavy workload of the existing operating method of relational database implemented based on C language.

In a first aspect, an embodiment of the present invention provides a method for operating a relational database based on the C language, including:

Create database tables of relational databases and corresponding C language data structures;

Determine the mapping structure between the database table and the C language data structure, and add the mapping structure to the C language data structure;

Obtain the user's operation instruction, and call the preset operation interface according to the operation instruction;

Through the preset operation interface, the SQL statement is generated according to the structured query language SQL grammar rules and the operation instruction;

Corresponding operation processing is performed on the relational database according to the SQL statement.

In an embodiment, the determining the mapping structure between the database table and the C language data structure includes:

Determine the correspondence between the table field in the database table and the member field in the C language data structure;

Calculate the memory address of each member field in the C language data structure according to the preset rule;

storing the correspondence and the memory address in the mapping structure.

In an embodiment, the generating an SQL statement according to the structured query language SQL grammar rules and the operation instruction includes:

Determine the operation type of the SQL statement according to the operation identifier in the operation instruction;

Convert the C language data structure object in the operation instruction into a data object in the database table according to the mapping structure;

Use the data object as a parameter of the SQL statement.

In one embodiment, converting the C language data structure object in the operation instruction into the data object in the database table according to the mapping structure includes:

According to the memory address of each member field in the C language data structure object in the described operation instruction, obtain each member field in the C language data structure object in the described operation instruction;

According to the correspondence between the table fields in the database table and the member fields in the C language data structure, determine the table in the database table corresponding to each member field in the C language data structure object in the operation instruction field;

According to the data type, each data member in the C language data structure object in the operation instruction is converted into table field data in the corresponding database table.

In one embodiment, if the operation indicated by the operation identifier in the operation instruction is an addition operation, a deletion operation or a modification operation, the method further includes returning the operation execution result status;

If the operation indicated by the operation identifier in the operation instruction is a query operation, the method further includes:

Obtain query result data from the relational database according to the generated SQL statement;

The query result data is converted into data in the C language data structure according to the mapping structure.

In an embodiment, converting the query result data into data in the C language data structure according to the mapping structure includes:

According to the correspondence between the table fields in the database table and the member fields in the C language data structure, determine the member fields in the C language data structure corresponding to each table field in the query result data;

Perform numerical conversion according to the data type of each table field and the corresponding member field;

According to the memory address of each member field in the C language data structure, the query result data after the numerical conversion is stored in the corresponding member field.

In one embodiment, before generating the SQL statement according to the structured query language SQL grammar rules and the operation instruction, the method further includes:

Each member of the data structure object of the operation instruction is scanned through the preset operation interface, and whether there is a syntax error in the operation instruction is detected according to a predefined regular expression.

In a second aspect, an embodiment of the present invention provides an apparatus for operating a relational database based on the C language, including:

Create a module for creating database tables and corresponding C language data structures of relational databases;

A determination module, for determining a mapping structure between the database table and the C language data structure, and adding the mapping structure to the C language data structure;

a calling module, used for obtaining the user's operation instruction, and calling the preset operation interface according to the operation instruction;

A generating module, configured to generate an SQL statement according to the structured query language SQL grammar rules and the operation instruction through the preset operation interface;

The processing module is configured to perform corresponding operation processing on the relational database according to the SQL statement.

In a third aspect, an embodiment of the present invention provides an electronic device, including:

at least one processor and memory;

memory stores computer-executed instructions;

The at least one processor executes the computer-executed instructions stored in the memory, so that the at least one processor executes the method for operating a relational database based on the C language according to any one of the first aspects.

In a fourth aspect, an embodiment of the present invention provides a computer-readable storage medium, where computer-executable instructions are stored in the computer-readable storage medium, and when the computer-executable instructions are executed by a processor, are used to implement any one of the first aspect. The method for operating relational database based on C language.

The method, device and device for operating a relational database based on C language provided by the embodiments of the present invention, by creating a database table of a relational database and a corresponding C language data structure; determining the database table and the C language data The mapping structure between the structures, and adding the mapping structure to the C language data structure; obtaining the user's operation instruction; and calling the preset operation interface according to the operation instruction; through the preset operation interface , generate SQL statements according to the structured query language SQL syntax rules and the operation instructions; perform corresponding operation processing on the relational database according to the SQL statements, and realize efficient operations on the relational database based on the C language. Through the mapping structure between the database table and the C language data structure and the preset operation interface, the operation is simplified and the workload is reduced.

Description of drawings

1 is a flowchart of an embodiment of a method for operating a relational database based on C language provided by the present invention;

2 is a flowchart of another embodiment of a method for operating a relational database based on C language provided by the present invention;

3 is a schematic structural diagram of an embodiment of an apparatus for operating a relational database based on C language provided by the present invention;

FIG. 4 is a schematic structural diagram of an embodiment of an electronic device provided by the present invention.

Detailed ways

The present invention will be further described in detail below through specific embodiments in conjunction with the accompanying drawings. Wherein similar elements in different embodiments have used associated similar element numbers. In the following embodiments, many details are described so that the present application can be better understood. However, those skilled in the art will readily recognize that some of the features may be omitted under different circumstances, or may be replaced by other elements, materials, and methods. In some cases, some operations related to the present application are not shown or described in the specification, in order to avoid the core part of the present application from being overwhelmed by excessive description, and for those skilled in the art, these are described in detail. The relevant operations are not necessary, and they can fully understand the relevant operations according to the descriptions in the specification and general technical knowledge in the field.

Additionally, the features, acts, or characteristics described in the specification may be combined in any suitable manner to form various embodiments. At the same time, the steps or actions in the method description can also be exchanged or adjusted in order in a manner obvious to those skilled in the art. Therefore, the various sequences in the specification and drawings are only for the purpose of clearly describing a certain embodiment and are not meant to be a necessary order unless otherwise stated, a certain order must be followed.

The serial numbers themselves, such as "first", "second", etc., for the components herein are only used to distinguish the described objects, and do not have any order or technical meaning. The "connection" and "connection" mentioned in this application, unless otherwise specified, include both direct and indirect connections (connections).

It should be noted that the method for operating a relational database based on the C language provided by the embodiment of the present invention can be applied to any device that needs to operate a relational database, including but not limited to user-side equipment and network-side equipment. Wherein, the user-side device may be, for example, a computer, a smart phone, a tablet computer, a personal digital assistant, etc.; the network-side device may be, for example, a network attached storage (Network Attached Storage, NAS for short) device, a network server, and a large number of cloud-based computing devices. A server group composed of computers or network servers, etc.

FIG. 1 is a flowchart of an embodiment of a method for operating a relational database based on the C language provided by the present invention. As shown in FIG. 1, the method for operating a relational database based on the C language provided by this embodiment may include:

S101. Create a database table of a relational database and a corresponding C language data structure.

In this embodiment, a database table of a relational database and a corresponding C language data structure can be created according to the data to be processed. Specifically, table fields and corresponding data types in the database table may be determined according to the data to be processed; and corresponding C language data structures may be determined according to the table fields and data types in the database table. The following is a concrete example to illustrate:

Taking the SQLite database as an example, you can use the following SQL statement to create a database table, including the data type and name of each database table field:

For the database table created above, the corresponding C language data structure can be determined by the following definitions, including the data type and name of each member field:

S102. Determine a mapping structure between the database table and the C language data structure, and add the mapping structure to the C language data structure.

After the database table and the corresponding C language data structure are created, the mapping structure between the database table and the C language data structure can be determined. The mapping structure between the database table and the C language data structure only maps the fields that need to be operated on the database.

In an optional implementation manner, determining the mapping structure between the database table and the C language data structure may include: determining a table field in the database table and a member in the C language data structure The corresponding relationship between the fields is calculated; the memory address of each member field in the C language data structure is calculated according to a preset rule; the corresponding relationship and the memory address are stored in the mapping structure.

For example, for the example in step S101, the table field `birthday` whose data type is INTEGER in the database table corresponds to the member field birthday whose data type is UInt32 in the C language data structure; The data type and order of the fields determine the memory address. Specifically, through the following field_map_user, reflection can be implemented to establish a relationship between the database table and the C language data structure.

S103: Acquire an operation instruction of the user, and call a preset operation interface according to the operation instruction.

When the method is applied to the user-side device, for example, the user's operation instruction can be obtained through the input device of the user-side device; when the method is applied to the network-side device, the user's operation instruction can be obtained, for example, through the communication module. The operation instruction may include an operation identifier and a C language data structure object. Wherein, the operation identifier may be used to instruct, for example, an addition operation, a deletion operation, a modification operation, or a query operation, and the like.

In this embodiment, some operation interfaces for operating the database, that is, preset operation interfaces, may be implemented in advance based on the C language. The preset operation interface may include, for example, an operation interface for adding data, an operation interface for deleting data, an operation interface for modifying data, an operation interface for querying data, and the like. When the operation identifier in the operation instruction is used to instruct the addition operation, the preset operation interface for adding data is called.

S104. Generate an SQL statement according to the structured query language SQL syntax rules and the operation instruction through the preset operation interface.

In an optional implementation manner, generating the SQL statement according to the structured query language SQL grammar rules and the operation instruction may include: determining the operation type of the SQL statement according to the operation identifier in the operation instruction; The mapping structure converts the C language data structure object in the operation instruction into the data object in the database table; the data object is used as the parameter of the SQL statement.

Wherein, converting the C language data structure object in the operation instruction into the data object in the database table according to the mapping structure may specifically include: according to each member of the C language data structure object in the operation instruction The memory address of the field is obtained, and each member field in the C language data structure object in the operation instruction is obtained; according to the corresponding relationship between the table field in the database table and the member field in the C language data structure, determine all the member fields. The table field in the database table corresponding to each member field in the C language data structure object in the operation instruction; according to the data type, each data member in the C language data structure object in the operation instruction is converted into a corresponding Table field data in a database table.

When the user needs to add, delete, modify, and query the SQLite database, enter the operation command. After the device receives the operation command, it can create a data structure object, add the mapping structure to the data structure object as needed, and then fill in the "data structure" object with the conditions of additions, deletions, modifications and inspections and the corresponding data according to the grammar rules. Each member field of , call the preset operation interface to pass in the constructed "data structure" object. Finally, according to different conditions such as single-table, multi-table, cross-database, and what kind of query results are required for the operation object, multiple different target "mapping structures" are passed to the preset operation interface. The preset operation interface scans each "data structure" member saved in the "mapped structure", and uses the "reflection mechanism" similar to dynamic language to obtain the corresponding member of the "data structure" according to the memory address of the member. Different data types obtain values from the "data structure" object members and convert them into the corresponding data types and data values of the SQLite database. Finally, according to the grammar rules of the SQL language, according to the different situations such as addition, deletion, modification, query, single table, multi-table, cross-database, whether there are query conditions, and whether to sort, construct the SQL statement corresponding to the operation.

S105. Perform corresponding operation processing on the relational database according to the SQL statement.

In this embodiment, after the SQL statement is generated, it is sufficient to perform corresponding operation processing on the relational database according to the SQL statement.

Taking the operation of the database in the NAS device as an example, for the file management function, you can set different conditions to query files according to different usage scenarios, such as querying all files under a user, querying a directory of a user There are many operations for adding, deleting, modifying, and querying files, such as files under a certain user's file name, and files containing the "xxx" keyword in the file name. In the prior art, not only database tables and data structures need to be created, but also many functions are needed to respectively correspond to the above operations. In the present application, after creating the database table and the data structure, only one mapping structure needs to be created, and then all the above operations can be implemented through the preset operation interface.

The method for operating a relational database based on the C language provided by this embodiment simplifies the operation and reduces the workload through the mapping structure between the database table and the C language data structure and the preset operation interface, and is based on the C language. Efficient operation of relational database is realized.

On the basis of the above embodiment, in order to improve the security of the operation, in this embodiment, before generating the SQL statement according to the SQL syntax rules of the structured query language and the operation instruction, the operation is also scanned through the preset operation interface Each member in the data structure object of the instruction detects whether there is a syntax error in the operation instruction according to a predefined regular expression. Specifically, the preset operation interface first scans each member of the "mapping structure" and the incoming data in the "data structure" object, interface conditions, sorting and target "mapping structure", etc., according to the predefined multiple regular expressions The regular expression used for syntax detection can be determined according to different conditions such as single-table, multi-table, cross-database, and what kind of query results are required.

On the basis of the foregoing embodiment, the present embodiment performs differentiated processing for different operation instructions. Specifically, if the operation indicated by the operation identifier in the operation instruction is an addition operation, a deletion operation or a modification operation, the method further includes returning the operation execution result status; if the operation indicated by the operation identifier in the operation instruction is an operation When it is a query operation, the method further includes: obtaining query result data from the relational database according to the generated SQL statement; converting the query result data into the C language data structure according to the mapping structure data in . Wherein, converting the query result data into data in the C language data structure according to the mapping structure includes: according to the relationship between the table field in the database table and the member field in the C language data structure The corresponding relationship, determine the member field in the C language data structure corresponding to each table field in the query result data; carry out numerical conversion according to the data type of each table field and the corresponding member field; according to the C language The memory address of each member field in the data structure, and the query result data after numerical conversion is stored in the corresponding member field.

FIG. 2 is a flowchart of another embodiment of a method for operating a relational database based on the C language provided by the present invention. As shown in FIG. 2, on the basis of the embodiment shown in FIG. 1, the method provided in this embodiment may further include:

S201. Determine whether the operation indicated by the operation identifier in the operation instruction is a query operation. If yes, go to step S202; if not, go to step S206.

S202. Obtain query result data from a relational database according to the generated SQL statement.

S203 , according to the correspondence between the table fields in the database table and the member fields in the C language data structure, determine the member fields in the C language data structure corresponding to each table field in the query result data.

S204. Perform numerical conversion according to the data types of each table field and the corresponding member field.

S205 , according to the memory addresses of each member field in the C language data structure, store the query result data after the numerical conversion into the corresponding member field, and complete the query operation on the database.

S206. Continue to determine whether the operation indicated by the operation identifier in the operation instruction is an addition operation, a deletion operation or a modification operation. If yes, continue to step S207.

S207 , returning the operation execution result status, and completing the addition operation, deletion operation or modification operation to the database.

The method for operating a relational database based on the C language provided by this embodiment, on the basis of the above embodiment, further converts the query result data obtained from the database into a data structure through the reflection mechanism implemented by the mapping structure member data in .

FIG. 3 is a schematic structural diagram of an embodiment of an apparatus for operating a relational database based on the C language provided by the present invention. As shown in FIG. 3 , the apparatus 30 for operating a relational database based on C language provided in this embodiment may include: a creating module 301 , a determining module 302 , a calling module 303 , a generating module 304 and a processing module 305 .

A creation module 301 is used to create a database table of a relational database and a corresponding C language data structure;

A determination module 302, configured to determine a mapping structure between the database table and the C language data structure, and add the mapping structure to the C language data structure;

The calling module 303 is used to obtain the operation instruction of the user, and call the preset operation interface according to the operation instruction;

A generating module 304, configured to generate an SQL statement according to the structured query language SQL syntax rules and the operation instruction through the preset operation interface;

The processing module 305 is configured to perform corresponding operation processing on the relational database according to the SQL statement.

The apparatus for operating a relational database based on the C language provided in this embodiment can be used to execute the technical solution of the method embodiment corresponding to FIG. 1 , and the implementation principles and technical effects thereof are similar, and are not repeated here.

In one embodiment, the determining module 302 is configured to determine the mapping structure between the database table and the C language data structure, which may specifically include:

Determine the correspondence between the table field in the database table and the member field in the C language data structure;

Calculate the memory address of each member field in the C language data structure according to the preset rule;

storing the correspondence and the memory address in the mapping structure.

In one embodiment, the generating module 304 is configured to generate the SQL statement according to the structured query language SQL syntax rules and the operation instruction, which may specifically include:

Determine the operation type of the SQL statement according to the operation identifier in the operation instruction;

Convert the C language data structure object in the operation instruction into a data object in the database table according to the mapping structure;

Use the data object as a parameter of the SQL statement.

In an embodiment, the generating module 304 is configured to convert the C language data structure object in the operation instruction into the data object in the database table according to the mapping structure, which may specifically include:

According to the memory address of each member field in the C language data structure object in the described operation instruction, obtain each member field in the C language data structure object in the described operation instruction;

According to the correspondence between the table fields in the database table and the member fields in the C language data structure, determine the table in the database table corresponding to each member field in the C language data structure object in the operation instruction field;

According to the data type, each data member in the C language data structure object in the operation instruction is converted into table field data in the corresponding database table.

In an embodiment, the apparatus 30 for operating the relational database based on the C language may further include a post-processing module (not shown in the figure), for if the operation indicated by the operation identifier in the operation instruction is an increase operation, When a deletion operation or a modification operation is performed, the operation execution result status is returned; if the operation indicated by the operation identifier in the operation instruction is a query operation, the query result data is obtained from the relational database according to the generated SQL statement; according to the The mapping structure converts the query result data into data in the C language data structure.

In an embodiment, the post-processing module is configured to convert the query result data into data in the C language data structure according to the mapping structure, which may specifically include:

According to the correspondence between the table fields in the database table and the member fields in the C language data structure, determine the member fields in the C language data structure corresponding to each table field in the query result data;

Perform numerical conversion according to the data type of each table field and the corresponding member field;

According to the memory address of each member field in the C language data structure, the query result data after the numerical conversion is stored in the corresponding member field.

In an embodiment, the apparatus 30 for operating a relational database based on the C language may further include a detection module (not shown in the figure) for generating SQL statements according to the structured query language SQL syntax rules and the operation instructions. Before, each member of the data structure object of the operation instruction is scanned through the preset operation interface, and whether there is a syntax error in the operation instruction is detected according to a predefined regular expression.

The embodiment of the present invention further provides an electronic device 40 . Please refer to FIG. 4 . The embodiment of the present invention only uses FIG. 4 as an example for description, which does not mean that the present invention is limited to this. FIG. 4 is a schematic structural diagram of an embodiment of an electronic device provided by the present invention. The electronic devices provided in this embodiment include, but are not limited to, computers, smart phones, tablet computers, personal digital assistants, servers, and server groups. As shown in FIG. 4 , the electronic device 40 provided in this embodiment may include: a memory 401 , a processor 402 and a bus 403 . Among them, the bus 403 is used to realize the connection between various components.

A computer program is stored in the memory 401, and when the computer program is executed by the processor 402, the technical solution of the method for operating a relational database based on the C language provided by any of the above method embodiments can be implemented.

The memory 401 and the processor 402 are electrically connected directly or indirectly to realize data transmission or interaction. For example, these elements can be electrically connected to each other through one or more communication buses or signal lines, such as the bus 403 . A computer program for implementing a method for operating a relational database based on C language is stored in the memory 401, including at least one software function module that can be stored in the memory 401 in the form of software or firmware, and the processor 402 is stored in the memory 401 by running software programs and modules that perform various functional applications and data processing.

The memory 401 can be, but is not limited to, a random access memory (Random Access Memory, referred to as: RAM), a read-only memory (Read Only Memory, referred to as: ROM), a programmable read-only memory (Programmable Read-Only Memory, referred to as: PROM) ), Erasable Programmable Read-Only Memory (EPROM for short), Electrical Erasable Programmable Read-Only Memory (EEPROM for short), etc. The memory 401 is used for storing the program, and the processor 402 executes the program after receiving the execution instruction. Further, the software programs and modules in the above-mentioned memory 401 may also include an operating system, which may include various software components and/or drivers for managing system tasks (such as memory management, storage device control, power management, etc.), and Can communicate with various hardware or software components to provide an operating environment for other software components.

The processor 402 may be an integrated circuit chip with signal processing capability. The aforementioned processor 402 may be a general-purpose processor, including a central processing unit (Central Processing Unit, CPU for short), a network processor (Network Processor, NP for short). Various methods, steps, and logical block diagrams disclosed in the embodiments of the present invention can be implemented or executed. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like. It can be understood that the structure of FIG. 4 is only for illustration, and may also include more or less components than those shown in FIG. 4 , or have different configurations from those shown in FIG. 4 . The components shown in FIG. 4 may be implemented in hardware and/or software.

Descriptions are made herein with reference to various exemplary embodiments. However, those skilled in the art will recognize that changes and modifications may be made to the exemplary embodiments without departing from the scope of this document. For example, various operational steps, and components for performing operational steps, may be implemented in different ways depending on the particular application or considering any number of cost functions associated with the operation of the system (eg, one or more steps may be deleted, modified or incorporated into other steps).

Additionally, as understood by those skilled in the art, the principles herein may be reflected in a computer program product on a computer-readable storage medium preloaded with computer-readable program code. Any tangible, non-transitory computer-readable storage medium may be used, including magnetic storage devices (hard disks, floppy disks, etc.), optical storage devices (CD-ROMs, DVDs, Blu Ray disks, etc.), flash memory, and/or the like . These computer program instructions may be loaded on a general purpose computer, special purpose computer or other programmable data processing apparatus to form a machine such that execution of the instructions on the computer or other programmable data processing apparatus may generate means for implementing the specified functions. These computer program instructions may also be stored in a computer-readable memory that instructs a computer or other programmable data processing device to operate in a particular manner, such that the instructions stored in the computer-readable memory form a piece of Articles of manufacture, including implementing means for implementing specified functions. Computer program instructions may also be loaded on a computer or other programmable data processing device to perform a series of operational steps on the computer or other programmable device to produce a computer-implemented process such that a process executed on the computer or other programmable device Instructions may provide steps for implementing specified functions.

The above specific examples are used to illustrate the present invention, which are only used to help understand the present invention, and are not intended to limit the present invention. For those skilled in the art to which the present invention pertains, according to the idea of the present invention, several simple deductions, modifications or substitutions can also be made.

Claims (10)

1. A method for operating a relational database based on a C language, comprising:

creating a database table of a relational database and a corresponding C language data structure body;

determining a mapping structure between the database table and the C language data structure, and adding the mapping structure into the C language data structure;

acquiring an operation instruction of a user, and calling a preset operation interface according to the operation instruction;

generating an SQL statement according to a Structured Query Language (SQL) grammar rule and the operation instruction through the preset operation interface;

and performing corresponding operation processing on the relational database according to the SQL statement.

2. The method of claim 1, wherein said determining a mapping structure between said database table and said C language data structure comprises:

determining the corresponding relation between the table fields in the database table and the member fields in the C language data structure;

calculating the memory address of each member field in the C language data structure according to a preset rule;

and storing the corresponding relation and the memory address to the mapping structure.

3. The method of claim 2, wherein generating the SQL statement according to the structured query language SQL syntax rules and the operation instructions comprises:

determining the operation type of the SQL statement according to the operation identifier in the operation instruction;

converting the C language data structure object in the operation instruction into a data object in a database table according to the mapping structure;

and taking the data object as a parameter of the SQL statement.

4. The method of claim 3, wherein the converting the C language data structure object in the operation instruction into a data object in a database table according to the mapping structure comprises:

acquiring each member field in the C language data structure object in the operation instruction according to the memory address of each member field in the C language data structure object in the operation instruction;

determining table fields in the database table corresponding to all member fields in the C language data structure object in the operation instruction according to the corresponding relation between the table fields in the database table and the member fields in the C language data structure;

and converting each data member in the C language data structure object in the operation instruction into table field data in a corresponding database table according to the data type.

5. The method of claim 2,

if the operation indicated by the operation identifier in the operation instruction is an adding operation, a deleting operation or a modifying operation, the method further comprises returning to an operation execution result state;

if the operation indicated by the operation identifier in the operation instruction is a query operation, the method further includes:

acquiring query result data from the relational database according to the generated SQL statement;

and converting the query result data into data in the C language data structure according to the mapping structure.

6. The method of claim 5, wherein said translating said query result data into data in said C language data structure according to said mapping structure comprises:

determining member fields in the C language data structure corresponding to the table fields in the query result data according to the corresponding relation between the table fields in the database table and the member fields in the C language data structure;

performing numerical value conversion according to the data types of each table field and the corresponding member field;

and storing the query result data after the numerical value conversion into the corresponding member fields according to the memory addresses of the member fields in the C language data structure.

7. The method of any of claims 1-6, wherein prior to generating the SQL statement according to the Structured Query Language (SQL) syntax rules and the operation instructions, the method further comprises:

and scanning each member in the data structure object of the operation instruction through the preset operation interface, and detecting whether a syntax error exists in the operation instruction according to a predefined regular expression.

8. An apparatus for operating a relational database based on a C language, comprising:

the creating module is used for creating a database table of the relational database and a corresponding C language data structure body;

the determining module is used for determining a mapping structure between the database table and the C language data structure and adding the mapping structure into the C language data structure;

the calling module is used for acquiring an operation instruction of a user and calling a preset operation interface according to the operation instruction;

the generating module is used for generating an SQL statement according to the SQL grammar rule of the structured query language and the operation instruction through the preset operation interface;

and the processing module is used for carrying out corresponding operation processing on the relational database according to the SQL statement.

9. An electronic device, comprising: at least one processor and memory;

the memory stores computer-executable instructions;

the at least one processor executing the computer-executable instructions stored by the memory causes the at least one processor to perform the method of operating a relational database based on the C language of any one of claims 1-7.

10. A computer-readable storage medium having stored thereon computer-executable instructions for implementing a method for operating a relational database based on C language according to any one of claims 1 to 7 when executed by a processor.

Images