Populate a combo box using data from a database

Home Answers Viewqa JSP-Servlet Populate a combo box using data from a database

robert merrett

Populate a combo box using data from a database
1 Answer(s) a year and 5 months ago
Posted in : JSP-Servlet

Hi Guys, In need of some help, so i have three combo boxes, the first is supplier, the second range and the final model

so what should happen is the user selects the first combo box which will then load the next combo box values,

now i know how to populate the first one, and then how to send the data off to a servlet and preform a search on the database for the values I want, but then how do I pass that back to the client using ajax, and then populate the combo box, I must'nt reload the page!

any help would be greatly appreciated!!!

View Answers

January 24, 2012 at 1:29 PM

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`));

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

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

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 I want to display related data in a textbox Hi Friend, Create

Acees data from database using combo box - JSP-Servlet
Acees data from database using combo box please let me how i access the data from database when i select combo box combo2 having values Arts, Commerce, Science. this combo box will appear when first combo box class_name having

populate dropdown box
populate dropdown box hi, Is there any ways in which i can populate my dropdown menu with values from 1 to n (n = the value stored in database)using java script or jsp, either is fine? Ex: If value corresponding to selected

Retrieving data from data base using jsp combo box
Retrieving data from data base using jsp combo box Hi guys please... combo box is there and another filed is version of the server(like 1.0,2.0) like... of the server it has to display the process name from database into the process name

combo box
combo box Hi, [_|] dropdown box... a screen like this using jsp-servlet(or DAO,DTO),in that drop down box i should get usernames from the database & upon selection of particular user i should get

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... = con.createStatement(); ResultSet rs = stmt.executeQuery("Select * from country

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

how i conditional access the data from database using combo box. - JSP-Servlet
how i conditional access the data from database using combo box. i have combox box named class when i select its value 11 or 12, another combo box... access the data from database when i select class 11 0r 12. Here is JSP file

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... stored Combobox values from

retrieve the data to text fields from database on clicking the value of combo box
retrieve the data to text fields from database on clicking the value of combo box retrieve the data to text fields from database on clicking... getting data into textarea from database table by clicking on the button

How to retreive data by using combo box value - JSP-Servlet
How to retreive data by using combo box value I am using a single... there... /// Here stored Combobox values from database. Note: I am using only this jsp form.. i do not use to get values from

How to retrieve data from database by using combo box value in jsp? - JSP-Servlet
How to retrieve data from database by using combo box value in jsp? Hello friend i want use only one jsp page.. but u give 2 pages... I want to work in one page... Pl response.. I do not need getParameter... Pl respose me

How to retrieve data by using combo box value in jsp? - JSP-Servlet
in combo box from database.. by using select*from studentinformation; But when i...How to retrieve data by using combo box value in jsp? Hi Friends... related value.... I am using only this page.. not get value from another page

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... = stmt.executeQuery("Select * from country"); while(rs.next()){ %>

retrieving from oracle database using jsp combo box
retrieving from oracle database using jsp combo box hi this is my... name of the server has to display in the process name field from the oracle database please help on this i need code using servlets please help me . <

JTable populate with resultset.
JTable populate with resultset. How to diplay data of resultset... provide view of data, stored in database, file or in some object. It does...) JTable(Vector data, Vector columneNames) Here is a JTable populate with resultset

How to retreive data by using combo box value - JSP-Servlet
How to retreive data by using combo box value Hello friend... the values from html. So u r using if(request.getParameter("cid")!=null... I can print combo box values

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

How to retrieve data using combo box value in jsp? - JSP-Servlet
How to retrieve data using combo box value in jsp? Hi freind, I already post this question. I need urgent help from u. pl response me.... All actions in the same page....... Hi Friend, Please visit

Dynamic loading of Combo box list using servlet - JSP-Servlet
Dynamic loading of Combo box list using servlet I have the category and their sub categories in database. How can I load the sub category from... I give theortical descrption read it! Select a value from drop dwon box

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 is the extract from the Struct?jsp application. Sector

combo box code problem
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... for city becuz it wil call the correspndng array[10] in MS Access database

How to populate text fields using php code?
How to populate text fields using php code? How could I use php to populate text fields by selecting a name of a business from dropdown list? Those..., suite number, description, and opening times from a mysql database. If you can

retrive the data from access database to drop down list box in jsp
retrive the data from access database to drop down list box in jsp hai, im new to jsp now im using the jsp along with access database.in table i load all the data's i need to retrive the data from database to dropdown list box

Combo Box operation in Java Swing
, remove items from the combo box. This program shows a text field, a combo box... at the 0th (zero) position of the combo box will be remove from the combo box... Combo Box operation in Java Swing

How to create Combo Box in SWT
are added to the first combo box by using the method add() of Combo class. ... is called. If you select the cold drink from the first combo box, the array of drinks is added to the second combo box by using the method combo2.setItems(drinks

Use of Select Box to show the data from database
Use of Select Box to show the data from database ... page to show the data fetched from the database. We are using Servlet to get data from the database using MySQL and we are forwarding this servlet data

retrieving data in to the dropdown box from postgresql database in core java
retrieving data in to the dropdown box from postgresql database in core...=st.executeQuery("SELECT role_name from role WHERE dept_id=1234"); if(rs... database: import java.sql.*; import java.awt.*; import javax.swing.*; import

How to get data from DB in to Text box by using Jsp & Ajax
How to get data from DB in to Text box by using Jsp & Ajax I want to get the data from database in to text box in a jsp page by using Ajax. If I... with a and from that i need to select the required value and i should store

Combo Box Using Ajax In JSP
to Select the Data from database using Ajax in combo box. We created two file... Combo Box Using Ajax In JSP ... id data come from database corresponding this id and auto fill the Emp Id

How to show autocomplete textbox values on combo box option selection using database?
How to show autocomplete textbox values on combo box option selection using database? When I select option(i.e First Year) then it will show list of student names in auto-complete text box

how to retrieve data into combo from database in java applet?
how to retrieve data into combo from database in java applet? hi,. i have written applet codes for linking two frames and database connectivity but the problem is, the database is not retrieving data into the combo..please

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

insert data using drop down box in java into database postgresql
insert data using drop down box in java into database postgresql can... data into database using an drop down box .....as i m using eclipse as jdbc and postgresql as data base syntax which i m using is like:- java class

How to populate an HTML table using jstl code - Spring
How to populate an HTML table using jstl code Hi I want to populate an HTML table using jstl code.I am using Hasp map.For 1 column its okay it works fine.But if I am suppose to populate 2 or 3 columns from the database than

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 box is my subjects.what's the coding to provide the connection between this three

how to display data from mysql table in text box using jsp??
how to display data from mysql table in text box using jsp?? <p>hi, i have a written a code to display data from a mysql table into txtboxes... QueryString = "SELECT * FROM code<em>ot WHERE code</em>codeot=12

JSP Populate - JSP-Servlet
parameters and at the same time want to use that parameter to populate the same XYZ jsp from database. How do I populate this XYZ jsp after hitting that URL (it needs to call java/servelt to populate that jsp.. my question is how?) Hi

retreiving data from microsoft access database
retreiving data from microsoft access database How can i retrieve data from microsoft access when i have select the vaules in combo box and text box. When i select these values... i want to retrieve the corresponding columns

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

Populate listbox according to selection value from another selectbox
listbox from database but campus list box will removes selected value.. please help...Populate listbox according to selection value from another selectbox ... appropriate courses from database without page refresh. I have tried one solution

How retreive data from database without using post method in jsp - JSP-Servlet
How retreive data from database without using post method in jsp Tell me how? Hi Friend, If you don't want to use post method then use... the selected value from the combo box and get textbox value from another page

Latest
Frameworks
Category