same thing i want but from db..

http://www.roseindia.net/tutorial/javascript/dynamicCombo.html

View Answers

August 28, 2012 at 6:09 PM

Here is a jsp application that retrieves data from the database and stored into first dropdown. If user click any option from the dropdown, the corresponding values will get displayed into another dropdown.

1)selDesg.jsp:

<%@page import="java.sql.*"%>
 <html>
      <head>  
      <script language="javascript" type="text/javascript">  
      var xmlHttp  
      var xmlHttp
      function showEmp(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="selEmp.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("emp").innerHTML=xmlHttp.responseText   
      }   
      }
      </script>  
      </head>  
      <body>  
      <select name='desg' onchange="showEmp(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 desg");
 while(rs.next()){
     %>
      <option value="<%=rs.getString("DESG_NO")%>"><%=rs.getString("DESIGNATION")%></option>  
      <%
 }
     %>
      </select>  
      <br>  
      <div id='emp'>  
      <select name='emp' >  
      <option value='-1'></option>  
      </select>  
      </div>  
      </body> 
      </html>

2)selEmp.jsp:

<%@page import="java.sql.*"%>
<%
String no=request.getParameter("count");  
 String buffer="<select name='emp' ><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 emp where DESG_NO='"+no+"' ");  
   while(rs.next()){
   buffer=buffer+"<option value='"+rs.getString("EMP_NAME")+"'>"+rs.getString("EMP_NAME")+"</option>";  
   }  
 buffer=buffer+"</select>";  
 response.getWriter().println(buffer); 
 }
 catch(Exception e){
     System.out.println(e);
 }
 %>

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

1)desg:

CREATE TABLE `desg` (                     
          `DESG_NO` int(100) default NULL,        
          `DESIGNATION` varchar(255) default NULL   
        );

2)emp:

CREATE TABLE `emp` (                                      
          `EMP_NO` int(10) NOT NULL auto_increment,               
          `EMP_NAME` varchar(100) default NULL,                   
          `DESIGNATION` varchar(100) default NULL,                
          `JOINING_DATE` date default NULL,                       
          `SALARY` int(100) default NULL,                         
          `DESG_NO` int(100) default NULL,                        
          `DEPT_NAME` varchar(100) default NULL,                  
          PRIMARY KEY  (`EMP_NO`)                                 
        );

August 29, 2012 at 10:30 AM

thank u for ur answer : but i need onclick SE(softwware eng) i should get a list of SOFTWARE ENG's similary .. HE(hardware eng) i should get a list of Hardware eng'r... if i click SE SE: HE ratan justin farooq martin sham ram rahul Deepak from database..

Thank YOu

August 29, 2012 at 10:31 AM

SE: martin sham ram rahul Deepak HE: ratan justin farooq

August 29, 2012 at 10:46 AM

hey i got it thank you

Advertisements

to upload a table from DB to the same html page
to upload a table from DB to the same html page how to make this booklist table to be opened in the same html page itself using a third frame

Want to access my Ms-access Db file which is placed inside the same Jar file
Want to access my Ms-access Db file which is placed inside the same Jar file how do i access my Ms-Access file placed in the same jar file where my application code/class file r present??? Want to access it via Code

I want to learn Hadoop from scratch
I want to learn Hadoop from scratch Hi, I want to learn Hadoop from... for companies. Now I want to learn Hadoop including all the technologies of it. How.... I have 2 years of experience in Java, JDBC and Web application development. I

i want to retriev and update in same form but its not working pls help....
i want to retriev and update in same form but its not working pls help.... <p><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN...("refno"); re=stmt.executeQuery("select * from passapp where refno='"+refno

I am from .net background, I want to learn SOA.
I am from .net background, I want to learn SOA. Hi I am from .net background, I want to learn SOA. Could it possible for me to learn SOA, I suppose SOA includes Java. I dont have knowledge of java. Please help Thanks

How to load elements from db when i press next.
but i want to show only 20 at the time and there will be 5 buttons for next page means when i click next, the next 20 books will be displayed from db on the same...How to load elements from db when i press next. Hello , I am working

I want to Populate ComBobox value from database that combox is Itemrenderer of DataGrid.
I want to Populate ComBobox value from database that combox is Itemrenderer of DataGrid. I want to Populate ComBobox value from database that combox is Itemrenderer of DataGrid

How to disable Browser's back button (at the same time i want my own back button to be enabled) :p
How to disable Browser's back button (at the same time i want my own back button to be enabled) :p Hi, I have designed a "back" button for jsp page. Now I want to disable Browser's default button So that people will use "back

Want to learn java - How i can learn Java from scratch?
Want to learn java - How i can learn Java from scratch? Hi, Want to learn java - How i can learn Java from scratch? Give me some guide. Thanks Want to learn java - How i can learn Java from scratch

i want to create invoice report editable. values should be taken from dabase and editable .. help out asap
i want to create invoice report editable. values should be taken from dabase and editable .. help out asap i want to create invoice report .. help out asap

i want code of signing off from a account how its done in jsp and servlet by using either cookies or session
i want code of signing off from a account how its done in jsp and servlet by using either cookies or session sig

i want to create an application with only a button which on click displays table from database using struts2 and hibernate on eclipse
i want to create an application with only a button which on click displays table from database using struts2 and hibernate on eclipse please help me i have to submit this soon

i want to copy files from one machine to other using java and the code will be running on third machine
i want to copy files from one machine to other using java and the code will be running on third machine i want to copy some files from one machine... machine say 'c'. So , can you help me on this that how can i do this using

i want to select a multiple value of check box by using onclick or onchange event without using from submission
i want to select a multiple value of check box by using onclick or onchange event without using from submission i have 4 check box name 1)profile... the result is ok but after getting value of first box now i want a result of second box

i want to update values
i want to update values in my form i have 2 submit buttons one for edit and another for update on page load all my details need to fetch from database and it need to insert automatically in to disabled text boxs and once i press

i want to learn Jquery
i want to learn Jquery i want to learn jquery can u plz guide me Yes, you can learn these technologies by yourself. Go through the following links: Ajax Tutorials JSON Tutorials JQuery Tutorials

i want for statement codding
i want for statement codding what is the for condition following out put 1 2 2 3 3 3 4 4 4 4 5 5 5 5 5

Want to display Arraylist items on same row in JSF
Want to display Arraylist items on same row in JSF I want do display values of one arraylist on same row using datatable? If i use h:column, then it goes on different row. Please tell me, how I can do it? Hi Friend

I want to Transfer only 1/3rd of contents from one folder to other but my code is transferring all contents
I want to Transfer only 1/3rd of contents from one folder to other but my code...("No files in directory: " + src); } for (int i = 0; i < entries.length; i++) { File file = entries[i

I want this jsp answers
I want this jsp answers How can we declare third party classes... jsp is subclass to HttpJspBase.Here HttpJspBase is from which package? HttpJspBase is subclass to HttpServlet(Y/N)? All over rided methods from the HttpServlet

i want code for these programs
i want code for these programs Advances in operating system Laboratory Work: (The following programs can be executed on any available and suitable platform) Design, develop and execute a program using any

Hi, I'm new to JSP I want to create 3 dropdown list each depend on the other and get the options from the database using JSP
Hi, I'm new to JSP I want to create 3 dropdown list each depend on the other and get the options from the database using JSP as i said i want to create 3 drop dropdown list each depend on the other and get the options from

i want to learn data science
i want to learn data science Hi, I am beginner in Data Science and machine learning field. I am searching for the tutorials to learn: i want... can learn the topic "i want to learn data science". Also tell me

i want to learn machine learning
i want to learn machine learning Hi, I am beginner in Data Science and machine learning field. I am searching for the tutorials to learn: i want... so that I can learn the topic "i want to learn machine learning"

I want design samples for JSP project
I want design samples for JSP project Sir, I world Like to do a project in jsp techonology. But i have no idea of selecting the project, especially if i selected any project i have no idea that is how to build ie how to design

I want solution for this jsp program..
I want solution for this jsp program.. <%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%>... * from Login"; stmt=con.createStatement(); rs=stmt.executeQuery

fat image from db
fat image from db <%@ page import="java.sql.*"%> <... = response.getOutputStream(); o.write(imgData); %> sir i want to display within... = stmt.executeQuery("select image from regimg where id ='45'"); if (rs.next

Do I learn ML and IoT at the same time
Do I learn ML and IoT at the same time Hi, I want to make better... to learn first? Do I learn ML and IoT at the same time? Thanks Hi, All... are very important. I advice you to start learning ML and also some time

i want to pass Javascript value to JSP scriptlet..
i want to pass Javascript value to JSP scriptlet.. i am having a problem that, i am having a combo box in the JSP page when i select an item from... now i want to pass this value to JSP scriptlet

i want to create dynamic calendar in java
i want to create dynamic calendar in java i want code and explanation

i want display integer number in a string of statement
i want display integer number in a string of statement i want display integer number in a string of statement

I want to learn Hibernate tutorial quickly
I want to learn Hibernate tutorial quickly Hello, I want to learn Hibernate tutorial quickly. Is there any way.. I want to learn Hibernate online.. Please help

take data from one table and insert same in another
take data from one table and insert same in another I want to know when a new field update in table and the same data has to update in another table

i want to show timeline chart for three year in chart..
i want to show timeline chart for three year in chart.. I am using Jfree chart library to display chart in web pages. i want to show three year data in chart in 3 lines for three year in same chart. i am able to show

I want detail information about switchaction? - Struts
I want detail information about switch action? What is switch action in Java? I want detail information about SwitchAction

i want to save image on server folder. and i want to save URL of this folder and name of image in database
i want to save image on server folder. and i want to save URL of this folder and name of image in database hi i want to save image on server folder. and i want to save URL of this folder and name of image in database.on click

Ads