How to poplulate a Spring form dropdown via SQL table

[Vishal Hegde]

Dear All,

I wanted to know, how to poplulate a Spring form dropdown via SQL Table.

I tried googling it, but it was of no help.

[Bill Gorder]

You would call one of your methods in your @Respostiory. The method would return a collection of options to populate your drop down box with. It might look something like this if your drop down were categories.

List<String> categories = myRepository.findAllCategories();

The database look-up work would be done in myRepository.

Once you have the list your question merely becomes how to populate a selection box.

If you are just selecting a list of Strings it is very simple. If you are using objects there is a little more to it. See this thread from a couple days ago. Pieces of it may be relevant to you.

https://coderanch.com/t/591440/Spring/ID-isn-binded-form-object

Also have a look at the reference documentation:
http://static.springsource.org/spring/docs/3.1.x/spring-framework-reference/html/view.html#view-jsp-formtaglib-selecttag

[Vishal Hegde]

Dear Bill,

I want it in JSTL tag format Like the below lines

<c:forEach items="${DEPARTMENT_LIST}" var="DEPARTMENT_LIST">

                                                        <option value="${DEPARTMENT_LIST.DEPARTMENT_ID}">${DEPARTMENT_LIST.DEPARTMENT}</option>

                                                </c:forEach>

[Bill Gorder]

It sounds like you are doing what the options tag does for you. If you want to do it that way you can but it should be within a select. You also need to use the Spring taglib for your select and option elements if you want it bound to your object.