Design/Implementation...most likely with AJAX

Question

I have a problem that is common, but I am not quite sure exactly how do go about solving it.

My situation is I have a form that will have a drop down of States. I also have a drop down that should have military installations(bases), but the bases that are populated are dependent on the value of the state dropdown.

In my database I will have a table BASES such as the following most likely.

BASES Table
            int base_id
            varchar state
            varchar base_name
            varcar  city

When a customer selects a state, I need to query all the bases in that state. and return them and populate the bases drop down. I am well aware that I can do this easily by just posting the data to the server as form data, but I would rather find a simpler solution and I know ajax is used to solve problems like this one.

I am entry level, and ajax is a new topic for me so any help I can get would be appreciated.

I am using Java/JSP/Servlets and am using MySQL.

You could simplify this by listing all the bases against the state of Maine, because I've often seen on the internet ... All your bases are belong to ME ;) — crowne, Jul 26 '10 at 22:31
I've answered this kind of question before [Populating child dropdowns in JSP/Servlet](http://stackoverflow.com/questions/2263996/populating-child-dropdownlists-in-jsp-servlet). — BalusC, Jul 26 '10 at 23:35

score 2 · Accepted Answer · answered Jul 26 '10 at 22:25

If you think that AJAX is the solution, and you're using Java, then check out DWR. It allows you to trivially expose Java objects in Javascript. You can create a server-side object to derive your list of data for pull-down menus and easily expose this in Javascript.

buckbova · Answer 2 · 2010-07-26T22:59:31.650

1

This can all be solved with javascript alone if you hardcoded the state/base relationship into an array(s) in the javascript file.

Here is an example I found on the internet.

http://www.javascriptkit.com/javatutors/selectcontent2.shtml

edited Jul 26 '10 at 22:59

answered Jul 26 '10 at 22:03

buckbova

1,213
6
11

Is This efficient if there is up to 250 bases? – TheJediCowboy Jul 26 '10 at 22:06
what would it look like hardcoding the state/base relationship, I wasn't aware you could do this. – TheJediCowboy Jul 26 '10 at 22:07

Design/Implementation...most likely with AJAX

2 Answers2