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.
How do you limit the display of only a certain amount of records from a database on one html/jsp page. I want to retrieve all records relative to my particular search, but I only want to display the most recent 10 items on one page, and make some sort of 1,2,3 counter - each number a link, to other pages which will display the previous 10 records and so on...1,2,3 links relative to how many records in database? I have an auto-increment table so I guess this will determine which are most recent or not, but how would I go about implementing my problem here? Im working on a jsp app, so that is the reason I have posted this subject here, wasn't sure what forum it would belong.