aspose file tools
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
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Assigning values from ResultSet to objects" Watch "Assigning values from ResultSet to objects" New topic
Author

Assigning values from ResultSet to objects

pramod talekar
Ranch Hand

Joined: Apr 26, 2010
Posts: 323

Hi,

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.
e.g.
So, how to assign the EmployeeName data to new Employee().name ?

Thanks,
Pramod
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 42701
    
  32
Isn’t it something like String employeeName = rs.getString(...);
There is a page in the Java Tutorials (about 6 lines down) about result sets.
 
Don't get me started about those stupid light bulbs.
 
subject: Assigning values from ResultSet to objects