combo box code problem

in this my problem related to :

when i select state MP then i wil open the its corresponding city but in database it only stores the option value no like MP at option value 10 then it will stores the 10 for city becuz it wil call the correspndng array[10] in MS Access database

<html>
<head>
<script language="javascript">
var arr = new Array();
arr[0] = new Array("-select-");
arr[1] = new Array("Adilabad","Anantapur","Chittoor","Cuddapah","East Godavari","Guntur","Hyderabad","Karimnagar","Khammam","Krishna","Mahbubnagar","Medak","Nalgonda","Nellore","Nizamabad","Prakasam","Rangareddy","Secundrabad","Srikakulam","Tirupati","Vijayawada","Visakhapatnam","Vizianagaram","Warangal","West Godavari");
arr[2] = new Array("Anjaw","Changlang","East Kameng","East Siang","Kurung Kumey","Lohit","Lower Dibang Valley","Lower Subansiri","Papum Pare","Tawang","Tirap","    Upper Dibang Valley","Upper Siang","Upper Subansiri","West Kameng","West Siang");
arr[3] = new Array("Barpeta","Bongaigaon","Cachar","Darrang","Dhemaji","Dhubri","Dibrugarh","Goalpara","Golaghat","Guwahati(Dispur)","Hailakandi","Jorhat","Kamrup","Karbi Anglong","Karimganj","Kokrajhar","Lakhimpur","Marigaon","Nagaon","Nalbari","North Cachar Hills","Sivasagar","Sonitpur","Tinsukia","Udalguri");
arr[4] = new Array("Araria","Arwal","Aurangabad","Banka","Begusarai","Bhagalpur","Bhojpur ( Arrah )","Buxar","Darbhanga","East Champaran","Gaya","Gopalganj","Jamui","Jehanabad","Kaimur (Bhabua)","Katihar","Khagaria","Kishanganj","Lakhisarai","Madhepura","Madhubani","Munger","Muzaffarpur","Nalanda","Nawada","Patna","Purnia","Rohtas","Saharsa","Samastipur","Saran","Sheikhpura","Sheohar","Sitamarhi","Siwan","Supaul","Vaishali","West Champaran");
arr[5] = new Array("chandigarh");

function change(combo1){
var comboValue = combo1.value;
document.forms["form1"].elements["combo2"].options.length=0;
for (var i=0;i<arr[comboValue].length;i++){
var option = document.createElement("option");
option.setAttribute('value',i+1);
option.innerHTML = arr[comboValue][i];
document.forms["form1"].elements["combo2"].appendChild(option);
}
}


  </script>


</head>

<body>



     <form name=form1  action="reg.jsp"  onsubmit="return validateForm()" method="post" >

<table width="425"  border="0" cellspacing="0" cellpadding="3">


    <tr><td width="5px" height=" 26px"></td><td height="26px" width="326px">
    <span id="lblState">State</span></td>
    <td width=" 193px" height=" 26px">
    <select name="ddlstState" onchange="javascript:setTimeout('__doPostBack(\'ddlstState\',\'\')', 0)" id="ddlstState" class="txtBox" width="119px">
    <option selected=3D"selected" value="0">-State-</option>

    <option value="Andhra Pradesh">Andhra Pradesh</option>

    <option value="Arunachal Pradesh">Arunachal Pradesh</option>
    <option value="Assam">Assam</option>
    <option value="Bihar">Bihar</option>
    <option value="Chandigarh">Chandigarh</option>


</select></td>
       <select name="combo2" >
</select>
    <td width="200px" height="26px"></td></tr>
    <tr><td width="5px"></td><td width=" 326px">
    <span id="lblCity">City/District </span></td>
    <td width=" 193px">
    <select name="ddlstCity" id="ddlstCity" class="txtBox" width="119px">
    <option value="0">-City/District-</option>

</select></td>
    <td width="200px"></td></tr>


<td width=" 193px">

      <input type="submit" name="submit" id="submit" value="Submit" />
      <input type="submit" name="Cancel" id="Cancel" value="Cancel" />
    </td>

    </tr>
</form>



</body>
</html>

View Answers

March 22, 2012 at 11:24 AM

1)country.jsp:

<%@page import="java.sql.*"%>
 <html>
      <head>  
      <script language="javascript" type="text/javascript">  
      var xmlHttp  
      var xmlHttp
      function showState(str){
      if (typeof XMLHttpRequest != "undefined"){
      xmlHttp= new XMLHttpRequest();
      }
      else if (window.ActiveXObject){
      xmlHttp= new ActiveXObject("Microsoft.XMLHTTP");
      }
      if (xmlHttp==null){
      alert("Browser does not support XMLHTTP Request")
      return;
      } 
      var url="state.jsp";
      url +="?count=" +str;
      xmlHttp.onreadystatechange = stateChange;
      xmlHttp.open("GET", url, true);
      xmlHttp.send(null);
      }

      function stateChange(){   
      if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete"){   
      document.getElementById("state").innerHTML=xmlHttp.responseText   
      }   
      }
      </script>  
      </head>  
      <body>  
      <select name='country' onchange="showState(this.value)">  
       <option value="none">Select</option>  
    <%
 Class.forName("com.mysql.jdbc.Driver").newInstance();  
 Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");  
 Statement stmt = con.createStatement();  
 ResultSet rs = stmt.executeQuery("Select * from country");
 while(rs.next()){
     %>
      <option value="<%=rs.getString(1)%>"><%=rs.getString(2)%></option>  
      <%
 }
     %>
      </select>  
      <br>  
      <div id='state'>  
      <select name='state' >  
      <option value='-1'></option>  
      </select>  
      </div>  
      </body> 
      </html>

2)state.jsp:

<%@page import="java.sql.*"%>
<%
String country=request.getParameter("count");  
 String buffer="<select name='state' ><option value='-1'>Select</option>";  
 try{
 Class.forName("com.mysql.jdbc.Driver").newInstance();  
 Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");  
 Statement stmt = con.createStatement();  
 ResultSet rs = stmt.executeQuery("Select * from state where countryid='"+country+"' ");  
   while(rs.next()){
   buffer=buffer+"<option value='"+rs.getString(1)+"'>"+rs.getString(3)+"</option>";  
   }  
 buffer=buffer+"</select>";  
 response.getWriter().println(buffer); 
 }
 catch(Exception e){
     System.out.println(e);
 }

For the above code, we have created two database tables:

CREATE TABLE `country` (                                 
           `countryid` bigint(255) NOT NULL auto_increment,       
           `countryname` varchar(255) default NULL,               
           PRIMARY KEY  (`countryid`));  


CREATE TABLE `state` (                                   
          `stateid` bigint(255) NOT NULL auto_increment,         
          `countryid` int(255) default NULL,                     
          `state` varchar(255) default NULL,                     
          PRIMARY KEY  (`stateid`));

Advertisements

Sub combo box problem - Development process
Sub combo box problem Hi, In this code Sub-Combo box is not working. plz solve the problem Search Page var arr = new Array(); arr["Select"] = new Array("-select-"); arr["Dkn/Tmz"] = new Array

Code to store sub combo box value - Development process
Code to store sub combo box value Hi Deepak, In the following code i want to store subcombo box value instead of number. Already "Dkn/Tmz" ,"kungumam... etc are storing but i want to store "Circulation,marketing

combo box
combo box Hi, [_|] dropdown box [ ] [INCLUDE... a screen like this using jsp-servlet(or DAO,DTO),in that drop down box i should get

combo box - JSP-Servlet
combo box how to get a combo box in jsp page which allows editing as well as list box

populate Combo Box dynamically
populate Combo Box dynamically Hi, How to populate the Combo Box dynamically using Flex with Jsp's

date in combo box
date in combo box strong texthello, how can i desplay the current year and next year in combo box???!!! it must be uppdate atumaticaly every year>>>

assigning arraylist to combo box
assigning arraylist to combo box Hi I am busy coding the Airline Reservation program, i have an arraylist of locations which i want to assing to the combo box. please help

loading value into combo box by selecting value from other combo box - JSP-Servlet
loading value into combo box by selecting value from other combo box �... and code; each district table contain constituency and code. MY problem is that as i select state from state_combo_box,then the next combo box is dynamically

populating the combo box - Struts
populating the combo box Hi I am having problem populating the combo box with a table in MS SQL Server 2005 Management Studio Express. Belo...; } ========================================================================== My problem is populating the combobox table

combo box connection
combo box connection how to provide connection between three combo boxes,if my 1st combo box is course and 2nd combo box is semester and 3rd combo... combo boxes. Here is Java swing code: import java.sql.*; import

Combo box value Error - WebSevices
Combo box value Error if($_SERVER['REQUEST_METHOD'] == 'POST... the correct code for this. Hi friend, Please give the full details and source code to solve the problem. http://www.roseindia.net

Combo Box - Struts
Combo Box I hava acombo box cnnected to my database via html collections. When selecting an option, i want to display specific parts (sectons) on my web page....am trying to use logic:present and logic:empty but its not working

combo box value
combo box value i want to populate one combo box value based on another combo box value using ajax 1)country.jsp: <%@page... e){ System.out.println(e); } %> For the above code

Helps with combo box and frame
Helps with combo box and frame Hi i have a combobox and when i click... on the second window and click confirm i would have the information on the combo box. i don't really know how to doing it. Sorry i forget to put my code i

Loading combo box from oracle
Loading combo box from oracle how can i load values into a combobox from oracle database when a value is selected in another combo box

combo box value
combo box value i want to populate one combo box value based on another combo box value using ajax 1)country.jsp: <%@page import="java.sql.*"%> <html> <head> <script language

Dojo Combo Box
Dojo Combo Box In this section, you will learn what is combo box and how to create a combo box in dojo. For creating the Combo box you need "

combo box - JSP-Servlet
combo box I am using a JSP form in which a combobox is given and I want to populate data in it from database and on the basis of yhe selected item... table country(country_id,country) in database and try the following code

java combo box
java combo box how to display messagedialogbox when the combobox is null, Thanks in advance

JCombo Box problem
JCombo Box problem I have three combo boxes First combo box display the year Second combo box display the month for the selected year.ADS_TO_REPLACE_1 Third combo box display number of week in a selected month for the year

JavaScript Dynamic Combo Box
JavaScript Dynamic Combo Box Here we are going to create dynamic combo box... in respective arrays. As the user selects a country from the first combo box, the cities of that country, get populated into the second combo. Here is the code

How to create Combo Box in SWT
How to create Combo Box in SWT This section illustrates you how to create a combo box... an action on the second combo box. The items tea , coffee and cold drink

Combo Box operation in Java Swing
JComboBox(items); The above code has been used to create a combo box in this program... for the position number of he of the item in combo box to remove it. Here is the code... Combo Box operation in Java Swing �

how to create a combo box in html
how to create a combo box in html <tr> <td>Number<span class=mandatory>*</span></td> <td> <select name="number" id="course" style="width:158px;"> <option value="none">----Select

Retrieving Data from Database to fill Combo Box
Page with a combo box and a label. I have a database that has two fields id and an image. Now I want to fill the combo box with image and on selecting a particular image in combo box it should be displayed on the label. My combo box is only

how to get selected name from combo box
how to get selected name from combo box i have fetched all records of worker i.e worker name. on a test.jsp and dispayed it into combo box ...my... of worker name within d combo box and display that id into a text box. plz

how to get combo box value - JSP-Servlet
in combo box in jsp page: (small part of my code) "> now i want...how to get combo box value i have created 1 servlet & 1 jsp page..., Try the following code: 1) combo.jsp: "> 2)Servlet

two text box problem
two text box problem i have two text box in two different pages and same variable use in two text box when enter value in first text box it's reflection show in second text box , how i reduce it in jsf ? Hi Friend

Dynamic check box problem
Dynamic check box problem In my project i have used a dynamic table, in the each row of that table there is one check box [that i have created dynamically]. Now my problem is that i can't access those values from that dynamic

Populate a combo box using data from a database
Populate a combo box using data from a database Hi Guys, In need... combo box which will then load the next combo box values, now i know how... to the client using ajax, and then populate the combo box, I must'nt reload

How to get the values from the Combo Box - JSP-Servlet
, Actually i am getting the values in the combo box from table.I want what ever the value i select in combo box its corresponding records will display in their respective text box. e.g suppose i select ram values from the combo box and its

JavaScript Combo Box Validation
JavaScript Combo Box Validation This application illustrates how to validate the combo box using JavaScript validation. In this example we create a combo box of different

Store combo box value - Development process
Store combo box value Hi , this is my code. Here wen i click submit button combo values are stored like 1,2,3... but i want to store value . plz send me code. while validating a form, i have entered data in first field

How to retrieve data by using combo box value in jsp? - JSP-Servlet
How to retrieve data by using combo box value in jsp? For example, In Employee.jsp form, When i click employee id value in combo box...... i already stored combo box values from database. pl

com.vaadin - vaadin-combo-box-flow version 2.1.3 Maven dependency. How to use vaadin-combo-box-flow version 2.1.3 in pom.xml?
dependency code: implementation group: 'com.vaadin', name: 'vaadin-combo-box-flow...com.vaadin - Version 2.1.3 of vaadin-combo-box-flow Maven dependency? How to use com.vaadin - Version 2.1.3 of vaadin-combo-box-flow

com.vaadin - vaadin-combo-box-flow version 1.1.0 Maven dependency. How to use vaadin-combo-box-flow version 1.1.0 in pom.xml?
dependency code: implementation group: 'com.vaadin', name: 'vaadin-combo-box-flow...com.vaadin - Version 1.1.0 of vaadin-combo-box-flow Maven dependency? How to use com.vaadin - Version 1.1.0 of vaadin-combo-box-flow

com.vaadin - vaadin-combo-box-flow version 1.0.7 Maven dependency. How to use vaadin-combo-box-flow version 1.0.7 in pom.xml?
dependency code: implementation group: 'com.vaadin', name: 'vaadin-combo-box-flow...com.vaadin - Version 1.0.7 of vaadin-combo-box-flow Maven dependency? How to use com.vaadin - Version 1.0.7 of vaadin-combo-box-flow

com.vaadin - vaadin-combo-box-flow version 3.0.2 Maven dependency. How to use vaadin-combo-box-flow version 3.0.2 in pom.xml?
dependency code: implementation group: 'com.vaadin', name: 'vaadin-combo-box-flow...com.vaadin - Version 3.0.2 of vaadin-combo-box-flow Maven dependency? How to use com.vaadin - Version 3.0.2 of vaadin-combo-box-flow

Need to push the combo box to flash movie - Java Beginners
Need to push the combo box to flash movie Hi, I need to push the combo box values to the flash movie. I am succusfull in pushing the textfield... in pushing the combo box values to the flash movie

code problem:ajax - Ajax
code problem:ajax Hi,I am using ajax to populate a select box.for this I am writing out.write("ONE"); like that.it runs fine in firefox.bt not in IE.Can anyone help me out this... thanks

How to retreive data by using combo box value - JSP-Servlet
How to retreive data by using combo box value Hello friend... I can print combo box values... only displayed... Your code is here.. function

Hibernate code problem - Hibernate
Hibernate code problem Hi, This is Birendra Pradhan.I want... in the DAO.Can it be possibe. Please send some sample code.. thanks & Regards Birendra Hi friend, For solving the problem visit

code problem - Java Beginners
code problem Dear sir, my problem is that I've a string value if this String value has "quit" then output should be "bye". i want to make this program using SWITCH CASE statement. how to implement String value in Switch plz

How to retrieve data by using combo box value in jsp? - JSP-Servlet
How to retrieve data by using combo box value in jsp? I am using a single jsp form.. i did not get from another form.. i do not use 2 jsp form.. all are satisfaction in this form.. What will i do. My code is following

Ads