Results 1 to 3 of 3
Thread: Insert Enum in Database
- 08-09-2013, 11:02 PM #1
Senior Member
- Join Date
- Jul 2013
- Posts
- 188
- Rep Power
- 8
Insert Enum in Database
Assume the following enumeration:
Java Code:public enum FederalState {BW, BY, BE, BB, BR, HH, HE, MV, NI, NR, RP, SL, SN, ST, SH, TH}
Java Code:public class Location { private FederalState state; private String ort; private String PLZ; private String strasse; private String country; //setters and 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();
- 08-09-2013, 11:33 PM #2
Moderator
- Join Date
- Jul 2010
- Location
- California
- Posts
- 1,638
- Rep Power
- 13
Re: Insert Enum in Database
Cross posted at setter of Type Enum
- 08-09-2013, 11:40 PM #3
Just a guy
- Join Date
- Jun 2013
- Location
- Netherlands
- Posts
- 5,114
- Rep Power
- 13
Similar Threads
-
Create registration form | insert into database | call the database
By FamilyGuy in forum JavaServer Pages (JSP) and JSTLReplies: 3Last Post: 04-23-2012, 12:08 PM -
insert vector to database
By jperson in forum JDBCReplies: 4Last Post: 01-20-2011, 03:42 AM -
how to insert data in database
By Vinay Bhatia in forum JDBCReplies: 6Last Post: 11-03-2010, 05:06 PM -
why i can't insert data to database
By khaa_khay in forum Web FrameworksReplies: 0Last Post: 05-26-2010, 06:37 AM -
How to insert large data into database using one insert query
By sandeepsai39 in forum New To JavaReplies: 3Last Post: 02-28-2009, 10:17 AM
Bookmarks