How can I create an array from a recordset?

[Gaz1634]

Hi,

Can anyone advice me how to move the contents of a recordset into an array.

I am trying to move the data into an array of objects, Customers to be specific. I have created the Customers class and that works, and can pull the contents off of the oracle DB into a recordset, but cant move it to an array. Can anyone help?

 

[thekobbler]

So.. you can create a "Customer" instance for each entry in the recordset, and add this to an ArrayList. An ArrayList is more flexible than an array, but you can convert the ArrayList to an array of Objects (i.e. Customer[]) by using

ArrayList customerList = new ArrayList;

for each element in record set, create a Customer.
{
customerList.add(customer);
}

Customer[] array = (Customer[])customerList.toArray(new Customer[]{});