13
Dec

Here i’m going to write, how to do pagination in Java. The situation is first count how many rows in the database table, then query the database by page size (how many rows you want to display on a web page).

In Jsp

String pno=request.getParameter("pno"); // this will be coming from url
int pageno=0;
if(pno==null)
{
pageno=1;
}
else
{
pageno=Integer.parseInt(pno);
}
int next=pageno+1;
int previous=pageno-1;

//Java method
ArrayList al=object.getData(pageno);

// do all your showing data logic here

//print the previous and next links
if(previous!=0){
Previous link (url.jsp?pno=previous)
}

int max=obj.getTotalRows(); // total number of rows from database table

int check=(next-1)*10; // each page 10 rows

if(check<max){ // print next link if check is less than total rows
Next link (url.jsp?pno=next)
}

In Java

//for getting the data according to page number
public ArrayList getData(int pagenumber)
{
ArrayList al=new ArrayList();
int offset = (pagenumber – 1) * 10;

//write all the logic and query data with the limit offset

Query + limit offset ,10;

return al;
}

//for getting total rows

public int getTotalRows() {
//write your logic to get total count of the rows
Query total rows from db table

return total_rows;
}

Post to Twitter Post to Yahoo Buzz Post to Delicious Post to Digg Post to Reddit Post to StumbleUpon

Share or Bookmark This Post With :

4 Comments
Rajkumar Posted On November 3rd, 2008

Hi dude, i need the complete code … I use JSP/Servlet to do pagination and MySQL as my backend… Please help me regarding this….

vima Posted On December 6th, 2008

Nothing happend

zaryaar Posted On June 16th, 2009

pno is undefined whats that is that a hidden feild how will the value of pno change?????such that the page number changes……can u please give the complete code

javatechie Posted On June 17th, 2009

Hello zaryaar,

Here pno is not a hidden field, but the page number attached to the URL
eg. url.jsp?pno=1, so u will get the pno from request.getParameter

I hope this may help you.

Leave a Reply

Subscribe to RSS Feeds Follow me on Twitter Add to Favourite
 
Sponsors
 
Tags
 
Network [+]
 
© Copyright 2009 - 2011 TechiePark.com. All Rights Reserved | Powered by WordPress
This work is licensed under a Creative Commons Attribution 3.0 Unported License
Php5 powered    Mysql powered    Apache powered   Best viewed with  Spread Firefox Affiliate Button