CN116881269A - Method and system for realizing object relation mapping framework based on JSON - Google Patents

Abstract

The invention discloses a method and a system for realizing an object relation mapping framework based on JSON, wherein the method comprises a database, an SQL execution module, a data editing module and a data query module, wherein the data editing module edits data in the database through the SQL execution module; the edited data information is sequentially processed by a JSON serialization module and a JSON analyzer and then transmitted to an SQL execution module; the data query module is in data connection with the SQL execution module and queries data meeting query conditions in the database through the SQL execution module; the data meeting the query conditions are obtained by the SQL execution module after being called from the database and sequentially processed by the JSON generator module and the JSON deserialization module. The invention has the following beneficial effects: 1. additional XML configuration files are not required to be written, so that maintenance difficulty is reduced; 2. the device is not dependent on other components, is small and flexible, and has low use cost; 3. the implementation based on C++ ensures that the running efficiency of the program is higher; 4. supporting multiple databases; 5. a variety of platforms are supported, including Linux, windows, arm, etc.

Description

Method and system for realizing object relation mapping framework based on JSON

Technical Field

The invention relates to the field of database persistence, in particular to a method and a system for realizing an object relation mapping framework based on JSON.

Background

The persistence of a database, in particular to a technology for solving the problem of mismatch between data types in an object-oriented database and a relational database. By describing the mapping relationship between the entity object and the data table, the object in the application program is automatically stored in the relational database in a lasting manner, so that the data table can be operated like the entity object.

The object-relationship mapping is generated as object-oriented software development methods evolve. The object-oriented development method is a mainstream development method in the current enterprise-level application development environment, and the relational database is a mainstream data storage system for permanently storing data in the enterprise-level application environment. The object and the relational data are two manifestations of the business entity, which is represented as an object in memory and as relational data in a database. There are association and inheritance relationships between objects in the memory, but in the database, the relationship data cannot directly express the many-to-many association and inheritance relationships. Thus, object-to-relational mapping (ORM) systems typically exist in the form of middleware, primarily to effect the mapping of program objects to relational database data.

The ORM will map records in the table of the relational database to objects, which are presented in the form of objects, and the programmer can translate operations on the database into operations on the objects. The purpose of the ORM is therefore to facilitate the manipulation of the database by developers with an object-oriented concept.

There are many ORM frameworks currently mature, commonly Hibernate and MyBatis. The Hibernate framework is an ORM framework of full table mapping, and a developer can complete the operation of a persistence layer through a method provided by the Hibernate framework as long as the mapping relation between a persistence object and a database table is defined. The developer does not need to master the writing of SQL sentences, and the Hibernate framework can automatically generate corresponding SQL according to the written storage logic and call the JDBC interface to execute. The Hibernate framework has low flexibility and is suitable for being used in projects with less complex scenes and low performance requirements. The MyBatis framework is a semi-automatic mapping framework, supports configuration of dynamic SQL and optimizes SQL, and determines mapping rules of SQL through configuration. The MyBatis framework is more flexible than the Hibernate framework, and is more advantageous for some complex and performance-optimized projects.

For example, in the prior art, hibernate has lightweight packaging for JDBC so that programmers can access data using object-oriented programming thought. Architecture of the Hibernate framework as shown in fig. 1, the Hibernate adopts the form of xml configuration to describe the mapping relationship between entity objects and data tables.

The following steps are used for the development of the Hibernate:

1. creating a persistence class;

2. creating an object-relationship mapping file;

3. creating a Hibernate configuration file;

4. code to access the database is written through the hibernateAPI.

The Hibernate framework itself has some drawbacks including:

1. the learning cost is high, and the HQL language is used;

2. the maintenance difficulty is high, and when the data table is too many, the configuration file is very bloated;

3. the flexibility is poor, and due to the high packaging of the JDBC, the developer cannot use the native JDBC;

4. batch modification and deletion are not supported;

5. all fields need to be sent at update time.

Disclosure of Invention

In order to solve the problems, the present disclosure proposes a system and a method for implementing an object relation mapping framework based on JSON, which designs a set of generalized implementation for an ORM framework, and is independent of programming language, and follows a unified design idea; the JSON is adopted as a mapping relation description language, so that a configuration file is abandoned, the workload of a developer is reduced, and the maintenance is convenient; and the function interfaces supporting the operations of customizing batch modification, deletion and the like are provided, so that the flexibility is improved.

In order to achieve the above purpose, the present invention adopts the following technical scheme: an implementation system of an object relation mapping framework based on JSON, comprising:

a database;

the SQL execution module is connected with the database in a bidirectional data way;

the data editing module is in data connection with the SQL execution module and edits data in the database through the SQL execution module; the data editing module comprises a JSON serialization module and a JSON analyzer, and edited data information is sequentially processed by the JSON serialization module and the JSON analyzer and then transmitted to the SQL execution module;

the data query module is in data connection with the SQL execution module and queries data meeting query conditions in the database through the SQL execution module; the data query module is provided with a JSON generator module and a JSON deserialization module, and data conforming to query conditions is obtained by the SQL execution module after being called from a database and sequentially processed by the JSON generator module and the JSON deserialization module.

Further, the system also comprises a data deleting module which is in data connection with the SQL executing module, and the data meeting the deleting condition in the database is inquired and the deleting command is executed through the SQL executing module.

Further, the data editing module comprises a data inserting module for inserting new data and a data modifying module for modifying the data in the database.

Further, the data editing module defines entity class and table structure according to the band insertion data to create an object; then transmitting the object to a JSON serialization module, calling a unified API interface, and converting the object into a JSON character string; transmitting the JSON character string to a JSON parser module, and enabling the JSON parser to be responsible for unified parsing and saving field names, field types and field values; the SQL execution module generates an SQL statement according to the saved field information; and calling a database interface, executing the generated SQL statement, and completing the insertion or modification of the data.

Further, the query conditions defined by the data query module are transmitted to the SQL execution module to generate an SQL sentence; the SQL execution module calls a database interface, executes SQL sentences and stores a result set obtained by query; analyzing the result set, and generating a JSON character string by a JSON generator; and transmitting the generated JSON character string to a JSON deserialization module to generate a queried entity object set.

Further, the system also comprises a data deleting module, wherein the data deleting module is used for defining deleting conditions; the SQL statement is generated by transmitting the SQL statement to the SQL execution module, and the SQL execution module calls an API interface provided by the database to delete the record; if the deletion is successful, returning true; if the deletion fails, return false.

The invention also provides a method for realizing the object relation mapping framework based on JSON, which comprises the following steps:

s1, selecting editing data or query data;

s2, if editing data is selected, inputting data to be inserted or data to be modified; if the query data is selected, defining a query condition;

s3, sequentially performing JSON serialization processing and JSON analysis processing on the input data to be inserted or the data to be modified to generate SQL sentences, and finally calling a database interface to execute the generated SQL sentences;

for defined query conditions, generating SQL sentences, calling a database interface, executing the SQL sentences, and storing a result set obtained by query; then analyzing the result set, and generating a JSON character string by a JSON generator; and performing JSON anti-sequence processing on the generated JSON character string to generate a queried entity object set.

Further, in S3, according to the data to be inserted, an entity class and a table structure are defined, and an object is created.

Further, in S3, the JSON serialization process includes calling a unified API interface to convert the object into a JSON string.

Further, in S3, the JSON string is subjected to unified parsing by the JSON parser, and the field name, the field type, and the field value are saved.

Further, the method for deleting the data comprises the following steps:

s103, defining a deletion condition;

s104, generating an SQL sentence, calling an API interface provided by a database, executing the SQL sentence, and deleting data;

s105, if the deletion is successful, returning true; if the deletion fails, return false.

The invention has the following beneficial effects:

1. additional XML configuration files are not required to be written, so that maintenance difficulty is reduced;

2. the device is not dependent on other components, is small and flexible, and has low use cost;

3. the implementation based on C++ ensures that the running efficiency of the program is higher;

4. support a variety of databases including mySQL, SQLite, etc.;

5. a variety of platforms are supported, including Linux, windows, arm, etc.

Drawings

FIG. 1 is a schematic architecture diagram of a prior art Hibernate framework;

FIG. 2 is a schematic diagram of a system processing procedure when data is stored in a database according to the present invention;

FIG. 3 is a schematic diagram of a system process flow when querying records from a database according to the present invention;

FIG. 4 is a schematic diagram of a system process flow when records are deleted from a database according to the present invention;

FIG. 5 is a flowchart illustrating a system process when modifying a database record according to the present invention.

Detailed Description

The following description of the embodiments of the present invention will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present invention, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.

As shown in fig. 2, an implementation system of an object relation mapping framework based on JSON includes:

a database;

the SQL execution module is connected with the database in a bidirectional data way;

the data editing module is in data connection with the SQL execution module and edits data in the database through the SQL execution module; the data editing module comprises a JSON serialization module and a JSON analyzer, and edited data information is sequentially processed by the JSON serialization module and the JSON analyzer and then transmitted to the SQL execution module;

the data query module is in data connection with the SQL execution module and queries data meeting query conditions in the database through the SQL execution module; the data query module is provided with a JSON generator module and a JSON deserialization module, and data conforming to query conditions is obtained by the SQL execution module after being called from a database and sequentially processed by the JSON generator module and the JSON deserialization module.

The comparison document CN202110985601 comprises the steps of establishing a JOSN data model, mapping the JOSN data structure into an SQL structure, correspondingly generating an SQL sentence according to the JOSN data and the data model, executing the SQL sentence through a calling interface, and storing data. The invention creates the object by defining the data, and further carries out module configuration and operation according to the required functions through modules such as serialization and deserialization, a parser, a generator and the like.

In some embodiments, the system further comprises a data deleting module which is in data connection with the SQL executing module and is used for inquiring data meeting deleting conditions in the database and executing deleting commands.

In some embodiments, the data editing module includes a data insertion module for inserting new data and a data modification module for modifying the data in the database.

In some embodiments, the data editing module defines entity classes and table structures according to the tape insertion data, creates objects; then transmitting the object to a JSON serialization module, calling a unified API interface, and converting the object into a JSON character string; transmitting the JSON character string to a JSON parser module, and enabling the JSON parser to be responsible for unified parsing and saving field names, field types and field values; the SQL execution module generates an SQL statement according to the saved field information; and calling a database interface, executing the generated SQL statement, and completing the insertion or modification of the data.

In some embodiments, the query conditions defined by the data query module are transferred to the SQL execution module to generate an SQL statement; the SQL execution module calls a database interface, executes SQL sentences and stores a result set obtained by query; analyzing the result set, and generating a JSON character string by a JSON generator; and transmitting the generated JSON character string to a JSON deserialization module to generate a queried entity object set.

In some embodiments, the system further comprises a data deletion module for defining deletion conditions; the SQL statement is generated by transmitting the SQL statement to the SQL execution module, and the SQL execution module calls an API interface provided by the database to delete the record; if the deletion is successful, returning true; if the deletion fails, return false.

The JSON serialization and deserialization module is responsible for the mutual conversion of the entity object and the JSON character string; the JSON parser is responsible for parsing the serialized JSON character strings and simultaneously storing field information obtained by parsing, wherein the field information comprises field names, field types and field values; the JSON generator generates a JSON character string according to the field information returned by the SQL execution module; the SQL execution module is responsible for generating and executing SQL sentences.

The JSON serialization module is responsible for implementing serialization of the entity objects into JSON strings. The design concept is that when defining entity class, the JSON serialization module saves the name and type of the attribute of the class. After instantiating the object and assigning a value to the attribute, a unified serialization interface ObjectToJSON provided by the JSON serialization module may be invoked. The ObjectToJSON interface is responsible for traversing the attribute set of the class and dynamically generating JSON strings according to attribute names, types and attribute values.

The JSON deserialization module is responsible for parsing JSON strings into entity objects. The design concept is that the deserialization interface JSONToObject, JSONToObject interface provided by the JSON deserialization module is called to analyze the JSON character string to obtain field information, including field name, field type and field value. And traversing the attribute set of the saved class, finding out the attribute matched with the field, and assigning a value to the attribute.

The JSON parser module receives the serialized JSON character string, calls a character string parsing function, obtains field information of the JSON character string, including a field name, a field type and a field value, and transmits the field information to the SQL execution module. The SQL execution module traverses the field set and generates a corresponding SQL statement according to the field information. And finally, calling the database handle and executing the SQL statement.

The JSON generator module receives the record set queried from the database from the SQL execution module, wherein the record set contains all field information in the data table, including field names, field types and field values. Then traversing the field set, calling a character string generating function, generating a corresponding JSON character string, and transmitting the JSON character string to a JSON deserializing module.

When data is stored in the database, the processing procedure of the system is as shown in fig. 2, and the processing procedure comprises the following steps:

step S1: defining entity class and table structure according to the band insertion data, and creating an object;

step S3: transferring to a JSON serialization module, calling a unified API interface, and converting the object into a JSON character string;

step S4: transmitting the JSON character string to a JSON parser module, wherein the JSON parser is responsible for unified parsing, and saving field names, field types and field values;

step S5: generating SQL sentences according to the stored field information;

step S6: calling a database interface, and executing the generated SQL statement;

step S7: insert data and feed back the results.

When inquiring records from the database, the processing flow of the system is shown in fig. 3, and the method comprises the following steps:

step S1: defining a query condition;

step S2: transferring to SQL execution module, calling database interface, executing SQL sentence, and storing result set obtained by inquiry;

step S3: analyzing the result set, and generating a JSON character string by a JSON generator;

step S4: and transmitting the generated JSON character string to a JSON deserialization module to generate a queried entity object set.

When a record is deleted from the database, the processing flow of the system is shown in fig. 4, and includes the following steps:

step S1: defining a deletion condition;

step S2: transferring the record to an SQL execution module, calling an API interface provided by a database, and deleting the record;

step S3: if the deletion is successful, returning true; if the deletion fails, return false.

When the record of the database is modified, the processing flow of the system is shown in fig. 5, and the method comprises the following steps:

step S1: inputting data to be modified, transmitting the data to a JSON serialization module, calling a unified API interface, and converting the object into a JSON character string;

step S2: transmitting the JSON character string to a JSON parser module, wherein the JSON parser is responsible for unified parsing, and saving field names, field types and field values;

step S3: generating SQL sentences according to the stored field information;

step S4: calling a database interface, and executing the generated SQL statement;

step S5: if the modification is successful, returning true; if the modification fails, return false.

The invention also provides a method for realizing the object relation mapping framework based on JSON, which comprises the following steps:

s1, selecting editing data or query data;

s2, if editing data is selected, inputting data to be inserted or data to be modified; if the query data is selected, defining a query condition;

s3, sequentially performing JSON serialization processing and JSON analysis processing on the input data to be inserted or the data to be modified to generate SQL sentences, and finally calling a database interface to execute the generated SQL sentences;

for defined query conditions, generating SQL sentences, calling a database interface, executing the SQL sentences, and storing a result set obtained by query; then analyzing the result set, and generating a JSON character string by a JSON generator; and performing JSON anti-sequence processing on the generated JSON character string to generate a queried entity object set.

Further, in S3, according to the data to be inserted, an entity class and a table structure are defined, and an object is created.

Further, in S3, the JSON serialization process includes calling a unified API interface to convert the object into a JSON string.

Further, in S3, the JSON string is subjected to unified parsing by the JSON parser, and the field name, the field type, and the field value are saved.

Further, the method for deleting the data comprises the following steps:

s103, defining a deletion condition;

s104, generating an SQL sentence, calling an API interface provided by a database, executing the SQL sentence, and deleting data;

s105, if the deletion is successful, returning true; if the deletion fails, return false.

The invention has the following beneficial effects:

1. additional XML configuration files are not required to be written, so that maintenance difficulty is reduced;

2. the device is not dependent on other components, is small and flexible, and has low use cost;

3. the implementation based on C++ ensures that the running efficiency of the program is higher;

4. support a variety of databases including mySQL, SQLite, etc.;

5. a variety of platforms are supported, including Linux, windows, arm, etc.

The foregoing is only a preferred embodiment of the present invention, but the scope of the present invention is not limited thereto, and any person skilled in the art, who is within the scope of the present invention, should make equivalent substitutions or modifications according to the technical scheme of the present invention and the inventive concept thereof, and should be covered by the scope of the present invention.

Claims (11)

1. An implementation system of an object relation mapping framework based on JSON is characterized by comprising:

a database;

the SQL execution module is connected with the database in a bidirectional data way;

the data editing module is in data connection with the SQL execution module and edits data in the database through the SQL execution module; the data editing module comprises a JSON serialization module and a JSON analyzer, and edited data information is sequentially processed by the JSON serialization module and the JSON analyzer and then transmitted to the SQL execution module;

the data query module is in data connection with the SQL execution module and queries data meeting query conditions in the database through the SQL execution module; the data query module is provided with a JSON generator module and a JSON deserialization module, and data conforming to query conditions is obtained by the SQL execution module after being called from a database and sequentially processed by the JSON generator module and the JSON deserialization module.

2. The system for implementing the JSON-based object-relationship mapping framework of claim 1, further comprising a data deletion module in data connection with the SQL execution module for querying the database for data meeting the deletion condition and executing the deletion command.

3. The system according to claim 1 or 2, wherein the data editing module comprises a data inserting module for inserting new data and a data modifying module for modifying data in the database.

4. The JSON-based object relationship mapping framework implementation system of claim 3, wherein the data editing module defines entity classes and table structures from the band insertion data, creating objects; then transmitting the object to a JSON serialization module, calling a unified API interface, and converting the object into a JSON character string; transmitting the JSON character string to a JSON parser module, and enabling the JSON parser to be responsible for unified parsing and saving field names, field types and field values; the SQL execution module generates an SQL statement according to the saved field information; and calling a database interface, executing the generated SQL statement, and completing the insertion or modification of the data.

5. The system for implementing the JSON-based object-relationship mapping framework of claim 4, wherein the query conditions defined by the data query module are transferred to the SQL execution module to generate an SQL statement; the SQL execution module calls a database interface, executes SQL sentences and stores a result set obtained by query; analyzing the result set, and generating a JSON character string by a JSON generator; and transmitting the generated JSON character string to a JSON deserialization module to generate a queried entity object set.

6. The JSON-based object-relationship mapping framework implementation system of claim 4, further comprising a data deletion module for defining a deletion condition; the SQL statement is generated by transmitting the SQL statement to the SQL execution module, and the SQL execution module calls an API interface provided by the database to delete the record; if the deletion is successful, returning true; if the deletion fails, return false.

7. The method for realizing the object relation mapping framework based on JSON is characterized by comprising the following steps of:

s1, selecting editing data or query data;

s2, if editing data is selected, inputting data to be inserted or data to be modified; if the query data is selected, defining a query condition;

s3, sequentially performing JSON serialization processing and JSON analysis processing on the input data to be inserted or the data to be modified to generate SQL sentences, and finally calling a database interface to execute the generated SQL sentences;

for defined query conditions, generating SQL sentences, calling a database interface, executing the SQL sentences, and storing a result set obtained by query; then analyzing the result set, and generating a JSON character string by a JSON generator; and performing JSON anti-sequence processing on the generated JSON character string to generate a queried entity object set.

8. The method for implementing a JSON-based object-relationship mapping framework of claim 7, wherein in S3, the object is created by defining an entity class and a table structure from the data to be inserted.

9. The method for implementing a JSON-based object-relationship mapping framework of claim 8, wherein in S3, JSON serialization processing includes invoking a unified API interface to convert the object into a JSON string.

10. The method for implementing the JSON-based object relationship mapping framework according to claim 9, wherein in S3, the JSON strings are subjected to unified parsing by a JSON parser, and field names, field types and field values are saved.

11. The method for implementing the JSON-based object-relationship mapping framework according to any one of claims 7-10, further comprising a method for deleting data, the method for deleting data comprising:

s103, defining a deletion condition;

s104, generating an SQL sentence, calling an API interface provided by a database, executing the SQL sentence, and deleting data;

s105, if the deletion is successful, returning true; if the deletion fails, return false.