Ajax-Struts

[Shihad Salam]

Hi, i am new to struts. I tried to populate a drop down list based on change in another select box. Pieces of code is given:

jsp:
....

<tr><th>Select Payee Bank</th><td><html:select property="payee_bank" onchange="retrieveURL(' showBankBranches.do?payee_bank=' + this.value);">
			<html:option value="">...Select One...</html:option>
			<html:option value="AXIS">AXIS</html:option>
			<html:option value="HDFC">HDFC</html:option>
			<html:option value="ICICI">ICICI</html:option>
			<html:option value="SBI">SBI</html:option>
			<html:option value="CITI">CITI</html:option>			
			</html:select>
<html:errors property="payee_bank" /></td></tr>

[b]<tr><th>Select Payee Branch</th>
<td>
<div id="branches">
</div>[/b]

javascript fn:

function retrieveURL(url) 
{
	 if (window.XMLHttpRequest)
  		{// code for IE7+, Firefox, Chrome, Opera, Safari
  			xmlhttp=new XMLHttpRequest();
 		}
	else
  		{// code for IE6, IE5
 			 xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
  		}
	   xmlhttp.onreadystatechange=function()
  		{
  			if (xmlhttp.readyState==4 && xmlhttp.status==200)
    			{
    				document.getElementById("branches").innerHTML=xmlhttp.responseText;

    			}
    		else
	    		{
	    			alert("Problem: " + xmlhttp.statusText);
	    		}
	    }
	    xmlhttp.open("GET", url, true);
	    xmlhttp.send();
}

</script>

struts.xml:
         <action path="/showBankBranches" type="banking.ShowBankBranches" validate="false" >
	     </action>

action class: banking.ShowBankBranches.java

				   	    PrintWriter out = response.getWriter();   
				   	    response.setContentType("text/xml");   
				   	    response.setHeader("Cache-Control", "no-cache");   
				   	    response.setStatus(HttpServletResponse.SC_OK); 
			    		ConnectionBean bean=new ConnectionBean();	
			    	    String bank = request.getParameter("payee_bank").toString(); 
			    		HttpSession session = request.getSession();
			    		Connection conn=bean.dbConnection();
			   			String query= "SELECT * FROM bank WHERE name='"+bank+"'" ;
			   			PreparedStatement ps=conn.prepareStatement(query);			     
			   			ResultSet rs = ps.executeQuery();
			   			out.write("<option>");
			   			while(rs.next())
			   			{
			   				String br=rs.getString(2);
			   				
			   			}
			   			out.write("</option>"); 
			   	        out.flush();
						conn.close();

--------------------------------------------------------------------------------------------------------------------------------
In Jsp am getting all values. But it is not getting in the drop down (which is marked as bold). How can i get those values in drop down list from action class. Please help me. Its Urgent

Thanks

[Joe Ess]

Welcome to the JavaRanch.
Please UseCodeTags in the future. I have added them to your post so it is readable.
In this line in the JavaScript you create a function:

xmlhttp.onreadystatechange=function()  

This should be the name of the callback from the AJAX call where you would populate your DIV.

[vipul John]

You did set the response in text/xml.
so, your statement will be
document.getElementById("branches").innerHTML=xmlhttp.responseXML;
Try this....

[Shihad Salam]

Hi, thanks for your reply.

When i tried

 alert(xmlhttp.responseText); 

in my javascript fn, i am getting list of values. But my real doubt is how can i get those list of data's in the drop down list of jsp ie, inside <html:select> tag as option. Please help me with code. It will be a great help for me

Thanks

[Joe Ess]

I told you that you need to declare a callback function to handle the reply. vipul gave you a line which would insert HTML at a particular point. That's pretty much all there is to it. What have you done to implement our suggestions?