Method for data paging display

Abstract

A method for displaying data in paging mode includes setting record number of data displayed on each page, making page number treatment on data and changing page number of surplus data to be page number of next page if data displayed on certain page is greater than set record.

Description

technical field [0001] The invention relates to a method for displaying data in pages. Background technique [0002] Data display is an important part of data application. Paging display is a common means of data display. [0003] The commonly used data table structure and recording methods are as follows in Table 1: [0004] [0005] The data table consists of several fields: the commonly used ID field is an automatic number, and the value of this field will be automatically incremented (decremented) every time a new record is added. Another commonly used field is to record the last update time information. [0006] Currently, the commonly used methods for pagination display are as follows: [0007] 1. The method of calculating the ID interval value of the page according to the ID number. If there are 5 items displayed on each page, the ID interval of the first page is 1-5, and the ID interval of the second page is 6-10, and so on. When reading a page of data, it is...

AI Technical Summary

Problems solved by technology

[0009] (1) ID numbers need to be continuous. If there are deleted records in the middle, due to the non-rearrangement of ID numbers, the data will be inaccurate when reading the ID interval with deleted records.

[0010] (2) The data content cannot be selected by classification and paging. It can be seen from Table 1 that the IDs in the classification content are not arranged continuously, and the ID interval cannot be determined

[0017] As can be seen from Table 3, the ID numbers of the updated data are discontinuous. When the data is continuously updated, the ID numbers are arranged irregularly, and pagination by ID number range cannot be performed.

[0018] 2. Use some methods with paging function, such as using the RecordSet of Microsoft's data positioning function, which can be paginated according to the selected content and automatically locate the record set of each page, but this method needs to load the pointers of all data records, so it is a waste of the system resources, it takes more time to open the data table

As the amount of opened data increases, when it reaches a certain level, it will cause the opening time to be very slow or exceed the limited resource value of the system

In the experiment, a P41G ordinary computer Windows2003 IIS was used to locate and open one page (20 records) of an Access data table with 120,000 records. The system displayed that the resource limit was exceeded and could not run

Images