Re: Populating an array with a Result Set Possible???

Hi Tom,
            I think, your facing this problem only because you don't know 
the number of records present in the ResultSet, am i right.
            Are you using JDBC 2 API, then it is very easy to solve this 
problem. After getting the ResultSet,
    1) Use     boolean is_true = resultset.last(); this will set the pointer 
in the last record of your ResultSet.
    2) Use     int no_of_records = resultset.getRow(); this will return the 
current record number, ie last record number. So you can get the number of 
records present in the result set.
            Using this you can easily create the Array, if you want you can 
get the column count, ie number of fields present in each record of the 
Resultset.
       ResultSetMetaData rsmd = resultset.getMetaData();
       int column_count = rsmd.getColumnCount();
           Now you got all the two values required to create the array. I 
belive this will help you. Please give your feed back, so that i could 
correct myself, if i did any mistake.

Regards,
Vijay.


>From: tmalin@hannasteel.com
>Reply-To: JAVA400-L@midrange.com
>To: "'JAVA400-L@midrange.com'" <JAVA400-L@midrange.com>
>Subject: Populating an array with a Result Set Possible???
>Date: Thu, 27 Jul 2000 15:29:22 -0500
>
>I am trying to populate an array with a ResultSet is this possible??
>
>
>(obviously this will not work)!!!!~~
>stmt = conn.createStatement(); // Execute the query
>           rs = stmt.executeQuery(sqlString);
>           while (rs.next())
>                {
>         String[][] data = new String[][] {
>                                 String MCLOT = rs.getString(1);
>                                 String MCITEM = rs.getString(2);
>                                 String MCGAGE = rs.getString(3);
>                                                 };
>                         }// endof while loop
>Any help would be greatly appreciated!
>
>Tom
>
>
>
>
>+---
>| This is the JAVA/400 Mailing List!
>| To submit a new message, send your mail to JAVA400-L@midrange.com.
>| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
>| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner: joe@zappie.net
>+---

________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---