Display database results across multiple pages..

[abhijeet_pcl]

Hi all,

I have database results in resultset object. I want to display it across multiple pages( say 10 results on a page) with the next and previous options and page number option as we see in google.

what is the solution??

[t_mohan]

Hi Abhijeet, Assume that u have all the data in an
Arraylist, Each object representing a row in the table,Please try to understand the code and let me know your questions

% ArrayList frmEmpList = new ArrayList();
if(session.getAttribute("frmEmpList")!=null)
{
frmEmpList = (ArrayList)session.getAttribute("frmEmpList");
}
int noOfPages = 0;
int remainder = 0;
int noOfRequests = 0;
if(frmEmpList!=null)
{
noOfRequests = frmEmpList.size();
remainder = frmEmpList.size()%10;
noOfPages = frmEmpList.size()/10;
if(remainder!=0)
noOfPages = noOfPages + 1;
}
int currentPage = 1;
String currentPageStr = request.getParameter("currentPage");
if(currentPageStr!=null)
currentPage =Integer.parseInt(currentPageStr);
%
head
script language="javascript"
function getNextOrPrevDetails(url)
{
window.location.href = url;
}
/script
/head
--YOUR STATIC HEADINGS LIKE EMPNO,EMPNAME,EMPEMAIL DOJ ETC in column format--
%
String empNo = "&nbsp";
String empName = "&nbsp";
String empEmail = "&nbsp";
String doj = "&nbsp";
int n=currentPage;
int startPoint = 0;
if(frmEmpList!=null && frmEmpList.size()>0)
{
if( (currentPage == n)&&(frmEmpList.size()==((n-1)*10)))
{
currentPage=(n-1);
}
if(currentPage!=1)
startPoint = (currentPage-1)*10;
if(((frmEmpList.size())-(startPoint))==0 )
{ currentPage=currentPage-1;
}
EmployeeDetailsObject empObj = null;
for (int i=startPoint,count=0;i empObj = (EmployeeDetailsObject)frmEmpList.get(i);
empNo = empObj.getEmpno();
empName = empObj.getEname();
empEmail = empObj.getEmail();
doj = empObj.getDoj();
count ++; %>
---Place ur UR DYNAMIC CONTENT HERE in TR and TD -----
%} } %
%if(currentPage!=1)
{% Previous
%} else {%> Previous
%} if(noOfPages==0)
currentPage=0;
%  |  Page%=currentPage% of %=noOfPages%
 | 
% String pageno=String.valueOf(currentPage);
session.setAttribute("PAGE",pageno);
if(currentPage < noOfPages) {%>
a href="javascript:getNextOrPrevDetails('employeeGrid.do?currentPage=%=(currentPage+1)%')">Next/a
%} else { %
Next %}
%

Where ever u find a % , it means it is a scriptlet in the JSP , replace the percentage with the scriptlet tag.

Its a huge logic ,try to understand, pls let me know your questions

Thank You