CN115510070A - Method and related device applied to page-crossing selection of paging request data table - Google Patents
Method and related device applied to page-crossing selection of paging request data table Download PDFInfo
- Publication number
- CN115510070A CN115510070A CN202211289522.9A CN202211289522A CN115510070A CN 115510070 A CN115510070 A CN 115510070A CN 202211289522 A CN202211289522 A CN 202211289522A CN 115510070 A CN115510070 A CN 115510070A
- Authority
- CN
- China
- Prior art keywords
- target
- data
- entry
- data table
- paging
- 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.)
- Pending
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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The application discloses a method and a related device applied to page crossing selection of a paging request data table, which are used for sending a data acquisition request to a database, wherein the data acquisition request comprises data requirements and target data volume of a user. And acquiring a target paging data table meeting the data requirement. And displaying the target paging data table on the display page so that a user can select aiming at the entries in the target paging data table, acquiring the index value of the selected target entry, wherein the index value and the target entry have a unique corresponding relation, and storing the index value and the target entry in the second storage space so that the target entry can be acquired based on the index value subsequently. Therefore, after a new paging data table is obtained, even if the target paging data table is covered, the storage of the index value and the target entry cannot be influenced, and the problem that data cannot be selected in a page crossing manner is solved.
Description
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a method and a related apparatus for selecting a paging request data table across pages.
Background
When a user views a data form with a large data volume, the terminal device generally displays the data form to the user in a paging display mode, so that the data transmission volume of each interaction with the database is reduced, and the waiting time of the user is reduced.
In the process of displaying data in a paging mode, a paging request technology is used, namely data of each page of a data table is obtained through an interface request, and the data is requested again when the page is switched once, so that the paging display effect is achieved.
However, in the process of obtaining data by using the paging request technology, the front end generally uses the same variable to store data of different pages, and if a user switches pages, data of a newly displayed page may cover data of a previously displayed page, so that a problem that data cannot be selected across pages occurs.
Disclosure of Invention
In view of the foregoing problems, the present application provides a method and a related apparatus for selecting a paging request data table across pages, so as to avoid the problem that data cannot be selected across pages.
Based on this, the embodiment of the application discloses the following technical scheme:
in one aspect, an embodiment of the present application provides a method for selecting a page crossing of a paging request data table, where the method includes:
sending a data acquisition request to a database, wherein the data acquisition request comprises a data demand and a target data volume of a user, and the target data volume is the data volume of items required to be displayed on a display page;
acquiring a target paging data table meeting the data requirement, wherein the data volume of entries included in the target paging data table is equal to the target data volume, and the target paging data table is stored in a first storage space;
displaying the target paging data table on the display page;
responding to the selection of a user aiming at a target entry in the target paging data table, and acquiring an index value of the target entry, wherein the index value and the target entry have a unique corresponding relation;
storing the index value and the target entry to a second storage space, the second storage space being different from the first storage space.
Optionally, the obtaining the index value of the target entry includes:
constructing an item identifier for each item in the data table;
and acquiring the entry identification of the target entry, and using the entry identification of the target entry as the index value of the target entry.
Optionally, the obtaining the index value of the target entry includes:
acquiring a page number of the target entry and a position of the target entry, wherein the page number is used for identifying the order of the target paging data table in a plurality of paging data tables included in the data table, and the position is used for identifying the order of the target entry in the target paging data table;
and determining the index value of the target entry according to the target data volume, the page number and the position.
Optionally, the determining an index value of the target entry according to the target data amount, the page number, and the position includes:
determining a difference value between the page number and 1;
determining a product of the difference and the target amount of data;
the sum of the product and the location is determined and used as the index value for the target entry.
In another aspect, the present application provides an apparatus for selecting a page crossing of a paging request data table, the apparatus comprising: the device comprises a sending unit, a first obtaining unit, a display unit, a second obtaining unit and a storage unit;
the sending unit is used for sending a data acquisition request to a database, wherein the data acquisition request comprises the data requirement of a user and a target data volume, and the target data volume is the data volume of items required to be displayed on a display page;
the first obtaining unit is configured to obtain a target paging data table that meets the data requirement, where a data size of an entry included in the target paging data table is equal to the target data size, and the target paging data table is stored in a first storage space;
the display unit is used for displaying the target paging data table on the display page;
the second obtaining unit is used for responding to the selection of a user aiming at a target entry in the target paging data table, and obtaining an index value of the target entry;
the storage unit is configured to store the index value and the target entry in a second storage space, where the second storage space is different from the first storage space.
Optionally, the second obtaining unit is specifically configured to:
constructing an item identifier for each item in the data table;
and acquiring the entry identification of the target entry, and using the entry identification of the target entry as the index value of the target entry.
Optionally, the second obtaining unit is specifically configured to:
acquiring a page number of the target entry and a position of the target entry, wherein the page number is used for identifying the order of the target paging data table in a plurality of paging data tables included in the data table, and the position is used for identifying the order of the target entry in the target paging data table;
and determining the index value of the target entry according to the target data volume, the page number and the position.
Optionally, the second obtaining unit is specifically configured to:
determining a difference between the page number and 1;
determining a product of the difference and the target amount of data;
the sum of the product and the location is determined and used as the index value for the target entry.
In another aspect, the present application provides a computer device comprising a processor and a memory:
the memory is used for storing program codes and transmitting the program codes to the processor;
the processor is configured to perform the method of the above aspect according to instructions in the program code.
In another aspect, the present application provides a computer-readable storage medium for storing a computer program for performing the method of the above aspect.
In another aspect, embodiments of the present application provide a computer program product or a computer program, which includes computer instructions stored in a computer-readable storage medium. The processor of the computer device reads the computer instructions from the computer-readable storage medium, and the processor executes the computer instructions to cause the computer device to perform the method of the above aspect.
The above technical scheme of this application's advantage lies in:
sending a data acquisition request to a database, wherein the data acquisition request comprises a data requirement of a user and a target data volume, the data requirement is used for indicating to acquire a data table required by the user, but because the data volume of the data table is generally large, in order to reduce the data transmission volume of each interaction with the database, the data table is displayed in a paging mode, that is, the data table is displayed by a plurality of paging data tables respectively, and the data volume of entries included in each paging data table is limited by the target data volume. And acquiring a target paging data table meeting the data requirement, wherein the data volume of the entries included in the target paging data table is equal to the target data volume. And displaying the target paging data table on the display page so that a user can select the entries in the target paging data table, wherein the selected entries are called target entries, acquiring the index values of the target entries, the index values and the target entries have unique corresponding relations, and storing the index values and the target entries in the second storage space so that the target entries can be acquired based on the index values. Therefore, by establishing the corresponding relation between the target entry and the index value and storing the index value and the target entry in the second storage space, wherein the second storage space is different from the first storage space for storing the target paging data table, after a new paging data table is obtained, even if the target paging data table is covered, the storage of the index value and the target entry cannot be influenced, and the problem that data cannot be selected across pages is avoided.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments described in the present application, and other drawings can be obtained by those skilled in the art without creative efforts.
FIG. 1 is a schematic diagram of a data presentation provided herein;
FIG. 2 is a schematic diagram of a data presentation provided herein;
FIG. 3 is a flowchart of a method for selecting a page crossing of a page request data table according to the present application;
FIG. 4 is a diagram illustrating an apparatus for selecting a page crossing of a page request data table according to the present application;
fig. 5 is a block diagram of a computer device according to an embodiment of the present application.
Detailed Description
In order to make the technical solutions of the present application better understood, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
In the related art, the front end obtains the data table by using a paging request technique, where the data table includes a plurality of paging data tables, as shown in fig. 1, each paging data table includes a plurality of rows, each row represents an entry, and each entry has a selection box, so that a user can select an entry by checking the selection box.
In order to facilitate the presentation of data in the same page location and reduce the space consumption caused by data storage, the same variable is usually used to store data of different pages, and as shown in fig. 2, data of different pages is stored by the same variable, for example, by the same array to store the required data, and the code thereof can be expressed as < div-repeat > = "item in array. When a user switches from a first page to a second page, the second page can cover the original data of the first page, so that state data such as user selection cannot be recorded on the basis of array variables, and the problem that data cannot be selected across pages occurs.
To record the entries selected by the user on the different paginated data tables, this can be done in the following manner.
The first method is as follows: all data is acquired at once, but from the database a small number of times, so that the user's selection is recorded on the basis of all data. However, acquiring all data at one time consumes large transmission bandwidth and storage space, and is not suitable for a data table scene with large data volume.
The second method comprises the following steps: recording all the paging data tables selected by the user, and recording the selection state of the user on the basis of the selected paging data tables. Although this method can be applied to a data table scenario with a large amount of data, the selected paginated data table includes, in addition to the entry selected by the user, other entries that are not selected by the user, that is, some useless data is additionally recorded, which results in a waste of memory space.
Based on this, an embodiment of the present application provides a method for selecting page crossing of a paging request data table, where a corresponding relationship between a target entry and an index value is established, and the index value and the target entry are stored in a second storage space, where the second storage space is different from a first storage space used for storing a target paging data table, so that after a new paging data table is obtained, even if the target paging data table is covered, storage of the index value and the target entry is not affected, thereby not only avoiding a problem that data cannot be selected in page crossing, but also reducing use of the storage space.
A method for selecting a page crossing of a page request data table according to an embodiment of the present application is described below with reference to fig. 3. Referring to fig. 3, which is a flowchart illustrating a method applied to selecting a page crossing of a paging request data table according to an embodiment of the present application, the method may include S301-S305.
S301: and sending a data acquisition request to the database.
In practical application, a user can input a data requirement in a mode of inputting a search word and the like in an input interface of terminal equipment and the like, the data requirement is used for indicating to acquire a data form required by the user, and the terminal equipment can generate a data acquisition request according to the data requirement of the user.
It should be noted that the data acquisition request includes, in addition to the data requirement of the user, a target data volume, which is a data volume of the item required to be displayed on the display page. It should be noted that the target data amount may be set by a user or may be default by the system, and this is not specifically limited in this application.
S302: and acquiring a target paging data table meeting the data requirement.
The database determines a data table meeting the data requirement from the database according to the data acquisition request sent by the terminal equipment, and divides the data table into a plurality of paging data tables according to the target data volume, so that the paging data tables are sent to the terminal equipment one by one.
The target paging data table is one of a plurality of paging data tables, the target paging data table includes a number of entries equal to the target data amount, and the target paging data table is stored in the first storage space.
S303: and displaying the target paging data table on the display page.
S304: in response to a user selection of a target entry in the target paginated data table, an index value of the target entry is obtained.
And displaying the target paging data table in a display page of the terminal device so that a user can select an entry in the target paging data table, wherein the selected entry is called a target entry.
After a user selects a target entry through the terminal device, the terminal device obtains an index value of the target entry, and the index value and the target entry have a unique corresponding relation, so that the corresponding target entry can be obtained based on the index value.
The manner of acquiring the target item is not particularly limited in the embodiments of the present application, and two manners are described below as examples.
The first method is as follows: and constructing an entry identifier for each entry in the data table, acquiring the entry identifier of the target entry, and taking the entry identifier of the target entry as an index value of the target entry.
Before the database sends the data table to the terminal device, the database may construct an entry identifier for each entry included in the data table, and the entry identifier and the entry have a unique corresponding relationship, so that the corresponding entry may be determined from the database through the entry identifier.
After an entry identifier is constructed for each entry in the database data table, the database may send the paginated data table and the entry identifier corresponding to each entry in the paginated data table to the terminal device, and in response to a selection of a target entry in the target paginated data table by a user, the terminal device may obtain the entry identifier of the target entry and use the entry identifier as an index value of the target entry. So that the corresponding entry can subsequently be retrieved from the database based on the index value.
Therefore, the database is used for constructing the entry identifier for each entry in advance and taking the entry identifier as the index value of the target identifier, so that the data selected by the user can be acquired through multiple requests, and the problem that the data cannot be selected in a page-crossing manner is avoided.
The second method comprises the following steps: acquiring the page number and the position of a target item; and determining the index value of the target entry according to the target data volume, the page number and the position.
Wherein the page number is used to identify an order of the target paginated data table in a plurality of paginated data tables included in the data table, and the position is used to identify an order of the target entry in the target paginated data table. For example, page 2, item 3, page number 2, position 3.
Therefore, the index value of the target entry can be determined according to the target data volume, the page number and the position, the index value is used for identifying the sequencing of all the entries of the target entry in the data table, so that the index value and the entries have unique corresponding relation, and the corresponding entries can be obtained through the index value.
One way to determine the index value of the target entry based on the target data amount, page number and location is described below, see equation (1):
index＝(curPage-1)×pageSize+curIndex (1)
wherein, the index is used for representing the index value of the target entry; curPage is used to represent page number; pageSize is used to represent a target amount of data; curIndex is used to indicate location.
Thus, by determining the difference between page number and 1; determining a product of the difference and the target data amount; the sum of the product and the location is determined and used as the index value for the target entry. When a user browses a data table, the pageSize may be switched in the process of selecting an entry, for example, when the user selects the 3 rd item of data on page 2 when the pageSize is 10, the index calculation result is 13; when the user switches the data amount per page to 20, and the number of pieces is the same as the number of users, the index =13 calculated just before still applies, and the following formula (2) can be used to judge that the index is the number of pieces of data in the current page, when the curPage is 1, the 13 th piece of data of the current page is marked as selected, and when the curPage is 2, the index value is-7 and is not in the range of 1 to Page size, so that the page 2 has no data to select by the user. Because index is calculated by means of pageSize, index is suitable for dynamic change of pageSize, and better expandability is achieved.
Equation (2) is as follows:
curIndex＝index-(curPage-1)×pageSize (2)
s305: and storing the index value and the target entry to a second storage space.
And storing the index value and the target entry to a second storage space so as to save the entry selected by the user. Wherein the second storage space is different from the first storage space. After the new paging data table is obtained, even if the target paging data table is covered, the storage of the index value and the target entry is not influenced, and the cross-page selection is supported, so that the problem that the data cannot be selected in a cross-page mode is solved.
According to the technical scheme, the data acquisition request is sent to the database, the data acquisition request comprises the data requirement of the user and the target data volume, wherein the data requirement is used for indicating the data table required by the user to be acquired, but as the data volume of the data table is generally large, in order to reduce the data transmission volume of each interaction with the database, the data table is displayed in a paging display mode, namely, the data table is respectively displayed through a plurality of paging data tables, and the data volume of entries included in each paging data table is limited by the target data volume. And acquiring a target paging data table meeting the data requirement, wherein the data volume of the entries included in the target paging data table is equal to the target data volume. And displaying the target paging data table on the display page so that a user can select the entries in the target paging data table, wherein the selected entries are called target entries, acquiring the index values of the target entries, the index values and the target entries have unique corresponding relations, and storing the index values and the target entries in the second storage space so that the target entries can be acquired based on the index values. Therefore, by establishing the corresponding relation between the target entry and the index value and storing the index value and the target entry in the second storage space, wherein the second storage space is different from the first storage space for storing the target paging data table, after a new paging data table is obtained, even if the target paging data table is covered, the storage of the index value and the target entry cannot be influenced, and the problem that data cannot be selected across pages is avoided.
In addition, by calculating the index by the method provided by the embodiment of the application, not only can the mapped data interface be adopted, and the time complexity of O (1) is obtained in the operations of adding, inquiring, deleting, modifying and the like, the operations of selecting items, canceling the selection and the like by a user can be efficiently completed, but also only the mapping between the items selected by the user and the index value is recorded in the use of an extra space, only the data selected by the user is stored, and the overhead on the storage space is low.
In addition to the method for selecting the page crossing of the paging request data table, an embodiment of the present invention further provides an apparatus for selecting the page crossing of the paging request data table, as shown in fig. 4, the apparatus includes: a sending unit 401, a first obtaining unit 402, a display unit 403, a second obtaining unit 404 and a storage unit 405;
the sending unit 401 is configured to send a data obtaining request to a database, where the data obtaining request includes a data requirement of a user and a target data volume, and the target data volume is a data volume of an entry that needs to be displayed on a display page;
the first obtaining unit 402, configured to obtain a target paging data table that meets the data requirement, where the target paging data table includes entries with a data size equal to the target data size, and the target paging data table is stored in a first storage space;
the display unit 403 is configured to display the target paging data table on the display page;
the second obtaining unit 404, configured to obtain an index value of a target entry in the target paginated data table in response to a selection of the target entry by a user;
the storage unit 405 is configured to store the index value and the target entry in a second storage space, where the second storage space is different from the first storage space.
As a possible implementation manner, the second obtaining unit 404 is specifically configured to:
constructing an item identifier for each item in the data table;
and acquiring the entry identification of the target entry, and using the entry identification of the target entry as the index value of the target entry.
As a possible implementation manner, the second obtaining unit 404 is specifically configured to:
acquiring a page number of the target entry and a position of the target entry, wherein the page number is used for identifying the order of the target paging data table in a plurality of paging data tables included in the data table, and the position is used for identifying the order of the target entry in the target paging data table;
and determining an index value of the target entry according to the target data volume, the page number and the position.
As a possible implementation manner, the second obtaining unit 404 is specifically configured to:
determining a difference between the page number and 1;
determining a product of the difference and the target amount of data;
the sum of the product and the location is determined and used as the index value for the target entry.
According to the technical scheme, the data acquisition request is sent to the database, the data acquisition request comprises the data requirement of the user and the target data volume, the data requirement is used for indicating the data table required by the user to be acquired, but the data volume of the data table is generally large, in order to reduce the data transmission volume of each interaction with the database, the data table is displayed in a paging display mode, namely, the data table is respectively displayed through a plurality of paging data tables, and the data volume of entries included in each paging data table is limited through the target data volume. And acquiring a target paging data table meeting the data requirement, wherein the data volume of the entries included in the target paging data table is equal to the target data volume. And displaying the target paging data table on the display page so that a user can select the entries in the target paging data table, wherein the selected entries are called target entries, acquiring the index values of the target entries, the index values and the target entries have unique corresponding relations, and storing the index values and the target entries in the second storage space so that the target entries can be acquired based on the index values. Therefore, by establishing the corresponding relation between the target entry and the index value and storing the index value and the target entry in the second storage space, wherein the second storage space is different from the first storage space for storing the target paging data table, after a new paging data table is obtained, even if the target paging data table is covered, the storage of the index value and the target entry cannot be influenced, and the problem that data cannot be selected across pages is avoided.
An embodiment of the present application further provides a computer device, and referring to fig. 5, this figure shows a structure diagram of a computer device provided in an embodiment of the present application, and as shown in fig. 5, the device includes a processor 510 and a memory 520:
the memory 510 is used for storing program codes and transmitting the program codes to the processor;
the processor 520 is configured to execute any one of the methods applied to page crossing selection of a paging request data table according to the instructions in the program code.
The embodiment of the present application provides a computer-readable storage medium, which is used for storing a computer program, and the computer program executes any one of the methods applied to the selection of the page crossing of the paging request data table provided in the above embodiments.
Embodiments of the present application also provide a computer program product or computer program comprising computer instructions stored in a computer-readable storage medium. The processor of the computer device reads the computer instructions from the computer-readable storage medium, and the processor executes the computer instructions to cause the computer device to perform the method applied to the selection of the page crossing of the paging request data table provided in the various alternative implementations of the above aspects.
It should be noted that, in the present specification, the embodiments are described in a progressive manner, each embodiment focuses on differences from other embodiments, and the same and similar parts among the embodiments may be referred to each other. For the system or the device disclosed by the embodiment, the description is simple because the system or the device corresponds to the method disclosed by the embodiment, and the relevant points can be referred to the method part for description.
It should be understood that in the present application, "at least one" means one or more, "a plurality" means two or more. "and/or" for describing an association relationship of associated objects, indicating that there may be three relationships, e.g., "a and/or B" may indicate: only A, only B and both A and B are present, wherein A and B may be singular or plural. The character "/" generally indicates that the former and latter associated objects are in an "or" relationship. "at least one of the following" or similar expressions refer to any combination of these items, including any combination of single item(s) or plural items. For example, at least one (one) of a, b, or c, may represent: a, b, c, "a and b", "a and c", "b and c", or "a and b and c", wherein a, b, c may be single or plural.
It is further noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising a … …" does not exclude the presence of another identical element in a process, method, article, or apparatus that comprises the element.
The steps of a method or algorithm described in connection with the embodiments disclosed herein may be embodied directly in hardware, in a software module executed by a processor, or in a combination of the two. A software module may reside in Random Access Memory (RAM), memory, read Only Memory (ROM), electrically programmable ROM, electrically erasable programmable ROM, registers, hard disk, a removable disk, a CD-ROM, or any other form of storage medium known in the art.
The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present application. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the application. Thus, the present application is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.
Claims (10)
1. A method for page crossing selection of a paging request data table, the method comprising:
sending a data acquisition request to a database, wherein the data acquisition request comprises a data demand and a target data volume of a user, and the target data volume is the data volume of an item required to be displayed on a display page;
acquiring a target paging data table meeting the data requirement, wherein the data volume of entries included in the target paging data table is equal to the target data volume, and the target paging data table is stored in a first storage space;
displaying the target paging data table on the display page;
responding to the selection of a user aiming at a target entry in the target paging data table, and acquiring an index value of the target entry, wherein the index value and the target entry have a unique corresponding relation;
storing the index value and the target entry to a second storage space, the second storage space being different from the first storage space.
2. The method of claim 1, wherein obtaining the index value of the target entry comprises:
constructing an item identifier for each item in the data table;
and acquiring the entry identification of the target entry, and using the entry identification of the target entry as the index value of the target entry.
3. The method of claim 1, wherein obtaining the index value of the target entry comprises:
acquiring a page number of the target entry and a position of the target entry, wherein the page number is used for identifying the order of the target paging data table in a plurality of paging data tables included in the data table, and the position is used for identifying the order of the target entry in the target paging data table;
and determining the index value of the target entry according to the target data volume, the page number and the position.
4. The method of claim 3, wherein determining the index value of the target entry based on the target amount of data, the page number, and the location comprises:
determining a difference between the page number and 1;
determining a product of the difference and the target amount of data;
the sum of the product and the location is determined and used as the index value for the target entry.
5. An apparatus for page crossing selection of a paging request data table, the apparatus comprising: the device comprises a sending unit, a first obtaining unit, a display unit, a second obtaining unit and a storage unit;
the sending unit is used for sending a data acquisition request to a database, wherein the data acquisition request comprises the data requirement of a user and a target data volume, and the target data volume is the data volume of items required to be displayed on a display page;
the first obtaining unit is configured to obtain a target paging data table that meets the data requirement, where a data size of an entry included in the target paging data table is equal to the target data size, and the target paging data table is stored in a first storage space;
the display unit is used for displaying the target paging data table on the display page;
the second obtaining unit is used for responding to the selection of a user aiming at a target entry in the target paging data table, and obtaining an index value of the target entry;
the storage unit is configured to store the index value and the target entry in a second storage space, where the second storage space is different from the first storage space.
6. The apparatus according to claim 5, wherein the second obtaining unit is specifically configured to:
constructing an item identifier for each item in the data table;
and acquiring the entry identification of the target entry, and using the entry identification of the target entry as the index value of the target entry.
7. The apparatus according to claim 5, wherein the second obtaining unit is specifically configured to:
acquiring a page number of the target entry and a position of the target entry, wherein the page number is used for identifying the order of the target paging data table in a plurality of paging data tables included in the data table, and the position is used for identifying the order of the target entry in the target paging data table;
and determining an index value of the target entry according to the target data volume, the page number and the position.
8. The apparatus according to claim 7, wherein the second obtaining unit is specifically configured to:
determining a difference between the page number and 1;
determining a product of the difference and the target data volume;
the sum of the product and the location is determined and used as the index value for the target entry.
9. A computer device, the device comprising a processor and a memory:
the memory is used for storing program codes and transmitting the program codes to the processor;
the processor is configured to perform the method of any of claims 1-4 according to instructions in the program code.
10. A computer-readable storage medium, characterized in that the computer-readable storage medium is used to store a computer program for performing the method of any of claims 1-4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211289522.9A CN115510070A (en) | 2022-10-20 | 2022-10-20 | Method and related device applied to page-crossing selection of paging request data table |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211289522.9A CN115510070A (en) | 2022-10-20 | 2022-10-20 | Method and related device applied to page-crossing selection of paging request data table |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115510070A true CN115510070A (en) | 2022-12-23 |
Family
ID=84509675
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211289522.9A Pending CN115510070A (en) | 2022-10-20 | 2022-10-20 | Method and related device applied to page-crossing selection of paging request data table |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115510070A (en) |
-
2022
- 2022-10-20 CN CN202211289522.9A patent/CN115510070A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106911780B (en) | Service ID generation method, device and system | |
| US20200042507A1 (en) | Information Processing Method and Apparatus | |
| CN109168047B (en) | Video recommendation method and device, server and storage medium | |
| CN105549936B (en) | Data table display method and device | |
| CN111144874B (en) | Payment mode recommendation method, device and equipment | |
| US20200074509A1 (en) | Business data promotion method, device, terminal and computer-readable storage medium | |
| CN110968585B (en) | Storage method, device, equipment and computer readable storage medium for alignment | |
| CN110222046B (en) | List data processing method, device, server and storage medium | |
| CN113448720A (en) | Memory allocation method, device, equipment and storage medium | |
| CN114328632A (en) | User data analysis method and device based on bitmap and computer equipment | |
| CN114020946A (en) | Target judgment processing method and system based on multi-graph retrieval data fusion | |
| US20200302507A1 (en) | Item presentation method, item presentation program, and item presentation apparatus | |
| CN111159131A (en) | Performance optimization method, device, equipment and computer readable storage medium | |
| CN112905937A (en) | Service content updating and generating method based on big data and cloud computing service system | |
| CN115510070A (en) | Method and related device applied to page-crossing selection of paging request data table | |
| CN116719843A (en) | Query method, storage medium and device for database system | |
| CN110933070A (en) | User identification method, system, equipment and computer readable storage medium | |
| CN106446080B (en) | Data query method, query service equipment, client equipment and data system | |
| CN110825898A (en) | Nail art recommendation method and device, electronic equipment and storage medium | |
| CN112835774B (en) | Visualization method and device for performance of display card, equipment and computer-readable storage medium | |
| CN112131840A (en) | Page processing method, device, storage medium and processor | |
| CN112906091A (en) | Geographic information drawing method, device, terminal and medium based on CAD | |
| CN108182202B (en) | Content update notification method, content update notification device, electronic equipment and storage medium | |
| CN113204704A (en) | Content information display method and device, electronic equipment and readable medium | |
| CN111125425A (en) | Method, system and device for reading and writing video data and readable 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 |