Controling the size of resultset

I want to control the size of result set. For example my query fetches 1500 hundred records. and I want first 300 records in the resultset. After processing the firs 300 records, I want the next 300 records and so on. How can I do this. Please help.
Please help with some code snippets.

Thanks

Courage is not having the strenth to go on
It's the going on without having the strength.

i think you should do it by putting some logic in your code.

its sounds like paging. so, i suggest you to go for paging some mechanism. you can find many threads here discussing paging stuff. you will find those threads in jsp forum most probably.