CN109271597A - A kind of non-relational database multilist scene Pagination Display method and device thereof - Google Patents
A kind of non-relational database multilist scene Pagination Display method and device thereof Download PDFInfo
- Publication number
- CN109271597A CN109271597A CN201811093912.2A CN201811093912A CN109271597A CN 109271597 A CN109271597 A CN 109271597A CN 201811093912 A CN201811093912 A CN 201811093912A CN 109271597 A CN109271597 A CN 109271597A
- Authority
- CN
- China
- Prior art keywords
- output
- data page
- record
- current
- scene
- 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.)
- Granted
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The invention discloses a kind of non-relational database multilist scene Pagination Display method and device thereof, comprising: receives the Pagination Display instruction that browser is sent, determines that Pagination Display instructs corresponding multiple tables to be output；Select a table to be output as current output formats from nosql；It is added in current data page from each item record is successively read in current output formats；Every data page outputs this to browser after meeting default output condition, and generates new data page；It detects the record in current output formats and whether reads and finish, if not having, continue to read in the record to current data page in current output formats；If reading finishes, judge in nosql with the presence or absence of table to be output, and if it exists, reselect table to be output, otherwise, Pagination Display terminates.The present invention realizes paging output of the nosql under multilist scene, improves the practicability of nosql by way of successively carrying out paging output to each table to be output.
Description
Technical field
The present invention relates to browser field of display technology, more particularly to a kind of non-relational database multilist scene paging
Display methods and its device.
Background technique
Web data paging is to improve the paging method of service response time, concrete application based on volume of transmitted data is reduced
Scene is that return browser is shown after the data for requesting browser into database are divided into multiple data pages.Current one
Kind common paging method is data source paging, data source paging refer to it is primary directly from database read page of data return to it is clear
Look at device.
General data source paging only relates to one database table in backstage, i.e. browser only needs to obtain a database table
Interior data, it is the database using limit, skip combination in most cases that the logic under this scene is more intuitive simple
What sql sentence was realized.And for multilist scene, i.e. multiple databases of data from website backstage for showing of browse request
Table can mainly be realized in sql database at present.
Sql database is relevant database, and after it receives the idsplay order that browser is sent, which can lead to
It crosses view function and is synthesized together the data group of multiple tables and carry out output and show.But for not having above-mentioned view function
Nosql database (non-relational database), then can not using aforesaid way carry out paging output.Nosql database receives
After paging instruction under the multilist scene sent to browser, can not usually Pagination Display be carried out to multilist, will lead to browser
It reports an error, the practicability of nosql database is poor.
Therefore, how a kind of non-relational database multilist scene Pagination Display method that practicability is high and its dress are provided
Setting is the current problem to be solved of those skilled in the art.
Summary of the invention
The object of the present invention is to provide a kind of non-relational database multilist scene Pagination Display method and device thereof, pass through
The mode that paging output is successively carried out to each under multilist scene table to be output, realizes nosql database under multilist scene
Paging output, improve nosql database practicability.
In order to solve the above technical problems, the present invention provides a kind of non-relational database multilist scene Pagination Display sides
Method, comprising:
Step s1: receiving the Pagination Display instruction that browser is sent, determine Pagination Display instruction it is corresponding it is multiple to
Output formats；
Step s2: select a table to be output as current output formats from non-relational database nosql；
Step s3: it is successively read each item record out of described current output formats and is added in current data page；Every number
The browser is output this to after meeting default output condition according to page, and generates new data page；
Step s4: whether the record in the detection current output formats, which reads, finishes, if not having, return step s3；If
Reading finishes, and enters step s5；
Step s5: judge in the nosql with the presence or absence of table to be output, and if it exists, return step s2, if it does not exist,
Pagination Display terminates.
Preferably, the default output condition includes: that the record strip number in data page reaches max-thresholds.
Preferably, the default output condition further include: a new table to be output has been selected to make from the nosql
For current output formats.
Preferably, the process of the step s3 specifically includes:
Step s31: it is added in the current data page from each item record is successively read in the current output formats；
Step s32: one record of every addition then judges whether the current data page meets the default output condition, if
Meet, enters step s33；If not satisfied, entering step s4；
Step s33: the current data page is exported to the browser, and generates new data page as current data
Page, enters step s4；
Correspondingly, in step s4, finished if recording in the detection current output formats is unread, return step
s31。
Preferably, the process of the step s3 specifically includes:
Determine the record quantity M that can also be added in the current data page；
Judge whether unread records quantity is greater than or equal to M in the current output formats, if so, working as from described
M unread records are read in preceding output formats to be added in the current data page, and export current data page to browsing
Device generates new data page as current data page, enters step s4；
If unread records quantity is less than M in the current output formats, will not be read in the current output formats
The record taken is all added in the current data page, and enters step s5；M is the integer not less than 0.
Preferably, in the step s3, it is successively read each item record out of described current output formats and is added to current number
It is specifically included according to the process in page:
The last item of label has been read into record as starting, has read next record in the current output formats
The position of record has been read in the current data page, and in current output formats described in real-time mark.
Preferably, it after the current data page meets the default output condition, outputs this to before browser, also
Include:
Record number including in this data page, belonging to the record strip number in current output formats and record page；
In step s3, it is successively read each item out of described current output formats and records the process being added in current data page
It specifically includes:
Recorded before statistics exported to it is recording in each data page of browser, belong to current output formats
The sum of the item number of record N skips top n record, exports since the N+1 record to new later out of current output formats
Data page in；N is the integer not less than 0.
Preferably, before step s2, further includes:
Each table to be output is ranked up；
Correspondingly, according to the vertical sequence that sorts, successively selecting table to be output as current output in step s2
Table.
Preferably, the nosql includes two tables to be output.
In order to solve the above technical problems, the present invention also provides a kind of non-relational database multilist scene Pagination Display dresses
It sets, comprising:
Command reception module determines that Pagination Display instruction is corresponding for receiving the Pagination Display instruction of browser transmission
Multiple tables to be output；
Table selecting module, for selecting a table to be output as current defeated from non-relational database nosql
Table out；
Output module is added in current data page for being successively read each item record out of described current output formats；
Every data page outputs this to the browser after meeting default output condition, and generates new data page；
Whether detection module reads for detecting the record in the current output formats and finishes, if not having, described in triggering
Output module；If reading finishes, judgment module is triggered；
Judgment module, for judging in the nosql with the presence or absence of table to be output, and if it exists, trigger the output mould
Block, if it does not exist, Pagination Display terminate.
In order to solve the above technical problems, the present invention also provides a kind of non-relational database multilist scene Pagination Displays to set
It is standby, comprising:
Memory, for storing computer program；
Processor realizes that the non-relational database as described in any of the above item is more when for executing the computer program
The step of table scene Pagination Display method.
The present invention provides a kind of non-relational database multilist scene Pagination Display methods, receive point that browser is sent
After page idsplay order, a table to be output can be selected to carry out paging as current output formats from nosql database first
Output then continues to select next table to be output as current output from nosql database after the Output of for ms
Table is exported, until Pagination Display, which instructs corresponding whole table to be output to export, to be finished.As it can be seen that the present invention is logical
Aforesaid way is crossed, making nosql database also can support the paging under multilist scene to export, and exist to meet nosql database
Paging under various application scenarios exports demand, improves the practicability of nosql database.
Detailed description of the invention
It to describe the technical solutions in the embodiments of the present invention more clearly, below will be to institute in the prior art and embodiment
Attached drawing to be used is needed to be briefly described, it should be apparent that, the accompanying drawings in the following description is only some implementations of the invention
Example, for those of ordinary skill in the art, without creative efforts, can also obtain according to these attached drawings
Obtain other attached drawings.
Fig. 1 is a kind of process of the process of non-relational database multilist scene Pagination Display method provided by the invention
Figure；
Fig. 2 is the process of the process of another non-relational database multilist scene Pagination Display method provided by the invention
Figure；
Fig. 3 is a kind of structural schematic diagram of non-relational database multilist scene Pagination Display device provided by the invention.
Specific embodiment
Core of the invention is to provide a kind of non-relational database multilist scene Pagination Display method and device thereof, passes through
The mode that paging output is successively carried out to each under multilist scene table to be output, realizes nosql database under multilist scene
Paging output, improve nosql database practicability.
In order to make the object, technical scheme and advantages of the embodiment of the invention clearer, below in conjunction with the embodiment of the present invention
In attached drawing, technical scheme in the embodiment of the invention is clearly and completely described, it is clear that described embodiment is
A part of the embodiment of the present invention, instead of all the embodiments.Based on the embodiments of the present invention, those of ordinary skill in the art
Every other embodiment obtained without making creative work, shall fall within the protection scope of the present invention.
The present invention provides a kind of non-relational database multilist scene Pagination Display methods, and shown in Figure 1, Fig. 1 is
A kind of flow chart of the process of non-relational database multilist scene Pagination Display method provided by the invention；This includes:
Step s1: receiving the Pagination Display instruction that browser is sent, and determines that Pagination Display instruction is corresponding multiple to be output
Table；
It is understood that the application is directed to the paging situation under multilist scene.Therefore, browser referred herein
The Pagination Display instruction of transmission can the multiple tables to be output of opposite rear end.I.e. purpose be by the content of this multiple table to be output with
The form of paging is sent to browser and is shown.
Step s2: select a table to be output as current output formats from non-relational database nosql；
The application is by the mode that successively paging exports of multiple tables to be output in nosql database by the way of.
For example, if Pagination Display instructs corresponding two tables to be output, table a and table b.Then the application is elder generation by the way of
It fetches from table a, is sent to browser after carrying out paging.After the data acquisition of table a, then data are obtained from table b and carry out paging
It is sent to browser later.Therefore, in the whole process, need successively to obtain each table to be output from nosql database
Paging output is carried out as current output formats, to realize the Pagination Display under multilist scene in nosql database.
Step s3: it is added in current data page from each item record is successively read in current output formats；Every data page
Browser is output this to after meeting default output condition, and generates new data page；
It is understood that including several records in each table to be output, when being exported to table, need
Whole records in the table are added in data page, data page is exported to browser show later.In paging
In the application of display, the record in table to be output is to be exported by multiple data pages to browser to realize that web paging is grasped
Make the effect for wanting to realize, therefore the purpose in order to realize paging, i.e., the content of all tables to be output can not be saved to
In one data page.Therefore it needs to set default output condition, when data page meets default output condition, that is, output this to
Browser generates new data page later, and the remaining record in current output formats is continued to be added in new data page,
To achieve the effect that paging.
Whether step s4: detecting the record in current output formats and read and finish, if not having, return step s3；If reading
It finishes, enters step s5；
It is understood that the paging mode under the multilist scene that the present invention uses, is by successively to multiple to be output
Table carries out paging output to realize.Therefore, it is necessary to detect whether the record in current output formats has all been added to
In data page, if added finish, then need to be read out output to the record in next table to be output at this time, from
And realize the purpose that multilist scene Pagination Display is realized in non-relational database.And if current output formats have not yet been read
If finishing, then return step s3, continues to read in the record to current data page in current output formats.
Step s5: judge in nosql with the presence or absence of table to be output, and if it exists, return step s2, if it does not exist, paging
Display terminates.
The present invention can select one after receiving the Pagination Display instruction that browser is sent first from nosql database
Table to be output carries out paging output as current output formats, after the Output of for ms, then continues from nosql database
It is middle that next table to be output is selected to be exported as current output formats, until Pagination Display instruction is corresponding all to defeated
Table exports out finish until.As it can be seen that the present invention is by the above-mentioned means, make nosql database that can also support multilist scene
Under paging output, thus meet nosql database under various application scenarios paging output demand, improve nosql number
According to the practicability in library.
In a kind of specific embodiment, default output condition includes: that the record strip number in data page reaches max-thresholds.
Defined in the embodiment, once the record strip number in data page reaches max-thresholds, then it represents that the data page
It has been expired that, the data page is directly output to front end browser later.For example, if max-thresholds are 20, then current defeated
Out after 20 record to data pages of the every addition of table, which meets default output condition, needs to output this to browsing
Device.Certainly, max-thresholds here can be set according to the actual situation, and the present invention is to without limitation.
In addition, if presetting output condition only includes if the record strip number in data page reaches max-thresholds, current
The content of output formats is all added in data page, but maximum has not yet been reached in the record strip number for including in current data page
When threshold value, due to being unsatisfactory for prediction output condition at this time, therefore new data page can't be generated.In this case, when selection is new
Table to be output as current output formats after, the record in next table to be output can be added to the current data page
It is interior, i.e., it is likely to occur the situation that the record saved in data page is respectively from two tables to be output in this case.
For by two tables and carrying out paging, it is assumed that have 15 records in TABLE1 table, have 20 records in TABLE2 table, to show altogether
Show 35 records, then first page is 10 records in display TABLE1 table, second page is that first half shows in TABLE1 table 5
Record, latter half of to lack 5 records by 5 record displays in TABLE2 table, third page is 10 records in display TABLE2 table, the
Page four are remaining 5 records in display TABLE2 table.It is understood that in this case, can guarantee in addition to last
Except a data page, when each data page is exported to browser, the record strip number for inside including has reached max-thresholds, thus
The utilization efficiency for improving data page, reduces the response time of corresponding with service in browser, and browser receive it is each
The data coherency of paging is stronger.
In another embodiment, output condition is preset further include: a new table to be output has been selected to make from nosql
For current output formats.
It is understood that when default output condition is other than record strip number reaches max-thresholds, also comprising current defeated
Table switches to new table to be output out.In this case, after current output formats switch, no matter current number
Whether expire according to page, current data page can have been exported to browser and has generated new data page.Still by taking two tables as an example,
There are 15 records in TABLE1 table, there are 20 records in TABLE2 table, then first page is 10 records in display TABLE1 table,
Second page is 5 records in display TABLE1 table, due to switching to TABLE2 output at this time, therefore can directly be exported second page,
Generating third page is 10 records in display TABLE2 table, and page four is the 10 articles of records shown in TABLE2 table.This mode
It is primarily adapted for use in the situation that Pagination Display instructs corresponding each table content relevance to be output little.In this case, if
If the splicing of the content of each table to be output is shown in same data page, may inconvenient staff pass through
Browsing of the browser to data page.Therefore, using aforesaid way by the content of different tables to be output carry out respectively paging and
Output, so that oneself the corresponding paging of each each table to be output, independence is stronger, between each table to be output
In the case that data coherency is not strong, it can be checked convenient for staff.
In other embodiments, prediction output condition can be only and work as to have selected new table to be output as current output
When table, control data page output.Record in i.e. each table to be output is all stored in the same data page.Certainly,
Predict that output condition can also include other content, this is not limited by the present invention.
In an advantageous embodiment, shown in Figure 2, this is not limited by the present invention by Fig. 2.It is provided by the invention another
A kind of flow chart of the process of non-relational database multilist scene Pagination Display method.
The process of step s3 specifically includes:
Step s31: it is added in current data page from each item record is successively read in current output formats；
Step s32: one record of every addition then judges whether current data page meets default output condition, if satisfied, into
Enter step s33；If not satisfied, entering step s4；
It is understood that being added to current data page, and every addition by being successively read each item record in the present embodiment
One record determines whether current data page meet the record in default output condition and current output formats
It is all added in data page, so as to avoid record from omitting and record the case where repeating, and is conveniently subsequently generated new
After data page, the initial position of confirmation record reading.
Step s33: output current data page to browser, and new data page is generated as current data page, into step
Rapid s4；
Correspondingly, in step s4, if detect in current output formats record it is unread finish, return step s31.
It is understood that by determining whether data page meets default output condition and current output formats in real time
State can not repeat, do not omit be successively added to the record in each table to be output in data page, and by data page
Output is shown into browser, to complete the paging activity under the multilist scene in nosql database.
In with another embodiment, when default output condition includes: that the record strip number in data page reaches max-thresholds,
The process of step s3 specifically includes:
Determine the record quantity M that can also be added in the current data page；
Judge whether unread records quantity is greater than or equal to M in the current output formats, if so, working as from described
M unread records are read in preceding output formats to be added in the current data page, and export current data page to browsing
Device generates new data page as current data page, enters step s4；
If unread records quantity is less than M in the current output formats, will not be read in the current output formats
The record taken is all added in the current data page, and enters step s5；M is the integer not less than 0.
It is understood that not needing to check a number after one record to data page of every addition under this mode
Whether meet preset need according to page and whether current output formats export and finish, reduce above-mentioned detection operation executes frequency
Rate, to improve the efficiency of paging.
Further, after generating new data page, new data page can be learnt from current output table for convenience
Start the record position read in lattice, after every data page meets default output condition, can be remembered using following two mode
The position for the record that record has currently been read.
A kind of mode be after the current data page meets the default output condition, output this to browser it
Before, record number including in this data page, belonging to the record strip number in current output formats and record page, Zhi Housheng
The data page of Cheng Xin.In step s3, it is successively read each item record out of described current output formats and is added in current data page
Process specifically include: recorded before statistics exported to it is recording in each data page of browser, belong to it is current defeated
The sum of item number of the record of table N out skips top n record, since the N+1 record later out of current output formats
In output to new data page；N is the integer not less than 0.I.e. in the process, after generating new data page, if simultaneous selection
New current output formats, then can reset the record strip number recorded, N=0 after return step s3, and start recording again
It exports in new current output formats to the record strip number in each data page；If after generating new data page, and not simultaneously
The new current output formats of selection, then N is not equal to 0 at this time, reads since the N+1 articles record.
Another way be after the current data page meets the default output condition, output this to browser it
Before, on the basis of the record strip number of the preceding current output formats once saved, increase current data page in include, belong to and work as
The quantity of record in preceding output formats obtains state-of-the-art record item number N.Output is recorded to data i.e. since current output formats
It when page, then counts including in every data page, belong to the quantity of record in current output formats, and often increase one newly
After data page, then in the quantity counted before, increase it is including in this data page, belong to note in current output formats
The quantity of record.For example, first data page saves the table when exporting record to data page since current output formats
10 records in lattice, then N=10, generates new data page later, 10 in the table is also saved in new data page
It records, then N=20.In i.e. this mode, N value is constantly accumulated, but does not need the number of record data page.Later in step s3,
It is successively read the process that each item record is added in current data page out of described current output formats to specifically include: before determining
The sum of item number recorded in each data page of record exported, record that belong to current output formats N, later from working as
Top n record is skipped in preceding output formats, is exported since the N+1 record to new data page；N is whole not less than 0
Number.
Subsequent, skipping the operation that top n record is read out can be realized by skip function.
No matter in addition, the mode that record is added to current data page all can be a rule under which kind of above mode
Addition, in this case, the initial position that subsequent confirmation record is read for convenience can also be currently defeated using real-time mark
The mode of the position of record has been read in table out.
That is in step s3, have from the process that each item record is added in current data page is successively read in current output formats
Body are as follows:
The last item of label has been read into record as starting, has read next in current output formats record to working as
The position of record has been read in preceding data page, and in the current output formats of real-time mark.
Make in this way, one record of every addition to after data page, in current spreadsheet i.e. update mark once it is current
Record position through reading, to facilitate subsequent carry out reading data.This mode real-time is stronger, records number compared to calculating
Mode, it is not easy to occurrence count mistake equal error, reliability and accuracy are higher.
Certainly, the above several ways be for capable of not repeating, do not omit by the record in each table to be output
Which kind of it is added in data page, therefore, specifically without limitation using the mode present invention, as long as can be realized the mode of above-mentioned purpose
It is within the scope of the present invention.
Preferably, before step s2, further includes:
Each table to be output is ranked up；
Correspondingly, according to the vertical sequence that sorts, successively selecting table to be output as current output in step s2
Table.
It is understood that under multilist scene, it is this there may be sequence and relevance between each table to be output
In the case of, in order to guarantee the convenience of user's browsing, it should paging is sequentially generated with being associated with according to this sequence and is shown, because
This needs to treat output formats and is ranked up in this case, and comes to carry out successively paging to each table according to sequence, from
And each data page for showing browser is also shown in sequence, user experience is more preferable.
Preferably, nosql includes two tables to be output.
It is understood that when under table more than two scene to be output, since data volume is very big, each table to be output
Between association also can be complex, in this case, time when carrying out paging by the way of of the invention can be longer, because
This, present invention is preferably used in carry out paging under the multilist scene of 2 tables to be output.
The present invention also provides a kind of non-relational database multilist scene Pagination Display device, shown in Figure 3, Fig. 3
For a kind of structural schematic diagram of non-relational database multilist scene Pagination Display device provided by the invention.The device includes:
Command reception module 1 determines that Pagination Display instruction is corresponding for receiving the Pagination Display instruction of browser transmission
Multiple tables to be output；
Table selecting module 2, for selecting a table to be output as current defeated from non-relational database nosql
Table out；
Output module 3, for being added in current data page from being successively read each item record in current output formats；Every
Data page outputs this to browser after meeting default output condition, and generates new data page；
Detection module 4, whether the record for detecting in current output formats, which reads, finishes, if not having, triggering output mould
Block 3；If reading finishes, judgment module 5 is triggered；
Judgment module 5, for judging in nosql with the presence or absence of table to be output, and if it exists, triggering output module 3, if not
In the presence of Pagination Display terminates.
Preferably, output module 3 specifically includes:
Output unit is recorded, for being added in current data page from being successively read each item record in current output formats；
One record of every addition then triggers output judging unit；
Judging unit is exported, whether meets default output condition for real-time judge current data page, if satisfied, triggering number
According to page output unit；If not satisfied, detection trigger module；
Data page output unit for exporting current data page to browser, and generates new data page as current number
According to page, detection trigger module 4；
Correspondingly, the detection module 4 detect in current output formats when recording unread finish, trigger recording is defeated
Unit out.
Preferably, when default output condition includes: that record strip number in data page reaches max-thresholds, output module
3 specifically include:
Volume residual determination unit, for determining the record quantity M that can also be added in the current data page；
Quantity judging unit, for judging whether unread records quantity is greater than or equal in the current output formats
M, if so, the first data adding unit of triggering；If it is not, the second data adding unit of triggering；
First data adding unit is added to institute for reading M unread records out of described current output formats
It states in current data page, and exports current data page to browser, generate new data page as current data page, detection trigger
Module 4；
Unread records in the current output formats are all added to described by the second data adding unit for this
In current data page, and trigger judgment module 5；M is the integer not less than 0.
Preferably, further includes:
Sorting module, for being ranked up to each table to be output；Trigger table selecting module 2；
Correspondingly, table selecting module 2 is specifically used for successively selecting table to be output according to the vertical sequence that sorts
As current output formats.
Above several specific embodiments are only the preferred embodiment of the present invention, and above several specific embodiments can be with
Any combination, the embodiment obtained after combination is also within protection scope of the present invention.It should be pointed out that for the art
For those of ordinary skill, relevant speciality technical staff deduced out in the case where not departing from spirit of that invention and concept thereof other change
Into and variation, should all be included in the protection scope of the present invention.
It should also be noted that, in the present specification, the terms "include", "comprise" or its any other variant are intended to contain
Lid non-exclusive inclusion, so that the process, method, article or equipment including a series of elements is not only wanted including those
Element, but also including other elements that are not explicitly listed, or further include for this process, method, article or equipment
Intrinsic element.In the absence of more restrictions, the element limited by sentence "including a ...", it is not excluded that
There is also other identical elements in process, method, article or equipment including the element.
Claims (10)
1. a kind of non-relational database multilist scene Pagination Display method characterized by comprising
Step s1: receiving the Pagination Display instruction that browser is sent, and determines that the Pagination Display instruction is corresponding multiple to be output
Table；
Step s2: select a table to be output as current output formats from non-relational database nosql；
Step s3: it is successively read each item record out of described current output formats and is added in current data page；Every data page
The browser is output this to after meeting default output condition, and generates new data page；
Step s4: whether the record in the detection current output formats, which reads, finishes, if not having, return step s3；If reading
It finishes, enters step s5；
Step s5: judge in the nosql with the presence or absence of table to be output, and if it exists, return step s2, if it does not exist, paging
Display terminates.
2. non-relational database multilist scene Pagination Display method according to claim 1, which is characterized in that described pre-
If output condition includes: that the record strip number in data page reaches max-thresholds.
3. non-relational database multilist scene Pagination Display method according to claim 2, which is characterized in that described pre-
If output condition further include: selected a new table to be output as current output formats from the nosql.
4. non-relational database multilist scene Pagination Display method according to claim 1-3, feature exist
In the process of the step s3 specifically includes:
Step s31: it is added in the current data page from each item record is successively read in the current output formats；
Step s32: one record of every addition then judges whether the current data page meets the default output condition, if full
Foot, enters step s33；If not satisfied, entering step s4；
Step s33: exporting the current data page to the browser, and generates new data page as current data page, into
Enter step s4；
Correspondingly, in step s4, finished if recording in the detection current output formats is unread, return step s31.
5. non-relational database multilist scene Pagination Display method according to claim 1-3, feature exist
In the process of the step s3 specifically includes:
Determine the record quantity M that can also be added in the current data page；
Judge whether unread records quantity is greater than or equal to M in the current output formats, if so, from described current defeated
M unread records are read in table out to be added in the current data page, and export current data page to browser, life
The data page of Cheng Xin enters step s4 as current data page；
If unread records quantity is less than M in the current output formats, will be unread in the current output formats
Record is all added in the current data page, and enters step s5；M is the integer not less than 0.
6. non-relational database multilist scene Pagination Display method according to claim 1-3, feature exist
In being successively read each item out of described current output formats and record the process being added in current data page in the step s3
It specifically includes:
The last item of label record is read into as starting, next read in the current output formats records to institute
It states in current data page, and has read the position of record in current output formats described in real-time mark.
7. according to the described in any item non-relational database multilist scene Pagination Display methods of Claims 2 or 3, feature exists
In outputting this to before browser after the current data page meets the default output condition, further includes:
Record number including in this data page, belonging to the record strip number in current output formats and record page；
In step s3, it is specific that the process that each item record is added in current data page is successively read out of described current output formats
Include:
What is recorded before statistics has exported to record recording in each data page of browser, belonging to current output formats
The sum of item number N skip top n record later out of current output formats, export since recording the N+1 to new number
According in page；N is the integer not less than 0.
8. non-relational database multilist scene Pagination Display method according to claim 1, which is characterized in that step s2
Before, further includes:
Each table to be output is ranked up；
Correspondingly, according to the vertical sequence that sorts, successively selecting table to be output as current output table in step s2
Lattice.
9. non-relational database multilist scene Pagination Display method according to claim 1, which is characterized in that described
Nosql includes two tables to be output.
10. a kind of non-relational database multilist scene Pagination Display device characterized by comprising
Command reception module determines that Pagination Display instruction is corresponding multiple for receiving the Pagination Display instruction of browser transmission
Table to be output；
Table selecting module, for selecting a table to be output as current output table from non-relational database nosql
Lattice；
Output module is added in current data page for being successively read each item record out of described current output formats；Every
Data page outputs this to the browser after meeting default output condition, and generates new data page；
Whether detection module reads for detecting the record in the current output formats and finishes, if not having, trigger the output
Module；If reading finishes, judgment module is triggered；
Judgment module, for judging in the nosql with the presence or absence of table to be output, and if it exists, the output module is triggered, if
It is not present, Pagination Display terminates.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811093912.2A CN109271597B (en) | 2018-09-19 | 2018-09-19 | Method and device for paging display of multi-table scene of non-relational database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811093912.2A CN109271597B (en) | 2018-09-19 | 2018-09-19 | Method and device for paging display of multi-table scene of non-relational database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109271597A true CN109271597A (en) | 2019-01-25 |
| CN109271597B CN109271597B (en) | 2022-02-18 |
Family
ID=65198040
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811093912.2A Active CN109271597B (en) | 2018-09-19 | 2018-09-19 | Method and device for paging display of multi-table scene of non-relational database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109271597B (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101425055A (en) * | 2008-10-29 | 2009-05-06 | 金蝶软件（中国）有限公司 | Table outputting method, device, system and apparatus |
| US20130103658A1 (en) * | 2011-10-19 | 2013-04-25 | Vmware, Inc. | Time series data mapping into a key-value database |
| CN104965873A (en) * | 2015-06-10 | 2015-10-07 | 努比亚技术有限公司 | Paging inquiring method and apparatus |
| CN105045932A (en) * | 2015-09-02 | 2015-11-11 | 南京邮电大学 | Data paging inquiry method based on descending order storage |
| CN105653537A (en) * | 2014-11-13 | 2016-06-08 | 阿里巴巴集团控股有限公司 | Paging query method and device for database application system |
-
2018
- 2018-09-19 CN CN201811093912.2A patent/CN109271597B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101425055A (en) * | 2008-10-29 | 2009-05-06 | 金蝶软件（中国）有限公司 | Table outputting method, device, system and apparatus |
| US20130103658A1 (en) * | 2011-10-19 | 2013-04-25 | Vmware, Inc. | Time series data mapping into a key-value database |
| CN105653537A (en) * | 2014-11-13 | 2016-06-08 | 阿里巴巴集团控股有限公司 | Paging query method and device for database application system |
| CN104965873A (en) * | 2015-06-10 | 2015-10-07 | 努比亚技术有限公司 | Paging inquiring method and apparatus |
| CN105045932A (en) * | 2015-09-02 | 2015-11-11 | 南京邮电大学 | Data paging inquiry method based on descending order storage |
Non-Patent Citations (2)
| Title |
|---|
| WEN B: "Research on data storage strategy for Industry 4.0 using multi-table schema and NoSQL big data technique", 《MICROCOMPUTER & ITS APPLICATIONS》 * |
| 戴传飞: "MongoDB分页技术优化研究", 《计算机技术与发展》 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109271597B (en) | 2022-02-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106951141B (en) | A kind of processing method and mobile terminal of icon | |
| CN110515896B (en) | Model resource management method, model file manufacturing method, device and system | |
| CN105354256A (en) | Data pagination query method and apparatus | |
| CN106919695B (en) | A kind of information recommendation method and terminal | |
| CN105718028B (en) | A kind of electricity saving method and device based on identification power consumption application | |
| CN106528889B (en) | A kind of information search method and terminal | |
| CN106055315A (en) | Method and system for processing batched tasks | |
| CN107943695A (en) | Testing case management, device, equipment and computer-readable recording medium | |
| CN106874326A (en) | A kind of item list obtains request processing method and device | |
| CN106469059A (en) | A kind of method of operation interface display pattern of adjustment mobile terminal and mobile terminal | |
| CN110928900B (en) | Multi-table data query method, device, terminal and computer storage medium | |
| CN107045499A (en) | A kind of method and server for realizing data query | |
| CN106874394A (en) | A kind of method and apparatus of file packing pretreatment | |
| CN110413974A (en) | Form template configuration and device, table deriving method and device | |
| CN101241513A (en) | Maintenance list item method and device | |
| CN109271597A (en) | A kind of non-relational database multilist scene Pagination Display method and device thereof | |
| CN109302449A (en) | Method for writing data, method for reading data, device and server | |
| CN109828984B (en) | Analysis processing method and device, computer storage medium and terminal | |
| CN107454267A (en) | The processing method and mobile terminal of a kind of image | |
| CN107608594A (en) | A kind of display methods and mobile terminal of more applications | |
| CN107330031A (en) | A kind of method of data storage, device and electronic equipment | |
| CN103678312A (en) | Method and client terminal for recommending website | |
| CN109783476A (en) | The Matrix Analysis Method and system of multi-dimensional data based on database | |
| CN105893402A (en) | Information displaying method used for terminal equipment, and terminal equipment | |
| WO2021057088A1 (en) | Data connection method and apparatus and electronic device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |