CN115114332A - Database query method, device and equipment and readable storage medium - Google Patents

Abstract

The application discloses a database query method, a database query device, database query equipment and a readable storage medium in the technical field of computers. The method provided by the application comprises the following steps: acquiring a query instruction, and determining a query condition corresponding to the query instruction; querying a database according to the query condition and a preset query limit value; if the preset query limit number of data items are returned by the database, displaying the preset query limit number of data items returned by the database, and asynchronously counting the total number of the data items which can be searched in the database by the query condition while displaying, so that the page loading time can be reduced, the user waiting time is shortened, and the user query experience is improved. Accordingly, the database query device, the database query equipment and the readable storage medium provided by the application also have the technical effects.

Description

A database query method, apparatus, device and readable storage medium

technical field

The present application relates to the field of computer technologies, and in particular, to a database query method, apparatus, device, and readable storage medium.

Background technique

Currently, users can query the database for the desired data entry. When there are many data items filtered out by the query conditions input by the user, the page displayed by the user client may take too long to load, causing the user to wait too long.

Therefore, how to reduce the page loading time during the database query process is a problem to be solved by those skilled in the art.

SUMMARY OF THE INVENTION

In view of this, the purpose of the present application is to provide a database query method, apparatus, device and readable storage medium, so as to reduce the page loading time during the database query process. Its specific plan is as follows:

In a first aspect, the present application provides a database query method, including:

Obtain a query instruction, and determine the query condition corresponding to the query instruction;

Query the database according to the query conditions and preset query limits;

If the database returns the preset query limit data items, display the preset query limit data items returned by the database, and asynchronously count the query conditions in the database while displaying. The total number of data entries that can be found in the .

Optionally, before the asynchronous statistics of the total number of data entries that can be found in the database for the query conditions, further include:

query the cache for the total number of data entries;

If the total number of data items is found in the cache, the total number of data items is obtained from the cache; otherwise, the step of asynchronously counting the total number of data items that can be found in the database by the query condition is performed.

Optionally, also include:

The query condition, the preset query limit number of data items, and the total number of data items are stored in the cache.

Optionally, if the preset query limit number of data items are displayed in paging, after storing the query condition, the preset query limit number of data items, and the total number of data items in the cache, the method further includes: :

Get the page turning instruction entered by the user;

Acquire and display the data entry corresponding to the page turning instruction from the cache;

Fetch and display the total number of data entries from the cache.

Optionally, the asynchronous statistics of the total number of data items that can be found in the database for the query conditions include:

The idle thread is called from the preset thread pool to count the total number of the data items.

Optionally, also include:

If the number of data items returned by the database is less than the preset query limit, the number of data items and all data items returned by the database are displayed.

Optionally, also include:

Allocate identification information for the query condition, and record the mapping relationship between the identification information and the query condition;

If the query instruction or page turning instruction including the query condition is obtained, the total number of data items is displayed according to the mapping relationship.

In a second aspect, the present application provides a database query device, comprising:

an acquisition module, configured to acquire a query instruction and determine the query condition corresponding to the query instruction;

a query module, used for querying the database according to the query conditions and preset query limit values;

A display module, configured to display the preset query limit data items returned by the database if the database returns the preset query limit data items, and asynchronously count the queries while displaying The total number of data entries available in the database for the condition.

Optionally, also include:

Query cache module, which is used to query the total number of data items that can be found in the database according to the current query conditions in the cache; if the total number of data items is found in the cache, the total number of data items is obtained from the cache; otherwise, an asynchronous statistical query is performed. Steps that condition the total number of data entries that can be found in the database.

Optionally, also include:

The cache module is used to store the query condition, the preset query limit number of data items and the total number of data items in the cache.

Optionally, also include:

The page-turning module is used to obtain the page-turning command input by the user if the preset query limit number of data items are displayed in paging; obtain and display the data items corresponding to the page-turning command from the cache; obtain and display the total number of data items from the cache .

Optionally, the display module is specifically used for:

Call idle threads from the preset thread pool to count the total number of data entries that can be found in the database according to the current query conditions.

Optionally, the display module is also used to:

If the number of data items returned by the database is less than the preset query limit, the number of data items and all data items returned by the database will be displayed.

Optionally, also include:

The mapping module is used to assign identification information to the query conditions, and record the mapping relationship between the identification information and the query conditions; if a query command or page-turning command containing the query conditions is obtained, it will be displayed according to the mapping relationship and can be searched in the database according to the query conditions. The total number of data entries received.

In a third aspect, the present application provides an electronic device, comprising:

memory for storing computer programs;

The processor is configured to execute the computer program to implement the database query method disclosed above.

In a fourth aspect, the present application provides a readable storage medium for storing a computer program, wherein when the computer program is executed by a processor, the database query method disclosed above is implemented.

In a fifth aspect, the present application provides a computer program product, comprising computer instructions, which, when executed on a computer, enable the computer to execute the database query method disclosed above.

It can be seen from the above solutions that the present application provides a database query method, comprising: obtaining a query instruction, and determining a query condition corresponding to the query instruction; querying a database according to the query condition and a preset query limit value; if the database If the preset query limit data items are returned, the preset query limit data items returned by the database are displayed, and at the same time of displaying, the query conditions can be found in the database asynchronously. The total number of data entries.

It can be seen that after obtaining the query instruction and determining the query conditions corresponding to the query instruction, the present application queries the database according to the query conditions and the preset query limit. The preset query limit in this step can make the database return no more than the preset query limit. The limit number of data items is queried, so when there are many data items filtered by the query conditions, a part of the data items can be returned for display first, so that there is no need to wait for all the data items obtained by the query, so the page loading time can be reduced. While displaying the currently returned batch of data, asynchronously count the total number of data items that can be found in the database by the query condition. That is to say, the display of the currently returned data items does not need to wait for the statistics of the total number of data items that can be found, and can be displayed first, which can also reduce the page loading time, shorten the user's waiting time, and improve the user's query experience.

Correspondingly, a database query apparatus, device, readable storage medium and computer program product provided by the present application also have the above technical effects.

Description of drawings

In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the following briefly introduces the accompanying drawings required for the description of the embodiments or the prior art. Obviously, the drawings in the following description are only It is an embodiment of the present application. For those of ordinary skill in the art, other drawings can also be obtained according to the provided drawings without any creative effort.

1 is a flowchart of a database query method disclosed in the application;

2 is a schematic diagram of a page display of a data entry and the total number of data entries disclosed in this application;

3 is a flowchart of another database query method disclosed in the application;

4 is a schematic diagram of a query and counting task disclosed in the present application;

FIG. 5 is a schematic diagram of a page in which a result detail disclosed by this application has been displayed, but the total number of details has not been counted;

6 is a schematic diagram of a database query device disclosed in the application;

7 is a schematic diagram of an electronic device disclosed in the application;

8 is a schematic structural diagram of a server disclosed in the application;

FIG. 9 is a schematic structural diagram of a terminal disclosed in this application.

Detailed ways

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. Obviously, the described embodiments are only a part of the embodiments of the present application, but not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by those of ordinary skill in the art without creative efforts shall fall within the protection scope of the present application.

Currently, users can query the database for the desired data entry. When there are many data items filtered out by the query conditions input by the user, the page displayed by the user client may take too long to load, causing the user to wait too long. Therefore, the present application provides a database query solution, which can reduce the page loading time during the database query process.

Referring to FIG. 1 , an embodiment of the present application discloses a database query method, including:

S101. Acquire a query instruction, and determine a query condition corresponding to the query instruction.

In this embodiment, the user can input query conditions through the client page, and then the client terminal adds the query conditions to the query instruction. Therefore, determining the query condition corresponding to the query instruction includes: obtaining the query condition from the query instruction. The query condition may be a database query statement, such as an SQL query statement.

S102, query the database according to the query condition and the preset query limit value.

In this embodiment, the database may be any type of database, such as an SQL database.

S103. If the database returns the preset query limit data items, display the preset query limit data items returned by the database, and at the same time of displaying, asynchronously count the total number of data items that can be found in the database by the query condition.

Based on the query conditions, all data items that meet the query conditions can be queried in the database. In this embodiment, a preset query limit is set to avoid excessively long loading time of the user client due to a large number of queried data items, and the preset query limit can reduce the amount of data returned from the database to the user client. For example: when the preset query limit is 500, it means that the database returns a maximum of 500 data items for a query condition, then if the database returns 500 data items at a time, it cannot be determined that the total data items queried this time are 500 or more than 500. However, in order to avoid the client display delay, the 500 data items are displayed first, and the total data items queried this time are counted asynchronously in the background. Of course, if the database returns 300 data items at one time, it can be directly determined that the total data items queried this time is 300, so the 300 data items and the total data items 300 queried this time can be displayed at the same time. Typically, the data entry itself and the total data entry are displayed on the same page on the client side. As shown in Figure 2, each data item is displayed in a paging form in the form of a list, and the total data item is also displayed on the current page; when the page is turned, the display position and value of the total data item remain unchanged.

In order to realize the asynchronous display of data items and the statistics of the total number of data items, a thread pool for counting the total number of data items can be preset in the background. At the same time of displaying, calling the thread in the thread pool can realize the asynchronous statistics of the total number of data items. Therefore, in a specific embodiment, asynchronously counting the total number of data items that can be found in the database by query conditions includes: calling an idle thread from a preset thread pool to count the total number of data items that can be found in the database according to the current query conditions.

Of course, the user may continuously input query conditions on the client side to conduct queries, so there may be multiple threads running at the same time for counting the total number of data items. An operation identification information is assigned to each query condition, and when the total number of data items needs to be displayed, the total number of data items that need to be displayed currently is determined based on the query condition corresponding to the currently displayed data item. Therefore, in a specific embodiment, identification information is allocated to the query conditions, and the mapping relationship between the identification information and the query conditions is recorded; if a query command or a page-turning command containing the query conditions is obtained, the query conditions are displayed according to the mapping relationship. The total number of data entries available in the database.

It should be noted that the above-determined query conditions, the preset query limit number of data items, and the total number of data items can be stored in the client cache. If you need to display these information repeatedly (such as page refresh, etc.), you can directly retrieve the information from the cache. Obtaining this information for display can also reduce page load times. Therefore, in a specific implementation manner, before the asynchronous statistical query condition is before the total number of data items that can be found in the database, it further includes: querying the cache for the total number of data items that can be found in the database according to the current query condition; If the total number of data items found in the database is obtained, the total number of data items is obtained from the cache; otherwise, the step of asynchronously counting the total number of data items that can be found in the database by the query condition is performed.

In a specific implementation manner, the query conditions, the preset query limit number of data items, and the total number of data items are stored in the cache. Wherein, if the preset query limit number of data items are displayed in pages, the query conditions, the preset query limit number of data items and the total number of data items are stored in the cache, and the method further includes: obtaining the page-turning instruction input by the user; Get and display the data entry corresponding to the page turning instruction; get and display the total number of data entries from the cache.

In this embodiment, the total number of data items can be displayed as follows. First: After asynchronous statistics get the total number of data items that can be found in the database for a certain query condition, the total number of data items obtained by asynchronous statistics and the data items returned by the database are displayed on the same page of the client. The display page can refer to Figure 2 . If the details of the data items currently displayed on the client page do not correspond to the total number of data items currently obtained by asynchronous statistics, the total number of data items will not be displayed, but based on the query conditions corresponding to the data items displayed on the current page, the The total number of data entries corresponding to the data entry is displayed. Second: when the user turns pages, the total number of cached data items is obtained from the cache for display, so the total number of data items shown in Figure 2 remains unchanged.

In a specific implementation, if the number of data items returned by the database is less than the preset query limit, the number of data items and all data items returned by the database are displayed, without calling the background thread to count the total number of data items, Therefore, computer resources can be saved, and page loading efficiency can be improved. That is, when the data filtered out by the user through the search criteria is relatively small, the background thread is no longer called to count the total number, but the total number of data items is directly determined based on all the returned data items, so that both query performance and user experience can be considered.

It can be seen that in this embodiment, after the query instruction is obtained and the query conditions corresponding to the query instruction are determined, the database is queried according to the query conditions and the preset query limit. The preset query limit in this step can make the database return no more than the preset query limit. Set the query limit number of data items, so when there are many data items filtered by the query conditions, a part of the data items can be returned for display first, so that there is no need to wait for all the data items obtained by the query, so the page loading time can be reduced. While displaying the currently returned batch of data, asynchronously count the total number of data items that can be found in the database by the query condition. That is to say, the display of the currently returned data items does not need to wait for the statistics of the total number of data items that can be found, and can be displayed first, which can also reduce the page loading time, shorten the user's waiting time, and improve the user's query experience.

The following describes a database query solution provided by the embodiments of the present application. The database query solution described below and the database query method described above can be referred to each other.

Referring to FIG. 3 , when the user enters filter conditions (ie, query conditions) on the front-end client page to search, the client queries the database according to the filter conditions and a preset query limit of 500. If the number of data items returned by the database is less than 500, the client-side background sends the number of data items queried to the front-end without calling the background thread to count the total number of data items. If the number of data items found in the database is not less than 500, the client backend determines whether there is a count of the same entity and the total number of data items corresponding to the current filter condition in the client cache, and if so, obtains the corresponding data from the cache and sends it to Front-end, if not, display these data items, and call the background thread to count the total number of data items found by this filter condition, and send it to the front-end for display. Of course, it is also cached. When the page is closed or the page is refreshed, the data in the cache can be cleaned up in time.

Among them, the query result list page of the front-end client is used for scenarios such as data display and search. The list page can be developed based on the dynamic form model, and different list page styles can be realized by binding different dynamic forms; the fields in the list page generally need to be added by mapping existing fields; the list page supports search filtering such as quick search and scheme filtering Function.

It can be seen that when querying the database according to this embodiment, the query task is responsible for querying the specific result details, and at the same time, there are counting threads running in the background. Detail, the counting task is performed at the same time as it is displayed. Specifically, the query task and the counting task can be seen in FIG. 4 . When displaying the queried specific result details, before the total number of details is counted, the total number of details is displayed as "Loading", as shown in Figure 5.

Among them, the count thread output value is the total number of rows of result details. When calculating the number of data rows, use the background thread to execute, and when the background thread has finished calculating the number of data rows, the calculation result will be displayed on the front end, so the user does not need to wait for the calculation of the number of data rows to complete before displaying the data. Of course, in the process of waiting for this number of data rows, the user may select other filter conditions and trigger a query again, then there will be another corresponding row number calculation. Display the number of data rows corresponding to the last query operation in the front-end list according to the order of user query. Since the calculation of the number of data rows is performed using the background thread pool, the execution order of the counting tasks corresponding to different query operations may be uncertain, for example, the background counting threads may be concurrent.

To this end, this embodiment maintains a bitmap Map<Long, String> for recording each query condition and the corresponding operation sequence number. Each time a query is clicked, the operation number increases by 1, and the mapping relationship between the operation number and the SQL query statement of the current query is recorded, then when the row count result is displayed on the front end, the SQL query statement corresponding to the largest operation number is counted. The result is returned and displayed.

It can be seen that this embodiment supports asynchronous counting and cache counting, reduces the page loading time, shortens the user's waiting time, and thus improves the user's query experience. Among them, asynchronous counting means that the user can display the query result details on the front end without waiting for the return of the counting result. The cache count refers to: the count result corresponding to the query condition of the current page can be obtained from the cache. For example, when the user turns the page through the previous page/next page, the count of the number of data rows will not be triggered, but the count result of the number of data rows under the current search condition is obtained from the cache through the cache technology and displayed.

The following describes a database query apparatus provided by an embodiment of the present application. A database query apparatus described below and a database query method described above can be referred to each other.

Referring to FIG. 6 , an embodiment of the present application discloses a database query device, including:

an obtaining module 601, configured to obtain a query instruction, and determine a query condition corresponding to the query instruction;

a query module 602, configured to query a database according to query conditions and preset query limits;

The display module 603 is configured to display the preset query limit data items returned by the database if the database returns the preset query limit data items, and at the same time of displaying, asynchronously count the data that can be found in the database by the query conditions Total number of entries.

In a specific embodiment, it also includes:

Query cache module, which is used to query the total number of data items that can be found in the database according to the current query conditions in the cache; if the total number of data items is found in the cache, the total number of data items is obtained from the cache; otherwise, an asynchronous statistical query is performed. Steps that condition the total number of data entries that can be found in the database.

In a specific embodiment, it also includes:

The cache module is used to store the query condition, the preset query limit number of data items and the total number of data items in the cache.

In a specific embodiment, it also includes:

The page-turning module is used to obtain the page-turning command input by the user if the preset query limit number of data items are displayed in paging; obtain and display the data items corresponding to the page-turning command from the cache; obtain and display the total number of data items from the cache .

In a specific embodiment, the display module is specifically used for:

Call idle threads from the preset thread pool to count the total number of data entries that can be found in the database according to the current query conditions.

In a specific embodiment, the display module is also used for:

If the number of data items returned by the database is less than the preset query limit, the number of data items and all data items returned by the database will be displayed.

In a specific embodiment, it also includes:

The mapping module is used to assign identification information to the query conditions, and record the mapping relationship between the identification information and the query conditions; if a query command or page-turning command containing the query conditions is obtained, it will be displayed according to the mapping relationship and can be searched in the database according to the query conditions. The total number of data entries received.

For the more specific working process of each module and unit in this embodiment, reference may be made to the corresponding content disclosed in the foregoing embodiments, which will not be repeated here.

It can be seen that this embodiment provides a database query device, which can reduce the page loading time during the database query process.

The following describes an electronic device provided by an embodiment of the present application. An electronic device described below and a database query method and apparatus described above can be referred to each other.

Referring to FIG. 7 , an embodiment of the present application discloses an electronic device, including:

a memory 701 for storing computer programs;

The processor 702 is configured to execute the computer program to implement the method disclosed in any of the foregoing embodiments.

Further, the embodiments of the present application also provide an electronic device. The above electronic device may be either the server 50 as shown in FIG. 8 or the terminal 60 as shown in FIG. 9 . FIG. 8 and FIG. 9 are both structural diagrams of an electronic device according to an exemplary embodiment, and the contents in the figures should not be considered as any limitation on the scope of use of the present application.

FIG. 8 is a schematic structural diagram of a server according to an embodiment of the present application. The server 50 may specifically include: at least one processor 51 , at least one memory 52 , a power supply 53 , a communication interface 54 , an input and output interface 55 and a communication bus 56 . Wherein, the memory 52 is used for storing a computer program, and the computer program is loaded and executed by the processor 51, so as to realize the relevant steps in the monitoring of publishing the application program disclosed in any of the foregoing embodiments.

In this embodiment, the power supply 53 is used to provide working voltage for each hardware device on the server 50; the communication interface 54 can create a data transmission channel between the server 50 and external devices, and the communication protocol it follows is applicable to this Any communication protocol applying for the technical solution is not specifically limited here; the input and output interface 55 is used to obtain external input data or output data to the outside world, and its specific interface type can be selected according to specific application needs, which is not carried out here. Specific restrictions.

In addition, the memory 52, as a carrier for resource storage, can be a read-only memory, a random access memory, a magnetic disk or an optical disk, etc. The resources stored on the memory 52 include the operating system 521, the computer program 522, and the data 523, etc., and the storage method can be short-term storage or Permanent storage.

The operating system 521 is used to manage and control each hardware device and computer program 522 on the server 50, so as to realize the operation and processing of the data 523 in the memory 52 by the processor 51, which can be Windows Server, Netware, Unix, Linux, etc. . In addition to the computer program 522 that can be used to complete the monitoring method for publishing an application program disclosed in any of the foregoing embodiments, the computer program 522 may further include a computer program that can be used to complete other specific tasks. The data 523 may include, in addition to data such as update information of the application, data such as developer information of the application.

FIG. 9 is a schematic structural diagram of a terminal according to an embodiment of the present application. The terminal 60 may specifically include, but is not limited to, a smart phone, a tablet computer, a notebook computer, or a desktop computer.

Generally, the terminal 60 in this embodiment includes: a processor 61 and a memory 62 .

The processor 61 may include one or more processing cores, such as a 4-core processor, an 8-core processor, and the like. The processor 61 may adopt at least one hardware form among DSP (Digital Signal Processing, digital signal processing), FPGA (Field-Programmable Gate Array, field programmable gate array), PLA (Programmable Logic Array, programmable logic array) accomplish. The processor 61 may also include a main processor and a co-processor. The main processor is a processor used to process data in the wake-up state, and is also called a CPU (Central Processing Unit, central processing unit); A low-power processor for processing data in a standby state. In some embodiments, the processor 61 may be integrated with a GPU (Graphics Processing Unit, image processor), and the GPU is used for rendering and drawing the content that needs to be displayed on the display screen. In some embodiments, the processor 61 may further include an AI (Artificial Intelligence, artificial intelligence) processor, where the AI processor is used to process computing operations related to machine learning.

Memory 62 may include one or more computer-readable storage media, which may be non-transitory. Memory 62 may also include high-speed random access memory, as well as non-volatile memory, such as one or more magnetic disk storage devices, flash storage devices. In this embodiment, the memory 62 is at least used to store the following computer program 621, wherein, after the computer program is loaded and executed by the processor 61, it can implement the monitoring method for publishing an application program executed by the terminal side disclosed in any of the foregoing embodiments related steps in . In addition, the resources stored in the memory 62 may also include an operating system 622, data 623, etc., and the storage mode may be short-term storage or permanent storage. The operating system 622 may include Windows, Unix, Linux, and the like. Data 623 may include, but is not limited to, update information for applications.

In some embodiments, the terminal 60 may further include a display screen 63 , an input/output interface 64 , a communication interface 65 , a sensor 66 , a power supply 67 and a communication bus 68 .

Those skilled in the art can understand that the structure shown in FIG. 9 does not constitute a limitation on the terminal 60, and may include more or less components than those shown in the drawings.

A readable storage medium provided by an embodiment of the present application is introduced below. A readable storage medium described below and a database query method, apparatus, and device described above can be referred to each other.

A readable storage medium for storing a computer program, wherein when the computer program is executed by a processor, the database query method disclosed in the foregoing embodiments is implemented. For the specific steps of the method, reference may be made to the corresponding content disclosed in the foregoing embodiments, which will not be repeated here.

The following describes a computer program product provided by the embodiments of the present application. The computer program product described below and the database query method, apparatus, and device described above can be referred to each other.

A computer program product comprising computer instructions which, when run on a computer, enable the computer to perform the aforementioned disclosed database query method. For the specific steps of the method, reference may be made to the corresponding content disclosed in the foregoing embodiments, which will not be repeated here.

References in this application to "first", "second", "third", "fourth", etc. (if any) are used to distinguish similar objects and are not necessarily used to describe a specific order or sequence. It is to be understood that data so used may be interchanged under appropriate circumstances so that the embodiments described herein can be practiced in sequences other than those illustrated or described herein. Furthermore, the terms "comprising" and "having", and any variations thereof, are intended to cover non-exclusive inclusion, for example, a process, method or apparatus comprising a series of steps or elements is not necessarily limited to those steps or elements expressly listed , but may include other steps or elements not expressly listed or inherent to these processes, methods or apparatus.

It should be noted that the descriptions involving "first", "second", etc. in this application are only for the purpose of description, and should not be construed as indicating or implying their relative importance or implying the number of indicated technical features . Thus, a feature delimited with "first", "second" may expressly or implicitly include at least one of that feature. In addition, the technical solutions between the various embodiments can be combined with each other, but must be based on the realization by those of ordinary skill in the art. When the combination of technical solutions is contradictory or cannot be realized, it should be considered that the combination of such technical solutions does not exist. , is not within the scope of protection claimed in this application.

The various embodiments in this specification are described in a progressive manner, and each embodiment focuses on the differences from other embodiments, and the same or similar parts between the various embodiments may be referred to each other.

The steps of a method or algorithm described in conjunction with the embodiments disclosed herein may be directly implemented in hardware, a software module executed by a processor, or a combination of the two. A software module can be placed in random access memory (RAM), internal memory, read only memory (ROM), electrically programmable ROM, electrically erasable programmable ROM, registers, hard disk, removable disk, CD-ROM, or any other in the technical field. in any other form of readable storage medium that is well known.

The principles and implementations of the present application are described herein by using specific examples. The descriptions of the above embodiments are only used to help understand the methods and core ideas of the present application. There will be changes in the specific implementation and application scope. To sum up, the content of this specification should not be construed as a limitation to the application.

Claims (10)

1. a database query method, is characterized in that, comprises: Obtain a query instruction, and determine the query condition corresponding to the query instruction; Query the database according to the query conditions and preset query limits; If the database returns the preset query limit data items, display the preset query limit data items returned by the database, and asynchronously count the query conditions in the database while displaying. The total number of data entries that can be found in the . 2. The method according to claim 1, wherein the asynchronously counting the total number of data entries that can be found in the database for the query condition further comprises: query the cache for the total number of data entries; If the total number of data items is found in the cache, the total number of data items is obtained from the cache; otherwise, the step of asynchronously counting the total number of data items that can be found in the database by the query condition is performed. 3. The method of claim 1, further comprising: The query condition, the preset query limit number of data items, and the total number of data items are stored in the cache. 4 . The method according to claim 3 , wherein, if the preset query limit data items are displayed on a page, the query condition, the preset query limit data items and all the data items are displayed in a page. 5 . After the total number of data entries is stored in the cache, it also includes: Get the page turning instruction entered by the user; Acquire and display the data entry corresponding to the page turning instruction from the cache; Fetch and display the total number of data entries from the cache. 5. The method according to claim 1, wherein the asynchronous statistics of the total number of data entries that can be found in the database for the query conditions, comprising: The idle thread is called from the preset thread pool to count the total number of the data items. 6. The method of claim 5, further comprising: If the number of data items returned by the database is less than the preset query limit, the number of data items and all data items returned by the database are displayed. 7. The method according to any one of claims 1 to 5, characterized in that, further comprising: Allocate identification information for the query condition, and record the mapping relationship between the identification information and the query condition; If the query instruction or page turning instruction including the query condition is acquired, the total number of data items is displayed according to the mapping relationship. 8. A database query device, comprising: an acquisition module, configured to acquire a query instruction and determine the query condition corresponding to the query instruction; a query module, used for querying the database according to the query conditions and preset query limit values; A display module, configured to display the preset query limit data items returned by the database if the database returns the preset query limit data items, and asynchronously count the queries while displaying The total number of data entries available in the database for the condition. 9. An electronic device, characterized in that, comprising: memory for storing computer programs; A processor for executing the computer program to implement the method according to any one of claims 1 to 7. 10. A readable storage medium, characterized by being used for storing a computer program, wherein the computer program implements the method according to any one of claims 1 to 7 when the computer program is executed by a processor.

Images