How to put a list of data retrieve from database into arraylist

[jay lai]

Hello,
I am writing a class that invoke a storeprocedure return multiple reccords from database.
While (rs.next())
{
string test1=rs.getString("testValueFromDB");
string test2=rs.getString("test2ValueFromDB");
string test3=rs.getString("test3ValueFromDB");
}
What do I do to put this resultset into an array and loope through it?
Any hints or suggestion is greatly appreciated.

[Nadeem Awad]

Originally posted by jamie lee:

What do I do to put this resultset into an array and loope through it?
Any hints or suggestion is greatly appreciated.

I think the best way is to wrap the String values in one object for each row, and then add the objects to the ArrayList. Something like this:

ArrayList result = new ArrayList();
while (rs.next()) {
string test1=rs.getString("testValueFromDB");
string test2=rs.getString("test2ValueFromDB");
string test3=rs.getString("test3ValueFromDB");
 
MyValueObject row = new MyValueObject();
row.setTest1(test1);
row.setTest2(test2);
row.setTest3(test3);
result.add(row);
}

Best regards,

[Scott Selikoff]

I agreed with Nadeem's solution, except the creation of a "MyValueObject" really depends on how frequently you need this object. Its it of a very temporary nature and you know the number of columns returned by the query, I suggest a typed array such as:

ArrayList result = new ArrayList();
while (rs.next()) {
String row = new String[3];
row[0]=rs.getString("testValueFromDB");
row[1]=rs.getString("testValueFromDB");
row[2]=rs.getString("testValueFromDB");
result.add(row);
}

This is just from my experiences in practice, only create a new class if it is appropriate to do so. It depends on a number of other factors though.

[jay lai]

Thanks Both,
I am going to try out.
Best Regards