Hi,

We are using spring and hibernate in our project and I am new to it.
I know how to map java fields to db colums.
But here is some different requirement , I have to choose one String from drop down box and instead of saving it directly in db;have to save it's lookup id(interger) in main table. Look up id and corresponding string are in different table(look up table).
Can it be possible.Please guide me in this.

Thank You.

This is more of a html question than hibernate.
First you query the database for the string/id combinations. These you use to populate the selectbox, using the string as display value and the id as value.
How to do this is dependent on the framework you use, but should result in somethnig like this in your page:


When the form is submitted the selected value (id of the string) is available in the form-element-id variable.

Hello tammingaj,

Thanks for help.
Yeah you are correct this is more of a HTML question rather than any framework specific but one doubt in mind.When we save id in main table and during updation it will retrieve id instead of original name.That will not be of any use. How can we display name instead of id during update.


Thank you.