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 write a code in servlet which retrieve data from the data base like mysql and display the results.at a time it display 15 record.i use link like show next and it display the next 15 records.if i am in a page that display 45-60 records i make a link to backword but it display the intial 15 records.how i make a link that display records from 30-45.means the immediate previous page.what'll be sql query for that.
Your HTML link must contain enough information to tell the servlet which records to start with. Questions about paging through database retrievals are pretty common here, you can probably find more details by searching the older forum records. Bill