ResultSet

[lape show]

Please how can i get the number of rows returned by a resultset. i need to pass data retrieved from SQL into an array then to the table model and finally to the jtable, but i need to know the size of the array.

[Brian Enochson]

This has been covered. http://www.coderanch.com/t/303346/JDBC/java/find-number-rows-resultset.

What you can also do is a select count with an identical where clause to your where used for the actual select?

Lastly, instead of using an array where you need to allocate it, add your results from your result set to an ArrayList as it will grow dynamically.

Brian

[Campbell Ritchie]

. . . and welcome to the Ranch, both of you

[lape show]

Thanks a bunch!!!

[Brian Enochson]

Thank you.