CN100426295C - Method for data paging display - Google Patents
Method for data paging display Download PDFInfo
- Publication number
- CN100426295C CN100426295C CNB2006100341548A CN200610034154A CN100426295C CN 100426295 C CN100426295 C CN 100426295C CN B2006100341548 A CNB2006100341548 A CN B2006100341548A CN 200610034154 A CN200610034154 A CN 200610034154A CN 100426295 C CN100426295 C CN 100426295C
- Authority
- CN
- China
- Prior art keywords
- data
- page
- classification
- record
- deliver
- 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.)
- Expired - Fee Related
Links
Images
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
The present invention relates to the method that a kind of data page shows.
Background technology
Data presentation is the important component part that data are used.Pagination Display is the conventional means of data presentation.
Data list structure and recording mode such as following table 1 commonly used at present:
Tables of data is made up of some fields: wherein Chang Yong id field is an automatic numbering, and this field value can increase progressively (subtracting) assignment automatically when new record of every adding.Another field commonly used is a record final updating temporal information.
Pagination Display method commonly used has following several at present:
1, press the method for calculating the ID interval value of recto for ID number, as 5 of every page of demonstrations, then the 1st page ID interval is 1-5, and the 2nd page is 6-10, as analogizes.When reading a page data, only need from tables of data, to obtain wherein ID number>=minimum ID number, and<=record of maximum ID number.
This method needs some certain conditions:
(1) the ID needs are continuous, if the middle record that deletion is arranged owing to do not reset characteristic ID number, read the ID of deletion record when interval data inaccurate.
(2) the data content paging of can not classifying is chosen, and as can be seen from Table 1, the ID in the categorised content is not continuously arranged, can't determine the ID interval.
(3) frequently,, generally can use last ID or final updating time inverted order to arrange, will be arranged as following table 2 situations as table 1 for up-to-date content is presented at the foremost.
Table 2:
Frequently because specific needs, after a certain recorded content in the tables of data is updated, will comes the foremost and show, if No. 1 ID record for example in the table 2 is updated, then the content of final updating time field will change to the final updating time, and the arrangement of tables of data will become as following table 3 situations:
Table 3:
As can be seen from Table 3, the data ID after the renewal is number discontinuous, and after constantly carrying out Data Update, ID number arrangement do not have rule, can't carry out carrying out paging by the ID interval.
2, use some to possess the method for two-page separation function, for example use the RecordSet of Microsoft's data locking function, can carry out paging by the content of choosing, automatically locate every page record set, but this method need load the pointer of all data recording, therefore relatively waste system resource, it is also more to open the used time of tables of data.Along with the increase of opening data volume, when acquiring a certain degree, will cause the time of opening to grow or exceed the qualification resource value of system very slowly.In the experiment, adopt P41G common computer Windows2003 IIS, the wherein one page (20 record) that the Access tables of data of 120,000 records is arranged is opened in the location, and system's demonstration exceeds the resource limit value, can't move.
Summary of the invention
The technical problem to be solved in the present invention is to overcome the deficiency that above-mentioned prior art exists, the method that provides a kind of effective reduction system resources consumption, the data page of saving data presentation time to show.
For solving the problems of the technologies described above, the invention provides the method that a kind of data page shows, may further comprise the steps:
(1) sets every page of data presented record number;
(2) add the page number field for data recording, and set the page number value to data recording according to every page of video data record number setting; And
(3) if certain page of data presented more than the record number of setting, then changes to down the page number of the data that have more the page number of one page.
Described step (2) further comprises:
(21) data are classified;
(22) in tables of data, add the page number field that writes down pagination; And
(23) each grouped data is carried out page number and handle, give data setting page number value according to every page of video data record number setting.
The present invention has following useful effect: adopt this method, no matter open which page or leaf of tables of data, all only choose the record of specifying page number, system resources consumption is low, and simultaneously, because the data of page number field are simple, during as search condition, degree judgement speed is exceedingly fast.
Description of drawings
Fig. 1 is the process flow diagram of the method for data page demonstration of the present invention.
Embodiment
Below in conjunction with Fig. 1 the method that data page of the present invention shows is described in detail.
The method that data page of the present invention shows may further comprise the steps:
(1) sets every page of data presented record number;
(2) add the page number field for data recording, and set the page number value to data recording according to every page of video data record number setting; And
(3) if certain page of data presented more than the record number of setting, then changes to down the page number of the data that have more the page number of one page.
At first, according to actual needs, need data presented record number to set to every page.
Secondly, improve data list structure, in tables of data, add the field of record pagination, as " page number " field in the following table 4:
Table 4:
ID | Field 1 | Field 2 | Field N | The final updating time | Page number |
1 | Classification 1 | Deliver the 1st message | 。。 | 2006-1-10 12:27:10 | 1 |
17 | Classification 1 | Deliver the 17th message | 。。 | 2006-1-10 12:26:10 | 1 |
16 | Classification 2 | Deliver the 16th message | 。。 | 2006-1-10 12:25:10 | 1 |
15 | Classification 1 | Deliver the 15th message | 。。 | 2006-1-10 12:24:10 | 1 |
14 | Classification 2 | Deliver the 14th message | 。。 | 2006-1-10 12:23:10 | 1 |
13 | Classification 2 | Deliver the 13rd message | 。。 | 2006-1-10 12:22:10 | 1 |
12 | Classification 1 | Deliver the 12nd message | 。。 | 2006-1-10 12:21:10 | 1 |
11 | Classification 1 | Deliver the 11st message | 。。 | 2006-1-10 12:20:10 | 1 |
10 | Classification 2 | Deliver the 10th message | 。。 | 2006-1-10 12:19:10 | 1 |
9 | Classification 1 | Deliver the 9th message | 。。 | 2006-1-10 12:18:10 | 2 |
8 | Classification 2 | Deliver the 8th message | 。。 | 2006-1-10 12:17:10 | 1 |
7 | Classification 1 | Deliver the 7th message | 。。 | 2006-1-10 12:16:10 | 2 |
6 | Classification 2 | Deliver the 6th message | 。。 | 2006-1-10 12:15:10 | 2 |
5 | Classification 1 | Deliver the 5th message | 。。 | 2006-1-10 12:14:10 | 2 |
4 | Classification 2 | Deliver the 4th message | 。。 | 2006-1-10 12:13:10 | 2 |
3 | Classification 2 | Deliver the 3rd message | 。。 | 2006-1-10 12:12:10 | 2 |
2 | Classification 1 | Deliver the 2nd message | 。。 | 2006-1-10 12:11:10 | 2 |
N | N | N | 。。。N | N | N |
By classification, time, page number is index, then obtains following tables of data and arranges:
Table 5:
ID | Field 1 | Field 2 | Field N | The final updating time | Page number |
1 | Classification 1 | Deliver the 1st message | 。。 | 2006-1-10 12:27:10 | 1 |
17 | Classification 1 | Deliver the 17th message | 。。 | 2006-1-10 12:26:10 | 1 |
15 | Classification 1 | Deliver the 15th message | 。。 | 2006-1-10 12:24:10 | 1 |
12 | Classification 1 | Deliver the 12nd message | 。。 | 2006-1-10 12:21:10 | 1 |
11 | Classification 1 | Deliver the 11st message | 。。 | 2006-1-10 12:20:10 | 1 |
9 | Classification 1 | Deliver the 9th message | 。。 | 2006-1-10 12:18:10 | 2 |
5 | Classification 1 | Deliver the 5th message | 。。 | 2006-1-10 12:14:10 | 2 |
7 | Classification 1 | Deliver the 7th message | 。。 | 2006-1-10 12:16:10 | 2 |
2 | Classification 1 | Deliver the 2nd message | 。。 | 2006-1-10 12:11:10 | 2 |
16 | Classification 2 | Deliver the 16th message | 。。 | 2006-1-10 12:25:10 | 1 |
14 | Classification 2 | Deliver the 14th message | 。。 | 2006-1-10 12:23:10 | 1 |
13 | Classification 2 | Deliver the 13rd message | 。。 | 2006-1-10 12:22:10 | 1 |
10 | Classification 2 | Deliver the 10th message | 。。 | 2006-1-10 12:19:10 | 1 |
8 | Classification 2 | Deliver the 8th message | 。。 | 2006-1-10 12:17:10 | 1 |
6 | Classification 2 | Deliver the 6th message | 。。 | 2006-1-10 12:15:10 | 2 |
4 | Classification 2 | Deliver the 4th message | 。。 | 2006-1-10 12:13:10 | 2 |
3 | Classification 2 | Deliver the 3rd message | 。。 | 2006-1-10 12:12:10 | 2 |
N | N | N | 。。。N | N | N |
In the practical operation, at first tables of data is carried out the page number processing of (each classification) data, it is composed according to every page of displayed record bar number setting go up corresponding page number value.As above in the table, suppose existing 5 records of the 1st page of 1 data of classification, sets every page and show 5 records that add when having non-the 1st page record now (or upgrade) as new record, the page number of this record is made as 1, so at this moment, the 1st page will have 6 records.When the user opens the 1st page, choose page number and be 1 record (totally 6), when being shown to the 6th (surpassing setting value) record, change its page number into 2,1 page of this moment revert to 5 records, 2 pages then increase by 1 record.In the time of should opening 2 pages together, if surpass every page of displayed record number setting, the page number of the record that then surpasses can change to down the page number of one page, so analogizes.
Adopt this method, no matter open which page or leaf of tables of data, all only choose the page number record of appointment, system resources consumption is low, simultaneously, because the data of page number field are simple, during as search condition, program judgement speed is exceedingly fast, so the growth of data volume does not have tangible increase for the data opening speed.
This method has great Practical significance.When for example being applied to data processing such as website news briefing or BBS, particularly middle-size and small-size data processing even large data are handled (crossing 100,000 records), Advanced Databases such as general needs use SQL could move or realize to open preferably data speed, to operation costs are improved.And use this method, in the experiment, with common P4 microcomputer, windows2003IIS opens arbitrary page or leaf (20 record) in the Access tables of data of one 12 ten thousand records, and required time has only a few tens of milliseconds.
Therefore, use this method, can reduce system resources consumption effectively, carry out the paging management operation of data efficiently, significant meaning is arranged for the social resources and the operating cost of saving the data management aspect.
Claims (2)
1, a kind of method of data page demonstration may further comprise the steps:
(1) sets every page of data presented record number;
(2) add the page number field for data recording, and set the page number value to data recording according to every page of video data record number setting; And
(3) if certain page of data presented more than the record number of setting, then changes to down the page number of the data that have more the page number of one page.
2, method according to claim 1 is characterized in that: described step (2) further comprises:
(21) data are classified;
(22) in tables of data, add the page number field that writes down pagination; And
(23) each grouped data is carried out page number and handle, give data setting page number value according to every page of video data record number setting.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CNB2006100341548A CN100426295C (en) | 2006-03-04 | 2006-03-04 | Method for data paging display |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CNB2006100341548A CN100426295C (en) | 2006-03-04 | 2006-03-04 | Method for data paging display |
Publications (2)
Publication Number | Publication Date |
---|---|
CN101030203A CN101030203A (en) | 2007-09-05 |
CN100426295C true CN100426295C (en) | 2008-10-15 |
Family
ID=38715555
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CNB2006100341548A Expired - Fee Related CN100426295C (en) | 2006-03-04 | 2006-03-04 | Method for data paging display |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN100426295C (en) |
Families Citing this family (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101207742B (en) * | 2007-12-25 | 2010-06-09 | 深圳市同洲电子股份有限公司 | Method and device for paging of display contents and digital television receiving device |
CN101237347B (en) * | 2008-02-19 | 2011-06-29 | 中兴通讯股份有限公司 | Page processing method for alarm data |
CN102314292A (en) | 2010-06-30 | 2012-01-11 | 国际商业机器公司 | Method for generating network service and system |
CN103778135B (en) * | 2012-10-18 | 2018-01-02 | 厦门雅迅网络股份有限公司 | A kind of distribution storage of real time data and paging query method |
Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1326290A (en) * | 2000-05-31 | 2001-12-12 | 网信有限公司 | Method for transmitting and receiving text data in portable terminal |
US20050198568A1 (en) * | 2003-01-30 | 2005-09-08 | Fujitsu Limited | Table display switching method, text data conversion program, and tag program |
-
2006
- 2006-03-04 CN CNB2006100341548A patent/CN100426295C/en not_active Expired - Fee Related
Patent Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1326290A (en) * | 2000-05-31 | 2001-12-12 | 网信有限公司 | Method for transmitting and receiving text data in portable terminal |
US20050198568A1 (en) * | 2003-01-30 | 2005-09-08 | Fujitsu Limited | Table display switching method, text data conversion program, and tag program |
Non-Patent Citations (8)
Title |
---|
Web数据库的查询分页显示. 刘化君,李铭.电脑开发与应用,第16卷第7期. 2003 |
Web数据库的查询分页显示. 刘化君,李铭.电脑开发与应用,第16卷第7期. 2003 * |
基于ASP技术的农业机械Web数据库的查询实现及结果显示. 杜春光,刘宏新.农业图书情报学刊,第1期. 2003 |
基于ASP技术的农业机械Web数据库的查询实现及结果显示. 杜春光,刘宏新.农业图书情报学刊,第1期. 2003 * |
基于ASP的数据库查询分页显示. 黄荔.兵工自动化,第23卷第1期. 2004 |
基于ASP的数据库查询分页显示. 黄荔.兵工自动化,第23卷第1期. 2004 * |
用ASP/ADO实现的Web数据浏览分页显示. 梅申信,梅林.安徽农业大学学报,第4期. 2003 |
用ASP/ADO实现的Web数据浏览分页显示. 梅申信,梅林.安徽农业大学学报,第4期. 2003 * |
Also Published As
Publication number | Publication date |
---|---|
CN101030203A (en) | 2007-09-05 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US11816100B2 (en) | Dynamically materialized views for sheets based data | |
US11755606B2 (en) | Dynamically updated data sheets using row links | |
CN102207948B (en) | Method for generating incident statement sentence material base | |
CN107958082A (en) | Offline increment synchronization method and system of the database to data warehouse | |
WO1999018524B1 (en) | Computer-based document management system | |
CN1838111A (en) | Method for editing file and recording modification mark | |
CN103019814A (en) | System and method for managing shear plate | |
CN100426295C (en) | Method for data paging display | |
CN102012861A (en) | Method and system for real-time embedded software test result data analysis | |
CN102087657A (en) | IO (Input/output) to point method and IO (Input/output) to point for nuclear power plant simulation platform | |
CN102193938A (en) | Method and device for acquiring incremental data | |
Stanley | Information overload: Causes, symptoms, consequences and solutions | |
CN113010615B (en) | Hierarchical data visualization method based on Gaussian mixture model clustering algorithm | |
CN101908063A (en) | Universal report query tool | |
JP2020067998A (en) | Method for analyzing patent literature set | |
CN1098495C (en) | Method for managing personal information | |
CN102207947A (en) | Direct speech material library generation method | |
Weber | The Constant Flux: A Study of Class Mobility in Industrial Societies. | |
CN107861956B (en) | Method and device for inquiring data record of bayonet passing vehicle | |
CN113221031A (en) | Method for automatically identifying website directory page | |
CN111260310A (en) | Enterprise resource management method and system based on big data technology | |
CN111143328A (en) | Agile business intelligent data construction method, system, equipment and storage medium | |
TWI779898B (en) | Method, electronic equipment and storage medium for emboss simulation | |
US20030236765A1 (en) | Determining a characteristic function from a matrix with enrichment and compression | |
CN111752997A (en) | Basic library data label analysis system and method |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C14 | Grant of patent or utility model | ||
GR01 | Patent grant | ||
C17 | Cessation of patent right | ||
CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20081015 Termination date: 20110304 |