On a JSP page, I have two dropdown fields and a type4 connection with Oracle 10g. I want the second dropdown to be automatically filled based on the selection from the first dropdown by fetching data from the database. This should happen without refreshing the JSP page, maybe showing an alert like "please wait". How can I achieve this using JSP-Servlet?
<select name="dropdown1">
<option value="<%out.println(name);%>"><%out.println(name);%></option>
</select>
My goal is: Fill the following dropdown based on the selection above:
<select name="dropdown2">
<option value="<%out.println(rollno);%>"><%out.println(rollno);%%gt;</option>
</select>
I found one potential solution :
<body onload="setModels()">
<% // Getting map in a different way.
Map<String,List<String>> map = new TreeMap<String,List<String>>();
Connection con=null;
String vehtypeout="";
...
(out of scope for rewrite)
catch(Exception e){
out.println(e);
}
%>
...
function setSelectOptionsForModels(modelArray) {
// JavaScript implementation here
}
function setModels() {
// JavaScript implementation here
}
function modelSelected() {
// JavaScript implementation here
}
</script>
<form name="myForm">
<select onchange="setModels()" id="manufacturer">
<% boolean first = true;
for (String mf : map.keySet()) { %>
<option value="<%= mf %>" <%=first ? "SELECTED" : ""%>><%= mf %></option>
<% first = false;} %>
</select>
<select onChange="modelSelected()" id="models">
<!-- Filled dynamically by setModels -->
</select>
However, I am only able to retrieve one value in vehtypeout1 while the database contains multiple values. How can I fetch all those values?