Pagination

[maganti suryanarayana]

How to do pagination in JSP ?

[J. Kevin Robbins]

That's not much information to go on, but I'll take a guess that you want to display a table and limit the number of rows on the page. I've used JQuery and DataTables for this.

Can you tell us more about what you are trying to accomplish and what you've tried so far? Is using JavaScript an option or do you need to do it all server-side?

[maganti suryanarayana]

Thanks Robbins. I want to know how to do it in javascript. I am using Mysql as database, Struts as UI.

[J. Kevin Robbins]

Start by looking at this jQuery plugin http://datatables.net/. There are lots of examples and decent support in the forums. Make your best attempt at it and when you run into problems come back here and post your code and explain the problem clearly.

You need to understand that nobody here is going to write the code for you. We're glad to help out, but only if you show some effort.

[jhon masco]

maganti suryanarayana wrote:How to do pagination in JSP ?

HI
Here a nice example. Without frameworks or Scripts.

[Bear Bibeault]

jhon masco wrote:
Here a nice example. Without frameworks or Scripts.

Nice example? It's horrible! It violates every good practice known to mankind.

[Koen Aerts]

Bear Bibeault wrote:

jhon masco wrote:
Here a nice example. Without frameworks or Scripts.

Nice example? It's horrible! It violates every good practice known to mankind.

It's like watching a horror movie

[Senthil Manoharan]

You can try Yahoo UI pagination....

[Sabarish Venkat]

hi maganti,

here is a set of codes for you try to add your own codes inside it along with the code

   
public int nullIntconv(String str) 
  {
    int conv = 0;
    if (str == null)
     {
      str = "0";
     }
    else if ((str.trim()).equals("null"))
     {
      str = "0";
     }
    else if (str.equals(""))
     {
      str = "0";
     }
      
   try {
        conv = Integer.parseInt(str);
       }
   catch (Exception e) {
       }
       
   return conv;
 }




// Your DB Connection here...

            ResultSet rsPagination = null;
            ResultSet rsRowCnt = null;

            PreparedStatement psPagination = null;
            PreparedStatement psRowCnt = null;
            
            int iShowRows = 10;  // Number of records show on per page
            int iTotalSearchRecords = 10;  // Number of pages index shown

            int iTotalRows = nullIntconv(request.getParameter("iTotalRows"));
            int iTotalPages = nullIntconv(request.getParameter("iTotalPages"));
            int iPageNo = nullIntconv(request.getParameter("iPageNo"));
            int cPageNo = nullIntconv(request.getParameter("cPageNo"));

            int iStartResultNo = 0;
            int iEndResultNo = 0;

            if (iPageNo == 0) {
                iPageNo = 0;
            } else {
                iPageNo = Math.abs((iPageNo - 1) * iShowRows);
            }


//add your query and the pageno and how many rows to show like this

           String sqlPagination = "Your query here "+ " limit " + iPageNo + "," + iShowRows + "";
           psPagination = conn.prepareStatement(sqlPagination);
           rsPagination = psPagination.executeQuery();	
  
// this will count total number of rows
          
           String sqlRowCnt = "SELECT FOUND_ROWS() as cnt";
           psRowCnt = conn.prepareStatement(sqlRowCnt);
           rsRowCnt = psRowCnt.executeQuery();
           if (rsRowCnt.next()) {
                iTotalRows = rsRowCnt.getInt("cnt");
            }


//// calculate next record start record  and end record
            
           try {
                if (iTotalRows < (iPageNo + iShowRows)) {
                    iEndResultNo = iTotalRows;
                } else {
                    iEndResultNo = (iPageNo + iShowRows);
                }

                iStartResultNo = (iPageNo + 1);
                iTotalPages = ((int) (Math.ceil((double) iTotalRows / iShowRows)));

            } catch (Exception e) {
                e.printStackTrace();
            }



//// index of pages

            int i = 0;
            int cPage = 0;
            if (iTotalRows != 0) {
                cPage = ((int) (Math.ceil((double) iEndResultNo / (iTotalSearchRecords * iShowRows))));

                int prePageNo = (cPage * iTotalSearchRecords) - ((iTotalSearchRecords - 1) + iTotalSearchRecords);
                if ((cPage * iTotalSearchRecords) - (iTotalSearchRecords) > 0) {
       
        <a href="Your_link.jsp?iPageNo="+prePageNo+" &cPageNo= "+prePageNo+""> << Previous</a>
        
                }

                for (i = ((cPage * iTotalSearchRecords) - (iTotalSearchRecords - 1)); i <= (cPage * iTotalSearchRecords); i++) {
                    if (i == ((iPageNo / iShowRows) + 1)) {
      
        <a href="Your_link.jsp?iPageNo="+i+" style='cursor:pointer;color: red'"><b>+i+</b></a>
       
                    } else if (i <= iTotalPages) {
      
        <a href="Your_link.jsp?iPageNo="+i+"">+i+</a>
       
                    }
                }
                if (iTotalPages > iTotalSearchRecords && i < iTotalPages) {
      
        <a href="Your_link.jsp?iPageNo="+i+"&cPageNo="+i+"> >> Next</a>
      
                }
            }
  
   

[jhon masco]

Nice example? It's horrible! It violates every good practice known to mankind.

It like me because tell with details how pagination works.
I guess all the scripts and frameworks use the same metodology.
I suppose he know that he can not work with databases inside JSP pages.!!! I just wanted to show the methodology.

Salutes

[Bear Bibeault]

jhon masco wrote:I just wanted to show the methodology.

But the shown methodology is horrible and should not be followed.

[jhon masco]

Bear Bibeault wrote:

jhon masco wrote:I just wanted to show the methodology.

But the shown methodology is horrible and should not be followed.

That means than not exist a way without script or frameworks??? Why this methodology is wrong???
I am curious!!!

PD: I was looking the Sabi Swa's code and it follow this methodology.!

Thanks

[Tim Moores]

I got one word for ya: DisplayTag

[Bear Bibeault]

jhon masco wrote:Why this methodology is wrong?

Because it uses many poor practices. Not only does it use scriptlets and Java code in a JSP, it actually performs the DB access in the JSP! This is an egregious violation of everything that is considered a good practice.

[jhon masco]

Because it uses many poor practices. Not only does it use scriptlets and Java code in a JSP, it actually performs the DB access in the JSP! This is an egregious violation of everything that is considered a good practice.

Yes, i know that!!!
I just want show how is the process.
Then i dont must say "methodology" , i must say "algorithm".

[Bear Bibeault]

You're missing the point. Showing how to do it wrong is not helpful. It just makes people think that that's a good way of doing it when it's not. It's like teaching someone to cook something and saying "Here's the wrong way of doing it. Now figure out on your own what the right way is".