Dear Experts
I am looping thru a Result Set from a SQL-Query using the 'while' statement. This is result set is "forward-only", which means can't call the 'first' method to loop it again. Actually I don't want to loop it twice anyway for performance reasons.
Instead my idea is to copy the values into a collection or multi-dimensional array and then scan this list twice to build my final result. (which is a string)
My idea was to use a nested class, but I got a compilation error. In C# one might use a 'struct' to get this done.
What's the deal in Java?
I'd ideally create something like
public class CodeInfo (...3 properties) and then pass that to an arrayList to iterate it...but haven't got it done myself...
Thanks
Roger