aspose file tools*
The moose likes Other Application Frameworks and the fly likes How to do database pagination using JSTL tags Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Frameworks » Other Application Frameworks
Bookmark "How to do database pagination using JSTL tags" Watch "How to do database pagination using JSTL tags" New topic
Author

How to do database pagination using JSTL tags

Pooja Chetty
Greenhorn

Joined: Aug 01, 2006
Posts: 13
I need to do Pagination from databse perspective. I am using Spring Framework with Jstl tags in the view.

Can any one suggest how to do that. I am using normal DAO class for JDBC connectivity so i dont want Hibernet or JSF to be used.

I need the solution as soon as possible
Chengwei Lee
Ranch Hand

Joined: Apr 02, 2004
Posts: 884
Depending on the database that you're doing, the method may differ. If you're using Oracle, you could go to Ask Tom and query on pagination. You would find what you need.

As for the custom tags, you could do a search at sourceforge.



SCJP 1.4 * SCWCD 1.4 * SCBCD 1.3 * SCJA 1.0 * TOGAF 8
sachin yadav
Ranch Hand

Joined: Nov 24, 2005
Posts: 156
Here goews the code.......



Now the database itteration where you wana apply pagination :



This logic will generate page numbers in the bottom.




I hope this will be usefull.
Pooja Chetty
Greenhorn

Joined: Aug 01, 2006
Posts: 13
Thanks for the reply sachin,

The problem is i am giving the query in the JSP. I am giving in the DAOImpl Class. In that how should i customise the code given by you.

Pooja
 
 
subject: How to do database pagination using JSTL tags