Function realization decomposition

1. Number of calculation results

rs.last();

int size = rs.getRow();

You can get the number of results .

2. It needs to be divided into several pages

If a page can be put 5 Bar record , be

int pageCount = (size%5==0)?(size/5):(size/5+1);

You can get it. You need to divide it into several pages .

3. Control the number of display records specified in one page

If a page can show 5 Bar record , By using count Count .

int count = 0;

do{

if(count>=5) break;

.....

count++;

}while(rs.next());

adopt break sentence , It can make it jump out when it exceeds the specified entry .

4. How to know the current page

adopt HTTP get Characteristics , Indicate the current address in the address bar , Such as http://.......?curPage=1  It means now is the first page .

String tmp = request.getParameter("curPage");
if(tmp==null){
tmp="1";
}
curPage = Integer.parseInt(tmp);

You can get the current page .

rs.absolute((curPage-1)*PAGESIZE+1); 

Adjust the result set pointer to the beginning of the record that should be displayed on the current page .

For example, if a page shows 5 Bar record , The current page is the second , You need to adjust the pointer to 6, The current page is the third , You need to adjust the pointer to 11.

5. Click home 、 The previous page 、 The next page 、 Behavior of the last page

<a href="multipage.jsp?curPage=<%curPage+1%>" > The next page </a>

<a href="multipage.jsp?curPage=<%curPage-1%>" > The previous page </a>

<a href="multipage.jsp?curPage=<%pageCount%>" > Tail page </a>

<a href="multipage.jsp?curPage=1" > home page </a>