File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Assigning values from ResultSet to objects Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Customer Requirements for Developers this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Assigning values from ResultSet to objects" Watch "Assigning values from ResultSet to objects" New topic

Assigning values from ResultSet to objects

pramod talekar
Ranch Hand

Joined: Apr 26, 2010
Posts: 323


Could you please tell me how to assign values from ResultSet to objects.

Suppose I have an Employee class with a String name as instance variable and setName() setter method.
And I have a table company which has a column named 'EmployeeName'

When ResultSet returns the values.
So, how to assign the EmployeeName data to new Employee().name ?

Campbell Ritchie

Joined: Oct 13, 2005
Posts: 43423
Isn’t it something like String employeeName = rs.getString(...);
There is a page in the Java Tutorials (about 6 lines down) about result sets.
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: Assigning values from ResultSet to objects
It's not a secret anymore!