SQL Server into Java array

[ck9663]

Hi guys, CK here from SQL Server forum.

Is there a function that will automatically populate a two-dimensional array coming from a SQL Server table? Or should I do it the old fashion "WHILE NOT EOF" way? Am not much of a java programmer but I need this one.

I can connect to my sql server and query the table. I just need to know how to place it to an array.

Can anyone give me a sample code or some links?

Thanks

-- CK

[BigDaddyLH]

If you are coding this just using JDBC you do the following:

1. Define a specific class to represent one row of data. In my example, this is BusinessObject.
2. Store the data in a list rather than an array, because you don't know ahead of time how many rows are in your result.

Example:

ResultSet rs = ...
try {
    List<BusinessObject> result = new ArrayList<BusinessObject>();
    while (rs.next()) {
        BusinessObject row = new BusinessObject();
        //populate row with data from rs
        result.add(row);
    }
    return result;
} finally {
    yourCloseMethod(rs);
}