java分页方法（Java paging method）.doc

java分页方法（Java paging method） A simple JAVA paging method Define two Vector, one for storing all the records of the query totalV, and the other store the current page of the record currentPageV; Total number of records: int totalSize = totalV.getSize (); The number of records displayed per page: int countPerPage; Total number of pages: int, totalPageNum = totalSize/countPerPage; / / if the remainder the total number of records and record the number of each page is greater than zero, Then the total number of pages / / for their results with a divisible If (totalSize%countPerPage 0) { TotalPageNum = totalSize/countPerPage + 1; } Current page number: pageNum; For (int, j = 0; jtotalV.size (); j++) { / / paging, according to the number of records the current page number and page display remove records from the totalV / / add records to the currentPageV; If the current record in the (/ / -1 page shows the current page number) * number of records (including equal) Each page shows the current page number * / / and the number of records (not equal) between the time; / / belong to the pages of data. If ((J = (pageNum - 1) * countPerPage (pageNum) J * countPerPage)) { CurrentPageV.addElement (totalV.get (J)); } When the currentPageV / number is equal to the number of records per page records, Stop / / add to the currentPageV record (if) (currentPageV.size = = countPerPage) { Break; } } The record shown in the current page, then, is the record in currentPageV. Second paging The use of paging functionality is unavoidable in the use of databases, but the JDBC specification does not work well. For this demand, many friends have their own solutions, such as the use of Vector and other collection classes, first save the data out, and then paging. But this approach is poorly available, completely different from the interface of JDBC itself and not supported by different types of fields. Here is a very good solution for compatibility with JDBC. JDBC and paging The Sun JDBC specif