Paging query method and device
A paging query and paging technology, which is applied in the field of data processing, can solve problems such as program exceptions and untimely responses, and achieve the effects of reducing query volume, improving query efficiency and return efficiency, and improving programs that cannot respond in time or are abnormal
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
no. 1 example
[0026] Please refer to image 3 , image 3 It is a flow chart of a paging query method provided in the first embodiment of the present invention. The paging query method specifically includes the following steps:
[0027] Step S110: Receive a data query command carrying a target data table.
[0028]When the user needs to query or export certain data in the database, as an implementation, the user can send a data query instruction to the server through the user terminal under network conditions, and the data query instruction can include: The data number interval to be queried, the page number to be queried, the data in the target data table, etc., the server end storing the database will receive the data query instruction carrying the target data table sent by the user terminal, and then the server will The above data query command completes the corresponding data query, wherein the database of the server can have one or more tables, and built-in indexes for each table, so t...
no. 2 example
[0041] Please refer to Figure 4 , Figure 4 It is a flow chart of a paged query method provided in the second embodiment of the present invention. The paged query method specifically includes the following steps:
[0042] Step S210: Receive a data query command carrying a target data table.
[0043] Step S220: Obtain the maximum data number and the minimum data number in the target data table, and obtain the total number of records according to the maximum data number and the minimum data number.
[0044] Step S230: Calculate and obtain an initial paging number based on the total number of records and the preset number of paging records.
[0045] Step S240: According to the initial page number and the preset page number of records, obtain the start data number and end data number of each initial page.
[0046] Specifically, the page number corresponding to each initial page is determined according to the initial page number calculated in step S230, wherein the page number ...
no. 3 example
[0067] In order to realize the above paged query method, the third embodiment of the present invention provides a paged query device 100, please refer to 5, Figure 5 A structural block diagram of a paging query device 100 provided in the third embodiment of the present invention, the device includes: a receiving instruction unit 110, a first obtaining unit 120, a second obtaining unit 130, a third obtaining unit 140, and a returning result unit 150.
[0068] The instruction receiving unit 110 is configured to receive a data query instruction carrying a target data table.
[0069] It should be noted that the data query instruction may also carry a specified interval.
[0070] The first obtaining unit 120 is configured to obtain a maximum data number and a minimum data number in the target data table, and obtain a total number of records according to the maximum data number and the minimum data number.
[0071] In particular, when the query instruction carries a specified int...
PUM
Abstract
Description
Claims
Application Information
- R&D Engineer
- R&D Manager
- IP Professional
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.
© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com