CN110175305B - Data processing method, data processing device, computer equipment and storage medium - Google Patents
Data processing method, data processing device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN110175305B CN110175305B CN201910367278.5A CN201910367278A CN110175305B CN 110175305 B CN110175305 B CN 110175305B CN 201910367278 A CN201910367278 A CN 201910367278A CN 110175305 B CN110175305 B CN 110175305B
- Authority
- CN
- China
- Prior art keywords
- data
- server
- browser
- ocx control
- processing
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/957—Browsing optimisation, e.g. caching or content distillation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/958—Organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/02—Protocols based on web technology, e.g. hypertext transfer protocol [HTTP]
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The application provides a data processing method, a data processing device, computer equipment and a storage medium, wherein the method comprises the following steps: the browser responds to the data query operation of a user and sends a data query request to the server; the browser receives data returned by the server in response to the data query request through the OCX control, wherein the OCX control is embedded in the browser, and the data returned by the server is JSON formatted data; and the browser processes the received data through the OCX control and displays the processed data. According to the data processing method, the data are received, processed and displayed through the OCX control, so that hundreds of thousands of data can be loaded and processed, the data analysis processing efficiency is improved, the technical problem that an IE (Internet Explorer) end in the prior art cannot load a large amount of data is solved, and the technical effects of loading and processing hundreds of thousands of data, effectively improving the data processing efficiency and improving the user experience are achieved.
Description
Technical Field
The present application relates to the field of computer technologies, and in particular, to a data processing method and apparatus, a computer device, and a storage medium.
Background
Generally, in a system of a B/S (Browser/Server) structure, a client loads and presents data using an IE Browser. However, when a large amount of data is directly loaded and displayed in an IE browser, the problem of slow, fake and even crash of the browser occurs.
At present, in the bank account cancellation business, a large amount of account details (for example, account cancellation data of more than one hundred thousand orders of magnitude) are displayed and checked every day, and the phenomenon of death or even breakdown can occur when the account details are directly loaded and displayed in an IE browser.
In view of the above problems, no effective solution has been proposed.
Disclosure of Invention
The embodiment of the application provides a data processing method and device, computer equipment and a storage medium, and aims to solve the problem that an IE terminal in the prior art cannot load a large amount of data.
The embodiment of the application provides a data processing method, which comprises the following steps: the browser responds to the data query operation of a user and sends a data query request to the server; the browser receives data returned by the server in response to the data query request through the OCX control, wherein the OCX control is embedded in the browser, and the data returned by the server is JSON formatted data; and the browser processes the received data through the OCX control and displays the processed data.
In one embodiment, the browser processes the received data through the OCX control, including: and the browser analyzes the received JSON formatted data through the OCX control.
In one embodiment, the browser processes the received data through the OCX control, and further includes: the browser decompresses the received data through the OCX control; and/or the browser decrypts the received data through the OCX control.
In one embodiment, after the browser processes the received data through the OCX control and displays the processed data, the method further includes: the browser receives a data operation instruction input by a user through an OCX control; the browser responds to the data operation instruction through the OCX control and performs operation processing on the processed data, wherein the operation processing comprises at least one of the following steps: searching, sorting, calculating, checking, sending a message and printing.
In one embodiment, after the browser detects a data operation instruction input by a user through the OCX control, the method further includes: the OCX control determines whether operation processing corresponding to a data operation instruction input by a user needs to process data at a server side; under the condition that the data on the server side needs to be processed, the OCX control sends the URL corresponding to the data operation instruction to the browser; and the browser responds to the URL and sends a request message to the server, wherein the request message carries a data operation instruction.
An embodiment of the present application further provides a data processing apparatus, located in a browser, including: the sending module is used for responding to the data query operation of the user and sending a data query request to the server; the receiving module is used for receiving data returned by the server in response to the data query request through the OCX control, wherein the OCX control is embedded in the browser, and the data returned by the server is JSON formatted data; and the processing module is used for processing the received data through the OCX control and displaying the processed data.
An embodiment of the present invention further provides a computer device, which includes a processor and a memory for storing processor-executable instructions, where the processor executes the instructions to implement the steps of the data processing method described in any of the above embodiments.
Embodiments of the present invention further provide a computer-readable storage medium, on which computer instructions are stored, and when executed, the instructions implement the steps of the data processing method described in any of the above embodiments.
An embodiment of the present application further provides a data processing method, including: the server receives a data query request sent by the browser in response to a data query operation of a user; the server responds to the data query request to acquire data from the database; the server carries out JSON formatting processing on the acquired data; and the server sends the JSON formatted data to an OCX control for processing and displaying, wherein the OCX control is embedded in the browser.
In one embodiment, after the server performs JSON formatting on the acquired data, the method further includes: the server compresses the acquired data; and/or the server encrypts the acquired data.
In one embodiment, after the server sends the JSON-formatted data to the OCX control for processing and presentation, the method further includes: the method comprises the steps that a server receives a request message sent by a browser in response to a data operation instruction input by a user, wherein the request message carries the data operation instruction; and responding to the received request message, and operating and processing the data on the server side by the server.
In one embodiment, after the server receives a request message sent by the browser in response to a data operation instruction input by a user, the method further includes: the server determines whether the operation processing corresponding to the received request message needs to process the data at the database side; and under the condition that the data at the database side needs to be processed, the server sends an operation request to the database according to the request message, wherein the operation request carries a data operation instruction.
An embodiment of the present application further provides a data processing apparatus, located in a server, including: the receiving module is used for receiving a data query request sent by a browser in response to a data query operation of a user; the acquisition module is used for responding to the data query request to acquire data from the database; the preprocessing module is used for carrying out JSON formatting processing on the acquired data; and the sending module is used for sending the JSON formatted data to an OCX control for processing and displaying, wherein the OCX control is embedded in the browser.
An embodiment of the present invention further provides a computer device, which includes a processor and a memory for storing processor-executable instructions, where the processor executes the instructions to implement the steps of the data processing method described in any of the above embodiments.
Embodiments of the present invention further provide a computer-readable storage medium, on which computer instructions are stored, and when executed, the instructions implement the steps of the data processing method described in any of the above embodiments.
In the embodiment of the application, a data processing method is provided, wherein when a user queries data, a browser sends a data query request to a server, the browser receives JSON-formatted data returned by the server in response to the data query request through an embedded OCX control, processes the received data through the OCX control, and displays the processed data. In the method, the data returned by the server is JSON formatted data, the JSON format is a lightweight data exchange format, the network transmission efficiency can be effectively improved, the network resources are saved, and meanwhile, the JSON format is easy for machine analysis, so that the difficulty of data analysis of the OCX control at the browser end can be reduced, and the data processing efficiency is improved. In addition, because the OCX control is embedded in the browser and receives, analyzes, processes and displays the data returned by the server through the OCX control, compared with the prior art that a large amount of data is directly loaded and displayed through the browser, the processing pressure of the browser can be reduced by receiving and processing the data through the OCX control, the efficiency of data analysis and processing is improved, and therefore a large amount of data can be loaded. By the scheme, the technical problem that an IE terminal in the prior art cannot load a large amount of data is solved, and the technical effects of loading and processing hundreds of thousands of data, effectively improving data processing efficiency and improving user experience are achieved.
Drawings
The accompanying drawings, which are included to provide a further understanding of the application, are incorporated in and constitute a part of this application, and are not intended to limit the application. In the drawings:
FIG. 1 shows a flow diagram of a data processing method in an embodiment of the present application;
FIG. 2 is a flow chart illustrating a data processing method in an embodiment of the present application;
fig. 3 shows a sequence diagram of a data processing method in an embodiment of the present application;
FIG. 4 shows a schematic diagram of a data processing apparatus in an embodiment of the present application;
FIG. 5 shows a schematic diagram of a data processing apparatus in an embodiment of the present application;
fig. 6 shows a schematic diagram of a computer device in an embodiment of the application.
Detailed Description
The principles and spirit of the present application will be described with reference to a number of exemplary embodiments. It should be understood that these embodiments are given solely for the purpose of enabling those skilled in the art to better understand and to practice the present application, and are not intended to limit the scope of the present application in any way. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.
As will be appreciated by one skilled in the art, embodiments of the present application may be embodied as a system, apparatus, device, method or computer program product. Accordingly, the present disclosure may be embodied in the form of: entirely hardware, entirely software (including firmware, resident software, micro-code, etc.), or a combination of hardware and software.
An embodiment of the present invention provides a data processing method, as shown in fig. 1, which may include the following steps:
step S101, the browser responds to the data query operation of the user and sends a data query request to the server.
The B/S structure is a network structure mode after WEB is started, and as long as a browser, such as Netscape Navigator or Internet Explorer, is installed on a client, the client can perform data interaction with a server through the browser. The server may be a single server, a server cluster, or a cloud server, and the specific composition forms the present application without limitation. The client installed with the browser may be a desktop computer, a notebook, a mobile phone terminal, a PDA, etc., and the present application is not limited to the presentation formation of the client.
Generally, a user opens a browser and inputs a user name and a password for logging in, and after the user provides an operation of querying data, the browser responds to the data query operation of the user and sends a data query request to a server by using an Http protocol through an interface.
In step S102, the browser receives data returned by the server in response to the data query request through an Object Linking and Embedding (OLE) Control Extension (OCX) Control, where the OCX Control is embedded in the browser, and the data returned by the server is JSON-formatted data. The JSON formatting refers to converting the obtained data into the JSON format by the server.
Specifically, after receiving a data query request, the server acquires corresponding data from the database according to the request, performs JSON formatting on the acquired data, and sends the processed data to an OCX control embedded in the browser. The OCX control is embedded into a JSP page (Java Server Pages ) of the browser, and the Server can directly send JSON formatted data to the OCX control by directly establishing an Http link with the Server in the OCX control, that is, the browser receives the JSON formatted data returned by the Server in response to the data query request through the OCX control.
And step S103, the browser processes the received data through the OCX control and displays the processed data.
Specifically, after receiving the JSON-formatted data, the OCX control may process the received data, convert the data into a form readable by a user, and display the data to the user according to a preset format.
In the embodiment, the data returned by the server is the data formatted by the JSON, and the JSON format is a lightweight data exchange format, so that the network transmission efficiency can be effectively improved, the network resources are saved, and meanwhile, the JSON format is easy for machine analysis, so that the difficulty of analyzing the data by the OCX control at the browser end can be reduced, and the data processing efficiency is improved. In addition, because the OCX control is embedded in the browser and the data returned by the server is analyzed, processed and displayed through the OCX control, compared with the prior art that a large amount of data are directly loaded and displayed through the browser, the processing pressure of the browser can be reduced by receiving and processing the data through the OCX control, the efficiency of data analysis and processing is improved, a large amount of data can be loaded, the user experience can be improved, and the response speed of the system is improved.
Because the data received by the OCX control is JSON-formatted data, in some embodiments of the present application, the processing, by the browser, of the received data through the OCX control may include: and the browser analyzes the received JSON formatted data through the OCX control. By the mode, the JSON formatted data can be analyzed into a user readable form through the OCX control, and a user can conveniently perform subsequent processing on the displayed data.
Considering that a large amount of data needs to be loaded in banking business and the banking business has high requirements on data security, before the server sends the data to the OCX control, the data can be compressed and/or encrypted in addition to the JSON formatting of the data, so that the data received by the OCX control is JSON formatted, compressed and/or encrypted data. Therefore, in some embodiments of the present application, the processing, by the browser, of the received data through the OCX control may further include: the browser decompresses the received data through the OCX control; and/or the browser decrypts the received data through the OCX control. By the mode, after the data sent by the server are received, the OCX control decompresses, decrypts and/or analyzes the received data to obtain the data which can be read by the user and displays the data to the user, so that the data transmission rate can be increased, the data transmission safety can be improved, and the data processing efficiency and safety can be further improved.
The data processing method can be applied to bank account cancellation business, in the bank account cancellation business, a large number of account details are displayed and checked every day, after the OCX control displays the processed data to a user, the user can perform various operation processing on the displayed data, such as inquiry, sorting, printing, message sending, cancellation and the like. Therefore, in some embodiments of the present application, after the browser processes the received data through the OCX control and displays the processed data, the method may further include: the browser receives a data operation instruction input by a user through an OCX control; the browser responds to the data operation instruction through the OCX control and performs operation processing on the processed data, wherein the operation processing comprises at least one of the following steps: searching, sorting, calculating, checking, sending a message and printing.
In order to improve the user operation friendliness, a plurality of buttons and shortcut keys can be arranged on the OCX control, so that the OCX control is convenient for the user to use. That is, besides decompression, decryption, parsing and window display of JSON format can be completed through the OCX control, other processing can be performed on data through the OCX control, for example, at least one of the following may be included but not limited to: searching, sorting, calculating, checking, sending a message and printing. For example, one-to-one or one-to-many combined search calculation can be performed through the OCX control (for example, if a plurality of pieces of data are selected on a first party, a plurality of pieces of data are automatically selected on a second party, the amount of money of the data of the second party is consistent with that of the data of the first party, and the date of origin and destination is consistent with that of the data of the first party), and after the data are selected by a user, direct verification can be performed by clicking a right button without clicking other buttons, so that verification speed can be increased. The displayed data can also be sorted according to a sorting operation instruction input by a user through the OCX control, for example, the displayed data are sorted according to the daily, amount, number, service type and the like. In addition, for example, when the user confirms that the account details match, the message needs to be sent according to the selected record, so when the user selects the record and clicks the "send message" button, the URL can be generated according to the selected data through the OCX control and sent to the browser, the browser sends a request message to the server according to the URL, and the server generates and sends out a transaction message according to the received request message. In addition, the OCX control may also be provided with the following shortcut keys, for example: CTRL + F, can carry on the tea axis from several hundred thousand data according to money amount, serial number, daily of rest and so on input; CTRL + P, which can print the selected record; CTRL + M, may adjust the price for the recording, remarks, etc.
The data processing method in the embodiment can respond to the operation instruction of the user through the OCX control to carry out various processing on the data displayed in the OCX window, and various buttons and shortcut keys are preset in the OCX control, so that the user can more conveniently and quickly process the data, the user experience is improved, the human-computer interaction is more friendly, in addition, the OCX control has high processing speed, the phenomenon of false collapse can not occur, hundreds of thousands of data can be displayed, processed and operated, and the processing efficiency of businesses such as bank account cancellation and the like is greatly improved.
It is considered that some operation processes, such as the above-mentioned messaging operation, need to be processed at the server side. Therefore, in some embodiments of the present application, after the browser detects a data operation instruction input by a user through the OCX control, the method may further include: the OCX control determines whether operation processing corresponding to a data operation instruction input by a user needs to process data at a server side; under the condition that the data on the server side needs to be processed, the OCX control sends the URL corresponding to the data operation instruction to the browser; and the browser responds to the URL and sends a request message to the server, wherein the request message carries a data operation instruction.
After a user clicks a message button to send a message operation instruction, the OCX control determines whether message sending processing corresponding to the message sending operation instruction input by the user needs to process data on the server side according to a preset rule, where the preset rule is set by a developer according to an actual situation when the OCX control is developed, for example, the data on the server side needs to be processed for the message sending operation. Under the condition that the data at the server side needs to be processed, the OCX control sends a URL corresponding to the data operation instruction to the browser, the browser responds to the URL and sends a request message to the server, wherein the request message carries a message sending operation instruction, and then the server performs corresponding operation on the data at the server side according to the received request message, for example, transaction messages are generated and sent out. In another example, when a user inputs an operation instruction for verification and cancellation, the OCX control determines that operation processing corresponding to the operation instruction needs to process data on the server side, generates a URL according to the selected record, sends the URL to the browser, the browser sends a request message to the server in response to the URL, and the server receives the request message and then processes the data on the server side, for example, deletes the data selected by the user for verification and cancellation. By the method, the request message can be sent to the server by responding to the data processing operation of the user through the OCX control, so that the data on the server side is processed, various operation processing of the data on the server side is realized, and the data consistency is ensured.
An embodiment of the present invention further provides a data processing method, as shown in fig. 2, which may include the following steps:
in step S201, the server receives a data query request sent by the browser in response to a data query operation of a user.
Specifically, a user opens a browser to input a user name and a password for logging in, after the user provides a data query operation, the browser responds to the data query operation of the user, a data query request can be sent to a server through an interface by using an Http protocol, and the server receives the data query request sent by the browser in response to the data query operation of the user.
In step S202, the server acquires data from the database in response to the data query request.
Specifically, after receiving a data query request, the server obtains corresponding data from the database according to the request.
In step S203, the server performs JSON formatting on the acquired data.
In order to improve the data transmission efficiency, the server performs JSON formatting processing on the obtained data.
And S204, the server sends the JSON formatted data to an OCX control for processing and displaying, wherein the OCX control is embedded in the browser.
The OCX control is embedded into a JSP page of the browser, and because an Http link is directly established with the server in the OCX control, the server can directly send JSON formatted data to the OCX control embedded in the browser. After the server carries out JSON formatting processing on the obtained data, the JSON formatted data are directly sent to an OCX control embedded in a browser through an Http link, and after the OCX control receives the data, the data are analyzed and processed, and the processed data are displayed to a user.
According to the data processing method, the data is processed through JSON formatting by the server and then sent to the browser, the JSON format is a lightweight data exchange format, so that the network transmission efficiency can be effectively improved, network resources are saved, and meanwhile, the JSON format is easy for machine analysis, so that the difficulty of data analysis of the OCX control at the browser end can be reduced, and the data processing efficiency is improved. In addition, the data are directly sent to the OCX control in the browser through the server, and compared with the method that the data are directly sent to the JSP page of the browser, the processing pressure of the browser can be greatly reduced by receiving and processing the data through the OCX control, the data analysis processing efficiency is improved, a large amount of data can be loaded, the friendliness of human-computer interaction can be guaranteed, the user experience is improved, and the response speed of a system is improved.
Considering that a large amount of data needs to be loaded in banking business and the banking business has high requirements on data security, before the server sends the data to the OCX control for processing and displaying, the data can be compressed and/or encrypted in addition to JSON formatting. Therefore, in some embodiments of the present application, after the server performs JSON formatting on the acquired data, the method may further include: the server compresses the acquired data; and/or the server encrypts the acquired data. For example, the data may be encrypted using a symmetric encryption algorithm (e.g., a 3DES encryption algorithm). By the mode, the data transmission efficiency can be further improved, and the data transmission safety can be improved.
Furthermore, after the OCX control receives the data, the data is analyzed, decompressed and/or decrypted, and then the data is presented to the user through the OCX window, and the user can perform operation processing on the data through the OCX control, where some operation processing needs to be performed on the server side, for example, verification, cancellation, message sending, and the like. Therefore, in some embodiments of the present application, after the server sends the JSON-formatted data to the OCX control for processing and presentation, the method may further include: the method comprises the steps that a server receives a request message sent by a browser in response to a data operation instruction input by a user, wherein the request message carries the data operation instruction; and responding to the received request message, and operating and processing the data on the server side by the server.
After a user clicks a message button to send a message operation instruction, the OCX control determines whether message sending processing corresponding to the message sending operation instruction input by the user needs to process data at the server side, and when it is determined that the data at the server side needs to be processed, the OCX control sends a URL corresponding to the data operation instruction to the browser, and the browser sends a request message to the server in response to the URL, where the request message carries the message sending operation instruction. The server performs corresponding operations on the data at the server side according to the received request message, for example, the server generates a corresponding transaction message according to the received request message and sends out the transaction message. In another example, when a user inputs an operation instruction for verification and cancellation, the OCX control determines that operation processing corresponding to the operation instruction needs to process data on the server side, generates a URL according to a selected record, and sends the URL to the browser, where the browser sends a request message to the server in response to the URL. After receiving the request message, the server processes the data on the server side, for example, the server deletes the data corresponding to the record selected by the user for verification. By the method, the server can process the data at the server side according to the request message sent by the browser in response to the data processing operation of the user, so that the data consistency is ensured, and various operation processes of the data are realized.
Further, when the above data processing method is applied to banking, some processing operations performed by the user may require updating of data on the database side. Therefore, in some embodiments of the present application, after the server receives a request message sent by the browser in response to a data operation instruction input by a user, the method may further include: the server determines whether the operation processing corresponding to the received request message needs to process the data at the database side; and under the condition that the data at the database side needs to be processed, the server sends an operation request to the database according to the request message, wherein the operation request carries a data operation instruction.
Specifically, after receiving a request message which is sent by a browser in response to a data operation instruction input by a user and is removed, a server determines whether an operation corresponding to the request message needs to process data at a database side, and sends an operation request to the database according to the request message under the condition that the operation needs to process the data at the database side, wherein the operation request carries the data operation instruction. And after receiving the operation request, the database processes the data on the database side. For example, when a user inputs an operation instruction for verification and cancellation, the browser sends a request message to the server, the server side deletes corresponding data and sends an operation request to the database, and the database updates the state of the data corresponding to the record selected by the user to verified and cancelled after receiving the operation request. Through the mode, the data on the database side can be updated in response to the data operation instruction of the user, and data synchronization is realized.
The data processing method is described below with reference to a specific embodiment, however, it should be noted that the specific embodiment is only for better describing the present application and is not to be construed as limiting the present application.
Referring to fig. 3, a sequence diagram illustrating an exemplary method for applying the above data processing method to a banking account cancellation service may include the following steps:
step 1, a browser responds to data query operation of a user and sends a data query request to a server;
step 2, after receiving the data query request, the server sends a data acquisition request to a database;
step 3, after receiving the data acquisition request, the database returns the requested data to the server;
and 4, preprocessing the data by the server, wherein the preprocessing can include but is not limited to at least one of the following: JSON formatting, compressing and encrypting;
step 5, the server sends the preprocessed data to an OCX control embedded in a browser page through a fixed interface;
and step 6, the OCX control processes the received data, and the processing may include but is not limited to at least one of the following: analyzing, decompressing and decrypting;
step 7, the OCX control displays the processed data to a user in an OCX window;
step 8, receiving a data operation instruction input by a user through the OCX control;
step 9, operating and processing the data according to the data operation instruction of the user by the OCX control through a plurality of preset buttons or shortcut keys, where the operating and processing may include, but is not limited to, at least one of the following: searching, sorting, calculating, checking and canceling, sending a message and printing;
step 10, the OCX control determines whether processing operation corresponding to a data operation instruction input by a user needs to process data at a server side, and under the condition that the processing operation needs to process the data at the server side, the OCX control generates a URL and sends the URL to a browser, the browser responds to the URL and sends a request message to the server, and the request message carries the data operation instruction input by the user;
step 11, the server processes the data of the server side according to the received request message;
step 12, the server determines whether the processing corresponding to the received request message needs to operate the data at the database side, and under the condition that the data at the database side needs to be operated, the server sends an operation request to the database, wherein the operation request carries a data operation instruction input by a user;
and step 13, after receiving the operation request, the database performs operation processing on the data on the database side according to the request.
In the data processing method in the above embodiment, since the server performs preprocessing on the acquired data, the preprocessing may include JSON formatting, compression and/or decryption, so that network transmission efficiency can be effectively improved, network resources are saved, and security of data transmission is ensured; meanwhile, the JSON format is easy for machine analysis, so that the difficulty of data analysis of the OCX control at the browser end can be reduced, and the data processing efficiency is improved. In addition, because the OCX control is embedded in the browser and receives, analyzes, processes and displays the data returned by the server through the OCX control, compared with the prior art that a large amount of data is directly loaded and displayed through the browser, the processing pressure of the browser can be reduced and the efficiency of data analysis and processing can be improved by receiving, processing and displaying the data through the OCX control, so that a large amount of data can be loaded and processed; and because the window of the OCX control can be provided with various buttons and shortcut keys, the data displayed by the OCX control can be conveniently processed by a user subsequently, so that the friendliness of human-computer interaction can be ensured, the user experience can be improved, and the response speed of the system can be increased. In addition, whether the data operation request input by the user needs to process the data at the server side is determined through the OCX control, and the data at the server side can be updated in time so as to ensure the consistency of the data; moreover, the server determines whether the operation corresponding to the request message needs to process the data on the database side, so that the consistency of the data on the server side and the data on the database side can be ensured. By the scheme, the technical problem that an IE terminal in the prior art cannot load a large amount of data is solved, and the technical effects of loading and processing hundreds of thousands of data, effectively improving data processing efficiency and improving user experience are achieved.
Based on the same inventive concept, the embodiment of the present application further provides a data processing apparatus, which is located in a browser, as described in the following embodiments. Because the principle of the data processing apparatus for solving the problem is similar to the data processing method, the implementation of the data processing apparatus can refer to the implementation of the data processing method, and repeated details 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. Although the means described in the embodiments below are preferably implemented in software, an implementation in hardware, or a combination of software and hardware is also possible and contemplated. Fig. 4 is a block diagram of a data processing apparatus according to an embodiment of the present application, and as shown in fig. 4, the data processing apparatus may include: the following describes the configuration of the transmission module 401, the reception module 402, and the processing module 403.
The sending module 401 is configured to send a data query request to the server in response to a data query operation of a user.
A receiving module 402, configured to receive, through an OCX control, data returned by a server in response to a data query request, where the OCX control is embedded in a browser, and the data returned by the server is JSON-formatted data.
The processing module 403 is configured to process the received data through the OCX control, and display the processed data.
In some embodiments of the present application, the processing module 403 may specifically be configured to: and analyzing the received JSON formatted data through the OCX control.
In some embodiments of the present application, the processing module 403 may be further specifically configured to: decompressing the received data through the OCX control; and/or decrypting the received data through the OCX control.
In some embodiments of the present application, the apparatus may further include an operation module, and the operation module may be configured to: after the received data are processed through the OCX control and the processed data are displayed, a data operation instruction input by a user is received through the OCX control; responding to the data operation instruction through the OCX control, and performing operation processing on the processed data, wherein the operation processing may include at least one of the following: searching, sorting, calculating, checking, sending a message and printing.
In some embodiments of the present application, the operation module may be further configured to: after a data operation instruction input by a user is detected through the OCX control, whether operation processing corresponding to the data operation instruction input by the user needs to process data on a server side or not is determined through the OCX control; under the condition that the data on the server side needs to be processed, sending the URL corresponding to the data operation instruction to a JSP (Java Server Page) of the browser through the OCX control; and responding to the URL, and sending a request message to the server, wherein the request message carries a data operation instruction.
Based on the same inventive concept, the embodiment of the present application further provides a data processing apparatus, which is located in the server, as described in the following embodiments. Because the principle of the data processing apparatus for solving the problem is similar to the data processing method, the implementation of the data processing apparatus can refer to the implementation of the data processing method, and repeated details 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. Although the means described in the embodiments below are preferably implemented in software, an implementation in hardware, or a combination of software and hardware is also possible and contemplated. Fig. 5 is a block diagram of a data processing apparatus according to an embodiment of the present application, and as shown in fig. 5, the data processing apparatus may include: a receiving module 501, an obtaining module 502, a preprocessing module 503, and a sending module 504, and the structure will be described below.
The receiving module 501 is configured to receive a data query request sent by a browser in response to a data query operation of a user.
An obtaining module 502 is configured to obtain data from a database in response to a data query request.
And the preprocessing module 503 is configured to perform JSON formatting on the acquired data.
A sending module 504, configured to send the JSON-formatted data to an OCX control for processing and displaying, where the OCX control is embedded in a browser.
In some embodiments of the present application, the preprocessing module 503 may be further configured to: after JSON formatting processing is carried out on the obtained data, the obtained data are compressed; and/or encrypting the acquired data.
In some embodiments of the present application, the data processing apparatus may further include a processing module, and the processing module may be configured to: after the server sends JSON formatted data to an OCX control for processing and displaying, receiving a request message sent by the browser in response to a data operation instruction input by a user, wherein the request message carries the data operation instruction; and responding to the received request message, and performing operation processing on the data of the server side.
In some embodiments of the present application, the processing module may be further configured to: after the server receives a request message sent by the browser in response to a data operation instruction input by a user, determining whether operation processing corresponding to the received request message needs to process data on a database side; and sending an operation request to the database according to the request message under the condition that the data at the database side needs to be processed, wherein the operation request carries the data operation instruction.
From the above description, it can be seen that the embodiments of the present invention achieve the following technical effects: the JSON format is a lightweight data exchange format, so that the network transmission efficiency can be effectively improved, the network resources are saved, and meanwhile, the JSON format is easy for machine analysis, so that the difficulty of analyzing the data by the OCX control at the browser end can be reduced, and the data processing efficiency is improved. In addition, because the OCX control is embedded in the browser and receives, analyzes, processes and displays the data returned by the server through the OCX control, compared with the prior art that a large amount of data are directly loaded and displayed through the browser, the processing pressure of the browser can be reduced by receiving and processing the data through the OCX control, the efficiency of data analysis and processing is improved, a large amount of data can be loaded, the friendliness of human-computer interaction can be ensured, the user experience is improved, and the response speed of the system is improved. By the scheme, the technical problem that an IE terminal in the prior art cannot load a large amount of data is solved, and the technical effects of loading and processing hundreds of thousands of data, effectively improving data processing efficiency and improving user experience are achieved.
The embodiment of the present application further provides a computer device, which may specifically refer to a schematic structural diagram of a computer device based on the data processing method provided in the embodiment of the present application shown in fig. 6, where the computer device may specifically include an input device 61, a processor 62, and a memory 63. Wherein the memory 33 is for storing processor-executable instructions. The processor 62, when executing the instructions, performs the steps of the data processing method described in any of the embodiments above. The input device 61 may be specifically configured to input a data query instruction and a data operation instruction of a user.
In this embodiment, the input device may be one of the main apparatuses for information exchange between a user and a computer system. The input device may include a keyboard, a mouse, a camera, a scanner, a light pen, a handwriting input board, a voice input device, etc.; the input device is used to input raw data and a program for processing the data into the computer. The input device can also acquire and receive data transmitted by other modules, units and devices. The processor may be implemented in any suitable way. For example, the processor may take the form of, for example, a microprocessor or processor and a computer-readable medium that stores computer-readable program code (e.g., software or firmware) executable by the (micro) processor, logic gates, switches, an Application Specific Integrated Circuit (ASIC), a programmable logic controller, an embedded microcontroller, and so forth. The memory may in particular be a memory device used in modern information technology for storing information. The memory may include multiple levels, and in a digital system, the memory may be any memory as long as it can store binary data; in an integrated circuit, a circuit without a physical form and with a storage function is also called a memory, such as a RAM, a FIFO and the like; in the system, the storage device in physical form is also called a memory, such as a memory bank, a TF card and the like.
In this embodiment, the functions and effects of the specific implementation of the computer device can be explained in comparison with other embodiments, and are not described herein again.
The present application further provides a computer storage medium based on the data processing method provided by the present application, where the computer storage medium stores computer program instructions, and the computer program instructions, when executed, implement the steps of the data processing method in any of the above embodiments.
In this embodiment, the storage medium includes, but is not limited to, a Random Access Memory (RAM), a Read-Only Memory (ROM), a Cache (Cache), a Hard Disk Drive (HDD), or a Memory Card (Memory Card). The memory may be used to store computer program instructions. The network communication unit may be an interface for performing network connection communication, which is set in accordance with a standard prescribed by a communication protocol.
In this embodiment, the functions and effects specifically realized by the program instructions stored in the computer storage medium can be explained by comparing with other embodiments, and are not described herein again.
It will be apparent to those skilled in the art that the modules or steps of the embodiments of the present application described above may be implemented by a general purpose computing device, they may be centralized on a single computing device or distributed across a network of multiple computing devices, and alternatively, they may be implemented by program code executable by a computing device, such that they may be stored in a storage device and executed by a computing device, and in some cases, the steps shown or described may be performed in an order different from that described herein, or they may be separately fabricated into individual integrated circuit modules, or multiple ones of them may be fabricated into a single integrated circuit module. Thus, embodiments of the present application are not limited to any specific combination of hardware and software.
It is to be understood that the above description is intended to be illustrative, and not restrictive. Many embodiments and many applications other than the examples provided will be apparent to those of skill in the art upon reading the above description. The scope of the application should, therefore, be determined not with reference to the above description, but instead should be determined with reference to the pending claims along with the full scope of equivalents to which such claims are entitled.
The above description is only a preferred embodiment of the present application and is not intended to limit the present application, and it will be apparent to those skilled in the art that various modifications and variations can be made in the embodiment of the present application. Any modification, equivalent replacement, improvement and the like made within the spirit and principle of the present application shall be included in the protection scope of the present application.
Claims (11)
1. A data processing method, comprising:
the browser responds to the data query operation of a user and sends a data query request to the server;
the browser receives data returned by the server in response to the data query request through an OCX control, wherein the OCX control is embedded in the browser, and the data returned by the server is JSON formatted data;
the browser processes the received data through the OCX control and displays the processed data;
wherein, the browser processes the received data through the OCX control, including:
the browser analyzes the received JSON formatted data through the OCX control;
after the browser processes the received data through the OCX control and displays the processed data, the method further includes:
the browser receives a data operation instruction input by a user through the OCX control;
the OCX control determines whether operation processing corresponding to a data operation instruction input by a user needs to process data at a server side;
under the condition that the data on the server side needs to be processed, the OCX control sends the URL corresponding to the data operation instruction to the browser;
the browser responds to the URL and sends a request message to the server, wherein the request message carries the data operation instruction;
after the browser receives a data operation instruction input by a user through the OCX control, the method further comprises the following steps:
the browser responds to the data operation instruction through the OCX control and performs operation processing on the processed data, wherein the operation processing comprises at least one of the following steps: searching, sorting, calculating, checking, sending a message and printing.
2. The method of claim 1, wherein the browser processes the received data through the OCX control, further comprising:
the browser decompresses the received data through the OCX control; and/or the presence of a gas in the gas,
and the browser decrypts the received data through the OCX control.
3. A data processing method, comprising:
the server receives a data query request sent by the browser in response to a data query operation of a user;
the server responds to the data query request to acquire data from a database;
the server carries out JSON formatting processing on the acquired data;
the server sends the JSON formatted data to an OCX control for analysis, processing and display, wherein the OCX control is embedded in the browser;
after the server sends the JSON-formatted data to the OCX control for processing and displaying, the method further includes:
the server receives a request message sent by the browser in response to a data operation instruction input by a user, wherein the request message carries the data operation instruction, and the browser responds to the data operation instruction through the OCX control and performs operation processing on the analyzed and processed data, wherein the operation processing includes at least one of the following: searching, sorting, calculating, checking and canceling, sending a message and printing;
and responding to the received request message, and the server performs operation processing on the data at the server side.
4. The method according to claim 3, further comprising, after the server JSON-formatting the acquired data:
the server compresses the acquired data; and/or
The server encrypts the acquired data.
5. The method according to claim 3, after the server receives a request message sent by the browser in response to a data operation instruction input by a user, further comprising:
the server determines whether the operation processing corresponding to the received request message needs to process the data at the database side;
and under the condition that the data at the database side needs to be processed, the server sends an operation request to the database according to the request message, wherein the operation request carries the data operation instruction.
6. A data processing apparatus, in a browser, comprising:
the sending module is used for responding to the data query operation of the user and sending a data query request to the server;
a receiving module, configured to receive, through an OCX control, data returned by the server in response to the data query request, where the OCX control is embedded in the browser, and the data returned by the server is JSON-formatted data;
the processing module is used for processing the received data through the OCX control and displaying the processed data;
the processing module is specifically configured to parse the received JSON-formatted data through the OCX control;
the processing module is further specifically configured to: after the browser processes the received data through the OCX control and displays the processed data, receiving a data operation instruction input by a user through the OCX control; determining whether the operation processing corresponding to the data operation instruction input by the user needs to process the data at the server side or not through the OCX control; under the condition that the data on the server side needs to be processed, sending the URL corresponding to the data operation instruction to the browser through the OCX control; responding to the URL, and sending a request message to the server, wherein the request message carries the data operation instruction;
wherein the processing module is further specifically configured to: after a data operation instruction input by a user is received through the OCX control, responding to the data operation instruction through the OCX control, and performing operation processing on the processed data, wherein the operation processing comprises at least one of the following steps: searching, sorting, calculating, checking, sending a message and printing.
7. A data processing apparatus, located in a server, comprising:
the receiving module is used for receiving a data query request sent by a browser in response to a data query operation of a user;
the acquisition module is used for responding to the data query request to acquire data from a database;
the preprocessing module is used for carrying out JSON formatting processing on the acquired data;
the sending module is used for sending the JSON formatted data to an OCX control for analysis processing and display, wherein the OCX control is embedded in the browser;
after the server sends the JSON-formatted data to the OCX control for processing and displaying, the method further includes:
the server receives a request message sent by the browser in response to a data operation instruction input by a user, wherein the request message carries the data operation instruction, and the browser responds to the data operation instruction through the OCX control and performs operation processing on the analyzed and processed data, wherein the operation processing includes at least one of the following: searching, sorting, calculating, checking and canceling, sending a message and printing;
and responding to the received request message, and the server performs operation processing on the data at the server side.
8. A computer device comprising a processor and a memory for storing processor-executable instructions which, when executed by the processor, implement the steps of the method of any of claims 1 to 2.
9. A computer device comprising a processor and a memory for storing processor-executable instructions which, when executed by the processor, implement the steps of the method of any of claims 3 to 5.
10. A computer readable storage medium having stored thereon computer instructions which, when executed, implement the steps of the method of any one of claims 1 to 2.
11. A computer readable storage medium having stored thereon computer instructions which, when executed, implement the steps of the method of any one of claims 3 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910367278.5A CN110175305B (en) | 2019-05-05 | 2019-05-05 | Data processing method, data processing device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910367278.5A CN110175305B (en) | 2019-05-05 | 2019-05-05 | Data processing method, data processing device, computer equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110175305A CN110175305A (en) | 2019-08-27 |
| CN110175305B true CN110175305B (en) | 2022-03-11 |
Family
ID=67690439
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910367278.5A Active CN110175305B (en) | 2019-05-05 | 2019-05-05 | Data processing method, data processing device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110175305B (en) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101075186A (en) * | 2006-05-18 | 2007-11-21 | 腾讯科技（深圳）有限公司 | Method for processing pictures of embedded WED browser |
| CN102546732A (en) * | 2010-12-31 | 2012-07-04 | 北大方正集团有限公司 | File transmission method and system in webpage |
| CN106485490A (en) * | 2016-10-19 | 2017-03-08 | 济南浪潮高新科技投资发展有限公司 | A kind of POS mode of payment realized based on OCX control |
| CN107977389A (en) * | 2016-10-25 | 2018-05-01 | 航天信息软件技术有限公司 | Method for processing report data based on browser |
| CN108038089A (en) * | 2017-12-01 | 2018-05-15 | 方欣科技有限公司 | A kind of online electronic spreadsheet engine of property tax |
| CN109543399A (en) * | 2018-11-12 | 2019-03-29 | 中国联合网络通信有限公司重庆市分公司 | A method of prevent second-generation ID card reader OCX control to be tampered |
| CN109558181A (en) * | 2018-11-26 | 2019-04-02 | 高新兴国迈科技有限公司 | Method, computer storage medium and the equipment of the compatible OCX control of non-IE browser |
-
2019
- 2019-05-05 CN CN201910367278.5A patent/CN110175305B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101075186A (en) * | 2006-05-18 | 2007-11-21 | 腾讯科技（深圳）有限公司 | Method for processing pictures of embedded WED browser |
| CN102546732A (en) * | 2010-12-31 | 2012-07-04 | 北大方正集团有限公司 | File transmission method and system in webpage |
| CN106485490A (en) * | 2016-10-19 | 2017-03-08 | 济南浪潮高新科技投资发展有限公司 | A kind of POS mode of payment realized based on OCX control |
| CN107977389A (en) * | 2016-10-25 | 2018-05-01 | 航天信息软件技术有限公司 | Method for processing report data based on browser |
| CN108038089A (en) * | 2017-12-01 | 2018-05-15 | 方欣科技有限公司 | A kind of online electronic spreadsheet engine of property tax |
| CN109543399A (en) * | 2018-11-12 | 2019-03-29 | 中国联合网络通信有限公司重庆市分公司 | A method of prevent second-generation ID card reader OCX control to be tampered |
| CN109558181A (en) * | 2018-11-26 | 2019-04-02 | 高新兴国迈科技有限公司 | Method, computer storage medium and the equipment of the compatible OCX control of non-IE browser |
Non-Patent Citations (1)
| Title |
|---|
| 基于ActiveX的网络视频监控客户端设计;徐佳健;《中国优秀硕士学位论文全文数据库》;20131231;1-12 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110175305A (en) | 2019-08-27 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105787077B (en) | Data synchronization method and device | |
| CN107249004B (en) | Identity authentication method, device and client | |
| US20170109371A1 (en) | Method and Apparatus for Processing File in a Distributed System | |
| US11263580B2 (en) | Information push method and device | |
| CN105827582A (en) | Communication encryption method, device and system | |
| CN107844488B (en) | Data query method and device | |
| CN110648216A (en) | Wind control method and device | |
| CN114697304A (en) | Gray scale publishing method, system, device, equipment and storage medium | |
| CN111046010A (en) | Log storage method, device, system, electronic equipment and computer readable medium | |
| CN113761565B (en) | Data desensitization method and device | |
| CN113572763A (en) | Data processing method and device, electronic equipment and storage medium | |
| CN113761566A (en) | Data processing method and device | |
| CN112463749A (en) | File sharing method, device, medium and electronic equipment | |
| CN105743890B (en) | Authority information generation method and device | |
| CN110175305B (en) | Data processing method, data processing device, computer equipment and storage medium | |
| US20240177200A1 (en) | Business service interaction method and apparatus, device, and storage medium | |
| CN113992345B (en) | Webpage sensitive data encryption and decryption method and device, electronic equipment and storage medium | |
| US20150088976A1 (en) | Information processing system, processing apparatus, and distributed processing method | |
| CN114202332A (en) | Digital currency wallet management method, device and system | |
| EP3291125A1 (en) | Server device, information management system, information management method, and computer program | |
| CN110659900A (en) | Payment method without application, device, medium and electronic equipment | |
| CN113609147B (en) | Data sharing method and device and electronic equipment | |
| CN112597067B (en) | Test method, test system, electronic device and test medium | |
| CN109218270B (en) | Method and device for processing hijacked request | |
| CN115643002A (en) | Service processing method, device and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |