Dynamically populating drop down menu with database values

[Suman Nandi]

Hi,

I have a JSP page which calls a Servlet via AJAX (XMLHTTPRequest). The Servlet's task is to hit the database. Now I want the values coming from database to be displayed in JSP in a dropdown fashion. Please help.

[yuvaraj KumarAmudhan]

in which manner you are receiving the data from the database?

in XML structure or something else?

[Joe San]

Plenty of examples are available in Google...

[David Newton]

If you were using a modern JavaScript framework this would be even easier.

[Bear Bibeault]

Moved to the HTML/JavaScript forum.

[Bear Bibeault]

David Newton wrote:If you were using a modern JavaScript framework this would be even easier.

Indeed, if the server-side resource were to just create the HTML fragment containing the options, the client-side code, using jQuery, would be as simple as:

$('#myDropdown').load('/url/to/servlet');    

Without jQuery, you'll need to do the Ajax "by hand" (not recommended) and use innerHTML to inject the options.

[Eric Pascarello]

actually you can not use innerHTML to add options since now all browser allow that to happen.

You would have to use

new Option("text", "value");

Eric

[Bear Bibeault]

I guess jQuery handles the browser differences. Another reason to use jQuery rather than doing it "by hand".