CN104298731A - Flex-based paged querying method - Google Patents
Flex-based paged querying method Download PDFInfo
- Publication number
- CN104298731A CN104298731A CN201410513849.9A CN201410513849A CN104298731A CN 104298731 A CN104298731 A CN 104298731A CN 201410513849 A CN201410513849 A CN 201410513849A CN 104298731 A CN104298731 A CN 104298731A
- Authority
- CN
- China
- Prior art keywords
- data
- query
- flex
- page
- paging
- 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.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/951—Indexing; Web crawling techniques
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a flex-based paged querying method. The method comprises the following steps: encapsulating data by sql paged querying; returning a data format as flex requirement; transferring to a flex form for analyzing and displaying. According to the paged querying method, the encapsulating is performed, the interface call is provided, and therefore, the importance of a code is improved, the development time is saved, and as a result, the development efficiency is raised.
Description
Technical field
The present invention relates to field of computer technology, particularly relate to a kind of method based on flex paging query.
Background technology
The epoch of internet now, increasing information transfers to internet to process, people can retrieve a lot of information on the internet, paging query is present application system, the modal function in website, user is according to querying condition data query, then show at the page of browser, if the data that retrieval is returned are a lot, do not carry out paging process, so just be unfavorable for that user checks information, and can inquire about very slow when big data quantity, so just do not reach the effect that user wants fast query, also likely there is the phenomenon of retrieve data time-out, paging query is used to address this problem, both data query can be shown easily, also search efficiency can be promoted.Existing a lot of paging plug-in unit cannot cross operating system or browser execution, and Flex can accomplish this point, not by the impact of operating system and browser.
Summary of the invention
The object of the invention is the defect in order to overcome prior art, there is provided a kind of method based on flex paging query, it is characterized in that, the method is to utilize sql paging query to encapsulate data, return the data layout that flex needs, transfer to flex form to carry out parsing display.Idiographic flow is:
S1., the record number of Query List every page display is set;
S2. inquiry sql statement is built according to querying condition;
S3. inquire about return data to sql to resolve, encapsulate;
S4. data query is returned to flex;
S5. by flex, data query resolved, show;
S6. " homepage ", " page up ", " lower one page ", " endpage " button data query is clicked;
S7. refresh inquiry list.
In addition, multiple paging query method can also be write according to dissimilar Query List, or Pagination Display not carried out to data query, be unfavorable for that user checks data like this, also likely cause data query very slow, reduce the experience of user.
The beneficial effect that technical solution of the present invention is brought:
Technical solution of the present invention, by encapsulating paging query method, provides interface interchange, is conducive to the reusability improving code, saves the development time, improve development efficiency.The effect of once writing and repeatedly calling can be reached by encapsulation, if other functional module needs the method calling paging query, without the need to rewriteeing the code of paging query, only need calling interface, reach simplified code thus to write, promote the effect of development efficiency.
Accompanying drawing explanation
In order to be illustrated more clearly in the embodiment of the present invention or technical scheme of the prior art, be briefly described to the accompanying drawing used required in embodiment or description of the prior art below, apparently, accompanying drawing in the following describes is only some embodiments of the present invention, for those of ordinary skill in the art, under the prerequisite not paying creative work, other accompanying drawing can also be obtained according to these accompanying drawings.
Fig. 1 is method flow diagram of the present invention.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, be clearly and completely described the technical scheme in the embodiment of the present invention, obviously, described embodiment is only the present invention's part embodiment, instead of whole embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art, not making the every other embodiment obtained under creative work prerequisite, belong to the scope of protection of the invention.
The present invention is the problem in order to solve flex paging query, paging query is used to improve search efficiency at flex, problem is slowly inquired about under solving big data quantity, also be conducive to checking flex data, can be intuitive, clear check total how many data, how many pages altogether, the information such as current page.
Main innovate point of the present invention is to utilize sql paging query to encapsulate data, returns the data layout that flex needs, and transfers to flex form to carry out parsing display.First, the record number of Query List every page display is set, the sql statement of inquiry is built according to Query List, sql paging query is utilized to inquire data count, total how many pages are calculated according to every page of inquiry how many data and the total number of records, the information such as current page, inquire about return data to sql to resolve, be packaged into the data layout that flex needs, PageBean is utilized to encapsulate data, PageBean can process dissimilar data, the data layout changed is put in List, finally return to flex, write corresponding code at flex to resolve inquiring about the data returned, shown by flex Query List again." page up ", " lower one page ", " homepage ", " endpage " button paging query data are provided at the flex page.
Be illustrated in figure 1 method flow diagram of the present invention, its specific implementation step is as follows:
(1) the record number of Query List every page display is set;
(2) inquiry sql statement is built according to querying condition;
(3) inquire about return data to sql to resolve, encapsulate;
(4) data query is returned to flex;
(5) by flex, data query resolved, show;
(6) " homepage ", " page up ", " lower one page ", " endpage " button data query is clicked;
(7) refresh inquiry list.
The present invention encapsulates flex paging query code, provides interface to call, and is conducive to the reusability improving code, improves development efficiency.
Multiple paging query method can also be write according to dissimilar Query List, but paging query method not encapsulated, be unfavorable for reusing of code, deepen workload, reduce work efficiency; Or Pagination Display is not carried out to data query, be unfavorable for that user checks data like this, also likely cause data query very slow, reduce the experience of user.
Above a kind of method based on flex paging query that the embodiment of the present invention provides is described in detail, apply specific case herein to set forth principle of the present invention and embodiment, the explanation of above embodiment just understands method of the present invention and core concept thereof for helping; Meanwhile, for one of ordinary skill in the art, according to thought of the present invention, all will change in specific embodiments and applications, in sum, this description should not be construed as limitation of the present invention.
Claims (5)
1. based on a method for flex paging query, it is characterized in that, the method is to utilize sql paging query to encapsulate data, returns the data layout that flex needs, and transfers to flex form to carry out parsing display; Idiographic flow is:
S1., the record number of Query List every page display is set;
S2. inquiry sql statement is built according to querying condition;
S3. inquire about return data to sql to resolve, encapsulate;
S4. data query is returned to flex;
S5. by flex, data query resolved, show;
S6. " homepage ", " page up ", " lower one page ", " endpage " button data query is clicked;
S7. refresh inquiry list.
2. method according to claim 1, is characterized in that, after building sql statement, utilizes sql paging query to inquire data count, calculates total how many pages, current page information according to every page of inquiry how many data and the total number of records.
3. method according to claim 1, is characterized in that, is encapsulated data query by PageBean, is put in List by the data layout changed.
4. method according to claim 1, is characterized in that, can also write multiple paging query method, but not encapsulate paging query method, be unfavorable for reusing of code according to dissimilar Query List, deepens workload, reduces work efficiency.
5. method according to claim 1, is characterized in that, can not also carry out Pagination Display, be unfavorable for that user checks data like this to data query, also likely causes data query very slow, reduces the experience of user.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410513849.9A CN104298731A (en) | 2014-09-29 | 2014-09-29 | Flex-based paged querying method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410513849.9A CN104298731A (en) | 2014-09-29 | 2014-09-29 | Flex-based paged querying method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104298731A true CN104298731A (en) | 2015-01-21 |
Family
ID=52318456
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410513849.9A Pending CN104298731A (en) | 2014-09-29 | 2014-09-29 | Flex-based paged querying method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104298731A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110442406A (en) * | 2018-05-02 | 2019-11-12 | 天津京东深拓机器人科技有限公司 | The method and paging control, electronic equipment of paging control processing data |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20110239106A1 (en) * | 2010-03-25 | 2011-09-29 | Microsoft Corporation | Sequential layout builder |
| CN103279509A (en) * | 2013-05-17 | 2013-09-04 | 北京首钢自动化信息技术有限公司 | Fast inquiring method using dynamic inquiring language |
-
2014
- 2014-09-29 CN CN201410513849.9A patent/CN104298731A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20110239106A1 (en) * | 2010-03-25 | 2011-09-29 | Microsoft Corporation | Sequential layout builder |
| CN103279509A (en) * | 2013-05-17 | 2013-09-04 | 北京首钢自动化信息技术有限公司 | Fast inquiring method using dynamic inquiring language |
Non-Patent Citations (1)
| Title |
|---|
| NIANSHI: "Flex自定义控件——Pagebar分页控件", 《HTTP://NIANSHI.ITEYE.COM/BLOG/846964》 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110442406A (en) * | 2018-05-02 | 2019-11-12 | 天津京东深拓机器人科技有限公司 | The method and paging control, electronic equipment of paging control processing data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11403364B2 (en) | Method and terminal device for extracting web page content | |
| CN102129364B (en) | Method for embedding widget toolbar in application program and rapid widget accessing method | |
| KR102348766B1 (en) | Data processing methods and devices | |
| CN105069132A (en) | Webpage implementation method based on static shell | |
| CN102664925B (en) | A kind of method of displaying searching result and device | |
| CN103530160A (en) | Page loading method and device | |
| US9582588B2 (en) | Methods and systems for providing custom crawl-time metadata | |
| CN102110169A (en) | Mobile terminal network searching method and mobile terminal | |
| CN109960491A (en) | Application program generation method, generating means, electronic equipment and storage medium | |
| CN105630454A (en) | Information display method and terminal equipment | |
| EP2933731A1 (en) | Method for configuring browser bookmarks, device and terminal thereof | |
| CN103577477A (en) | Method and system for displaying browsing history of browser | |
| CN102426612A (en) | Condition object query method and system | |
| CN104809173A (en) | Search result processing method and device | |
| CN105528369A (en) | Webpage transcoding method and device and server | |
| CN102306163A (en) | Dynamic integration technology based on B2B (business to business) platform | |
| CN110020343B (en) | Method and device for determining webpage coding format | |
| CN104298731A (en) | Flex-based paged querying method | |
| CN103150355A (en) | Web page content preview method and device, and equipment | |
| CN105589918A (en) | Method and device for extracting page information | |
| CN103064839A (en) | Portable document format (Pdf) full-text on-line retrieval method | |
| CN105224099A (en) | A kind of searching method based on input method and system thereof | |
| CN104881453A (en) | Method and device for indentifying type of webpage | |
| CN104298723A (en) | Method for achieving page staticizing in website | |
| CN103399746A (en) | Information management system convenient to develop secondarily and development method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20150121 |
|
| WD01 | Invention patent application deemed withdrawn after publication |