column fields values questions

[Kruger Scheitz]

Regarding the JCombobox fields values, i would like to know how does everyone normally implement them? do they hardcode them or get the field values from the db ?? pls help

[Stephane Weber]

Personnally, I read those values from the database ...
This is more generic.
But of course, you could also hardcode them.

Stephane

[Kruger Scheitz]

if u get the values from the db, i guess u need to write some algorithm method to elimate the duplication of values when the combobox retrieves the them from db...am i right?

[Stephane Weber]

Yes indeed.
But as I am using a HashSet as temporary structure while reading the database, this takes care of eliminating duplicates for me.
And I just ahve to fill the combo with the contents of the HashSet.
Stephane

[Kruger Scheitz]

oh that's cool

[Thomas Fly]

ArrayList serves about the same purpose as HashSet, and sorting an ArrayList is fairly painless using java.util.Collections (hint, if you have a box for selecting flight days, you shouldn't use an alphabetic sort )
I also get my column names from the database. On the other hand, Michael Morris said he hard-coded his (in an FBNconstants class), and he made a 154 (lost a point on documentation ).