How to cast resultset in rowmapper to an enum?

Question

I have my rowmapper like:

private static final class UserRowMapper implements RowMapper<User> {

    User user = new User();

      user.setId(rs.getInt("id"));
      user.setUserType( (UserType)rs.getInt("userType")); // ?????

    return user;

}

So I am trying to cast the integer value in the db for userType to the enumeration UserType.

Why doesn't this work?

score 13 · Accepted Answer · answered Jan 23 '12 at 02:22

13

Cast it? No, can't be done.

You can call valueOf to get the Enum value from the String, as long as the String is valid.

answered Jan 23 '12 at 02:22

duffymo

305,152
44
369
561

score 4 · Answer 2 · answered Jan 23 '12 at 02:30

4

You can index into Enum.values():

user.setUserType( UserType.values()[rs.getInt("userType")] );

You might want to put in some error checking. :)

answered Jan 23 '12 at 02:30

Ted Hopp

232,168
48
399
521

How to cast resultset in rowmapper to an enum?

2 Answers2