getting items stored in a vector?

[rich werth]

I have a vector in which i'm storing a resultSet. Each Element of the resultSet is one row from a db. I need to get the items out of the vector one at a time and place them in a form somewhere.
My problem is I can't seem to figure out how to get the items out of the vector one at a time and place them where they need to go.
This is what I have so far.
try {
ResultSetMetaData rmeta = rsGl.getMetaData();
columns = rmeta.getColumnCount();
colnames = new Vector();
for (int i = 1; i <= columns; ++i) {
colnames.addElement(rmeta.getColumnLabel(i));
}
rows = new Vector();
rows.addElement(colnames);
rowcount = 0;
while (rsGl.next()) {
rowcount = rowcount + 1;
Vector newRow = new Vector();
for (int j = 1; j <= columns; j++) {
value = rsGl.getObject(j);
newRow.addElement(value);
}
rows.addElement(newRow);
}
System.out.println("Capacity " + rows.capacity());
for(int i = 0; i < 25; ++i) {
System.out.println("Vector Item at " + i + ": " + rows.elementAt(i));
}
Iterator vItr = rows.iterator();
while(vItr.hasNext())
System.out.println(vItr.next() + " ");
}
Can anyone point me in the right direction please.....
Thanks

[Greg Brouelette]

(I didn't see what type of object "value" was, so I'll just assume it's of a class called "Value"
Use nested loops to walk through the rows.

// THis loop walks thorugh the rows
for(int i = 0; i < rows.size(); i++) {
   Vector oneRow = (Vector)rows.elementAt(i);
   // This loop is walking through each item within a single row
   for(int j = 0; j < oneRow.size(); j++){
      // Let's get the objects
      Value v = (Value)oneRow.elementAt(j);
      // Here's the point where you put the "v" object 
      // wherever you want it.
   }
}

[Gerry Giese]

A better implementation is to store a ResultSet row in a Hashtable, then store the row in the Vector, and use Enumerations to get the stuff back out. For example:

Vector    rows     = new Vector();
Hashtable row      = null;
try
{
ResultSetMetaData rmeta = rsGl.getMetaData();
    int columns = rmeta.getColumnCount();
while( rsGl.next() )
{            
row = new Hashtable();
for( int i = 1; i <= columns; i++ ) {
row.put( rmeta.getColumnLabel(i),
rsGl.getObject( rmeta.getColumnLabel(i) ) );
}

rows.add( row );
}
}
catch( SQLException sqe ) { System.out.println( "oops" ); }
            
Enumeration rowElements = rows.elements();
while( rowElements.hasMoreElements() ) {
Hashtable row = (Hashtable) e.nextElement();

Enumeration colNames = row.keys();

String colName = null;

while( colNames.hasMoreElements() ) {
colName = e.nextElement();

System.out.println( colName + " = [" + 
row.get( colName ) + "]" );
}
}

This won't likely compile, but you should catch my drift. Let us know what you end up with.