Multi-level page switching table data method and device, electronic equipment and storage medium

By responding to switching commands in multi-level pages, using the sequence number and connector mapping relationship to find the primary key identifier, and directly retrieving and displaying detailed information from the database, the problem of cumbersome data switching in multi-level pages is solved, achieving convenient data switching and an optimized user experience.

CN115221451BActive Publication Date: 2026-01-23BEIJING TOPSEC NETWORK SECURITY TECH +2
View PDF 2 Cites 0 Cited by

Patent Information

Application Number
CN202211009060.0
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2022-08-22
Publication Date
2026-01-23
Estimated Expiration
2042-08-22

AI Technical Summary

Technical Problem

In multi-level page scenarios, switching data is cumbersome, time-consuming, and results in a poor user experience.

Method used

By responding to the switching command, the serial number of the target data is determined, and the primary key identifier of the target data is found using the preset connector mapping relationship. Detailed information is then obtained from the database and rendered and displayed directly on the current subpage.

Benefits of technology

It simplifies data switching operations across multiple page levels, reduces time costs, and optimizes the user experience.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN115221451B_ABST
    Figure CN115221451B_ABST
Patent Text Reader

Abstract

The application provides a multi-level page switching table data method and device, electronic equipment and storage medium. The method comprises the following steps: in response to a switching instruction for a current sub-page, determining a serial number of target data; wherein the target data is table data indicated by the switching instruction to be switched, and the serial number of the target data indicates the arrangement order of the target data in a main page; determining the primary key identifier of the target data in a preset connector according to the serial number; wherein the connector comprises the mapping relationship between the serial numbers and the primary key identifiers of multiple pieces of table data in the main page; finding the detailed information of the target data from a database according to the primary key identifier of the target data; determining the target information corresponding to the current sub-page from the found detailed information, and rendering and displaying the target information in the current sub-page. According to the application, the table data can be conveniently switched in the multi-level page scenario, the cumbersome switching operation is simplified, and the time cost is reduced.
Need to check novelty before this filing date? Find Prior Art

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of computer, in particular to a multi-level page switching table data method and device, electronic equipment and computer readable storage medium. BACKGROUND

[0002] In a web end management platform, there are a large number of main pages to display data lists in the form of tables. When the content in the data list is more, pagination can be designed to improve query efficiency. If the data volume of each data in the data list is large, a multi-level page can also be set, which includes a main page and a plurality of level sub-pages under the main page. Among them, the table in the main page records the information of each data (such as: data name, data identifier, etc.) in a concise manner, and each level sub-page respectively displays the detailed information of each data at each level. The main page opens the first level sub-page through the pop-up window function, the first level sub-page opens the second level sub-page through the pop-up window function, and so on.

[0003] In the related technology, when opening a sub-page of a certain level to display the detailed information of a certain data, if it is needed to switch to another data and then display the detailed data of the another data in the sub-page of the level, it is necessary to return to the upper level sub-page step by step until the main page is returned, and then another data is selected. After selection, the sub-page is opened one by one until the sub-page displaying the detailed information is returned.

[0004] It can be seen that in the related technology, the operation of switching data in the multi-level page scenario is very cumbersome, the time cost is high, and the user experience is poor. SUMMARY

[0005] The purpose of the embodiments of the present application is to provide a multi-level page switching table data method and device, electronic equipment and computer readable storage medium, which is used to simplify the operation of switching data when displaying detailed information in the sub-page, reduce the time cost, and optimize the use experience.

[0006] In one aspect, the present application provides a multi-level page switching table data method, comprising:

[0007] In response to a switching instruction for a current sub-page, a sequence number of target data is determined; wherein the target data is the table data indicated by the switching instruction, and the sequence number of the target data indicates the arrangement order of the target data in the main page;

[0008] According to the sequence number, the primary key identifier of the target data is determined in a preset connector; wherein the connector includes the mapping relationship between the sequence number and the primary key identifier of the plurality of table data in the main page;

[0009] According to the primary key identifier of the target data, detailed information of the target data is found from a database;

[0010] From the found detailed information, target information corresponding to the current sub-page is determined, and the target information is rendered and displayed in the current sub-page.

[0011] Through the above measures, in the multi-level page scenario, the table data can be conveniently switched, the cumbersome switching operation is simplified, the time cost is reduced, and the user experience is optimized.

[0012] In an embodiment, in response to the switching instruction for the current sub-page, the sequence number of the target data is determined, including:

[0013] The switching amplitude value indicated by the switching instruction is parsed;

[0014] According to the switching amplitude value and the sequence number of the current data, the sequence number of the target data is determined; wherein the current data is the table data displayed in the current sub-page.

[0015] Through the above measures, the sequence number of the target data can be determined, so that subsequent switching of the table data is performed with the sequence number.

[0016] In an embodiment, the switching instruction is issued by a user corresponding to target account information;

[0017] According to the sequence number, the primary key identifier of the target data is determined in a preset connector, including:

[0018] The corresponding connector is found with the target account information;

[0019] According to the sequence number, the primary key identifier of the target data is determined in the found connector.

[0020] Through the above measures, different users use unique independent connectors to switch table data, thereby meeting the application requirements.

[0021] In an embodiment, before the primary key identifier of the target data is determined in the preset connector according to the sequence number, the method further includes:

[0022] According to the filtering instruction, a plurality of table data satisfying the filtering condition in the filtering instruction is filtered from the database;

[0023] The sequence number of the plurality of table data in the main page is determined;

[0024] The mapping relationship between the sequence number of each table data and its corresponding primary key identifier is constructed, and written into the connector constructed for the target account information.

[0025] Through the above measures, the connector can be constructed for subsequent quick switching of table data.

[0026] In an embodiment, the connector is configured with a corresponding expiration time, and the method further comprises:

[0027] In the case where the expiration time of the connector is reached, the connector is deleted.

[0028] Through this measure, the connector can avoid occupying too much memory space, and memory leakage can also be avoided.

[0029] In an embodiment, the detailed information of the target data is found from the database according to the primary key identifier of the target data, comprising:

[0030] According to the primary key identifier of the target data, the database is searched to determine whether the detailed information corresponding to the primary key identifier is found;

[0031] If the detailed information cannot be found, the sequence number of the target data is updated based on the switching direction indicated by the switching instruction; wherein the switching direction is an increasing direction or a decreasing direction;

[0032] The updated sequence number is used to determine the updated primary key identifier through the connector, and the updated primary key identifier is used as the primary key identifier of the target data, and the step of searching the database is returned;

[0033] The above process is repeated until the detailed information corresponding to the primary key identifier is found.

[0034] Through the above measures, when the data in the database changes, the sequence number can be updated in the form of sequentially increasing or sequentially decreasing from the sequence number, and the primary key identifier of the target data can be replaced, so that the table data that can be normally displayed can be switched to.

[0035] In an embodiment, the method further comprises:

[0036] If the detailed information corresponding to the updated sequence number cannot be found within the sequence number range recorded by the connector, the table data of the main page is re-screened according to the screening instruction;

[0037] Based on the re-screened table data, the connector is re-constructed.

[0038] Through the above measures, if the table data recorded by the main page is deleted in the database, the table data of the main page can be updated, the table data of the main page is ensured to be consistent with the database, and the subsequent switching of the table data can be normally performed.

[0039] In another aspect, the present application provides a multi-level page switching table data device, comprising:

[0040] A first determining module is configured to determine a sequence number of target data in response to a switching instruction for a current sub-page, wherein the target data is table data indicated by the switching instruction to switch, and the sequence number of the target data indicates an arrangement order of the target data in a main page;

[0041] A second determining module is configured to determine a primary key identifier of the target data in a preset connector according to the sequence number, wherein the connector comprises a mapping relationship between sequence numbers and primary key identifiers of multiple pieces of table data in the main page;

[0042] A searching module is configured to search for detailed information of the target data from a database according to the primary key identifier of the target data;

[0043] A displaying module is configured to determine target information corresponding to the current sub-page from the searched detailed information, and render and display the target information in the current sub-page.

[0044] In addition, the present application provides an electronic device, comprising:

[0045] A processor;

[0046] A memory for storing processor-executable instructions;

[0047] The processor is configured to execute the multi-level page switching table data method.

[0048] Further, the present application also provides a computer-readable storage medium, which stores a computer program executable by a processor to complete the multi-level page switching table data method. BRIEF DESCRIPTION OF DRAWINGS

[0049] In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings needed to be used in the embodiments of the present application will be briefly introduced as follows.

[0050] Figure 1 An application scenario diagram of the multi-level page switching table data method provided by an embodiment of the present application;

[0051] Figure 2 A structural diagram of the electronic device provided by an embodiment of the present application;

[0052] Figure 3 A flowchart of the multi-level page switching table data method provided by an embodiment of the present application;

[0053] Figure 4 A schematic flowchart illustrating a method for constructing a connector according to an embodiment of this application;

[0054] Figure 5 Provided for an embodiment of this application Figure 3 A detailed flowchart of step 310 is shown below;

[0055] Figure 6 A block diagram of a multi-level page switching table data device provided in an embodiment of this application. Detailed Implementation

[0056] The technical solutions in the embodiments of this application will now be described with reference to the accompanying drawings.

[0057] Similar reference numerals and letters in the following figures indicate similar items; therefore, once an item is defined in one figure, it does not need to be further defined and explained in subsequent figures. Furthermore, in the description of this application, terms such as "first," "second," etc., are used only to distinguish descriptions and should not be construed as indicating or implying relative importance.

[0058] Figure 1 This is a schematic diagram illustrating an application scenario of the multi-level page switching table data method provided in an embodiment of this application. For example... Figure 1 As shown, the application scenario includes a client 20 and a server 30. The client 20 can be a user terminal such as a host, mobile phone, or tablet computer, used to send a switching instruction to the server 30 to switch the table data. The server 30 can be a server, server cluster, or cloud computing center, which can respond to the switching instruction, determine the target information to be displayed on the subpage, and display it, thereby switching the table data on the current subpage.

[0059] like Figure 2 As shown, this embodiment provides an electronic device 1, including: at least one processor 11 and a memory 12. Figure 2 Taking a processor 11 as an example, the processor 11 and the memory 12 are connected via a bus 10. The memory 12 stores instructions that can be executed by the processor 11. The instructions are executed by the processor 11 to enable the electronic device 1 to perform all or part of the processes of the methods in the embodiments described below. In one embodiment, the electronic device 1 may be the server 30 described above, used to execute a multi-level page switching table data method.

[0060] The memory 12 can be implemented by any type of volatile or non-volatile storage device or a combination thereof, such as static random access memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), magnetic storage, flash memory, magnetic disk or optical disk.

[0061] The application also provides a computer readable storage medium, the storage medium stores a computer program, the computer program can be executed by the processor 11 to complete the multi-level page switching table data method provided by the application.

[0062] Referring to Figure 3 The flowchart of the multi-level page switching table data method provided by an embodiment of the application is shown in Figure 3 The method can include the following steps 310-340.

[0063] Step 310: in response to a switching instruction for a current sub-page, determining the serial number of target data; wherein the target data is the table data indicated by the switching instruction to switch, and the serial number of the target data indicates the arrangement order of the target data in the main page.

[0064] The current sub-page is the sub-page currently displayed at the front end in the multi-level page. When the multi-level page is connected by a single linked list or switched by a jump mode, only one level of sub-page is displayed at the front end at the same time.

[0065] The switching instruction is used to indicate the switching of the table data displayed by the multi-level page. The main page of the multi-level page records the information of the table data more concisely, and the detailed information of each data is displayed by the sub-pages of different levels respectively. For example, the table data is the personal information of a consumer, including the name, address, purchase record, purchase time, purchase habit and consumption amount of the consumer, and the name can be recorded in the main page, and the address and purchase time, purchase record, purchase habit and consumption amount are recorded by four levels of sub-pages respectively. Each table data in the main page has a corresponding serial number, which is used to indicate the arrangement order of each table data in the table of the main page. For example, there are 100 table data in the table of the main page, and the serial number can be from 1 to 100.

[0066] The switching instruction can be triggered by a user through a switching operation. For example, each page of the multi-level page can include a button in the increment direction and a button in the decrement direction. By clicking the button on the page, the switching instruction can be generated. Alternatively, each page of the multi-level page can include an input box for inputting a switching magnitude value, so as to generate the switching instruction with the switching magnitude value. Alternatively, the user can generate the switching instruction by voice control as the switching operation.

[0067] After receiving the switching instruction, the electronic device can determine that the table data in the current sub-page needs to be switched, so as to display the detailed information of the target data in the current sub-page. At this time, the electronic device can determine the sequence number of the target data to be switched according to the switching instruction.

[0068] In an embodiment, the electronic device can parse the switching magnitude value indicated by the switching instruction. The switching magnitude value represents the size of the switching magnitude of the table data. In addition, the switching magnitude value can also represent the switching direction, which includes the increment direction and the decrement direction. The increment direction indicates switching from the table data displayed in the current sub-page to the direction with a higher sequence number. The decrement direction indicates switching from the table data displayed in the current sub-page to the direction with a lower sequence number.

[0069] The electronic device can determine the sequence number of the target data according to the switching magnitude value and the sequence number of the current data. Here, the current data is the table data displayed in the current sub-page. During the opening of the sub-page in each level, the sequence number of the current data can be passed to the opened sub-page, so as to be used for table data switching.

[0070] For example, the sequence number of the current data is 40, and the switching magnitude value is -20, which indicates switching 20 data in the decrement direction. Therefore, the sequence number of the target data is 20. For example, the sequence number of the current data is 10, and the switching magnitude value is 1, which indicates switching 1 data in the increment direction. Therefore, the sequence number of the target data is 11.

[0071] Through the above measures, the sequence number of the target data can be determined, so as to subsequently switch the table data with the sequence number.

[0072] Step 320: According to the sequence number, determine the primary key identifier of the target data in the preset connector; wherein, the connector includes the mapping relationship between the sequence number and the primary key identifier of the plurality of table data in the main page.

[0073] The electronic device can find the serial number in the connector, determine the primary key identifier corresponding to the serial number as the primary key identifier of the target data. The connector provides a query interface, and by calling the query interface, the corresponding primary key identifier is found in the dictionary of the connector according to the serial number. The dictionary in the connector stores the mapping relationship between the serial number of each table data in the main page and the primary key identifier. The primary key identifier of the table data is used to indicate the position of the table data in the data table of the database.

[0074] Step 330: According to the primary key identifier of the target data, find the detailed information of the target data from the database.

[0075] After obtaining the primary key identifier of the target data, the electronic device can find the detailed information of the target data in the data table of the database according to the primary key identifier. Here, the target data can be taken as the detailed information.

[0076] Step 340: From the found detailed information, determine the target information corresponding to the current sub-page, and render and display the target information in the current sub-page.

[0077] After finding the detailed information of the target data, the electronic device can select the target information corresponding to the current sub-page from the detailed information. Here, the target information is the information displayed by the target data at the level of the current sub-page. For example, the table data is the personal information of a consumer, and the target data is the personal information of a consumer "Xiaoming". After finding the detailed data, since the current sub-page is used to display the consumption amount in the personal information, the consumption amount can be selected as the target information from the detailed data.

[0078] After obtaining the target information, the target information is rendered according to the display form of the current sub-page, and then the target information is displayed in the current sub-page.

[0079] Through the above measures, in the multi-level page scenario, the table data can be switched conveniently, the cumbersome switching operation is simplified, the time cost is reduced, and the user's use experience is optimized.

[0080] In an embodiment, the switching instruction is issued by a user corresponding to target account information. Here, the target account information is the account information of the user who controls the page to switch the table data. For the scenario of using one account for each user, the account information can be the account itself. For the scenario of using a single account for multiple users, in order to distinguish the user operations, a user identifier (such as a random number) can be assigned to different users respectively, and at this time, the account information can include the account and the user identifier.

[0081] In this case, each account information corresponds to a unique and independent connector. The connector on the electronic device can be associated with the account information. When searching for the primary key identifier of the target data in the connector, the electronic device can search for the corresponding connector with the target account information, and then search for the primary key identifier corresponding to the serial number of the target data in the found connector, as the primary key identifier of the target data.

[0082] Through the above measures, different users use unique and independent connectors to switch table data, thereby meeting the application requirements.

[0083] In an embodiment, before performing the table data switching method of the present application, a connector can be constructed. Referring to Figure 4 The flowchart of the construction method of the connector provided by an embodiment of the present application is shown in Figure 4 The connector can be constructed by the following steps 410 to 430.

[0084] Step 410: According to the filtering instruction, a plurality of table data satisfying the filtering condition in the filtering instruction are filtered from the database.

[0085] The filtering instruction is used to indicate that the table data displayed on the main page is filtered from the database. The filtering instruction can be issued by the user corresponding to the target account information, or can be generated autonomously according to the demand before the multi-level page is opened. The filtering instruction can include one or more filtering conditions, and the filtering condition is used to filter the data in the database data table; the filtering condition can include but is not limited to paging, time range, fuzzy search, accurate search, etc.

[0086] The electronic device can respond to the filtering instruction, parse the filtering condition therefrom, and filter a plurality of table data from the database according to the filtering condition.

[0087] Step 420: Determine the serial number of the plurality of table data in the main page.

[0088] After filtering out a plurality of table data, the total number of table data can be counted, and the plurality of table data can be sorted according to a preset arrangement manner. For example, the plurality of table data can be sorted according to the default arrangement manner of the plurality of table data, or the plurality of table data can be sorted according to the size of the primary key identifier of the plurality of table data.

[0089] After sorting, the serial number of each table data in the main page can be determined.

[0090] Step 430: Construct the mapping relationship between the serial number of each table data and the primary key identifier corresponding thereto, and write it into the connector constructed for the target account information.

[0091] After determining the sequence number of each table data, a mapping relationship between the sequence number of each table data and the primary key identifier can be constructed, so as to obtain a plurality of mapping relationships. The electronic device can write the mapping relationship into a connector constructed for the target account information.

[0092] Through the above measures, the connector can be constructed for subsequent quick switching of table data.

[0093] In the actual development process, the connector can be constructed in various ways. For example, the connector can be constructed by using a cache mechanism, which includes but is not limited to a cache mechanism provided by a development language. For example, the ob cache technology of the PHP (Hypertext Preprocessor) language, the connector buffer area is opened through the ob_start instruction, and then the mapping relationship between the sequence number of each table data and the primary key identifier is written into the buffer area. Finally, the mapping relationship of the buffer area is obtained through the ob_get_contents instruction to obtain the connector.

[0094] Alternatively, the connector can be constructed by using a language framework cache. For example, the S method of the ThinkPHP commonly used in PHP framework, after writing the mapping relationship between the sequence number of each table data and the primary key identifier into the cache, the connector is constructed.

[0095] Alternatively, the connector can be constructed by using a file storage method. A JSON (JavaScript Object Notation) file with read-write and executable rights is created, and after writing the mapping relationship between the sequence number of each table data and the primary key identifier into the JSON file, the JSON file is used as the connector.

[0096] Alternatively, a NoSQL cache database (such as Redis, Memcache, MongoDB, Cassandra, CouchDB, etc.) can be used to write the mapping relationship between the sequence number of each table data and the primary key identifier into the connector in the cache database.

[0097] Alternatively, the connector can be constructed by using a session or cookie session mechanism. The session start is used to open the session session mechanism, and the mapping relationship between the sequence number of each table data and the primary key identifier is written into the session session to obtain the connector.

[0098] In an embodiment, each connector is configured with a corresponding expiration time, which represents a time limit within which the connector can be used normally. For any connector, the electronic device can delete the connector when the corresponding expiration time of the connector is reached, so as to release the memory space occupied by the connector. By this measure, the connector can be prevented from occupying too much memory space, and memory leakage can also be avoided.

[0099] In an embodiment, referring to Figure 5 For an embodiment of the present application, the details of step 330 in Figure 3 The detailed flowchart of step 330 in

[0100] Step 331: According to the primary key identifier of the target data, the database is searched to determine whether the detailed information corresponding to the primary key identifier is found.

[0101] After the primary key identifier of the target data is determined, the electronic device can search the data table of the database for the detailed information corresponding to the primary key identifier. The electronic device can determine whether the detailed information corresponding to the primary key identifier is found. On one hand, if the detailed information is found, step 340 can be continued to be executed. On the other hand, if the detailed information is not found, it indicates that a change occurs in the database, and step 332 can be continued to be executed.

[0102] Step 332: If the detailed information corresponding to the primary key identifier is not found, the sequence number of the target data is updated based on the switching direction indicated by the switching instruction; wherein the switching direction is an increasing direction or a decreasing direction.

[0103] In the case that the detailed information corresponding to the primary key identifier is not found, the electronic device can update the sequence number of the target data according to the switching direction indicated by the switching instruction. In one case, the switching direction is the increasing direction, and the sequence number of the target data can be increased by one to obtain a new sequence number. In another case, the switching direction is the decreasing direction, and the sequence number of the target data can be decreased by one to obtain a new sequence number.

[0104] Step 333: The updated sequence number is used to determine the updated primary key identifier through the connector, and the updated primary key identifier is taken as the primary key identifier of the target data, and the step of searching the database is returned.

[0105] After the sequence number of the target data is updated, the electronic device can search the connector for the primary key identifier corresponding to the updated sequence number, so as to update the primary key identifier of the target data. The electronic device can return to step 331 to search the database with the updated primary key identifier.

[0106] Step 334: The above process is repeated until the detailed information corresponding to the primary key identifier is found.

[0107] The electronic device can repeat the steps 331 to 333 until the corresponding detailed information can be found in the database by the primary key identification, in which case the step 340 can be continued.

[0108] By the above measures, when the data in the database changes, the primary key identification of the target data can be replaced by updating the serial number in a way of sequentially increasing or sequentially decreasing, so as to switch to the table data that can be normally displayed.

[0109] In an embodiment, if the detailed information cannot be found by the primary key identification of the target data, and after updating the serial number for multiple times, if the detailed information cannot be found according to the primary key identification corresponding to the updated serial number within the serial number range recorded by the connector, it indicates that the table data currently recorded by the main page has been deleted in the database. In this case, the table data in the main page needs to be updated. The electronic device can re-filter a plurality of table data of the main page according to the filtering instruction. The specific filtering process can be referred to the foregoing, and will not be described here.

[0110] After updating the table data of the main page, the electronic device can re-construct the connector based on the plurality of table data re-filtered. The specific way of constructing the connector can be referred to the foregoing, and will not be described here.

[0111] By the above measures, if the table data recorded by the main page is deleted in the database, the table data of the main page can be updated to ensure that the table data of the main page is consistent with the database, so that the table data can be normally switched subsequently.

[0112] In actual application, the multi-level page can be a security event list main page of a firewall Web management platform. The main page records table data obtained by aggregating and querying key information such as security event name, attacker IP (Internet Protocol), victim IP, etc. Each table data can be used to view un-aggregated security event information meeting the query condition by opening a sub-page. When viewing the security event information on the sub-page, the table data can be directly switched by the scheme of the present application, so as to directly view another security event information on the sub-page.

[0113] Figure 6 is a block diagram of a multi-level page table data switching device according to an embodiment of the present application, as shown in Figure 6 The device can include:

[0114] The first determination module 610 is configured to determine a serial number of target data in response to a switching instruction for a current sub-page, wherein the target data is table data indicated to be switched by the switching instruction, and the serial number of the target data indicates an arrangement order of the target data in a main page.

[0115] The second determining module 620 is configured to determine the primary key identifier of the target data according to the serial number in a preset connector, wherein the connector comprises a mapping relationship between the serial number and the primary key identifier of the table data in the main page.

[0116] The searching module 630 is configured to search the detailed information of the target data from a database according to the primary key identifier of the target data.

[0117] The displaying module 640 is configured to determine the target information corresponding to the current sub-page from the searched detailed information, and render and display the target information in the current sub-page.

[0118] The functions and effects of the modules in the above device are specifically described in the implementation process of the corresponding steps in the above multi-level page switching table data method, and will not be repeated here.

[0119] In several embodiments provided in the present application, the disclosed device and method can also be implemented in other ways. The device embodiments described above are only schematic, for example, the flowcharts and block diagrams in the drawings show the possible implementation architectures, functions and operations of the device, method and computer program product according to the embodiments of the present application. In this regard, each block in the flowcharts or block diagrams can represent a module, a program segment or a part of code, which contains one or more executable instructions for implementing the specified logical function. In some alternative implementation manners, the functions noted in the blocks can also occur in different orders from those noted in the drawings. For example, two consecutive blocks can actually be executed substantially in parallel, and sometimes they can be executed in reverse order, depending on the functions involved. It should also be noted that each block in the block diagrams and / or flowcharts, and the combination of blocks in the block diagrams and / or flowcharts, can be implemented by a dedicated hardware-based system for implementing the specified functions or actions, or can be implemented by a combination of dedicated hardware and computer instructions.

[0120] In addition, the functional modules in each embodiment of the present application can be integrated together to form an independent part, or each module can exist independently, or two or more modules can be integrated to form an independent part.

[0121] If the functions are implemented in the form of software function modules and sold or used as independent products, the functions can be stored in a computer readable storage medium. Based on this understanding, the technical solutions of the present application can be embodied in the form of a software product, and the computer software product is stored in a storage medium, including a plurality of instructions for causing a computer device (which can be a personal computer, a server, or a network device, etc.) to execute all or part of the steps of the embodiments of the method of the present application. The aforementioned storage medium includes: a U disk, a mobile hard disk, a read-only memory (ROM, Read-Only Memory), a random access memory (RAM, Random Access Memory), a magnetic disk or an optical disk, and various media that can store program codes.

Claims

1. A method for switching table data across multiple page levels, characterized in that, include: In response to a switching instruction for the current subpage, the sequence number of the target data is determined; wherein the target data is the table data to be switched by the switching instruction, and the sequence number of the target data indicates the arrangement order of the target data on the main page; Based on the serial number, the primary key identifier of the target data is determined in a preset connector; wherein, the connector includes the mapping relationship between the serial numbers and primary key identifiers of multiple table data in the main page; Based on the primary key identifier of the target data, retrieve the detailed information of the target data from the database; From the detailed information found, determine the target information corresponding to the current subpage, and render and display the target information on the current subpage; The step of retrieving detailed information about the target data from the database based on the primary key identifier of the target data includes: Based on the primary key identifier of the target data, search the database to determine whether detailed information corresponding to the primary key identifier is found. If the data cannot be found, the sequence number of the target data is updated based on the switching direction indicated by the switching instruction; wherein the switching direction is an increasing or decreasing direction. The updated primary key identifier is determined by using the updated serial number through the connector, and the updated primary key identifier is used as the primary key identifier of the target data. The process then returns to the step of searching the database. Repeat the above process until the detailed information corresponding to the primary key identifier is found.

2. The method according to claim 1, characterized in that, The step of determining the sequence number of the target data in response to a switching instruction for the current subpage includes: Parse the switching magnitude value indicated by the switching command; The sequence number of the target data is determined based on the switching amplitude value and the sequence number of the current data; wherein, the current data is the table data displayed on the current subpage.

3. The method according to claim 1, characterized in that, The switching instruction is issued by the user corresponding to the target account information; The step of determining the primary key identifier of the target data in a preset connector based on the serial number includes: Use the target account information to find the corresponding connector; Based on the serial number, determine the primary key identifier of the target data in the found connector.

4. The method according to claim 3, characterized in that, Before determining the primary key identifier of the target data in a preset connector based on the serial number, the method further includes: According to the filtering instructions, several tables of data that meet the filtering conditions in the filtering instructions are filtered from the database; Determine the serial number of the aforementioned table data on the main page; Construct a mapping relationship between the sequence number of each table data and its corresponding primary key identifier, and write it into the connector constructed for the target account information.

5. The method according to claim 4, characterized in that, The connector is configured with a corresponding expiration time, and the method further includes: If the connector reaches its expiration time, the connector is deleted.

6. The method according to claim 1, characterized in that, The method further includes: If detailed information cannot be found based on the primary key identifier corresponding to the updated serial number within the range of serial numbers recorded by the connector, several table data of the main page are re-filtered according to the filtering instructions. Based on the re-filtered table data, the connectors were rebuilt.

7. A multi-level page switching table data device, characterized in that, include: The first determining module is used to determine the sequence number of target data in response to a switching instruction for the current subpage; wherein the target data is the table data to be switched by the switching instruction, and the sequence number of the target data indicates the arrangement order of the target data on the main page; The second determining module is used to determine the primary key identifier of the target data in a preset connector based on the serial number; wherein, the connector includes the mapping relationship between the serial numbers and primary key identifiers of multiple table data in the main page; The search module is used to search for detailed information about the target data from the database based on the primary key identifier of the target data. The display module is used to determine the target information corresponding to the current subpage from the found detailed information, and to render and display the target information in the current subpage; The search module is specifically used to search the database based on the primary key identifier of the target data, and determine whether detailed information corresponding to the primary key identifier is found. If not found, the serial number of the target data is updated based on the switching direction indicated by the switching instruction, wherein the switching direction is an increasing or decreasing direction. The updated serial number is used through the connector to determine the updated primary key identifier, and the updated primary key identifier is used as the primary key identifier of the target data. The process then returns to the step of searching the database. The above process is repeated until detailed information corresponding to the primary key identifier is found.

8. An electronic device, characterized in that, The electronic device includes: processor; Memory used to store processor-executable instructions; The processor is configured to execute the multi-level page switching table data method according to any one of claims 1-6.

9. A computer-readable storage medium, characterized in that, The storage medium stores a computer program that can be executed by a processor to perform the multi-level page switching table data method according to any one of claims 1-6.

Citation Information

Patent Citations

  • List data query method and device, electronic equipment and storage medium

    CN114637790A

  • Page switching method and apparatus, computer program, and readable medium

    WO2017107834A1