Paging query method and system

Abstract

The invention discloses a paging query method. The method comprises steps as follows: a client sends the number N of data on a current query page to a server, and N is a positive integer which is larger than or equal to 1; if the current query page is the first page, the server extracts N data from a database from the first datum according to the sequence of paging query data in the database and returns the extracted N data to the client for display; if the current query page isn't the first page, the server looks up the last datum on the page before the current query page from the database, performs sequencing on the paging query data in the database, extracts N data from the database from the next datum of the last datum and returns the extracted N data to the client for display. The invention further discloses a paging query system.

Description

technical field [0001] The present invention relates to the field of computer technology, in particular to a paging query method and system. Background technique [0002] The traditional paging query is based on the page number and the number of data items that should be displayed in the page number, and the starting position of the query is calculated based on the page number and the number of data items in the page number for each query. For example, when a user inquires about QQ friend news, since the QQ client side presets the number of dynamic items that should be displayed for each query page number, assuming that the number of dynamic items that should be displayed on each page is 10, then when the user uses the QQ client When the client loads the first page of dynamic data, the server will retrieve the first to tenth friend dynamics from the database according to the data sorting and return them to the client for display. When the user loads the second page of dynami...

AI Technical Summary

Problems solved by technology

[0003] Although the above method can realize pagination query, but the pagination query data will be inaccurate

For example, when the user queries the data on the second page, if the data in the database has increased before this, for example, it is added to the position of the first piece of data, then according to the above page query method, the data on the second page will appear before The last piece of data that has appeared when the first page is queried, which will cause the client to repeatedly load the dynamic data; for example, when the user queries the second page of data, if the data in the database is deleted before this, such as If a piece of data in the first 10 items is deleted, according to the above paging query method, the data that should have appeared on the second page will be calculated as the data on the first page, which will cause the data on the second page to be missing

Images