how to page though DB table with JTable?

[robert walker]

Hi all, is there a general technique for
retreiving say 500 rows at a time from a DB table and displaying it in
a JTable, I am wondering if I have to write this myself.

The DB table will prob have way to many to ull back in one hit to the
client.

I supposed I could keep track of the current index that the GUI is on,
then when the user clicks "next" button, do the sql again and then do
a
resultSet.next() a bunch of times to skip to the next block rows I
wish to retrieve.

any free utils that can help with this or is this the general free way
to accomplish this issue.

thanks