hi all ranchers.. recently in an interview i faced a question for to achieving pagination. how can this be done using jsp's and jdbc. suppose there 1000 records in the DB.i have to show them to the user 100 records per page, and use next buttons on the page. how can this be done? in a simple way..