Either ResultSet or a specific object?

[saul_2110]

Hello. I have this doubt... When querying a DB through JDBC, should I take the data directly from the ResultSet and into the GUI or should I create an object, fill that object with the data from the ResultSet and then use the object to fill the GUI.

Which would be the criteria to choose from one or the other approach?

Thanks a lot.

[masijade]

A ResultSet should not live beyond the retrieval from the DB and all DB resources should be closed ASAP. Now, knowing this, which is better?

[saul_2110]

Stated that (masijade's reply), I suppose copying the data from the ResultSet to a specific object (please correct me if I am wrong).

About closing all DB resourses ASAP after DB retrieval... does that include the Connection and Statement objects?

[masijade]

The statement definately, and if you are using a pool, the connection as well.