Enum in Datenbank

[vector_ever]

Angenommen die folgende enumeration:

public enum FederalState {BW, BY, BE, BB, BR, HH, HE, MV, NI, NR, RP, SL, SN, ST, SH, TH}

public class Location {
	
	private FederalState state;
	private String ort;
	private String PLZ;
	private String strasse;
	private String country;

//setters und getters

PreparedStatement ps = null;
ps = con.prepareStatement(query);

	           Iterator<Location> it = set.iterator();
	           while (it.hasNext()){
	           Location obj = it.next();

	           ps.setString(1, obj.getState()); //error State is type enum not String but there is no setEnum
	           ps.setString(2, obj.getOrt());	           
	           ps.setString(3, obj.getPLZ());
	           ps.setString(4, obj.getStrasse());

	       	     ps.executeUpdate();

"State" ist enumeration (nicht String, deswegen), wie kann man die richtige Anweisung enum "State" mit prepareStatement?

 

[diel2001]

Ganz einfach:

ps.setString(1, obj.getState().toString());