How do I put a ResultSet into an Array?

[rastas biggs]

I need to get rows of data from the database and place in an Arraylist.

I'm not sure if an ArrayList is the right choice, I need to get my ArrayList and call the Column names to place the out put in a sorted order to print to a file for another system to process so it is imperative that data is in a specific order.

Can some one point me in the right direction.

RB

[jefff willis]

Storing the output into an array, a list, or a vector is all simple enough, but you should let the DB do the sorting for you.

When you query for the data, use the ORDER BY phrase in your statement

[rastas biggs]

Thanks Jeff, do you have some example code of placing the result set into an array or vector

RB

[jefff willis]

Here is a code snippit:

  
String sql = "SELECT data FROM table ORDER BY whetever ";
 
Vector theData = new Vector();
Statement stmt = theConnection.createStatement();
ResultSet rst  = stmt.executeQuery(sql);
 
while(rst.next())
{
   String someData = rst.getString("someColumnInATable")                                     
   theData.add(someData);
}

This is just rudimentry. modify it to fit your needs.

[rastas biggs]

cool thanks for that

RB

[Tony Morris]

Why do people insist on using Vector still?
It is well out of date - 7 years in fact.

Why oh why oh why?

[Stan James]

If you get multiple columns from your query you'll probably want to make a class that represents one row and put instances of that class into the collection:

Collection theData = new ArrayList(); // no Vectors!
while(rst.next())
{
   MyThing thing = new MyThing();
   thing.setName  = rst.getString("name");
   thing.setSize  = rst.getString("size");
   thing.setColor = rst.getString("color");
   theData.add(thing);
}

If you really need to sort MyThings after the query (I agree with making the database do the sort if at all possible!) look into implementing Comparable in MyThing and using an ordered collection like TreeSet. Holler if that's not enough to go on.