Query database |
ResultSet rx = statement. executeQuery(“select count() from items”) |
Rx.next() |
Recordcount = rx.getInt(1); |
Rx = statement.executeQuery (SELECT image-url, author, price,item-id FROM Items ORDER BYitem-id DESC LIMIT” + StartRow+”,” + PageSize); |
Address of destination page |
Out. Print(“[“); |
For(int c = CounterStart;c<CounterEnd;c++){ |
If(c<MaxPageone) { |
If(c = Pageone) { |
If(c % Pagesize =1) { |
Outtest.print(c); |
}else{ |
Outtest.print(c+”,”); |
} |
} else if (c % Pagesize =1) { |
Outtest.print(“<ahref = TestPage, jsp? Page None=”+c+”> ”+c+”</a>”) |
}else{ |
Outtest.print(“<ahref = TestPage, jsp? Page None=”+c+”> ”+c+”</a>,”); |
} |
}else{ |
If(PageNone<MaxPageone) {/ |
Outtest.print(c); |
Break; |
}else{ |
Outtest.print(“<ahref = TestPage, jsp? Page None=”+c+”> ”+c+”</a>,”); |
Break; |
} |
} |
} |
Outtest.print(“J”); |
Data display codes are as follows. |
<table width = “100%” border = “0” class = “Normal TableOne”> |
<tr> |
<td class = “InternalHder”>Number</td> |
<td class = “InternalHder”>Login name</td> |
<td class = “InternalHder”>Login time</td> |
<tr> |
<% |
Int i =1; |
While (rx.nest()){ |
Int bil = i + (pageNo-1)PageSize; |
%> |
<tr> |
<td class = “Normal TableOne”><% = bil%></td> |
<td class = “Normal TableOne”><% = rx.getstring(1)%></td> |
<td class = “Normal TableOne”><% = rx.getstring(2)%></td> |
<td class = “Normal TableOne”><% = rx.getstring(3)%></td> |
<tr> |
<% |
i++ |
}%> |
</table> |