Database connection structure based on json format

Abstract

The invention discloses a database connection structure based on a json format. A middleware based on the json format is arranged between an application program and a database; JDBC and SQL statements are packaged; when operation and access are carried out to the database, the method provided by the middleware based on the json format is directly invoked, and operation to the database is finished. The structure is advantaged by that with respect to different data table structures, the data are unnecessarily packaged by respectively developed corresponding entity Bean; the workload of a developer is greatly reduced; the professional requirement to a programmer is reduced; and data exchange is more general.

Description

technical field [0001] The invention relates to a data connection structure of a database. Background technique [0002] Most traditional applications use JDBC to connect to data. JDBC is a "low-level" interface, that is, it is used to directly invoke SQL commands. Also designed as a base interface upon which advanced interfaces and tools can be built. A high-level interface is a "user-friendly" interface that uses a more understandable and convenient API that is translated behind the scenes to a lower-level interface such as JDBC. [0003] In the "object / relational" mapping of a relational database, each row in a table corresponds to an instance of a class, and the value of each column corresponds to an attribute of that instance. Thus, programmers can directly operate on Java objects; the SQL calls required to access data will be automatically generated "under the covers". It is also possible to provide more complex mappings, such as combining rows from multiple tables ...

AI Technical Summary

Problems solved by technology

[0005] 1. When used in a relatively large project, due to the large number of data tables, each table needs to develop a corresponding entity bean to encapsulate the data, which increases the development workload, and if the structure of the data table changes, the corresponding entity Bean also needs to be changed accordingly;

[0006] 2. Programmers who participate in the development must be very familiar with SQL syntax, otherwise the program will be abnormal due to the syntax problem of the incoming SQL statement, which will affect the debugging of the entire project

Images