How to pass results to rowmapper in enum?

Question

I have a cool line 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 apply an integer value in db for userType to a UserType enumeration.

Why is this not working?

Answer 1

Drop it? No, it cannot be done.

You can call valueOf to get the Enum value from String if the string is valid.

Answer 2

You can index in Enum.values() :

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

You might want to check out some errors. :)