Loop for Enums in Java

You could use Enum#values() to get all enum values in an array. The ordinal maps 1:1 to the array index. Add the following method fo your Classification enum:

public static Classification of(int ordinal) { if (0 <= ordinal && ordinal < values().length) { return values()[ordinal]; } throw new IllegalArgumentException("Invalid ordinal " + ordinal); } 

and use it as follows

Classification classification = Classification.of(rs.getInt("classification")); // ... 

However, using enum's ordinal for this is not the best practice. What if some developer rearranges the enum's values or adds/removes values? Even the javadoc warns that it has usually no use for developers. Rather give each enum value a fixed identifier. You could pass it in as an additional argument of the enum constructor argument. You could even use enum's String representation for that.

UNKNOWN(1, "Unknown"), DELETION(2, "Deletion"), DUPLICATION(3, "Duplication"), // ... 

Then use that value for DB instead and modify the of() method to walk through them in a foreach loop:

public static Classification of(int id) { for (Classification classification : values()) { if (classification.id == id) { return classification; } } throw new IllegalArgumentException("Invalid id " + id); } 

You can loop through an enumeration’s values via the object the someEnum.values() method returns:

for (Classification clz : Classification.values()) doSomethingWith(clz); 

found here

I don’t know how exactly I can help you, since i don’t know what rs.getInt(String) does.

It seems to give back an Integer representing a enum value of Classification, but why?

Use variant.setClassification(YourEnumClassHere.values()[classification]). Enum.values() returns an array of all the declared enums in that class.

Instead of storing ordinal, you can store the name and use the valueOf method to convert the String back to your Enum type.

If you willing and able to store a string representation (this is a good technique) of the ENUM in your database, see Reference from Gareth Davis in comments above. If you are unwilling and/or unable to store a string representation and must continue with an ordinal representation, I suggest that a Map is called for. Here is some example code:

public class EnumMap { private enum FistSounds { Blam, Kapow, Zowie, Biff; private static Map<Integer, FistSounds> ordinalMap = new HashMap<Integer, FistSounds>(); static { ordinalMap.put(Blam.ordinal(), Blam); ordinalMap.put(Kapow.ordinal(), Kapow); ordinalMap.put(Zowie.ordinal(), Zowie); ordinalMap.put(Biff.ordinal(), Biff); } public static final FistSounds getByOrdinal(final int enumIndex) { return ordinalMap.get(enumIndex); } } public static void main(String[] args) { FistSounds fistSound; for (int index = -1; index < 5; ++index) { fistSound = FistSounds.getByOrdinal(index); System.out.print("Ordinal: "); System.out.print(index); System.out.print(", FistSound: "); System.out.println(fistSound); } } } 

I'd recommend using a switch statement, if the logic to execute is different for each case....

do as @Gareth Davis instructs and then just have a switch statement and handle each case as required.

Enums are also eligible to be used in switch statements see here