I have an application that is currently working in returning data from an oracle database. The place where I am getting stuck is display the next set of a resultset with the click of a JButton called "Next" The resultset returns 15 line items, based on a variable that I pass to it from the swing application. some have 3 sets of 15 line items. Here is the code I have in place so far, any help or thoughts would be much appreciated.
That depends on the DB in question. Basically you need to invoke a SQL query which returns only an ordered subset of rows from the database. For the ordering you can use the standard ORDER BY clause and for returning subsets you need to consult the SQL documentation of the DB in question. Mostly it's the LIMIT and/or OFFSET clause, but for some DB's you need to write a stored procedure.