JSP RSS JSP RSS

2 comboboxes values of 2nd depends on 1st ,OPTION values from Database

Reply
1 2

•
•
Join Date: Jun 2009
Posts: 7
Reputation: sriups is an unknown quantity at this point 
Solved Threads: 0
sriups sriups is offline Offline
Newbie Poster

2 comboboxes values of 2nd depends on 1st ,OPTION values from Database

 
0
  #1
Jun 12th, 2009
hi all!
i am new to jsp, i have two comboboxes,in which values of 2nd combo box are linked two first combo box and we get values for both these boxes from database.

table1
JSP Syntax (Toggle Plain Text) 
  1. (pk)itemno:text
  2. itemname:text (no duplicates)

table2
JSP Syntax (Toggle Plain Text) 
  1. (pk)itemno:text(duplicates)
  2. (pk)pcode:text
  3. pname:text(no duplicates)

i want to display..

combobox1:itemname
combobox2:pname

Note: Both Values of combobox are to be retrieved from database.

when user select itemname corresponding values of pname should be displayed. I went through google and some threads of this forum and found some info but there option values are not retrieved from database(given in code itself), but i'm puzzled from retrieving 1st combo values and select one to retrieve the values of 2nd combo.

Hope i have made my question clear. Thank You all!
Reply With Quote Quick reply to this message  
•
•
Join Date: Oct 2008
Posts: 2,559
Reputation: adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of 
Solved Threads: 454
Moderator
adatapost's Avatar
adatapost adatapost is online now Online
Posting Maven

Re: 2 comboboxes values of 2nd depends on 1st ,OPTION values from Database

 
0
  #2
Jun 12th, 2009
Can I see you code please? Start to code and post your problems. Definitely, we will help you.
Failure is not fatal, but failure to change might be. - John Wooden
Reply With Quote Quick reply to this message  
•
•
Join Date: Jun 2009
Posts: 7
Reputation: sriups is an unknown quantity at this point 
Solved Threads: 0
sriups sriups is offline Offline
Newbie Poster

Re: 2 comboboxes values of 2nd depends on 1st ,OPTION values from Database

 
0
  #3
Jun 12th, 2009
•
•
•
•
Can I see you code please? Start to code and post your problems. Definitely, we will help you.
Many thanks. Well i started coding and succesful in retrieveing first combox values from database and stored the selected value in a hidden type input now i dunno know to proceed frm here.

my problem is that, i will use <form action="servlet "> and retrieve values from database using selected value in combobox1 (getParameter()).now how can i send back these reteieved values of combobox 2 back to jsp...??

my code trail.jsp

JSP Syntax (Toggle Plain Text) 
  1. <%@ page language="java" contentType="text/html" import="java.sql.*" %>
  2.  
  3. <html>
  4. <head><title>select  box demos</title>
  5. <script type="text/javascript">
  6. function redirect()
  7. {
  8.  var index=document.myForm.selbox.selectedIndex;
  9.  document.myForm.selv.value=document.myForm.selbox.options[index].value;
  10. document.write(document.myForm.selv.value);// stored selected value in hidden type value
  11. }
  12.  
  13. </script>
  14. </head>
  15. <body>
  16. <form name="myForm">
  17. <table>
  18. <%
  19.  try
  20.  {
  21.   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  22.   Connection conn=DriverManager.getConnection("jdbc:odbc:trail");
  23.   try
  24.   {
  25.    String itname[]={};
  26.  
  27.    int i=0,j=0,m=0;
  28.  
  29.    String str1="select * from table1";
  30.    PreparedStatement stmt1=conn.prepareStatement(str1);
  31.    ResultSet rs1=stmt1.executeQuery();
  32.  
  33.    itname=new String[100];
  34.  
  35.    while(rs1.next())
  36.    { 
  37.     itname[m]=rs1.getString(2);
  38.     m++;
  39.    }
  40.  
  41.  
  42.    for(j=m;j<100;j++)
  43.    {
  44.     itname[j]="null";
  45.    }
  46.  
  47.  
  48.   out.println("<tr>");
  49.   out.println("<td>Item Type:</td>");
  50.   out.println("<td>"); 
  51. %>
  52.  <select name="selbox" id="sel" onchange=redirect(this.form) >
  53. <%
  54.   while(i<itname.length)
  55.   {
  56.    if(itname[i]!="null")
  57.     out.println("<option value="+itname[i]+">"+itname[i]+"</option>");
  58.     i++;
  59.   }
  60.   out.println("</select>");
  61.  
  62.   }
  63.   catch(SQLException e)
  64.   {
  65.    out.print("SQL Not Executing");
  66.   }
  67.  } 
  68.  catch(Exception e)
  69.  {
  70.   e.printStackTrace();
  71.  }
  72. %>
  73. <input type="hidden" name="selv" >
  74. </table>
  75. </form>
  76. </body>
  77. </html>
Last edited by sriups; Jun 12th, 2009 at 3:53 pm.
Reply With Quote Quick reply to this message  
•
•
Join Date: Feb 2009
Posts: 21
Reputation: amarjeetsingh has a little shameless behaviour in the past 
Solved Threads: 1
amarjeetsingh amarjeetsingh is offline Offline
Newbie Poster

Re: 2 comboboxes values of 2nd depends on 1st ,OPTION values from Database

 
0
  #4
Jun 13th, 2009
Use Ajax for your reqirement

i am giving solution to your problem

first create 2 jsp for your reqirement

first you show the one list itemname in the first jsp page
when user select the option from the list ,call ajax function in the
first jsp page ,and reterieve the value from the database according
to the itemname
i show the code
this is your first jsp page itemname.jsp

JSP Syntax (Toggle Plain Text) 
  1. <html>
  2. <head>
  3.  
  4.  
  5.  
  6.  
  7.  
  8.  
  9. </head>
  10.  
  11.  
  12.  
  13. <body>
  14. <script type="text/javascript">function ajaxFunction()
  15. {var xmlHttp;
  16. try
  17.   {  // Firefox, Opera 8.0+, Safari 
  18.    xmlHttp=new XMLHttpRequest();
  19.   }
  20. catch (e)
  21.   {  // Internet Explorer 
  22.    try
  23.     {    xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");    }
  24.   catch (e)
  25.     {    try
  26.       {      xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");      }
  27.     catch (e)
  28.       {      alert("Your browser does not support AJAX!");      return false;      }    }  }
  29.   xmlHttp.onreadystatechange=function()
  30.     {
  31. 	   //alert("i m  not  in ready state");
  32.  
  33. 	    if(xmlHttp.readyState==0)
  34.       {
  35.       //document.myForm.time.value=xmlHttp.responseText;
  36. 	    alert("The request is not initialized");
  37.  
  38.  
  39.  
  40.  
  41.  
  42.       }
  43. 	      if(xmlHttp.readyState==1)
  44.       {
  45.       //document.myForm.time.value=xmlHttp.responseText;
  46. 	    alert("The request has been set up");
  47.  
  48.  
  49.  
  50.  
  51.  
  52.       }
  53.  
  54.  
  55.  
  56. 	        if(xmlHttp.readyState==2)
  57.       {
  58.       //document.myForm.time.value=xmlHttp.responseText;
  59. 	    alert("The request has been sent");
  60.  
  61.  
  62.  
  63.  
  64.  
  65.       }
  66.  
  67. 	  	        if(xmlHttp.readyState==3)
  68.       {
  69.       //document.myForm.time.value=xmlHttp.responseText;
  70. 	    alert("The request is in process");
  71.  
  72.  
  73.  
  74.  
  75.  
  76.       }
  77.  
  78.  
  79.  
  80.  
  81.  
  82.  
  83.  
  84.  
  85.     if(xmlHttp.readyState==4)
  86.       {
  87.       //document.myForm.time.value=xmlHttp.responseText;
  88. 	    //alert("i m in ready state");
  89.  
  90. 	   document.getElementById("theResponse").innerHTML = xmlHttp.responseText;
  91.  
  92.  
  93.  
  94.       }
  95.     }
  96. 	      var itemname=document.myForm.itemname.value;
  97. 	      var url="getProduct.jsp";
  98.           url=url+"?itemname="+itemname+"&sid="+Math.random();
  99.           //url=url+"&sid="+Math.random();
  100.  
  101.  
  102.  
  103.          xmlHttp.open("GET",url,true);
  104.          xmlHttp.send(null); 
  105.    }
  106.  
  107.   </script>
  108. select itemname:<form name="myForm" onBlur="ajaxFunction();" >
  109.   <select  name="itemname">
  110.   <option value="computer">computer</option>
  111.   <option value="cars">Cars</option>
  112.  
  113.   </select>
  114.  
  115. <div id="theResponse">
  116.  
  117. </div>
  118. </form></body>
  119. </html>



Now your second Jsp page
getProduct.jsp

JSP Syntax (Toggle Plain Text) 
  1.  
  2. <%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %>
  3. <html>
  4. <head>
  5.  
  6. <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  7. </head>
  8.  
  9. <body>
  10.  
  11. <%
  12. // open the database connection and get the ResultSet
  13. // according to your itemname
  14.  // take example 
  15. // ResultSet rs=select pname from product where itemname='"+request.getParameter(itemname)+"' ;
  16.  
  17. %>
  18.  <select  name="pname">
  19.  
  20. <%   while(rs.next())
  21.    { %>
  22.     <option value="<%=rs.getString(1)%>">"<%=rs.getString(1)%>"</option>
  23.  
  24.  <%  } %>
  25.  
  26.  </select>
  27.  
  28.  
  29.  
  30.  
  31.  
  32.  
  33.  
  34.  
  35. %>
  36.  
  37.  
  38.  
  39. </body>
  40. </html>



try it
Reply With Quote Quick reply to this message  
•
•
Join Date: Oct 2008
Posts: 2,559
Reputation: adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of 
Solved Threads: 454
Moderator
adatapost's Avatar
adatapost adatapost is online now Online
Posting Maven

Re: 2 comboboxes values of 2nd depends on 1st ,OPTION values from Database

 
0
  #5
Jun 13th, 2009
Promise me that you will the follows Peter budo's post.

A code I am posting here is a solution of your current problem. It can't help to solve your Java Web Development problems.

DB.java - Place this java file in WEB-INF/classes folder and compile it.
Java Syntax (Toggle Plain Text) 
  1. package com.me;
  2.  
  3. import java.sql.*;
  4. import java.util.*;
  5.  
  6. public class DB
  7. {
  8.    static String url="jdbc:odbc:sampledb";
  9.    static String username="your_user_name";
  10.    static String password="your_password";
  11.    static String driver="sun.jdbc.odbc.JdbcOdbcDriver";
  12.     static{
  13.          try {
  14.                  Class.forName(driver);
  15.              }catch(Exception ex) {}
  16.    }
  17.   public static Connection getCn() throws Exception {
  18.          return DriverManager.getConnection(url,username,password);  
  19.   }
  20.   public static int execute(String sql) throws Exception {
  21.          Connection cn=getCn();
  22.          Statement st=cn.createStatement();
  23.          int i=st.executeUpdate(sql);
  24.          st.close(); cn.close();
  25.          return i;
  26.   }
  27.   public static Object getValue(String sql) throws Exception{
  28.          Connection cn=getCn();
  29.          Statement st=cn.createStatement();
  30.          ResultSet rs=st.executeQuery(sql);
  31.          Object i=null;
  32.           if(rs.next())
  33.                 i=rs.getObject(1);
  34.          rs.close();
  35.          st.close(); cn.close();
  36.          return i;
  37.   }
  38.  
  39.   public static String getCombo(String sql,String sel) throws Exception{
  40.          Connection cn=getCn();
  41.          Statement st=cn.createStatement();
  42.          ResultSet rs=st.executeQuery(sql);
  43.          if(sel==null) sel="";
  44.  
  45.          String result="<option value=''>Select</option>";
  46.          String value="";
  47.          String text="";
  48.          while(rs.next()){
  49.                 value=rs.getString(1); text=rs.getString(2);
  50.  
  51.                 if(value.equals(sel)) {
  52.                   result=result + "<option value=\"" + value + "\"  selected=\"selected\" >" + text + "</option>";
  53.  
  54.                 }
  55.                 else{
  56.                    result=result + "<option value=\"" + value + "\">" + text + "</option>";
  57.  
  58.                 } 
  59.           }
  60.          rs.close(); st.close(); cn.close();  
  61.          return result;
  62.    }
  63. }

and a page1.jsp
JSP Syntax (Toggle Plain Text) 
  1. <?% page language="java" import="java.sql.*" %>
  2.  
  3. <%
  4.    String item=request.getParameter("item");
  5.    if(item==null) item="";
  6.  
  7. %>
  8. <form name="form1" method="post" action="page1.jsp">
  9.    <select name="item"  onchange="form1.submit()">
  10.        <%=com.me.DB.getCombo("select itemno,itemname from item",item) %>
  11.    </select>
  12.  
  13.    <select name="prod">
  14.         <%=com.me.DB.getCombo("select pcode,pname from product where itemno='" + item + "'",item) %>
  15.    </select>
  16. </form>
Failure is not fatal, but failure to change might be. - John Wooden
Reply With Quote Quick reply to this message  
•
•
Join Date: Jun 2009
Posts: 7
Reputation: sriups is an unknown quantity at this point 
Solved Threads: 0
sriups sriups is offline Offline
Newbie Poster

Re: 2 comboboxes values of 2nd depends on 1st ,OPTION values from Database

 
0
  #6
Jun 13th, 2009
•
•
•
•
Use Ajax for your reqirement

i am giving solution to your problem

first create 2 jsp for your reqirement

first you show the one list itemname in the first jsp page
when user select the option from the list ,call ajax function in the
first jsp page ,and reterieve the value from the database according
to the itemname
i show the code
this is your first jsp page itemname.jsp
Thank You amarjeetsingh for spending your valuable time on answering this.

well i heared AJAX will solve the problem but i have no time (deadline of this project) to learn AJAX. So, looking for other alternative, anyway i managed to get through your code and going to work on it.


•
•
•
•
</script>
select itemname:<form name="myForm" onBlur="ajaxFunction();" >
<select name="itemname">
<option value="computer">computer</option>
<option value="cars">Cars</option>

</select>

Seems like you have given values directly , i want these values from database too. Wat's the job of this AJAX Script u given? .
Does it gets values for itemname from database?

Once again Many Thanks.Added Reputation.
Last edited by sriups; Jun 13th, 2009 at 8:09 am.
Reply With Quote Quick reply to this message  
•
•
Join Date: Jun 2009
Posts: 7
Reputation: sriups is an unknown quantity at this point 
Solved Threads: 0
sriups sriups is offline Offline
Newbie Poster

Re: 2 comboboxes values of 2nd depends on 1st ,OPTION values from Database

 
0
  #7
Jun 13th, 2009
Thank you adatapost , with your motivation i started coding and it's very kind of you for helping me to solve this.

•
•
•
•
Promise me that you will the follows Peter budo's post.
Sure, I Promise.

•
•
•
•
A code I am posting here is a solution of your current problem. It can't help to solve your Java Web Development problems.
what kind of java web development problems?

I have seen your code and not familiar with some lines anyway got some sense of it, i will get back to you as soon as i run this code.

Thanks for Spending your valuable time.Added Reputation.
Reply With Quote Quick reply to this message  
•
•
Join Date: Feb 2009
Posts: 21
Reputation: amarjeetsingh has a little shameless behaviour in the past 
Solved Threads: 1
amarjeetsingh amarjeetsingh is offline Offline
Newbie Poster

Re: 2 comboboxes values of 2nd depends on 1st ,OPTION values from Database

 
0
  #8
Jun 13th, 2009
you want to show the itemname from the database
it is very easy,

in your servlet
by open a dao connection
get all the data from the database
set into the ArrayList
then in the servlet
set the ArrayList
JSP Syntax (Toggle Plain Text) 
  1. request.setAttribute("arr",ArrayList);

now
in the jsp

JSP Syntax (Toggle Plain Text) 
  1. <select name="itemname">
  2. <c:forEach   items="${arr}"   var="show" >
  3.  <option value=" ${show}">${show}</option>
  4.  
  5.  
  6. </c:out>
  7.  
  8.  
  9. </c:forEach>
  10.  
  11. </select>



but it will be in your first jsp page

then use the Ajax in the first jsp page for the second jsp page
Last edited by amarjeetsingh; Jun 13th, 2009 at 9:27 am.
Reply With Quote Quick reply to this message  
•
•
Join Date: Jun 2009
Posts: 7
Reputation: sriups is an unknown quantity at this point 
Solved Threads: 0
sriups sriups is offline Offline
Newbie Poster

Re: 2 comboboxes values of 2nd depends on 1st ,OPTION values from Database

 
0
  #9
Jun 16th, 2009
Hai adatapost compiled ur java code but no results it gives Http status 500 error...anyway Thanks 4 ur effort.

Just now finished tutorial on AJAX now i'm moving to amarjeetsingh's AJAX code...will be back after testing it!!!
Reply With Quote Quick reply to this message  
•
•
Join Date: Jun 2009
Posts: 7
Reputation: sriups is an unknown quantity at this point 
Solved Threads: 0
sriups sriups is offline Offline
Newbie Poster

Re: 2 comboboxes values of 2nd depends on 1st ,OPTION values from Database

 
0
  #10
Jun 28th, 2009
hi amarjeetsingh i have coded as you said

2 Jsp pages
itemname.jsp
getproduct.jsp

the problem here is the value of itemname selected was not sent to secondpage (request.getparameter not working) this is wat i get when i run the code
http://i43.tinypic.com/dwqve1.jpg

i am giving you the 2 jsp pages and access database Zipped and i put them in attachment down here, Could u please help me to run this code, i would be very greatful to you.

Thank You,
sriups
Attached Files
File Type: zip working.zip (12.6 KB, 5 views)
Reply With Quote Quick reply to this message  
Reply
1 2

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the JSP Forum
Thread Tools Search this Thread



apache backbutton combobox connection database development directorystructure dynamicpagetitles eclipse frames glassfish ie8 imagetodatabse imageupload integer internet java javaee javascript jsf jsp jsppagetitles levels mvc2 mvcmodel2 network parameters passing ping printinserverinsteadofclient redirect request.getparameter response servlet servletdopost()readxml sessions software ssl state_saving_method stocks sun tomcat tutorial update video web
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC