CN115291914A

CN115291914A - Data processing method, device, equipment and medium

Info

Publication number: CN115291914A
Application number: CN202210987933.9A
Authority: CN
Inventors: 朱宇戈; 陈郑渊明; 云一凡
Original assignee: Industrial and Commercial Bank of China Ltd ICBC
Current assignee: Industrial and Commercial Bank of China Ltd ICBC
Priority date: 2022-08-17
Filing date: 2022-08-17
Publication date: 2022-11-04

Abstract

The application provides a data processing method, a device, equipment and a medium. In the method, when monitoring that field information of a table in a database changes, a server side sends table identification and generated control configuration update information to a client side. The client updates the stored control configuration information and the table identification according to the control configuration update information and the table identification; when a user maintains service data, the client acquires corresponding updated control configuration information according to the table identifier selected by the user, and then updates the client maintenance control on the user graphical interface according to the updated control configuration information. According to the scheme, whether field information changes or not is monitored through a server, and control configuration updating information and form identification are sent to a client when the field information changes; and when the user maintains the service data, the client updates the client maintenance control according to the updated control configuration information, so that the efficiency of generating the client interface is effectively improved.

Description

Data processing method, device, equipment and medium

Technical Field

The present application relates to the field of financial technology or other related fields, and in particular, to a data processing method, apparatus, device, and medium.

Background

With the rapid development of science and technology, more and more data are generated in various fields, and how to maintain and query the data more efficiently is a concern.

In the prior art, for maintenance and query of data, the data is usually stored in a database, and when operations such as addition, deletion, modification, query and the like need to be performed on the data, a person needing to know knowledge of the database uses a code corresponding to the database to realize the maintenance and query of the data; or for each table in the database, a developer edits the codes to generate a corresponding client interface, and the data can be maintained for users who do not know the knowledge of the database. After new fields are added, deleted and changed in the database, the client interface cannot be changed, and errors may occur when the data in the database is operated through the client interface, so that a developer can only edit the codes again to generate a new client interface.

In summary, in the existing data processing method, when a new field is added, a field is deleted, and a field is changed in the database, a worker can only re-edit a code to generate a new client interface, which results in a low efficiency of generating the client interface and a low efficiency of maintaining data.

Disclosure of Invention

Embodiments of the present application provide a data processing method, an apparatus, a device, and a medium, which are used to solve the problem that in the case of adding a new field, deleting a field, and changing a field in a database in the existing data processing method, a worker can only re-edit a code to generate a new client interface, which results in lower efficiency of generating the client interface and further results in lower efficiency of maintaining data.

In a first aspect, an embodiment of the present application provides a data processing method, which is applied to a client, and the method includes:

receiving control configuration updating information and table identification sent by a server, wherein the control configuration updating information comprises at least one service data type and field identification corresponding to each service data type;

updating the stored control configuration information and the table identification according to the control configuration updating information and the table identification to obtain updated control configuration information and updated table identification, wherein the stored control configuration information and the table identification have a corresponding relationship;

responding to the table selection operation of a user, and acquiring the table identification selected by the user;

acquiring updated control configuration information corresponding to the form identification according to the form identification;

and updating the client maintenance control on the graphical user interface according to the service data type and the field identification corresponding to the service data type for each service data type in the updated control configuration information.

In a specific embodiment, the updating the stored control configuration information and the table identifier according to the control configuration update information and the table identifier to obtain updated control configuration information and updated table identifier includes:

if the control configuration information corresponding to the table identification sent by the server is determined to be stored, updating the control configuration information into control configuration update information sent by the server, wherein the table identification corresponding to the control configuration information is unchanged, and obtaining the updated control configuration information and the updated table identification;

and if the control configuration information corresponding to the table identification sent by the server is determined not to be stored, taking the control configuration information and the table identification sent by the server as the updated control configuration information and the updated table identification to establish a corresponding relationship and then storing the corresponding relationship.

In a specific embodiment, the attribute information of the client maintenance control includes the form identifier and a field identifier corresponding to a service data type for updating the client maintenance control; the method further comprises the following steps:

acquiring maintenance data input by a user in each client maintenance control;

for each maintenance data, verifying the maintenance data according to a corresponding preset legal verification rule;

if each piece of maintenance data passes the verification, generating a maintenance data request according to the attribute information of each client maintenance control, wherein the maintenance data request comprises the form identification, the field identification in each attribute information and each piece of maintenance data;

and sending the maintenance data request to the server.

In one embodiment, the method further comprises:

responding to the query operation of a user, and acquiring a form identifier selected by the user;

generating a client query control on a graphical user interface according to the updated control configuration information;

acquiring query data input by a user;

generating a query condition expression according to the query data;

sending the query conditional expression and the table identifier to the server;

and receiving and displaying query result data returned by the server.

In a second aspect, an embodiment of the present application provides a data processing method, which is applied to a server, and the method includes:

when field information of a table in a database is monitored to be changed, generating control configuration updating information according to the table, wherein the control configuration updating information comprises at least one service data type and a field identifier corresponding to each service data type;

and sending the control configuration updating information and the table identification of the table to a client.

In one embodiment, the method further comprises:

receiving a maintenance data request sent by the client, wherein the maintenance data request comprises a form identifier, a field identifier and maintenance data;

and maintaining the table in the database according to the data maintenance request.

In one embodiment, the method further comprises:

receiving a query condition expression and a table identifier sent by the client;

and if the query condition expression and the query result data corresponding to the table identification are stored in the cache middleware, returning the query result data in the cache middleware to the client.

In a specific embodiment, the method further comprises

If the query result data corresponding to the query condition expression and the table identification is not stored in the cache middleware, generating a database query statement according to the query condition expression and the table identification;

acquiring query result data from a database according to the database query statement;

and returning the query result data to the client.

In one embodiment, the method further comprises:

updating the query times of receiving the query condition expression and the table identifier;

sequencing the stored query condition expressions and table identifications according to the sequence of the query times;

and storing the query conditional expressions and the table identifications in the sorted query conditional expressions and table identifications in the front preset number and the corresponding query result data in the cache middleware.

In a third aspect, an embodiment of the present application provides a data processing apparatus, including:

the communication module is used for receiving control configuration updating information and table identification sent by a server, wherein the control configuration updating information comprises at least one service data type and a field identification corresponding to each service data type;

the processing module is used for updating the stored control configuration information and the table identification according to the control configuration updating information and the table identification to obtain updated control configuration information and updated table identification, and the stored control configuration information and the table identification have a corresponding relation;

an acquisition module to:

and the processing module is further used for updating the client maintenance control on the graphical user interface according to the service data type and the field identifier corresponding to the service data type for each service data type in the updated control configuration information.

In a fourth aspect, an embodiment of the present application provides a data processing apparatus, including:

the processing module is used for generating control configuration updating information according to a table when monitoring that field information of the table in the database changes, wherein the control configuration updating information comprises at least one service data type and a field identifier corresponding to each service data type;

and the communication module is used for sending the control configuration updating information and the table identifier of the table to a client.

In a fifth aspect, an embodiment of the present application provides an electronic device, including:

a processor, a memory, a communication interface;

the memory is used for storing executable instructions of the processor;

wherein the processor is configured to perform the data processing method of any of the first aspect via execution of the executable instructions.

In a sixth aspect, an embodiment of the present application provides an electronic device, including:

a processor, a memory, a communication interface;

the memory is used for storing executable instructions of the processor;

wherein the processor is configured to perform the data processing method of any of the second aspect via execution of the executable instructions.

In a seventh aspect, an embodiment of the present application provides a readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the data processing method described in any one of the first aspect to the second aspect.

In an eighth aspect, an embodiment of the present application provides a computer program product, which includes a computer program, and when the computer program is executed by a processor, the computer program is used to implement the data processing method of any one of the first aspect to the second aspect.

According to the data processing method, the data processing device, the data processing equipment and the data processing medium, when the server side monitors that field information of the table in the database changes, the table identification and the generated control configuration updating information are sent to the client side. The client updates the stored control configuration information and the table identification according to the control configuration update information and the table identification; when a user maintains service data, the client acquires corresponding updated control configuration information according to the table identifier selected by the user, and then updates the client maintenance control on the user graphical interface according to the updated control configuration information. According to the scheme, whether field information changes or not is monitored through the server side, and control configuration updating information and a table identifier are sent to the client side when the field information changes; and when the user maintains the service data, the client updates the client maintenance control according to the updated control configuration information, so that the efficiency of generating the client interface is effectively improved.

Drawings

In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings used in the embodiments or the description of the prior art will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present application, and those skilled in the art can obtain other drawings without inventive labor.

Fig. 1a is a schematic flowchart of a first embodiment of a data processing method provided in the present application;

FIG. 1b is a diagram of a client maintenance interface provided by an embodiment of the present application;

fig. 2 is a schematic flowchart of a second embodiment of a data processing method provided in the present application;

fig. 3 is a schematic flowchart of a third embodiment of a data processing method provided in the present application;

fig. 4a is a schematic flowchart of a fourth embodiment of a data processing method provided in the present application;

FIG. 4b is a diagram of a client query interface provided by an embodiment of the present application;

fig. 5 is a schematic flowchart of a fifth embodiment of a data processing method provided in the present application;

fig. 6 is a schematic structural diagram of a first data processing apparatus according to an embodiment of the present disclosure;

fig. 7 is a schematic structural diagram of a second data processing apparatus according to an embodiment of the present disclosure;

fig. 8 is a first schematic structural diagram of an electronic device provided in the present application;

fig. 9 is a schematic structural diagram of an electronic device according to the second embodiment of the present disclosure.

Detailed Description

In order to make the objects, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are some embodiments of the present application, but not all embodiments. All other embodiments that can be made by one skilled in the art based on the embodiments in the present application in light of the present disclosure are within the scope of the present application.

The terms "first," "second," "third," "fourth," and the like in the description and in the claims of the present application and in the above-described drawings (if any) are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the application described herein are capable of operation in sequences other than those illustrated or described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, 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.

With the development of science and technology, how to better manage data is a concern. In the prior art, data is usually stored in a database in a table form, and when data of an existing field needs to be added, deleted, modified and queried, the data can be implemented by writing codes by a person who knows knowledge of the database. In order to facilitate the operation of the database by a person who does not know the knowledge of the database, a developer can write codes and generate a corresponding client interface for each table.

In a table, if each column corresponds to a header, the field represents the column; if each row corresponds to a header, the field indicates the row.

When a new field is added, a field is deleted, and a field is changed in a table in a database, a user can operate by using an original client interface, and an error may occur, so that a developer can only write a code again to generate a new client interface, the efficiency of generating the client interface is low, and the maintenance efficiency of data is low.

Aiming at the problems in the prior art, the inventor finds that in the process of researching a data processing method, in order to improve the efficiency of generating a front-end interface, a server side can monitor field information of a table in a database, and when the field information is monitored to be changed, control configuration updating information and a table identifier are sent to a client side. After receiving the control configuration updating information and the table identification, the client updates the stored control configuration information and the table representation, and then responds to the table selection operation of the user when the user wants to maintain the data, the table identification selected by the user is obtained, and then the corresponding updated control configuration information is obtained, so that the client maintenance control is generated, the efficiency of generating a client interface is effectively improved, and the efficiency of maintaining the data by the user is also improved. Based on the inventive concept, the data processing scheme in the application is designed.

An application scenario of the data processing method provided by the present application is described below.

For example, in the application scenario, when a worker directly adds, deletes or changes a field to a table in the database, the server may monitor that the field information changes. And then the server side generates control configuration updating information according to the form with the changed field information, and then sends the control configuration updating information and the form identification of the form to the client side.

After receiving the control configuration update information and the table identifier, the client firstly judges whether the table identifier and the corresponding control configuration information are stored or not, if the table identifier and the table identifier are stored, the stored control configuration information needs to be updated into the received control configuration update information, and the table identifier corresponding to the control configuration information is unchanged to obtain the updated control configuration information and the updated table identifier; and if not, the table identification and the control configuration updating information are used as the updated control configuration information and the updated table identification to establish the corresponding relationship and then are stored.

When a user wants to maintain data, the user selects a table that the user wants to maintain, the client can obtain the table identifier of the table, and then searches the corresponding updated control configuration information, and the client maintenance control on the graphical user interface can be updated according to the control configuration information, namely the client maintenance control is displayed on the graphical user interface, so that the user can input maintenance information.

It should be noted that the control may be a time drop box, an input box, a date selection box, etc., and the user may operate the control on the graphical user interface to input data. The control form is not limited in the embodiment of the application, and the control form can be determined according to actual conditions.

It should be noted that the server and the client may be a server, a computer, or a terminal device. The embodiment of the application does not limit the server and the client, and can be selected according to actual conditions.

It should be noted that the above scenario is only an illustration of an application scenario provided in the embodiment of the present application, and the embodiment of the present application does not limit actual forms of various devices included in the scenario, nor limits an interaction manner between the devices, and in a specific application of a scheme, the setting may be performed according to actual requirements.

The technical solution of the present application will be described in detail below with reference to specific examples. It should be noted that the following specific embodiments may be combined with each other, and the same or similar concepts or processes may not be described in detail in some embodiments.

Fig. 1a is a schematic flow chart of a first data processing method provided by the present application, which is used for sending a form identifier and generated control configuration update information to a client when a server monitors that field information of a form in a database changes. The client updates the stored control configuration information and the table identifier, further responds to the table selection operation of the user, and can search the corresponding updated control configuration information according to the acquired table identifier, and further update the condition of the client for maintaining the control. The method in this embodiment may be implemented by software, hardware, or a combination of software and hardware. As shown in fig. 1a, the data processing method specifically includes the following steps:

s101: and when monitoring that the field information of the table in the database changes, the server generates control configuration updating information according to the table.

In this step, after the worker performs operations of field addition, field deletion, and field modification on the table in the database, the server can monitor the operation, and then generate control configuration update information according to the data in the table, where the control configuration update information includes at least one service data type and a field identifier corresponding to each service data type.

Illustratively, table 1 is a database table provided in the embodiments of the present application.

TABLE 1

Weight (ton)	Price (Yuan)	Material of	Time
				5	3000	Pig iron	2022.7.1
8	4000	Cooked iron	2022.7.5
				10	5000	Steel	2022.7.9

Illustratively, in Table 1, the time column is a newly added column, which is also added field information. The control configuration update information generated according to table 1 includes four service data types and four corresponding field identifiers, where the service data types and the corresponding field identifiers are respectively: numerical-weight, numerical-price, character-material, time-date-time.

It should be noted that the table is only an example of a table in a database, and the table, service data in the table, a service data type, a field identifier, and the like are not limited in the embodiment of the present application, and may be determined according to an actual situation.

It should be noted that, for a new table added in the database, the server also generates control configuration update information.

S102: and the server side sends the control configuration updating information and the table identification of the table to the client side.

In this step, after the server generates the control configuration update information, the server needs to send the control configuration update information and the table identifier to the client in order that the subsequent client can generate the control.

S103: and after receiving the control configuration updating information and the table identification sent by the server, the client updates the stored control configuration information and the table identification according to the control configuration updating information and the table identification to obtain the updated control configuration information and the updated table identification.

In this step, after the server sends the control configuration update information and the form identifier to the client, the client may receive the configuration update information and the form identifier, where the control configuration update information includes at least one service data type and a field identifier corresponding to each service data type.

Because the table identifier and the control configuration information corresponding to the table identifier are stored in the client, in order to avoid data repetition and data updating, whether the control configuration information corresponding to the table identifier sent by the server is stored needs to be judged, and if the control configuration information is stored, the stored control configuration information is updated to the control configuration update information sent by the server. And if not, taking the control configuration updating information and the table identification sent by the server as the updated control configuration information and the updated table identification to establish a corresponding relationship and store the corresponding relationship.

S104: and the client responds to the table selection operation of the user and acquires the table identification selected by the user.

In this step, after the client updates the stored control configuration information and the table identifier, the user can maintain the table data, the user can select the table to be maintained on the graphical user interface of the client, and the client can respond to the table selection operation of the user to obtain the table identifier selected by the user.

S105: and the client acquires the updated control configuration information corresponding to the form identifier according to the form identifier.

In this step, after the client acquires the form identifier, the updated control configuration information corresponding to the form identifier selected by the user is acquired from the stored control configuration information according to the corresponding relationship between the form identifier and the control configuration information.

S106: and for each service data type in the updated control configuration information, the client updates the client maintenance control on the graphical user interface according to the service data type and the field identification corresponding to the service data type.

In this step, after the client acquires the updated control configuration information, for each service data type in the control configuration information, the client maintenance control on the graphical user interface is updated according to the service data type and the field identifier corresponding to the service data type. The corresponding relation between the service data type and the client maintenance control form is stored in the client, so that the client maintenance control form can be obtained according to the service data type, and the specific client maintenance control is updated and generated by combining the field identification.

Illustratively, the control configuration information includes: numerical-weight, numerical-price, character-material, time-date-time. The client maintenance control corresponding to the numerical type is in the form of an input box, the client maintenance control corresponding to the character type is in the form of a drop-down box, and the client maintenance control corresponding to the date and time type is in the form of a date selection box. Four client-side maintenance controls can be generated, two input boxes, a drop-down box, and a date selection box. Fig. 1b is a client maintenance interface diagram provided in an embodiment of the present application, and as shown in fig. 1b, there are four client maintenance controls generated according to the update of the control configuration information, an input box corresponding to weight, an input box corresponding to price, a drop-down box corresponding to material, and a date selection box corresponding to time.

It should be noted that the above example is only an example of generating a client maintenance control according to control configuration information and a field identifier, and the embodiment of the present application does not limit a service data type, a client maintenance control, a correspondence between a service data type and a client maintenance control form, and the like, and may be set according to an actual situation.

In the data processing method provided by this embodiment, when monitoring that field information of a table in a database changes, a server generates control configuration update information, and then sends a table identifier and the control configuration update information to a client. And the client updates the stored table identification and control configuration information according to the table identification and control configuration updating information. And when the user uses the client to maintain the table, the client responds to the table selection operation of the user, can acquire the table identification, further acquire the corresponding updated control configuration information, and then update the client to maintain the control. Compared with the prior art that a developer needs to edit codes again to generate a client interface, the method and the device for generating the client interface update the control configuration information and the form identification when the field information changes, and update the client maintenance control according to the control configuration information and the field identification, so that the efficiency of generating the client interface is effectively improved, and the efficiency of maintaining data is also improved.

Fig. 2 is a schematic flow diagram of a second embodiment of the data processing method provided in the present application, and on the basis of the foregoing embodiments, in the embodiment of the present application, after receiving control configuration update information and a table identifier sent by a server, a client updates the stored control configuration information and the table identifier according to whether control configuration information corresponding to the table identifier is already stored. As shown in fig. 2, the data processing method specifically includes the following steps:

s201: and receiving control configuration updating information and table identification sent by the server.

In this step, after the server monitors that the field information changes and sends the form identifier and the generated control configuration update information to the client, the client can receive the control configuration update information and the form identifier sent by the server.

S202: judging whether control configuration information corresponding to the table identification sent by the server side is stored; if the control configuration information corresponding to the table identifier sent by the stored server has been stored, executing S203; and if the control configuration information corresponding to the table identifier sent by the server is not stored, executing S204.

S203: and updating the control configuration information into control configuration updating information sent by the server, wherein the table identifier corresponding to the control configuration information is unchanged, and the updated control configuration information and the updated table identifier are obtained.

S204: and establishing a corresponding relation between the updated control configuration information and the updated table identification and storing the control configuration information and the table identification which are sent by the server.

In the above steps, after the client receives the control configuration update information and the table identifier sent by the server, in order to prevent data duplication and update data, it is necessary to determine whether the control configuration information corresponding to the table identifier sent by the server is stored in the client.

If the control configuration information corresponding to the table identifier sent by the server side is stored, in order to reduce data repetition, the control configuration information is updated to the control configuration update information sent by the server side, the table identifier corresponding to the control configuration information is not changed, the updated control configuration information and the updated table identifier are obtained, and at this time, the updated control configuration information and the updated table identifier still have a corresponding relation.

If the control configuration information corresponding to the table identifier sent by the server is not stored, in order to generate a client maintenance control for subsequent updating, the control configuration information and the table identifier sent by the server need to be used as the updated control configuration information and the updated table identifier to establish a corresponding relationship and then stored.

In the data processing method provided by this embodiment, after receiving the table identifier and the control configuration update information sent by the server, the client determines whether control configuration information corresponding to the table identifier sent by the server has been stored; if the control configuration information is stored, updating the control configuration information; if the table identifier and the control configuration update information are not stored, the table identifier and the control configuration update information are used as the updated table identifier and the updated control configuration information to establish a corresponding relation and then are stored, and data repetition is effectively reduced.

Fig. 3 is a schematic flow chart of a third embodiment of the data processing method provided by the present application, where on the basis of the above embodiments, after a client updates a client maintenance control, the client performs validity check on maintenance data input by a user to generate a data maintenance request, and sends the data maintenance request to a server. The server side will explain the situation of maintaining data according to the data maintenance request. As shown in fig. 3, the data processing method specifically includes the following steps:

s301: and the client acquires the maintenance data input by the user in each client maintenance control.

In this step, after the client generates the client maintenance control, the user can perform data maintenance through the client maintenance control, and the client can acquire the maintenance data input by the user at each client maintenance control.

S302: and for each maintenance data, the client checks the maintenance data according to the corresponding preset legal check rule.

In this step, after the client acquires the maintenance data, in order to ensure that the maintenance data input by the user conforms to the rules, the client checks the maintenance data according to the corresponding preset legal check rule for each maintenance data.

It should be noted that the preset legal verification rule may be a verification string digit verification, an e-mail legal verification, a password legal verification, a pure number verification, or the like, or may be a user-defined verification rule. The embodiment of the application does not limit the preset legal verification rule and can select the legal verification rule according to the actual situation.

S303: the client judges whether each piece of maintenance data passes the verification; if each check data passes the check, executing S305; if there is a check data failure, S304 is executed.

S304: the client outputs a data error prompt message.

S305: and the client generates a maintenance data request according to the attribute information of each client maintenance control.

S306: and the client sends the maintenance data request to the server.

In the above steps, after the client checks each piece of maintenance data, a check result can be obtained, and it is further determined whether each piece of maintenance data passes the check.

If each piece of verification data passes the verification, the maintenance data input by the user is proved to be in accordance with the rule, a maintenance data request can be generated according to the attribute information of each client maintenance control, the attribute information comprises a form identifier and a field identifier corresponding to the data type of the updated client control, and the maintenance data request comprises the form identifier, the field identifier in each piece of attribute information and each piece of maintenance data. And then sending the maintenance data request to the server.

If the verification data does not pass, the maintenance data input by the user does not accord with the rules, the user needs to input the data again, the client side outputs a data error prompt message, and the data error prompt message can comprise the maintenance data which does not pass the verification and the corresponding verification rules.

It should be noted that the data error prompt message output by the client may be a data error prompt message displayed on the display, a data error prompt message played through a speaker, or a data error prompt message sent to the terminal device of the user. The embodiment of the application does not limit the way of outputting the data error prompt message by the client, and can be selected according to the actual situation.

S307: and after receiving the data maintenance request sent by the client, the server maintains the table in the database according to the data maintenance request.

In this step, after the client sends a data maintenance request to the server, the server can receive the data maintenance request, and the data maintenance request includes a form identifier, a field identifier, and maintenance data. And then the server can search the corresponding table and field from the database according to the table identification and the field identification, and further can maintain the data in the table according to the maintenance data.

In the data processing method provided by this embodiment, the client performs validity check on the maintenance data input by the user, and sends a data maintenance request to the server after the check is passed. And the server side maintains the table in the database according to the data maintenance request. The accuracy of data maintenance is effectively improved, and the data in the database is maintained.

Fig. 4a is a schematic flow chart of a fourth embodiment of the data processing method provided by the present application, where on the basis of the above embodiments, in the embodiment of the present application, a client generates a client query control in response to a query operation of a user, acquires query data, and sends the generated query condition expression to a server. And the server acquires the query result data and returns the query result data to the client for explaining the condition according to whether the cache middleware has the query data corresponding to the query conditional expression. As shown in fig. 4a, the data processing method specifically includes the following steps:

s401: and the client responds to the query operation of the user and acquires the table identifier selected by the user.

In this step, when the user wants to query the data in the database, the user can perform a query operation on the graphical user interface of the client, and the client can obtain the form identifier selected by the user in response to the query operation of the user.

S402: and the client acquires the updated control configuration information corresponding to the form identifier according to the form identifier.

S403: and the client generates a client query control on the graphical user interface according to the updated control configuration information.

In the above steps, after the client obtains the table identifier, since the client has the corresponding relationship between the table identifier and the control configuration information, the updated control configuration information corresponding to the table identifier can be obtained according to the table identifier. And generating a client query control according to the control configuration information.

For example, fig. 4b is a client query interface diagram provided in the embodiment of the present application, and as shown in fig. 4b, the control configuration information includes: numerical-weight, numerical-price, character-material, time-date-time. The generated client query control is a drop-down box, and after a user clicks the drop-down box, four options of weight, price, material and time are displayed.

It should be noted that the above example is only an example of a query interface of a client, and the embodiment of the present application does not limit a client maintenance control, control configuration information, and the like, and may be determined according to an actual situation.

S404: the client acquires query data input by a user.

S405: and the client generates a query condition expression according to the query data.

S406: and the client sends the query conditional expression and the table identification to the server.

In the above steps, after the client generates the client query control, the user can input the query data through the client query control, and the client can obtain the query data input by the user. Because the query data are all characters or numbers, in order to better query data, a query condition expression needs to be generated according to the query data, and the query condition expression and the table identifier are sent to the server.

Optionally, after the client obtains the query data input by the user, the client may also perform validity check on the query data, and when the check fails to pass the query data, a data error prompt message may be output to prompt the user that the data input is incorrect and the query data needs to be input again.

Optionally, for data security, the client may further encrypt the query conditional expression and the table identifier and send the encrypted query conditional expression and the table identifier to the server.

Illustratively, a user wants to query the price of pig iron on 7 months and 1 days in 2021, after inputting corresponding query data, the client can acquire the query data and perform validity check on the query data, so as to generate a query condition expression { "material = pig iron", "time =2021.7.1" }.

It should be noted that the above examples are only examples of query data and query conditional expressions, and the query data and the query conditional expressions are not limited in the embodiments of the present application and may be determined according to actual situations.

S407: after receiving the query condition expression and the table identification sent by the client, the server judges whether query result data corresponding to the query condition expression and the table identification are stored in the cache middleware or not; if the query result data corresponding to the query condition expression and the table identifier has been stored in the cache middleware, executing S408; if the query result data corresponding to the query conditional expression and the table identifier is not stored in the cache middleware, S409 is executed.

S408: and the server side returns the query result data in the cache middleware to the client side.

In the above steps, after the client sends the query condition expression and the table identifier to the server, the server can receive the query condition expression and the table identifier, and then the server judges whether the cache middleware stores query result data corresponding to the query condition expression and the table identifier.

If the query result data corresponding to the query condition expression and the table identifier are stored in the cache middleware, the server side can directly return the query result data in the cache middleware to the client side.

S409: and the server generates a database query statement according to the query condition expression and the table identifier.

S410: and the server side acquires query result data from the database according to the database query statement.

S411: and the server returns the query result data to the client.

In the above step, if the cache middleware does not store the query result data corresponding to the query condition expression and the table identifier, it indicates that the query result data needs to be acquired from the database.

In order to obtain query result data from a database, a database query statement is required to be generated, and the database query statement has certain syntax rules, such as the specific characters, the sequence of parameters in the statement and the like, so that the server generates the database query statement conforming to the syntax rules according to the query condition expression and the table identifier.

And then obtaining query result data from the database according to the database query statement, wherein the database query statement is generated by a query condition expression and a table identifier, and the query condition expression is generated according to query data, so that the server finds the table which the user wants to query according to the database query statement, and further finds the data which the user wants to query. And the server returns the query result data to the client.

Optionally, if the query condition expression and the table identifier sent by the client are encrypted, the server decrypts the encrypted query condition expression and the table identifier and then generates a database query statement.

Optionally, the query result data may further include data for displaying on a graphical user interface of the client, such as: some english acronyms exist in the query result data, and the chinese names corresponding to the english acronyms need to be added to the query result data.

S412: and the client receives and displays the query result data returned by the server.

In this step, after the server returns the query result data to the client, the client can receive the query result data, and then the query result data is displayed on the graphical user interface of the client for the user to view.

In the data processing method provided by this embodiment, the query control of the client is generated when the user queries data, the query condition expression is further generated according to the query data, and then the query condition expression and the table identifier are sent to the server. The server judges whether the query condition expression and the query result data corresponding to the table identification are stored in the cache middleware or not, and returns the query result data in the cache middleware to the client if the query result data are stored; if not, searching the query result data from the database and sending the query result data to the client, thereby effectively reducing the query pressure of the database.

Fig. 5 is a schematic flow chart of a fifth embodiment of the data processing method provided by the present application, and on the basis of the above embodiments, the present application describes a situation in which after receiving a query condition expression and a table identifier, a server updates query times of receiving the query condition expression and the table identifier, and updates a query condition expression, a table identifier, and a query data result in cache middleware according to the query times. As shown in fig. 5, the data processing method specifically includes the following steps:

s501: and updating the query times of receiving the query condition expression and the table identification.

In this step, the server receives the query condition expression and the table identifier sent by the client, and after obtaining the query result data, the server will judge whether the query condition expression and the table identifier sent by the client have been stored, and if yes, the query times are updated; if not, storing the query number and setting the corresponding query number to be 1.

S502: and sequencing the stored query condition expressions and the table identifications according to the sequence of the query times.

S503: and storing the query condition expressions and the table identifications in the front preset number and the corresponding query result data in the sorted query condition expressions and table identifications to a cache middleware.

In the above steps, after the query times are updated by the server, the stored query condition expressions and table identifiers are sorted according to the sequence of the query times, and then the query condition expressions and the table identifiers in the sorted query condition expressions and table identifiers, which are in the front preset number, and the corresponding query result data are stored in the cache middleware.

The more the query times are, the greater the probability of querying the data next time is shown, in order to reduce the database pressure and improve the query hit rate, the query condition expressions and the table identifiers which are in the sorted order and are in the front preset number are stored to the cache middleware together with the corresponding query result data.

It should be noted that the preset number may be 5, 10, or 20, and the preset number is not limited in the embodiment of the present application and may be selected according to actual situations.

It should be noted that, after the user maintains the data in the database, the server side also updates the cache middleware data.

In the data processing method provided by this embodiment, the stored query condition expressions and table identifiers are sorted, and a preset number of query condition expressions and table identifiers in the sorted query condition expressions and table identifiers, and corresponding query result data are stored in the cache middleware, so that query pressure of the database is reduced, and data query efficiency can also be improved.

The following are embodiments of the apparatus of the present application that may be used to perform embodiments of the method of the present application. For details which are not disclosed in the embodiments of the apparatus of the present application, reference is made to the embodiments of the method of the present application.

Fig. 6 is a schematic structural diagram of a first data processing apparatus according to an embodiment of the present disclosure. As shown in fig. 6, the data processing apparatus 60 includes:

the communication module 61 is configured to receive control configuration update information and a table identifier sent by a server, where the control configuration update information includes at least one service data type and a field identifier corresponding to each service data type;

the processing module 62 is configured to update the stored control configuration information and the table identifier according to the control configuration update information and the table identifier, so as to obtain updated control configuration information and an updated table identifier, where the stored control configuration information and the table identifier have a correspondence;

an obtaining module 63, configured to:

the processing module 62 is further configured to update, for each service data type in the updated control configuration information, a client maintenance control on a graphical user interface according to the service data type and a field identifier corresponding to the service data type.

Further, the processing module 62 is specifically configured to:

if the control configuration information corresponding to the table identifier sent by the server is determined to be stored, updating the control configuration information to the control configuration update information sent by the server, and if the table identifier corresponding to the control configuration information is not changed, obtaining the updated control configuration information and the updated table identifier;

Further, the attribute information of the client maintenance control includes the form identifier and a field identifier corresponding to the service data type for updating the client maintenance control; the obtaining module 63 is further configured to obtain maintenance data input by the user at each client maintenance control;

further, the processing module 62 is further configured to:

further, the communication module 61 is further configured to send the maintenance data request to the server.

Further, the obtaining module 63 is further configured to, in response to a query operation of a user, obtain a table identifier selected by the user;

further, the processing module 62 is further configured to:

further, the obtaining module 63 is further configured to obtain query data input by a user;

further, the processing module 62 is further configured to generate a query condition expression according to the query data;

further, the communication module 61 is further configured to:

and receiving and displaying query result data returned by the server.

The data processing apparatus provided in this embodiment is configured to execute the technical solution of the client in any one of the foregoing method embodiments, and the implementation principle and the technical effect are similar, which are not described herein again.

Fig. 7 is a schematic structural diagram of a second data processing apparatus according to an embodiment of the present disclosure; as shown in fig. 7, the data processing apparatus 70 includes:

the processing module 71 is configured to, when it is monitored that field information of a table in the database changes, generate control configuration update information according to the table, where the control configuration update information includes at least one service data type and a field identifier corresponding to each service data type;

a communication module 72, configured to send the control configuration update information and the table identifier of the table to the client.

Further, the communication module 72 is further configured to receive a maintenance data request sent by the client, where the maintenance data request includes a table identifier, a field identifier, and maintenance data;

further, the processing module 71 is further configured to maintain the table in the database according to the data maintenance request.

Further, the communication module 72 is further configured to:

Further, the processing module 71 is further configured to:

if the query result data corresponding to the query condition expression and the table identification are not stored in the cache middleware, generating a database query statement according to the query condition expression and the table identification;

further, the communication module 72 is further configured to return the query result data to the client.

Further, the communication module 72 is further configured to:

and storing the query condition expressions and the table identifications in the front preset number and the corresponding query result data in the sorted query condition expressions and table identifications to the cache middleware.

The data processing apparatus provided in this embodiment is configured to execute the technical solution of the server in any of the foregoing method embodiments, and the implementation principle and the technical effect are similar, which are not described herein again.

Fig. 8 is a schematic structural diagram of an electronic device according to the present application. As shown in fig. 8, the electronic apparatus 80 includes:

a processor 81, a memory 82, and a communication interface 83;

the memory 82 is used for storing executable instructions of the processor 81;

wherein the processor 81 is configured to execute the technical solution of the client in any of the foregoing method embodiments via executing the executable instructions.

Alternatively, the memory 82 may be separate or integrated with the processor 81.

Optionally, when the memory 82 is a device independent from the processor 81, the electronic device 80 may further include:

the bus 84, the memory 82 and the communication interface 83 are connected with the processor 81 through the bus 84 and communicate with each other, and the communication interface 83 is used for communicating with other devices.

Alternatively, the communication interface 83 may be implemented by a transceiver. The communication interface is used for realizing communication between the database access device and other equipment (such as a client, a read-write library and a read-only library). The memory may comprise Random Access Memory (RAM) and may also include non-volatile memory (non-volatile memory), such as at least one disk memory.

The bus 84 may be a Peripheral Component Interconnect (PCI) bus, an Extended Industry Standard Architecture (EISA) bus, or the like. The bus may be divided into an address bus, a data bus, a control bus, etc. For ease of illustration, only one thick line is shown, but this does not mean that there is only one bus or one type of bus.

The processor may be a general-purpose processor, including a central processing unit CPU, a Network Processor (NP), and the like; but also a digital signal processor DSP, an application specific integrated circuit ASIC, a field programmable gate array FPGA or other programmable logic device, discrete gate or transistor logic, discrete hardware components.

The electronic device is configured to execute the technical solution of the client in any of the foregoing method embodiments, and the implementation principle and technical effect are similar, which are not described herein again.

Fig. 9 is a schematic structural diagram of an electronic device according to the present application. As shown in fig. 9, the electronic device 90 includes:

a processor 91, a memory 92, and a communication interface 93;

the memory 92 is used for storing executable instructions of the processor 91;

wherein the processor 91 is configured to execute the technical solution of the server in any of the foregoing method embodiments by executing the executable instruction.

Alternatively, the memory 92 may be separate or integrated with the processor 91.

Optionally, when the memory 92 is a device independent from the processor 91, the electronic device 90 may further include:

the bus 94, the memory 92 and the communication interface 93 are connected to the processor 91 through the bus 94 and communicate with each other, and the communication interface 93 is used for communicating with other devices.

Optionally, the communication interface 93 may be implemented by a transceiver. The communication interface is used for realizing communication between the database access device and other equipment (such as a client, a read-write library and a read-only library). The memory may comprise Random Access Memory (RAM), and may also include non-volatile memory, such as at least one disk memory.

The bus 94 may be a Peripheral Component Interconnect (PCI) bus, an Extended Industry Standard Architecture (EISA) bus, or the like. The bus may be divided into an address bus, a data bus, a control bus, etc. For ease of illustration, only one thick line is shown, but this does not mean that there is only one bus or one type of bus.

The electronic device is configured to execute the technical solution of the server in any of the foregoing method embodiments, and the implementation principle and the technical effect are similar, which are not described herein again.

The embodiment of the present application further provides a readable storage medium, on which a computer program is stored, and the computer program, when executed by a processor, implements the technical solutions provided by any of the foregoing method embodiments.

The embodiment of the present application further provides a computer program product, which includes a computer program, and the computer program is used for implementing the technical solution provided by any of the foregoing method embodiments when being executed by a processor.

Those of ordinary skill in the art will understand that: all or a portion of the steps of implementing the above-described method embodiments may be performed by hardware associated with program instructions. The program may be stored in a computer-readable storage medium. When executed, the program performs steps comprising the method embodiments described above; and the aforementioned storage medium includes: various media that can store program codes, such as ROM, RAM, magnetic or optical disks.

Finally, it should be noted that: the above embodiments are only used for illustrating the technical solutions of the present application, and not for limiting the same; although the present application has been described in detail with reference to the foregoing embodiments, it should be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some or all of the technical features may be equivalently replaced; and the modifications or the substitutions do not make the essence of the corresponding technical solutions depart from the scope of the technical solutions of the embodiments of the present application.

Claims

1. A data processing method is applied to a client, and the method comprises the following steps:

2. The method according to claim 1, wherein the updating the stored control configuration information and the table identifier according to the control configuration update information and the table identifier to obtain updated control configuration information and updated table identifier comprises:

3. The method according to claim 1 or 2, wherein the attribute information of the client maintenance control comprises the table identifier and a field identifier corresponding to a service data type for updating the client maintenance control; the method further comprises the following steps:

acquiring maintenance data input by a user in each client maintenance control;

and sending the maintenance data request to the server.

4. The method of claim 3, further comprising:

acquiring query data input by a user;

generating a query condition expression according to the query data;

and receiving and displaying query result data returned by the server.

5. A data processing method is applied to a server side, and the method comprises the following steps:

6. The method of claim 5, further comprising:

7. The method of claim 5 or 6, further comprising:

receiving a query condition expression and a table identification sent by the client;

and if the query result data corresponding to the query conditional expression and the table identifier are stored in the cache middleware, returning the query result data in the cache middleware to the client.

8. The method of claim 7, further comprising

and returning the query result data to the client.

9. The method of claim 8, further comprising:

10. A data processing apparatus, comprising:

an acquisition module to:

and the processing module is further configured to update, for each service data type in the updated control configuration information, a client maintenance control on a graphical user interface according to the service data type and a field identifier corresponding to the service data type.

11. A data processing apparatus, characterized by comprising:

and the communication module is used for sending the control configuration updating information and the table identification of the table to a client.

12. An electronic device, comprising:

a processor, a memory, a communication interface;

the memory is used for storing executable instructions of the processor;

wherein the processor is configured to perform the data processing method of any of claims 1 to 4 via execution of the executable instructions.

13. An electronic device, comprising:

a processor, a memory, a communication interface;

the memory is used for storing executable instructions of the processor;

wherein the processor is configured to perform the data processing method of any of claims 5 to 9 via execution of the executable instructions.

14. A readable storage medium on which a computer program is stored, which computer program, when being executed by a processor, carries out the data processing method of any one of claims 1 to 9.

15. A computer program product, comprising a computer program which, when executed by a processor, is adapted to carry out the data processing method of any one of claims 1 to 9.