This week's book giveaway is in the OCAJP forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide 1Z0-808 and have Jeanne Boyarsky & Scott Selikoff on-line! See this thread for details.
Originally posted by vinod kumar Bongurala: Thanks Jai for providing some information on limiting the rows from database. But i am looking for more in depth concept of Pagination, where it will be implemented in complex projects.
In complex projects, pagination wouldn't be handled in a JSP. JSP would only be used for marking up the output (view code).
The information in that FAQ entry does't just pertain to limiting rows. The sample code shows how to get the database to return pages of rows for a given query. This is the most common way of implementing paging in a Java Web App.