Search...
FAQs
Subscribe
Pie
FAQs
Recent topics
Flagged topics
Hot topics
Best topics
Search...
Search within JSP
Search Coderanch
Advance search
Google search
Register / Login
Win a copy of
Cloud Application Architecture Patterns: Designing, Building, and Modernizing for the Cloud
this week in the
Cloud/Virtualization
forum!
Bookmark Topic
Watch Topic
New Topic
programming forums
Java
Mobile
Certification
Databases
Caching
Books
Engineering
Micro Controllers
OS
Languages
Paradigms
IDEs
Build Tools
Frameworks
Application Servers
Open Source
This Site
Careers
Other
Pie Elite
all forums
this forum made possible by our volunteer staff, including ...
Marshals:
Campbell Ritchie
Tim Cooke
paul wheaton
Paul Clapham
Ron McLeod
Sheriffs:
Jeanne Boyarsky
Liutauras Vilda
Saloon Keepers:
Tim Holloway
Carey Brown
Roland Mueller
Piet Souris
Bartenders:
Forum:
JSP
JSP table pagination is not working
Mahmood Ali
Greenhorn
Posts: 16
posted 14 years ago
Number of slices to send:
Optional 'thank-you' note:
Send
Hello All,
I am having a
jsp
which is listing more than 30records. I would like to have a page pagination to the table, But it is showing the correct results. Can you pleaSE HELP
<html> <head> </head> <body> <form name ="form" action="Report1.jsp" method="post" > <%! int numPages = 0; %> <% String columnName = ""; int count = 0; int totalCols = 0; int increment = 1; int numRows = 0; String startIndexString = request.getParameter("startIndex"); if(startIndexString == null) { startIndexString = "1"; } int startIndex = Integer.parseInt(startIndexString); try{ totalCols = 3; %> <table border="1" width="84%" align="center" bgcolor=#66CCFF bordercolor=#000000 height="137"> <tr> <div id="container"> <td colspan="7" height="65"> <p align="center"><b>Customer Information Request Form</b></td> </tr> <tr> <td colspan="2" height="33"> <p align="center"> <span style="font-size: 8pt; font-weight:700">CIR_ID</span></td> <td height="33"> <span style="font-size: 8pt; font-weight:700">Bank Name</span></td> <td height="33" width="26%"> <span style="font-size: 8pt; font-weight: 700">Request From</span></td> <td height="33" width="18%" colspan="3"> <span style="font-weight: 700; font-size: 8pt">Created</span><span style="font-size: 8pt; font-weight: 700"> Date</span></td> </tr> <% for(int j=0; j<=totalCols && rs.next(); j++) { %> <tr bgcolor="#FFFFFF" onMouseOver="this.bgColor='gold';" onMouseOut="this.bgColor='#FFFFFF';"> <td width="3%"><span style="font-size: 8pt"><%=j=j+1%></span></td> <td width="10%"><span style="font-size: 8pt"> <a href="cir_view.jsp?cir_id=<%=rs.getString("cir_id")%>" Title="View" onClick="return popup(this, 'Report')"> <%=rs.getString("cir_id")%> </a> </span> </td> <td width="39%" ><span style="font-size: 8pt"><%=rs.getString("institution_name")%></span></td> <td width="26%" align="left"><span style="font-size: 8pt"><%=rs.getString("requester")%></span></td> <td width="10%" align="left"><span style="font-size: 8pt"> <%=rs.getString("created_date")%></span></td> <td width="3%" align="left"><a href="cir_delete.jsp?cir_id=<%=rs.getString("cir_id")%>" class="ask" onclick="target='_blank';"> <IMG SRC="12.png" ALT="Delete" BORDER="0" ></a></td> <td width="3%" align="left"><a href="cir_update.jsp?cir_id=<%=rs.getString("cir_id")%>" onClick="return popup(this, 'Report')"><IMG SRC="28.png" ALT="Edit" BORDER="0"></a></td> </div> </tr> <% } List list = new ArrayList(); for( int i=0 ; i<100 ; i++){ list.add("item"+i); } numRows = list.size(); out.println(" total no. of records : "+ numRows ); int numRecordsPerPage = 5; out.println(" Num of Records per page : " + numRecordsPerPage + "\n" ); numPages = numRows /numRecordsPerPage ; int remain = numRows % numRecordsPerPage ; if(remain != 0){ numPages = numPages +1 ; } out.println(" \n no. of pages : " + numPages ); if((startIndex + numRecordsPerPage) <= numRows) { increment = startIndex + numRecordsPerPage ; } else{ if (remain == 0){ increment = startIndex + numRecordsPerPage ; }else{ increment = startIndex + remain; } } for(count = startIndex; count < increment; count++) { %><tr><% for(int i=1; i<=totalCols; i++) { %><td><% out.println(list.get(count-1)); %></td><% } %></tr><% } %> </td> </table> Displaying Records: <% if(startIndex + numRecordsPerPage < numRows){%> <%= " " + startIndex %> - <%= increment - 1 %> <%}else{%> <%= " " + startIndex %> - <%= numRows %> <%}%> <%if(startIndex != 1) {%> <a href="Report1.jsp?startIndex=<%=startIndex-numRecordsPerPage%>">Previous</a> <%}%> <%increment += numRecordsPerPage ;%> <%if(startIndex + numRecordsPerPage <= numRows){%> <a href="Report1.jsp?startIndex=<%=startIndex+numRecordsPerPage %>">Next</a> <%}%> </tr> <% }catch(Exception exc){ out.println(exc.toString()); } // end try-catch %> <p> </p> </form> </body> <% conn.close(); rs.close(); %> </html>
Bear Bibeault
Sheriff
Posts: 67756
173
I like...
posted 14 years ago
Number of slices to send:
Optional 'thank-you' note:
Send
See the JSP FAQ. Always check the FAQ before posting. Thanks.
[
Asking smart questions
] [
About Bear
] [
Books by Bear
]
Don't get me started about those stupid
light bulbs
.
Bookmark Topic
Watch Topic
New Topic
Boost this thread!
Similar Threads
Access Data from Database By Submitting The select Values
The program error!
Please help with pagination in JSP?
Pagination in Servlets from a Resultset
no error message display for invalid user and password authentication
More...