This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
I have a jsp page, where-in I simply retrieve rows from a table.
Now i want to display the results page-wise (20 results each)
something similar to google.
What are the best practices for accomplishing such tasks.
I am using MySQL 5.0 ( so database specific solutions are also welcome)
My tables would not always have ID numbers in serial order , so using them as a reference number will be waste