CN115587148A - Business-meaning-free data access method and device suitable for low-code platform - Google Patents

Abstract

The invention provides a method and a device for accessing non-business meaning data suitable for a low-code platform, wherein the corresponding method comprises the following steps: generating a mapping relation between a service field in the query configuration object and a field of the universal table without service meaning; then, generating an sql statement corresponding to the mapping relation; and finally, running the sql statement according to the query condition. The invention can improve the maintenance convenience of the low-code platform and the built application and can greatly improve the performance of database operation.

Description

Business-meaning-free data access method and device suitable for low-code platform

Technical Field

The application belongs to the technical field of computer data processing, and particularly relates to a service-meaning-free data access method and device suitable for a low-code platform.

Background

In the prior art, when an information system develops a data access layer, specific table names and field names are compiled to achieve the purpose of increasing, deleting, searching and modifying a database, a general table operating device is designed in a low-code platform, data operation under different service scenes is achieved through a configuration mode, and the capabilities of database indexing, associated query, sequencing and the like are fully utilized as in a traditional development mode.

(1) The functions of data association query, sequencing and the like are manually written by developers and are realized in a memory, so that the realization is complex and the maintainability of the system is poor.

(2) The data is associated, inquired and ordered in the memory, and the index is not supported, so that the performance is not good.

Disclosure of Invention

The invention can be used in the technical field of application of computer data processing technology in finance, and can also be used in any field except the finance field. And the codes (including Java codes and xml codes) of the low-code platform do not need to be modified according to business requirements, and the normal use of the self capacity of the database is not influenced.

In order to solve the technical problems, the invention provides the following technical scheme:

in a first aspect, the present invention provides a method for accessing non-business meaning data suitable for a low-code platform, comprising:

generating a mapping relation between a service field in the query configuration object and a field of the universal table without service meaning;

generating an sql statement corresponding to the mapping relation;

and running the sql statement according to the query condition.

In an embodiment, the generating the sql statement corresponding to the mapping relationship includes:

and generating the sql statement according to the query configuration object, the sql template and the mapping relation.

In an embodiment, before the generating a mapping relationship between a service field in the query configuration object and a field of a general table without service meaning, the method further includes:

and setting a query condition configuration interface to accept the query condition.

In one embodiment, the running the sql statement according to the query condition includes:

and running the sql statement by using data source middleware.

In a second aspect, the present invention also provides a non-business meaning data access apparatus suitable for a low-code platform, the apparatus comprising:

the mapping relation generating module is used for generating the mapping relation between the service field in the query configuration object and the field of the universal table without service meaning;

the statement generating module is used for generating an sql statement corresponding to the mapping relation;

and the statement operation module is used for operating the sql statement according to the query condition.

In one embodiment, the statement generation module includes:

and the statement generating unit is used for generating the sql statement according to the query configuration object, the sql template and the mapping relation.

In one embodiment, the non-service meaning data access device suitable for the low-code platform further comprises:

and the interface setting module is used for setting a query condition configuration interface so as to receive the query condition.

In one embodiment, the statement execution module includes:

and the statement running unit is used for running the sql statement by using the data source middleware.

In a third aspect, the present invention provides a computer program product comprising computer programs/instructions which, when executed by a processor, implement the steps of a non-business meaning data access method suitable for low code platforms.

In a fourth aspect, the present invention provides an electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor executes the computer program to implement the steps of a non-business meaning data access method suitable for low-code platforms.

In a fifth aspect, the invention provides a computer readable storage medium having stored thereon a computer program which, when executed by a processor, performs the steps of a method for business implication-free data access suitable for low code platforms.

As can be seen from the above description, an embodiment of the present invention provides a method and an apparatus for accessing data without business meaning for a low-code platform, including: firstly, generating a mapping relation between a service field in a query configuration object and a field of a universal table without service meaning; then, generating an sql statement corresponding to the mapping relation; and finally, running the sql statement according to the query condition. The invention can improve the maintenance convenience of the low-code platform and the built application and can greatly improve the performance of database operation.

Drawings

In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to these drawings without creative efforts.

FIG. 1 is a first flowchart illustrating a non-business meaning data access method for a low-code platform according to an embodiment of the present invention;

FIG. 2 is a flowchart of a step 200 provided by an embodiment of the present invention;

FIG. 3 is a second flowchart illustrating a non-business meaning data access method for a low-code platform according to an embodiment of the present invention;

FIG. 4 is a flowchart of step 300 provided by an embodiment of the present invention;

FIG. 5 is a flow chart of a non-business meaning data access method for a low code platform according to an embodiment of the present invention;

FIG. 6 is a block diagram of a business-implication-free data access device for low-code platforms according to a first embodiment of the present invention;

FIG. 7 is a block diagram of statement generation module 20 provided by an embodiment of the present invention;

FIG. 8 is a block diagram of a business-implication-free data access apparatus for low-code platforms according to a second embodiment of the present invention;

FIG. 9 is a block diagram of a statement execution module 30 provided by an embodiment of the present invention;

fig. 10 is a schematic structural diagram of an electronic device in an embodiment of the invention.

Detailed Description

In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.

As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.

It should be noted that the terms "comprises" and "comprising," and any variations thereof, in the description and claims of this application and the above-described drawings, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.

According to the technical scheme, the data acquisition, storage, use, processing and the like meet relevant regulations of national laws and regulations.

It should be noted that the embodiments and features of the embodiments in the present application may be combined with each other without conflict. The present application will be described in detail below with reference to the embodiments with reference to the attached drawings.

The embodiment of the invention provides a specific implementation manner of a non-business meaning data access method suitable for a low-code platform, and referring to fig. 1, the method specifically includes the following steps:

step 100: generating a mapping relation between a service field in the query configuration object and a field of the universal table without service meaning;

specifically, the business fields in the query configuration object are converted into fields in the universal table without business meaning through the mapping configured in the field mapping relation table.

Step 200: and generating an sql statement corresponding to the mapping relation.

Specifically, the query configuration object is compiled into a complex sql statement in combination with the sql template.

It is understood that Structured Query Language (SQL) is abbreviated as SQL, which is a database Query and programming Language for accessing data and querying, updating, and managing a relational database system; the sql statement is one language in which the database is operated.

Step 300: and running the sql statement according to the query condition.

Specifically, data sources and database sessions are managed, and sql is executed. Preferably, this is done through data source middleware.

As can be seen from the foregoing description, an embodiment of the present invention provides a service-meaning-free data access method applicable to a low-code platform, including: firstly, generating a mapping relation between a service field in a query configuration object and a field of a non-service meaning universal table; then, generating an sql statement corresponding to the mapping relation; and finally, running the sql statement according to the query condition. The invention can improve the maintenance convenience of the low-code platform and the built application and can greatly improve the performance of database operation. The invention relates to a method for generating a service meaning-free sql statement by corresponding fields of a general table without service meaning with service meaning fields through configuration, and the generated service meaning-free sql statement is transmitted to a database, (1) atomic data does not need to be processed, so that the system is simple, and maintainability is improved. (2) The system performance is greatly improved by fully utilizing the capabilities of database correlation query, indexing, sequencing and the like.

In one embodiment, referring to fig. 2, step 200 comprises:

step 201: and generating the sql statement according to the query configuration object, the sql template and the mapping relation.

Specifically, templates were compiled using xml sql of mybatis, and the designed template structure is schematically:

<select>

column > </foreach required for select < foreach >

from $ { tableName } < if has an association table > </if >

where < query condition >

< if equal to Condition > </if >

< if greater than less than Condition > </if >

< if contains Condition > </if >

< if image Condition > </if >

</foreach>

</select>

The compiled sql statement is:

select col1,col2,col3

from table1

where col2 like'％123456789％'and col3>100

in one embodiment, referring to fig. 3, before step 100, the method further includes:

step 90: and setting a query condition configuration interface to accept the query condition.

It will be appreciated that prior to a query, a series of query condition configuration interfaces need to be provided for the user to construct the query conditions.

In one embodiment, referring to fig. 4, step 300 comprises:

step 301: and running the sql statement by using data source middleware.

The database middleware can simplify the operations of read-write separation and database and table division, hide bottom layer implementation details, can operate a plurality of libraries and tables like operating a single library and table, and the mainstream design scheme mainly comprises two types:

1. the server side agent: an agent service is required to be independently deployed, a plurality of database instances are managed behind the agent service, a connection is established between the agent service and the agent server through a data source in application, the agent operates the bottom-layer database, and a corresponding result is returned. The method has the advantages of supporting multiple languages, being transparent to the service, having the defects of complex realization and great realization difficulty, and ensuring high availability of the agent by the agent

2. A client agent: and performing one-layer packaging on a connection pool or a database driver, establishing connection between the inside and different databases, and performing necessary operations on the SQL, such as reading and writing separation to select a master library or a slave library, and how to aggregate results after sub-library sub-table selection. Its advantages are simple implementation, natural decentralization, less supporting languages and difficult version upgrade

When the amount of database storage is not large, but concurrent read and write operations are large, the processing power of the database is exceeded. Or the number of applied business modules is large, the total data volume is large, and the concurrent processing operation exceeds the processing capacity of a single database server.

If the data size of a single table is large, the storage upper limit of the single table, such as a commodity table, an order table and the like, is exceeded. In order to solve the data storage and access performance, the database middleware is needed. The database middleware can enable a user to rapidly apply read-write separation and database division and table division in an application program, and if the user wants to write codes, the user does not need to pay attention to whether the database is read-write separated or not, so that the influence on the upper end caused by the change brought by the lower-end database read-write separation is shielded, and a database access module, namely the database middleware, needs to be added.

The design key points of the database middleware comprise: SQL can be parsed; the read-write separation can be supported; load balancing of reading from the library can be supported; supporting the database-splitting operation; supporting sub-table operation; supporting cross-library correlation query; support for transactions; primary key ID generation and data source management.

In a specific embodiment, the present invention further provides a specific embodiment of the non-business meaning data access method suitable for the low-code platform, and the following contents are specifically included with reference to fig. 5.

Interpretation of terms:

a low code platform: the method is a new platform for software development and aims to realize service functions through parameter configuration or a small amount of codes. The software product is a software product, and the user not only comprises a research and development personnel, but also can be a business personnel.

J2EE: java 2Platform Enterprise Edition, which is a widely recognized Enterprise-level distributed application development specification.

And (3) a data layer: the information system provides a layer of function of disk data adding, deleting, checking and modifying service for the business logic layer.

Indexing: a technology for directly positioning the position of data in a table according to service search conditions can avoid the condition that a database is searched line by line, and greatly improves the search efficiency.

Mybatis: an industry-wide variety of sql template compilation and execution plug-ins.

Criterion: java objects in Mybatis for configuring sql operations and execution conditions support configuration of query conditions in an interface manner.

First, the embodiment of the invention provides a non-service meaning data access system suitable for a low-code platform, which comprises:

1. the query configuration module: the module provides a series of configuration interfaces for inquiring configuration for developers of low-code platforms, and the developers can generate inquiry configuration objects.

The module provides a series of configuration interfaces for inquiring configuration for developers of the low-code platform, and the developers can transmit parameters to generate inquiry configuration objects by calling the interfaces.

Examples of interfaces are:

(1) Setting query body

(2) Setting query correlation main body and correlation relation with main body

(3) Set equal to condition

(4) Setting greater than, less than conditions

(5) Setting including conditions

(6) Set to null, not null condition

(7) Is arranged like

2. A data field mapping module: the mapping table is used for converting the service fields in the query configuration object into the fields in the universal table without service meaning through the mapping configured in the field mapping relation table. The module also supports remapping of non-business meaning query results queried from the database into business fields. In particular, the amount of the solvent to be used,

and converting the service field in the query configuration object into a field in a universal table without service meaning through the mapping configured in the field mapping relation table. The module also supports remapping of non-business meaning query results queried from the database into business fields. See table 1 for "field mapping table" table structure:

TABLE 1

The table structure of the mapping table of the service main body and the general table name is shown in table 2:

TABLE 2

Sql compilation module: and the system is used for compiling the query configuration object into a complex sql statement by combining the sql template and transmitting the complex sql statement to the sql execution module.

Sql execute module: and managing data sources and database sessions, and executing sql. This module is implemented using common data source middleware.

Based on the above system for accessing data without business meaning suitable for the low-code platform, the method for accessing data without business meaning suitable for the low-code platform provided by the specific application example of the invention comprises the following steps:

s1: generating a mapping relation between a service field in the query configuration object and a field of the universal table without service meaning;

under the constraint of the condition of normal use without influencing the self capability of the database, the general table structure still needs to be a relational database structure, and the normal use of the traditional indexing, associated query and sorting functions can be met.

The business meaning of the data table is extracted to be a configuration item, wherein mapping between the business field and the table general field needs to be contained. The index can be configured on the corresponding table column according to the service meaning. The field naming of the non-service meaning common table uses a naming mode supporting infinite extension like col1 and col2[,. ], so as to support service scenes with any complexity. And the configuration items are stored in the configuration table and are loaded when the low-code platform is started.

Specifically, a 'field mapping relation table', 'service subject and general table name mapping table' for storing service fields and meaningless table fields, and a 'meaningless general table' are designed. Then, a field mapping function is designed to map the operation on the service field to each field of the universal table without service meaning.

In this step, the business meaning needs to be stripped from the data query, removed before generating sql, and restored after query, so as to ensure the pureness and high reusability of the data table. Meanwhile, for a user, the logic design is still considered by the business meaning, and the use convenience is improved.

S2: and generating an sql statement corresponding to the mapping relation.

Firstly, a query configuration object (similar to a criterion object) is designed, transferred to an sql generation template, identified and compiled into sql by sql generation middleware, and complex operations such as table association query and joint query can be realized. Then, the query configuration object is combined with an sql template (a template for converting the query configuration condition into executable sql), compiled into a complex sql statement, and transmitted to the sql execution module.

S3: and running the sql statement according to the query condition.

And managing a data source and a database session and executing sql. This module is implemented using common data source middleware. The compiled sql is then passed to the data source component for execution to obtain execution results, and the database fields are converted back to business fields.

As can be seen from the above description, an embodiment of the present invention provides a method for accessing data without business meaning for a low-code platform, including: firstly, generating a mapping relation between a service field in a query configuration object and a field of a non-service meaning universal table; then, generating an sql statement corresponding to the mapping relation; and finally, running the sql statement according to the query condition. The invention can improve the maintenance convenience of the low-code platform and the built application and can greatly improve the performance of database operation. The invention generates sql statement without business meaning by configuring the field of the general table without business meaning to correspond to the business meaning field, and (1) does not need to process the atomic data, the system becomes simple, and the maintainability is improved. (2) The capabilities of database correlation query, indexing, sequencing and the like are fully utilized, and the system performance is greatly improved.

Based on the same inventive concept, the embodiment of the present application further provides a non-business meaning data access apparatus suitable for a low-code platform, which can be used to implement the method described in the foregoing embodiment, such as the following embodiments. The principle of solving the problems of the non-service meaning data access device suitable for the low-code platform is similar to that of a non-service meaning data access method suitable for the low-code platform, so the implementation of the non-service meaning data access device suitable for the low-code platform can refer to the implementation of the non-service meaning data access method suitable for the low-code platform, and repeated parts are not repeated. As used hereinafter, the term "unit" or "module" may be a combination of software and/or hardware that implements a predetermined function. While the system described in the embodiments below is preferably implemented in software, implementations in hardware, or a combination of software and hardware are also possible and contemplated.

The embodiment of the present invention provides a specific implementation manner of a non-business meaning data access device suitable for a low-code platform, which is capable of implementing a non-business meaning data access method suitable for a low-code platform, and referring to fig. 6, the non-business meaning data access device suitable for a low-code platform specifically includes the following contents:

a mapping relation generating module 10, configured to generate a mapping relation between a service field in the query configuration object and a field of the general table without service meaning;

a statement generating module 20, configured to generate an sql statement corresponding to the mapping relationship;

and the statement operating module 30 is configured to operate the sql statement according to the query condition.

In one embodiment, referring to fig. 7, the sentence generation module 20 includes:

a statement generating unit 201, configured to generate the sql statement according to the query configuration object, the sql template, and the mapping relationship.

In one embodiment, referring to fig. 8, the non-business meaning data access apparatus suitable for the low-code platform further includes:

and the interface setting module 40 is used for setting a query condition configuration interface so as to accept the query condition.

In one embodiment, referring to fig. 9, the statement execution module 30 includes:

a statement running unit 301, configured to run the sql statement by using data source middleware.

As can be seen from the above description, an embodiment of the present invention provides a non-business meaning data access apparatus suitable for a low-code platform, including: firstly, generating a mapping relation between a service field in a query configuration object and a field of a non-service meaning universal table; then, generating an sql statement corresponding to the mapping relation; and finally, running the sql statement according to the query condition. The invention can improve the maintenance convenience of the low-code platform and the built application and can greatly improve the performance of database operation. The invention generates sql statement without business meaning by configuring the field of the general table without business meaning to correspond to the business meaning field, and (1) does not need to process the atomic data, the system becomes simple, and the maintainability is improved. (2) The system performance is greatly improved by fully utilizing the capabilities of database correlation query, indexing, sequencing and the like.

Embodiments of the present application further provide a specific implementation manner of an electronic device, which is capable of implementing all steps in a non-business meaning data access method applicable to a low-code platform in the foregoing embodiments, and referring to fig. 10, the electronic device specifically includes the following contents:

a processor (processor) 1201, a memory (memory) 1202, a communication Interface (Communications Interface) 1203, and a bus 1204;

the processor 1201, the memory 1202 and the communication interface 1203 complete communication with each other through the bus 1204; the communication interface 1203 is used for implementing information transmission between related devices such as server-side devices and client-side devices;

the processor 1201 is used to call the computer program in the memory 1202, and the processor executes the computer program to implement all the steps in one of the above-described embodiments of the non-business meaning data access method for a low-code platform, for example, to implement the following steps when the processor executes the computer program:

step 100: generating a mapping relation between a service field in the query configuration object and a field of the universal table without service meaning;

step 200: generating an sql statement corresponding to the mapping relation;

step 300: and running the sql statement according to the query condition.

Embodiments of the present application also provide a computer-readable storage medium capable of implementing all steps in a non-business meaning data access method suitable for a low-code platform in the above embodiments, where the computer-readable storage medium stores thereon a computer program, and the computer program implements all steps of a non-business meaning data access method suitable for a low-code platform in the above embodiments when being executed by a processor, for example, the processor implements the following steps when executing the computer program:

step 100: generating a mapping relation between a service field in the query configuration object and a field of a universal table without service meaning;

step 200: generating an sql statement corresponding to the mapping relation;

step 300: and running the sql statement according to the query condition.

The embodiments in the present specification are described in a progressive manner, and the same and similar parts among the embodiments are referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, for the hardware + program class embodiment, since it is substantially similar to the method embodiment, the description is simple, and the relevant points can be referred to the partial description of the method embodiment.

The foregoing description has been directed to specific embodiments of this disclosure. Other embodiments are within the scope of the following claims. In some cases, the actions or steps recited in the claims may be performed in a different order than in the embodiments and still achieve desirable results. In addition, the processes depicted in the accompanying figures do not necessarily require the particular order shown, or sequential order, to achieve desirable results. In some embodiments, multitasking and parallel processing may also be possible or may be advantageous.

Although the present application provides method steps as in an embodiment or a flowchart, more or fewer steps may be included based on conventional or non-inventive labor. The order of steps recited in the embodiments is merely one manner of performing the steps in a multitude of sequences, and does not represent a unique order of performance. When an actual apparatus or client product executes, it may execute sequentially or in parallel (e.g., in the context of parallel processors or multi-threaded processing) according to the embodiments or methods shown in the figures.

For convenience of description, the above devices are described as being divided into various modules by functions, and are described separately. Of course, in implementing the embodiments of the present description, the functions of each module may be implemented in one or more software and/or hardware, or a module implementing the same function may be implemented by a combination of multiple sub-modules or sub-units, and the like. The above-described embodiments of the apparatus are merely illustrative, and for example, the division of the units is only one logical division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.

Those skilled in the art will also appreciate that, in addition to implementing the controller as pure computer readable program code, the same functionality can be implemented by logically programming method steps such that the controller is in the form of logic gates, switches, application specific integrated circuits, programmable logic controllers, embedded microcontrollers and the like. Such a controller may therefore be considered as a hardware component, and the means included therein for performing the various functions may also be considered as a structure within the hardware component. Or even means for performing the functions may be regarded as being both a software module for performing the method and a structure within a hardware component.

In a typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.

The memory may include forms of volatile memory in a computer readable medium, random Access Memory (RAM) and/or non-volatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). Memory is an example of a computer-readable medium.

The embodiments of this specification may be described in the general context of computer-executable instructions, such as program modules, being executed by a computer. Generally, program modules include routines, programs, objects, components, data structures, etc. that perform particular tasks or implement particular abstract data types. The specification embodiments may also be practiced in distributed computing environments where tasks are performed by remote processing devices that are linked through a communications network. In a distributed computing environment, program modules may be located in both local and remote computer storage media including memory storage devices.

The embodiments in the present specification are described in a progressive manner, and the same and similar parts among the embodiments are referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, for the system embodiment, since it is substantially similar to the method embodiment, the description is simple, and for the relevant points, reference may be made to the partial description of the method embodiment. In the description herein, references to the description of the term "one embodiment," "some embodiments," "an example," "a specific example," or "some examples," etc., mean that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of an embodiment of the specification. In this specification, the schematic representations of the terms used above are not necessarily intended to refer to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples. Furthermore, various embodiments or examples and features of different embodiments or examples described in this specification can be combined and combined by one skilled in the art without contradiction.

The above description is only an example of the embodiments of the present disclosure, and is not intended to limit the embodiments of the present disclosure. Various modifications and variations to the embodiments described herein will be apparent to those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the embodiments of the present specification should be included in the scope of the claims of the embodiments of the present specification.

Claims (11)

1. A service-meaning-free data access method for a low-code platform, comprising:

generating a mapping relation between a service field in the query configuration object and a field of the universal table without service meaning;

generating an sql statement corresponding to the mapping relation;

and running the sql statement according to the query condition.

2. The non-business meaning data access method applicable to the low-code platform as claimed in claim 1, wherein the generating of the sql statement corresponding to the mapping relationship comprises:

and generating the sql statement according to the query configuration object, the sql template and the mapping relation.

3. The method of claim 2, wherein prior to generating the mapping between the business fields in the query configuration object and the fields of the non-business meaning common table, further comprising:

and setting a query condition configuration interface to accept the query condition.

4. The non-business meaning data access method for low code platforms according to claim 1, wherein the running the sql statement according to the query condition comprises:

and running the sql statement by using data source middleware.

5. A non-business meaning data access apparatus adapted for use with a low code platform, comprising:

the mapping relation generating module is used for generating the mapping relation between the service field in the query configuration object and the field of the universal table without service meaning;

the statement generating module is used for generating an sql statement corresponding to the mapping relation;

and the statement operation module is used for operating the sql statement according to the query condition.

6. The non-business meaning data access apparatus for low code platforms of claim 5 wherein the statement generation module comprises:

and the statement generating unit is used for generating the sql statement according to the query configuration object, the sql template and the mapping relation.

7. The non-business meaning data access apparatus adapted for use with a low code platform of claim 6, further comprising:

and the interface setting module is used for setting a query condition configuration interface so as to receive the query condition.

8. The non-business meaning data access apparatus for low code platforms of claim 5 wherein the statement execution module comprises:

and the statement running unit is used for running the sql statement by using the data source middleware.

9. A computer program product comprising computer program/instructions, characterized in that the computer program/instructions, when executed by a processor, implement the steps of the non-business meaning data access method applicable to low code platforms of any one of claims 1 to 4.

10. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the steps of the non-business meaning data access method for a low code platform of any one of claims 1 to 4 when executing the program.

11. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method for Business-implication-free data access for low-code platforms of any one of claims 1 to 4.

Images