I have a need to display small number of items in select boxes. Most of them are of the binary tuple form. e.g. service codes 1 = now 2 = tomorrow 3 = next month I do not want to query the database every time I need to display these in a drop down box ? What alternatives are available to manage these codes efficiently ? Note that ease of editing these codes is vital. Thanks Pho
You can query the database once, and store the information in a bean available for the whole session. Then you can have jsp pages for managing and displaying the items. HTH