Is there any way to cast a JDBC ReultSet to an ArrayList of Strings
(or another type of DTO) with a single assignment statement?

Otherwise I end up iterating through the ResultSet twice - once on the
server to assign its values to an ArrayList of DTOs - and once after
its returned to the client in order to display the results. I'd rather
just assign (cast) the resultSet to the ArrayList and return it. For
example:

Rather than do this on the server:

resultSet = statement.executeQuery("SELECT first_name from
Employees");
while (resultSet.next()) {
   arrayList.add(resultSet.getString("first_name")); //Loops through
over a hundred records
}
return arrayList;


It would be nice to simply do this:

resultSet = statement.executeQuery("SELECT first_name from
Employees");
arrayList = (ArrayList<Names>) resultSet; //Assign the entire
resultSet to the ArrayList
return arrayList;

Is this (or something similar) possible?

Thanks in advance,
-Russ
-- 
You received this message because you are subscribed to the Google Groups 
"Google Web Toolkit" group.
To post to this group, send email to google-web-tool...@googlegroups.com.
To unsubscribe from this group, send email to 
google-web-toolkit+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-web-toolkit?hl=en.


Reply via email to