Interactive Method, Device, and Storage Medium for Displaying Data
By using EasyExcel library in a large-screen display system to process Excel file data and generate JSON data, and using a relational database to realize real-time data transmission, the problem of complex and insufficient real-time adjustment of large-screen data is solved, and the efficiency and real-timeness of data management are improved.
Patent Information
- Application Number
- CN202510489839.4
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2025-04-18
- Publication Date
- 2025-06-27
- Estimated Expiration
- 2045-04-18
AI Technical Summary
In the prior art, the process of adjusting data on large-screen displays is complicated and insufficient real-time, resulting in high development costs and long development cycles, making it difficult to meet the requirements of exhibition hall demonstrations for real-time data.
By providing an interactive method for displaying data, using the front-end display system to receive import request instructions, the back-end control system uses the EasyExcel library to write Excel file data into the data table, generate JSON data, and transmits the data to the front-end display system through a relational database to realize real-time update and display of data.
It simplifies the process of adjusting data on large screens, improves the real-time and flexibility of data, reduces development costs and cycles, and meets the real-time requirements of exhibition hall demonstrations.
Smart Images

Figure CN120011441B_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of data interaction, and in particular to an interaction method, device, and storage medium for display data. Background Art
[0002] In the field of intelligent manufacturing large-screen demonstrations, the existing technology usually develops a specific data configuration module for each large-screen component separately to manage the demonstration data. These systems are usually developed customized based on specific business requirements. For different components (such as order statistics, inventory analysis, etc.), independent data processing logics and interaction interfaces are constructed respectively.
[0003] However, since the demonstration data configuration modules of each component are developed independently, the code reuse rate is low. Whenever a new large-screen component needs to be added or modified, the corresponding data configuration function must be re-developed, which not only increases the development cost but also prolongs the development cycle. In addition, the existing technology cannot respond to the changes in real-time data in a timely manner and is difficult to meet the requirements of real-time data for exhibition hall demonstrations.
[0004] Therefore, in order to solve the problems of complex process and insufficient real-time performance in adjusting large-screen display data in the existing technology, a new technical solution is urgently needed to optimize the data management method of the large-screen demonstration system and improve the development efficiency and data real-time performance. Summary of the Invention
[0005] The main purpose of the present invention is to solve the technical problems of complex process and insufficient real-time performance in adjusting large-screen display data in the existing technology.
[0006] The first aspect of the present invention provides an interaction method for display data. The interaction method for display data is applied to an interaction system for display data. The interaction system for display data includes: a front-end display system and a back-end control system. The interaction method for display data includes:
[0007] The front-end display system receives an import request instruction and sends the import request instruction to the back-end control system, where the import request instruction includes: an Excel file;
[0008] The back-end control system receives the import request instruction, and writes the data of the Excel file into a data table according to a preset EasyExcel library to generate a map data table;
[0009] Obtain a preset josn template, replace the placeholders in the josn template with the data in the map data table to generate display JOSN data, store the display JSON data in a relational database, and record the storage information;
[0010] Push the stored information into the front - end display system using a webSocket connection;
[0011] The front - end display system receives the stored information, and based on the stored information, queries the display JSON data from the relational database and performs parsing and display processing on the display JSON data.
[0012] Optionally, in the first implementation manner of the first aspect of the present invention, the writing the data of the Excel file into a data table according to a preset EasyExcel library to generate a map data table includes:
[0013] Use the ExcelUtil tool class in the preset EasyExcel library to perform file legality verification on the Excel file to obtain a verification result;
[0014] When the verification result is qualified, write the data of the Excel file into a List<Map<String, String>> structure to generate a map data table.
[0015] Optionally, in the second implementation manner of the first aspect of the present invention, the writing the data of the Excel file into a List<Map<String, String>> structure to generate a map data table includes:
[0016] Use the ReadListener class in the EasyExcel library to listen to each row of data written from the Excel file into the List<Map<String, String>> structure to obtain the data during the listening process;
[0017] When there is an exception in the data during the listening process, terminate the data writing process and send error data to the front - end display system.
[0018] Optionally, in the third implementation manner of the first aspect of the present invention, after performing parsing and display processing on the display JSON data, it further includes:
[0019] The front - end display system receives a data query request and sends the data query request to the back - end control system according to a preset HTTP protocol;
[0020] The back - end control system receives the data query request and queries the corresponding display JOSN data from the relational database based on the data query request;
[0021] Package and process the display JOSN data according to a preset front - end format to generate formatted JOSN data;
[0022] Through the HTTP protocol, the response feeds back the JSON data in the specified format to the front-end display system.
[0023] Optionally, in the fourth implementation manner of the first aspect of the present invention, querying the corresponding display JSON data from the relational database based on the data query request includes:
[0024] Caching the preset historical query records into a preset Redis database;
[0025] Determining whether the data query request exists in the Redis database;
[0026] If it exists in the Redis database, copying the display JSON data corresponding to the data query request from the Redis database;
[0027] If it does not exist in the Redis database, querying the display JSON data corresponding to the data query request from the relational database and writing the data query request into the historical query record.
[0028] Optionally, in the fifth implementation manner of the first aspect of the present invention, querying the display JSON data corresponding to the data query request from the relational database includes:
[0029] Generating an SQL query statement corresponding to the data query request based on the MyBatis framework;
[0030] Querying and processing the index of the relational database based on the SQL query statement to obtain the display JSON data.
[0031] Optionally, in the sixth implementation manner of the first aspect of the present invention, before pushing the stored information to the front-end display system by using the webScoket connection, it includes:
[0032] The back-end control system establishes a Websocket service based on the Spring WebSocket framework;
[0033] The front-end display system establishes a WebSocket connection with the back-end control system based on the SockJS library and the STOMP text protocol, and uses the subscribe function to listen for the data pushed by the back-end control system.
[0034] Optionally, in the seventh implementation manner of the first aspect of the present invention, the front-end display system receiving the import request instruction includes:
[0035] The front-end display system receives a click event;
[0036] Based on the click event, trigger the display of the configurator interface and receive the import request instruction of the configurator interface.
[0037] The second aspect of the present invention provides an interactive device for displaying data, including: a memory and at least one processor, wherein instructions are stored in the memory, and the memory and the at least one processor are interconnected by a line; the at least one processor calls the instructions in the memory to enable the interactive device for displaying data to execute the above-mentioned interactive method for displaying data.
[0038] The third aspect of the present invention provides a computer-readable storage medium, in which instructions are stored, and when it runs on a computer, it enables the computer to execute the above-mentioned interactive method for displaying data.
[0039] In the embodiments of the present invention, the imported Excel data is obtained through front-end technology, and users can edit and adjust the front-end display data by editing the Excel data. The front-end interface sends the imported data to the back-end system, and the back-end system uses the EasyExcel library to write the Excel data into a data table and generates corresponding JSON data based on the generated data table. The JSON data is transmitted to the front-end display system across systems using a relational database, realizing a simple adjustment process and flexible modification method for the display data of the large screen, and solving the technical problems of complex adjustment process and insufficient real-time performance of the large-screen display data in the prior art. Description of the Drawings
[0040] Figure 1 It is a schematic diagram of an embodiment of the interactive method for displaying data in the embodiments of the present invention;
[0041] Figure 2 It is a schematic diagram of a specific embodiment of the front-end display system of the interactive method for displaying data in the embodiments of the present invention;
[0042] Figure 3 It is a schematic diagram of a specific embodiment of step 102 of the interactive method for displaying data in the embodiments of the present invention;
[0043] Figure 4 It is a schematic diagram of a specific embodiment after step 105 of the interactive method for displaying data in the embodiments of the present invention;
[0044] Figure 5 It is a schematic diagram of an embodiment of the interactive device for displaying data in the embodiments of the present invention. Detailed Embodiments
[0045] The embodiments of the present invention provide an interactive method, device and storage medium for displaying data.
[0046] Embodiments disclosed in the present invention will be described in more detail below with reference to the accompanying drawings. Although some embodiments of the present invention are shown in the drawings, it should be understood that the present invention can be implemented in various forms and should not be construed as limited to the embodiments set forth herein. On the contrary, these embodiments are provided to more thoroughly and completely understand the present disclosure. It should be understood that the drawings and embodiments of the present invention are only for exemplary purposes and are not used to limit the protection scope of the present invention.
[0047] In the description of the embodiments of the present invention, the term "including" and its similar terms should be understood as open inclusion, that is, "including but not limited to". The term "based on" should be understood as "at least partially based on". The term "an embodiment" or "the embodiment" should be understood as "at least one embodiment". Terms such as "first", "second", etc. may refer to different or the same objects. There may also be other explicit and implicit definitions hereinafter.
[0048] For ease of understanding, the specific process of the embodiments of the present invention will be described below. Please refer to Figure 1 , an embodiment of the method for displaying data interaction in the embodiments of the present invention. The method for displaying data interaction is applied to a display data interaction system. The display data interaction system includes: a front-end display system and a back-end control system. The method for displaying data interaction includes:
[0049] 101. The front-end display system receives an import request instruction and sends the import request instruction to the back-end control system. Among them, the import request instruction includes: an Excel file;
[0050] In this embodiment, the front-end display system can be a large screen. The application fields of this large screen include but are not limited to the following aspects:
[0051] 1. The field of intelligent manufacturing: In the factory production workshop, using the technology of the present invention, various types of data on the production line, such as equipment operation status, output, quality inspection results, etc., are displayed in real time through the large screen. Managers can click on the large screen title to quickly configure demonstration data, such as switching data of different production lines, viewing historical data comparison, etc. Through the data import function, it is also possible to simulate data under different production scenarios to assist production scheduling decisions, optimize the production process, and improve production efficiency.
[0052] 2. The field of education and training: When schools or training institutions display teaching achievements, they use the large screen to display data such as student grades, course completion status, and skill mastery. Teachers or managers can, as needed, quickly update the demonstration data by downloading templates, editing data, and importing it, and display the teaching achievements of different time periods and different classes to parents, students, or visitors, intuitively presenting the teaching effect.
[0053] 3. Financial field: In the trading hall or business hall of financial institutions, large screens display real-time market data of financial products such as stocks, funds, and foreign exchange. Traders or investors can view detailed data analysis, such as price increases, trading volume comparisons, etc., by clicking on the component title. At the same time, using the demonstration data configuration function, simulate data trends under different market conditions to assist investment decisions and predict market trends.
[0054] Send an import request instruction in the front-end display system. The import request instruction contains an Excel file, and send the import request instruction to the back-end control system. The back-end control system is used to parse and process each instruction data displayed on the front end and execute relevant execution instructions.
[0055] Specifically, please refer to Figure 2 , Figure 2 FIG.
[0056] 1011. The front-end display system receives a click event;
[0057] 1012. Based on the click event, trigger the display configurator interface and receive the import request instruction of the configurator interface.
[0058] In steps 1011-1012, the front-end display system can receive multiple click events. When the click event triggers the display of the configurator interface, the configurator interface of the pop-up window can be triggered, and the user generates an import request instruction in the configurator interface.
[0059] 102. The back-end control system receives the import request instruction, and according to the pre-set EasyExcel library, writes the data of the Excel file into the data table to generate a map data table;
[0060] In this embodiment, the back-end control system receives the import request instruction using the HTTP protocol. The EasyExcel library is an external library integrated in the Java development environment, and the EasyExcel library integrates various functions for Excel files.
[0061] If the project is based on Maven, add the dependency of EasyExcel in the pom.xml file:
[0062] <dependency>
[0063] <groupid>com.alibaba< / groupid>
[0064] <artifactid>easyexcel< / artifactid>
[0065] <version> 3.2.0< / version> <!-- Please select the latest version as needed. -->
[0066] < / dependency>
[0067] In the above manner, configure the EasyExcel library and use the EasyExcel library to write the data of the Excel file into a data table to generate a map data table.
[0068] Further, please refer to Figure 3 , Figure 3 which is a specific embodiment of step 102 of the data interaction method for displaying data in the embodiments of the present invention. In step 102, "According to the pre-set EasyExcel library, write the data of the Excel file into a data table to generate a map data table" includes the following specific embodiments:
[0069] 1021. Use the ExcelUtil tool class in the pre-set EasyExcel library to perform file legality verification on the Excel file to obtain a verification result;
[0070] 1022. When the verification result is qualified, write the data of the Excel file into a List<Map<String, String>> structure to generate a map data table.
[0071] In steps 1021-1022, the ExcelUtil tool class is a wrapper tool class based on the EasyExcel library. Use the ExcelUtil tool class to check whether the Excel file contains specific column names, whether it contains blank rows or columns, and whether the data types are correct. A boolean parameter will be returned when all verifications are qualified.
[0072] When the boolean parameter is true, write the data of the Excel file into a List<Map<String, String>> structure to generate a map data table. List<Map<String, String>> is a common Java data structure used to store tabular data or a structure similar to key-value pairs. Each element of the List is a Map, representing a row of data in the table. Map<String, String> is a collection of key-value pairs. The key (String) is usually the table header (column name), and the value (String) is the cell content of the corresponding column.
[0073] Write the Excel file into a List<Map<String, String>> according to the structure of the original table to generate a map data table with multiple maps.
[0074] Specifically, step 1022 includes the following specific embodiments:
[0075] 10221. Use the ReadListener class in the EasyExcel library to listen to each line of data written to the Excel file and stored in the List<Map<String, String>> structure, obtaining the data during the listening process;
[0076] 10222. When an exception occurs in the data during the listening process, terminate the data writing process and send the error data to the front-end display system.
[0077] In steps 10221 - 10222, to monitor whether an exception in the Excel file is not detected during the data writing process, use the ReadListener class in the EasyExcel library. For example, the invoke(T data, AnalysisContext context) function is triggered every time a line of data is read. Data is the data object of the current line. Under this function, set conditions to trigger when the header or data is empty. When empty data is found during the listening process, terminate the data writing process and send the error data to the front-end display system so that the user can adjust the input Excel data.
[0078] 103. Obtain a preset josn template, replace the placeholders in the josn template with the data in the map data table, generate display JOSN data, store the display JSON data in a relational database, and record the storage information;
[0079] In this embodiment, a josn template is preset in advance, and the data in the map data table is used to replace the placeholders in the josn template. For example, the value of the "total order quantity" field in the map data table is used to replace the "#{total order quantity}" placeholder in the json template, directly generating display JOSN data that can be used for parsing. Then store the display JOSN data in a relational database and record storage information such as app_id, component_id, time, create_by, and create_time, etc.
[0080] The relational database can be a NoSQL database, such as MongoDB or Cassandra. NoSQL databases have better scalability and flexibility, can more conveniently store and process complex data structures, and are suitable for storing JSON-formatted demonstration data. The relational database can also be a MySQL relational database, but it is not recommended to use a local database like SQLite, as SQLite is not conducive to cross-system and device processing and is not convenient for users to debug and modify data.
[0081] 104. Use a webScoket connection to push the storage information to the front-end display system;
[0082] In this embodiment, the stored information is pushed to the front-end display system by using a webScoket connection, so that the front-end display system can pull josn data from the database based on the stored information for parsing and display.
[0083] Specifically, before 104, the following specific implementation manners are included:
[0084] 1041. The back-end control system establishes a Websocket service based on the Spring WebSocket framework;
[0085] 1042. The front-end display system establishes a WebSocket connection with the back-end control system based on the SockJS library and the STOMP text protocol, and uses the subscribe function to listen for the data pushed by the back-end control system.
[0086] In steps 1041-1042, the back-end control system first establishes a Websocket service based on the Spring WebSocket framework. The front-end display system uses the SockJS library to create a STOMP client to parse and execute the STOMP protocol, establish a WebSocket connection with the back-end control system, and the subscribe function subscribes to the data pushed by the back-end control system.
[0087] 105. The front-end display system receives the stored information, and based on the stored information, queries the display JSON data from the relational database, and performs parsing and display processing on the display JSON data.
[0088] In this embodiment, the front-end display system receives the stored information, uses the stored information as an index, queries the display JSON data corresponding to the stored information from the relational database across systems and devices, performs parsing and display processing on the display JSON data, and generates a display interface corresponding to the display JSON data.
[0089] Please refer to Figure 4 , Figure 4 which is a specific embodiment after step 105 of the method for interacting with display data in the embodiment of the present invention. After step 105, the following specific implementation manners are further included:
[0090] 106. The front-end display system receives a data query request, and according to the preset HTTP protocol, sends the data query request to the back-end control system;
[0091] 107. The backend control system receives the data query request and, based on the data query request, queries the corresponding display JSON data from the relational database;
[0092] 108. Package and process the display JSON data according to a preset front-end format to generate formatted JSON data;
[0093] 109. Respond and feedback the formatted JSON data to the front-end display system through the HTTP protocol.
[0094] In steps 106 - 109, the front-end display system can not only import a data request, but also execute a data query request after importing the data request. The front-end display system receives the data query request and, according to the preset HTTP protocol, sends the data query request to the backend control system.
[0095] The backend queries the display JSON data corresponding to app_id, component_id, and time from the relational database according to the query request sent by the front-end. Package and process the display JSON data according to a preset front-end format to generate formatted JSON data, and return the formatted JSON data to the front-end display system through the HTTP response mechanism.
[0096] Specifically, in step 107, "query the corresponding display JSON data from the relational database based on the data query request" includes the following specific embodiments:
[0097] 1071. Cache the preset historical query records in a preset Redis database;
[0098] 1072. Determine whether the data query request is in the Redis database;
[0099] 1073. When it is in the Redis database, copy out the display JSON data corresponding to the data query request from the Redis database;
[0100] 1074. When it is not in the Redis database, query the display JSON data corresponding to the data query request from the relational database and write the data query request into the historical query records.
[0101] In steps 1071 - 1074, a caching mechanism is introduced to cache historical query records in the Redis database. When there is a data query request, first query in the Redis database. If the data corresponding to the historical query record exists in the Redis database, then copy out the display JSON data corresponding to the data query request from the Redis database. If the data corresponding to the historical query record does not exist in the Redis database, then still query out the display JSON data corresponding to the data query request from the relational database and write the data query request into the historical query record. This can reduce the access pressure on the database and improve the response speed of the system.
[0102] Specifically, in step 1074, "query out the display JSON data corresponding to the data query request from the relational database" includes:
[0103] 10741. Generate the SQL query statement corresponding to the data query request based on the MyBatis framework;
[0104] 10742. Based on the SQL query statement, perform a query process on the index of the relational database to obtain the display JSON data.
[0105] In steps 10741 - 10742, the dynamic SQL function of the MyBatis framework allows for dynamically generating SQL statements according to runtime conditions, can flexibly handle complex query requirements, reduce unnecessary data loading, and thus improve the query efficiency. Utilizing the second-level cache based on the MyBatis framework can improve the index query efficiency of the relational database, reduce the number of accesses to the database, and achieve the effect of obtaining the display JSON data more quickly.
[0106] In the embodiment of the present invention, the imported Excel data is obtained through front-end technology, and the user can edit and adjust the front-end display data through the editing of the Excel data. The front-end interface sends the imported data to the back-end system, and the back-end system uses the EasyExcel library to write the Excel data into the data table and generates the corresponding JSON data based on the generated data table. The JSON data is transmitted to the front-end display system across the system using the relational database, realizing a simple adjustment process and flexible modification method for the display data on the large screen, and solving the technical problems of complex adjustment process and insufficient real-time performance of the large-screen display data in the prior art.
[0107] Figure 5FIG. 0 is a schematic structural diagram of an interactive device for displaying data provided by an embodiment of the present invention. The interactive device 500 for displaying data may vary greatly due to different configurations or performances, and may include one or more processors (central processing units, CPUs) 510 (for example, one or more processors) and a memory 520, and one or more storage media 530 (for example, one or more mass storage devices) storing application programs 533 or data 532. Among them, the memory 520 and the storage media 530 may be transient storage or persistent storage. The program stored in the storage media 530 may include one or more modules (not shown in the figure), and each module may include a series of instruction operations on the interactive device 500 for displaying data. Further, the processor 510 may be configured to communicate with the storage media 530 and execute a series of instruction operations in the storage media 530 on the interactive device 500 for displaying data.
[0108] Based on the interactive device 500 for displaying data may further include one or more power supplies 540, one or more wired or wireless network interfaces 550, one or more input / output interfaces 560, and / or, one or more operating systems 531, such as Windows Server, Mac OS X, Unix, Linux, Free BSD, and so on. Those skilled in the art can understand that Figure 5 The shown structural diagram of the interactive device for displaying data does not constitute a limitation on the interactive device for displaying data, and may include more or fewer components than shown, or combine certain components, or have different component arrangements.
[0109] The present invention also provides a computer-readable storage medium, which may be a non-volatile computer-readable storage medium or a volatile computer-readable storage medium. Instructions are stored in the computer-readable storage medium. When the instructions are run on a computer, the computer is caused to execute the steps of the interactive method for displaying data.
[0110] In the context of the present disclosure, a machine-readable medium can be a tangible medium that can contain or store a program for use by or in connection with an instruction execution system, apparatus, or device. A machine-readable medium can be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium can include, but is not limited to, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor systems, apparatus, or devices, or any suitable combination of the foregoing. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or Flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
[0111] Moreover, although the operations are depicted in a particular order, this should be understood as requiring that such operations be performed in the particular order shown or in sequential order, or that all illustrated operations be performed to achieve the desired result. In certain circumstances, multitasking and parallel processing may be advantageous. Similarly, although several specific implementation details are included in the above discussion, these should not be construed as limiting the scope of the present disclosure. Certain features that are described in the context of separate embodiments can also be implemented in combination in a single implementation. Conversely, the various features that are described in the context of a single implementation can also be implemented separately or in any suitable sub-combination in multiple implementations.
[0112] Although the subject matter has been described in language specific to structural features and / or methodological acts, it should be understood that the subject matter defined in the appended claims is not necessarily limited to the specific features or acts described above. Rather, the specific features and acts described above are merely example forms of implementing the claims.
Claims
1. An interactive method for displaying data, characterized in that: The interactive method for displaying data is applied to an interactive system for displaying data, the interactive system for displaying data comprises: a front-end display system and a back-end control system, and the interactive method for displaying data comprises: The front-end display system receives an import request instruction, and sends the import request instruction to the back-end control system, wherein the import request instruction includes: an Excel file; The backend control system receives the import request instruction, writes the data of the Excel file into a data table according to the preset EasyExcel library, and generates a map data table; Obtain a preset JSON template, replace the placeholder in the JSON template with the data in the map data table, generate display JSON data, store the display JSON data in a relational database, and record the storage information; Using webScoket connection, the stored information is pushed to the front-end display system; The front-end display system receives the storage information, queries the display JSON data from the relational database based on the storage information, and performs parsing and display processing on the display JSON data; Wherein, the step of writing the data of the Excel file into a data table according to the preset EasyExcel library to generate a map data table comprises: Using the ExcelUtil tool class in the preset EasyExcel library, the Excel file is verified for file legitimacy to obtain a verification result; When the verification result is qualified, the data of the Excel file is written into List <Map<String,String> >In the structure, generate a map data table; Wherein, the data of the Excel file is written into List <Map<String,String> > In the structure, the generated map data table includes: Use the ReadListener class in the EasyExcel library to listen to the data of the Excel file being written into the List <Map<String,String> >For each row of data in the structure, get the monitoring process data; When there is an abnormality in the monitoring process data, the data writing process is terminated and the error data is sent to the front-end display system.
2. The interactive method for displaying data according to claim 1, characterized in that: After parsing and displaying the display JSON data, the method further includes: The front-end display system receives the data query request and sends the data query request to the back-end control system according to the preset HTTP protocol; The backend control system receives the data query request, and based on the data query request, queries the corresponding display JSON data from the relational database; According to the preset front-end format, the display JSON data is encapsulated and processed to generate formatted JSON data; Through the HTTP protocol, the formatted JSON data is responded to and fed back to the front-end display system.
3. The interactive method for displaying data according to claim 2, characterized in that: The querying of corresponding display JSON data from the relational database based on the data query request includes: Cache the preset historical query records in the preset Redis database; Determine whether the data query request is in the Redis database; When in the Redis database, the display JSON data corresponding to the data query request is copied from the Redis database; If the data is not in the Redis data, the display JSON data corresponding to the data query request is queried from the relational database, and the data query request is written into the historical query record.
4. The interactive method for displaying data according to claim 3, characterized in that: The step of querying the display JSON data corresponding to the data query request from the relational database includes: Generate the SQL query statement corresponding to the data query request based on the MyBatis framework; Based on the SQL query statement, query processing is performed on the index of the relational database to obtain and display JSON data.
5. The interactive method for displaying data according to claim 1, characterized in that: Before the storage information is pushed to the front-end display system by using the webScoket connection, the method includes: The backend control system establishes a Websocket service based on the Spring WebSocket framework; The front-end display system establishes a WebSocket connection with the back-end control system based on the SockJS library and the STOMP text protocol, and uses the subscribe function to monitor the data pushed by the back-end control system.
6. The interactive method for displaying data according to claim 1, characterized in that: The front-end display system receiving the import request instruction includes: The front-end display system receives a click event; The configurator interface is displayed based on the click event, and an import request instruction of the configurator interface is received.
7. An interactive device for displaying data, characterized in that: The interactive device for displaying data comprises: a memory and at least one processor, the memory stores instructions, and the memory and the at least one processor are interconnected via a line; The at least one processor calls the instruction in the memory to enable the interactive device for displaying data to execute the interactive method for displaying data according to any one of claims 1 to 6.
8. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the interactive method for displaying data according to any one of claims 1 to 6 is implemented.
Citation Information
Patent Citations
Excel general import implementation method based on template configuration
CN117236304A
Source code transfer control method, computer program therefor, and recording medium therefor
US20180018165A1