jsp dropdown
in my table there are 3 fields named orderid ,itemname, itemqty. i want code that fetch orderid in dropdown... on select dropdown get all items list of that orderid... there are multiple items at one orderid...View Answers
September 2, 2010 at 2:57 PM
Hi Friend,
Try the following code:
1)orderid.jsp:
<%@page import="java.sql.*"%>
<%@page import="java.util.*"%>
<html>
<head>
<script language="javascript" type="text/javascript">
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= "item.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("item").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/register","root","root";);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("Select * from item");
List myList = new ArrayList();
while(rs.next()){
myList.add(rs.getString(1));
}
Set mySet = new HashSet(myList);
for (Object id : mySet){
%>
<option value="<%=id%>"><%=id%></option>
<%
}
%>
</select>
<br>
<div id='item'>
<select name='item' >
<option value='-1'></option>
</select>
</div>
</body>
</html>
2)item.jsp:
<%@page language="java" import ="java.sql.*" %>
<%
String itemid=request.getParameter("count");
String buffer="<select name='state'><option value='-1'>Select</option>";
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/register","root","root";);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("Select * from item where itemid='"+itemid+"' ");
while(rs.next()){
buffer=buffer+"<option value='"+rs.getString(2)+"'>"+rs.getString(2)+"</option>";
}
buffer=buffer+"</select>";
response.getWriter().println(buffer);
%>
Thanks
Try the following code:
1)orderid.jsp:
<%@page import="java.sql.*"%>
<%@page import="java.util.*"%>
<html>
<head>
<script language="javascript" type="text/javascript">
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= "item.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("item").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/register","root","root";);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("Select * from item");
List myList = new ArrayList();
while(rs.next()){
myList.add(rs.getString(1));
}
Set mySet = new HashSet(myList);
for (Object id : mySet){
%>
<option value="<%=id%>"><%=id%></option>
<%
}
%>
</select>
<br>
<div id='item'>
<select name='item' >
<option value='-1'></option>
</select>
</div>
</body>
</html>
2)item.jsp:
<%@page language="java" import ="java.sql.*" %>
<%
String itemid=request.getParameter("count");
String buffer="<select name='state'><option value='-1'>Select</option>";
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/register","root","root";);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("Select * from item where itemid='"+itemid+"' ");
while(rs.next()){
buffer=buffer+"<option value='"+rs.getString(2)+"'>"+rs.getString(2)+"</option>";
}
buffer=buffer+"</select>";
response.getWriter().println(buffer);
%>
Thanks
Related Tutorials/Questions & Answers:
jsp dropdown - JSP-Servlet
jsp dropdown in my table there are 3 fields named orderid ,itemname, itemqty. i want code that fetch orderid in dropdown... on select dropdown get all items list of that orderid... there are multiple items at one orderid
jsp dropdown in my table there are 3 fields named orderid ,itemname, itemqty. i want code that fetch orderid in dropdown... on select dropdown get all items list of that orderid... there are multiple items at one orderid
jsp dropdown - JSP-Servlet
jsp dropdown print dropdown selected value in same page without refreshing page in jsp.... Hi Friend, Try the following code: 1)selectbox.jsp: var xmlHttp function showState(str
jsp dropdown print dropdown selected value in same page without refreshing page in jsp.... Hi Friend, Try the following code: 1)selectbox.jsp: var xmlHttp function showState(str
Advertisements
dropdown list in jsp
dropdown list in jsp hai, i have static dropdown list.. i want to get the selected value in string variable without jsp regards asha
dropdown list in jsp hai, i have static dropdown list.. i want to get the selected value in string variable without jsp regards asha
checkbox with dropdown listbox in jsp
checkbox with dropdown listbox in jsp i loaded the the data into the drop down listbox in jsp from access database.now i have to add a check box,if it checked means dropdownlist box carryout the data's,else it should
checkbox with dropdown listbox in jsp i loaded the the data into the drop down listbox in jsp from access database.now i have to add a check box,if it checked means dropdownlist box carryout the data's,else it should
jsp dropdown refresh - JSP-Servlet
jsp dropdown refresh Sir Thank u for your jsp code for dependent dropdown list, i used it in different table for data extraction but the probleam during data extraction when i select first drop down its refresh then 2nd
jsp dropdown refresh Sir Thank u for your jsp code for dependent dropdown list, i used it in different table for data extraction but the probleam during data extraction when i select first drop down its refresh then 2nd
creating dropdown lists in jsp
creating dropdown lists in jsp i want to create two dropdown list which are dependent that is the first box choice have to evaluate the second boxs options
creating dropdown lists in jsp i want to create two dropdown list which are dependent that is the first box choice have to evaluate the second boxs options
dropdown - JSP-Servlet
dropdown i have below code for dropdown . now i want to user that textbox value in query at same page... how to get it in a new variable??? function getValue(){ var combo = document.getElementById("sel"); var val
dropdown i have below code for dropdown . now i want to user that textbox value in query at same page... how to get it in a new variable??? function getValue(){ var combo = document.getElementById("sel"); var val
dropdown - JSP-Servlet
dropdown i want to use dropdown select value in query-string in same page.. Using selected 'name' want to fetch details of that person from database.. without using Ajax... Hi Friend, Try the following code
dropdown i want to use dropdown select value in query-string in same page.. Using selected 'name' want to fetch details of that person from database.. without using Ajax... Hi Friend, Try the following code
DropDown in ajax+jsp
DropDown in ajax+jsp I have four dropdown if i select first dd then only corresponding values must be there in 2nd dd,same with 3 and 4... dropdown. You can create the fourth one similarly. For the above code, we have
DropDown in ajax+jsp I have four dropdown if i select first dd then only corresponding values must be there in 2nd dd,same with 3 and 4... dropdown. You can create the fourth one similarly. For the above code, we have
dropdown - JSP-Servlet
dropdown i want to use dropdown select value in query-string in same page.. Using selected 'name' want to fetch details of that person from database.. Hi Friend, Try the following code: 1)ajaxExample.jsp
dropdown i want to use dropdown select value in query-string in same page.. Using selected 'name' want to fetch details of that person from database.. Hi Friend, Try the following code: 1)ajaxExample.jsp
reading dropdown values from properties file in jsp
reading dropdown values from properties file in jsp reading dropdown values from properties file in jsp
reading dropdown values from properties file in jsp reading dropdown values from properties file in jsp
3 dropdown list from the database using JSP
3 dropdown list 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
3 dropdown list 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
jsp- database dependent dropdown list
jsp- database dependent dropdown list i want 2 dropdown list 1... suppose class a the corresponding section dropdown list should retrieve the section respective to that class from database. please help by providing the code in jsp
jsp- database dependent dropdown list i want 2 dropdown list 1... suppose class a the corresponding section dropdown list should retrieve the section respective to that class from database. please help by providing the code in jsp
jsp -sevlet connecting to database using dropdown
jsp -sevlet connecting to database using dropdown How can I get my dropdown list from oracle database and then submit it to another table in JSP. I... it to the JSP to populate the options and when an option is submitted, it send
jsp -sevlet connecting to database using dropdown How can I get my dropdown list from oracle database and then submit it to another table in JSP. I... it to the JSP to populate the options and when an option is submitted, it send
Inserting values into a database table of selected DropDown in jsp.
Inserting values into a database table of selected DropDown in jsp. http://www.roseindia.net/answers/viewqa/Ajax/15250-DropDown-in-ajax+jsp.html Thank you for this program, it helped me alot to learn. I have done it. now i want
Inserting values into a database table of selected DropDown in jsp. http://www.roseindia.net/answers/viewqa/Ajax/15250-DropDown-in-ajax+jsp.html Thank you for this program, it helped me alot to learn. I have done it. now i want
Populate dropdown menu from database using jsp and servlet
Populate dropdown menu from database using jsp and servlet please i need code to populate dropdown menu from mysql database using jsp and servlet. thanks
Populate dropdown menu from database using jsp and servlet please i need code to populate dropdown menu from mysql database using jsp and servlet. thanks
DropDown and text boxes with AJAX, JSP - Ajax
DropDown and text boxes with AJAX, JSP Hi, we are using one drop... present. we are already using jsp's and java technology. can we integrate ajax in jsp's to achieve the same? if so could you please guide me to achive the same
DropDown and text boxes with AJAX, JSP Hi, we are using one drop... present. we are already using jsp's and java technology. can we integrate ajax in jsp's to achieve the same? if so could you please guide me to achive the same
getting and storing dropdown list in database in jsp
getting and storing dropdown list in database in jsp i have a drop down list to select book from database. i'm able to retrieve dropdown list from database. but unable to store the selected value in database table. please help
getting and storing dropdown list in database in jsp i have a drop down list to select book from database. i'm able to retrieve dropdown list from database. but unable to store the selected value in database table. please help
How to access Contacts from gmail using LDAP in JSP dropdown list
How to access Contacts from gmail using LDAP in JSP dropdown list HI, I am creating a JSP page in which i have to make a dropdown box, and access gmail contacts in that drop downlist using LDAP. Can any one plz help me out
How to access Contacts from gmail using LDAP in JSP dropdown list HI, I am creating a JSP page in which i have to make a dropdown box, and access gmail contacts in that drop downlist using LDAP. Can any one plz help me out
How to backup a selected file from the dropDown Menu in JSP?
How to backup a selected file from the dropDown Menu in JSP? I am trying to create a dropdown menu list for some type of files contained ina... file into the backup directory. I need the jsp code that can generate
How to backup a selected file from the dropDown Menu in JSP? I am trying to create a dropdown menu list for some type of files contained ina... file into the backup directory. I need the jsp code that can generate
how to use dropdown list in JSP and display value in same page
how to use dropdown list in JSP and display value in same page I have a Dropdown list with some values say "A", "B" and "C" When the user selects... in the same page Value selected = C How can we do this in a JSP page
how to use dropdown list in JSP and display value in same page I have a Dropdown list with some values say "A", "B" and "C" When the user selects... in the same page Value selected = C How can we do this in a JSP page
dropdown
dropdown I have a dropdown having 2 options-"Open"& "closed".When i select "open" option the related rows of data are retrieved from database and same with the other option.My database is Mysql and coding in PHP
dropdown I have a dropdown having 2 options-"Open"& "closed".When i select "open" option the related rows of data are retrieved from database and same with the other option.My database is Mysql and coding in PHP
how to add data dynamically from database into a dropdown list in a jsp
how to add data dynamically from database into a dropdown list in a jsp hi friends i am doing a project in jsp and oracle as my database.In my... and department fields also.I have a create an jsp page in which there should 2 drop down
how to add data dynamically from database into a dropdown list in a jsp hi friends i am doing a project in jsp and oracle as my database.In my... and department fields also.I have a create an jsp page in which there should 2 drop down
JSP Get Data Into Dropdown list From Database
JSP Get Data Into Dropdown list From Database In this section we will discuss about how to fetch data dynamically into the dropdown list in JSP... fetching of data into the dropdown list in JSP using Eclipse IDE and the Tomcat 7
JSP Get Data Into Dropdown list From Database In this section we will discuss about how to fetch data dynamically into the dropdown list in JSP... fetching of data into the dropdown list in JSP using Eclipse IDE and the Tomcat 7
jsp login code when username , password and dropdown box value is correct...
jsp login code when username , password and dropdown box value is correct... my project has login in whic i should select the company name in dropdown box.... so when i login i all the three username,password and dropdown box
jsp login code when username , password and dropdown box value is correct... my project has login in whic i should select the company name in dropdown box.... so when i login i all the three username,password and dropdown box
jsp login code when username , password and dropdown box value is correct...
jsp login code when username , password and dropdown box value is correct... my project has login in which i should select the company name in dropdown box.... so when i login i all the three username,password and dropdown box
jsp login code when username , password and dropdown box value is correct... my project has login in which i should select the company name in dropdown box.... so when i login i all the three username,password and dropdown box
populating one dropdown box depending on the value of other using jsp
populating one dropdown box depending on the value of other using jsp HI i have scenario i need to populating one dropdown box depending... in dropdown box one after the other CREATE TABLE CITY_MASTER( CITYID BIGINT
populating one dropdown box depending on the value of other using jsp HI i have scenario i need to populating one dropdown box depending... in dropdown box one after the other CREATE TABLE CITY_MASTER( CITYID BIGINT
how can i send a mail to a particular user from a many user dropdown list in jsp
how can i send a mail to a particular user from a many user dropdown list in jsp how can i a sent a user question to a particular person from a drop down list in jsp
how can i send a mail to a particular user from a many user dropdown list in jsp how can i a sent a user question to a particular person from a drop down list in jsp
dropdown box
dropdown box i need to have country,state and city in drop down box using ajax and use db2 database Have a look at the following link: JSP dependent dropdown
dropdown box i need to have country,state and city in drop down box using ajax and use db2 database Have a look at the following link: JSP dependent dropdown
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... to create 3 drop dropdown list each depend on the other and get the options from the database using JSP. like country,state,city..please guide me
Hi, I'm new to JSP I want to create 3 dropdown list each depend on the other... to create 3 drop dropdown list each depend on the other and get the options from the database using JSP. like country,state,city..please guide me
inserting dropdown values into database table
inserting dropdown values into database table hi i want to insert dropdown values into a database table by using jsp
inserting dropdown values into database table hi i want to insert dropdown values into a database table by using jsp
DropDown Menu
DropDown Menu Hello, i have a program that can view,add,delete... me draw to your my mind my program.. in my homepage which i have a dropdown... is the problem.. for example; if i select page 1 in my dropdown menu, and click
DropDown Menu Hello, i have a program that can view,add,delete... me draw to your my mind my program.. in my homepage which i have a dropdown... is the problem.. for example; if i select page 1 in my dropdown menu, and click
store dropdown box values in database server
store dropdown box values in database server how to store dropdown box values in database server in jsp
store dropdown box values in database server how to store dropdown box values in database server in jsp
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
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
fetch values in dropdown
fetch values in dropdown in my application i want fetch dropdown values in jsp page through servlet. means i have to fetch the database fields values in array variable of servlet and then i have to print those values in dropdown
fetch values in dropdown in my application i want fetch dropdown values in jsp page through servlet. means i have to fetch the database fields values in array variable of servlet and then i have to print those values in dropdown
Dropdown Checkbox list
({}); Now create "dropdown_checkboxresult.jsp" jsp file under...Dropdown Checkbox list This tutorial explains how to create jquery Dropdown Checkbox list in JSP. This example is created in eclipse IDE and run
({}); Now create "dropdown_checkboxresult.jsp" jsp file under...Dropdown Checkbox list This tutorial explains how to create jquery Dropdown Checkbox list in JSP. This example is created in eclipse IDE and run
Ajax Dropdown
Ajax Dropdown hi I have One Dropdown that contains 2 options assume A and B,if i select A option then samepage one more Dropdown is their it should display values in german language using DWRUtil Parameter values in ajax. Only
Ajax Dropdown hi I have One Dropdown that contains 2 options assume A and B,if i select A option then samepage one more Dropdown is their it should display values in german language using DWRUtil Parameter values in ajax. Only
DropDown list
DropDown list how to get mysql database values into dropdown usign java servlet and ajax? Here is a jsp code that displays the database values into dropdown list. 1)country.jsp: <%@page import="java.sql.*"%>
DropDown list how to get mysql database values into dropdown usign java servlet and ajax? Here is a jsp code that displays the database values into dropdown list. 1)country.jsp: <%@page import="java.sql.*"%>
dropdown cacheing
dropdown cacheing I need code to create cache for load drop down list from db in struts1 example
dropdown cacheing I need code to create cache for load drop down list from db in struts1 example
struts dropdown list
struts dropdown list In strtus how to set the dropdown list values from database ? I have a ArrayList object and set this object in dropdown jsp page using struts ? please send me jsp code... sample code: **Action
struts dropdown list In strtus how to set the dropdown list values from database ? I have a ArrayList object and set this object in dropdown jsp page using struts ? please send me jsp code... sample code: **Action
binding data with textbox on dropdown click
binding data with textbox on dropdown click Hello friends,Divyesh here. i have jsp page and i would like to bind data with text box on dropdown click. in dropdown employee id are load.and when we select perticular id than how
binding data with textbox on dropdown click Hello friends,Divyesh here. i have jsp page and i would like to bind data with text box on dropdown click. in dropdown employee id are load.and when we select perticular id than how
dropdown in struts - Struts
dropdown in struts how to populate a drop down from database entries in struts application when i have the workflow as jsp->acton->Business Delegator->controller->Business object->DAO->database. Where should i
dropdown in struts how to populate a drop down from database entries in struts application when i have the workflow as jsp->acton->Business Delegator->controller->Business object->DAO->database. Where should i
Dropdown and label issue
Dropdown and label issue This is Venkat from Hyderabad,India.Working... suggestions.. Technologies I used are Java, J2ee, jsp,Servlets, Javascript... to display the dropdowns with corresponding labels... the last dropdown
Dropdown and label issue This is Venkat from Hyderabad,India.Working... suggestions.. Technologies I used are Java, J2ee, jsp,Servlets, Javascript... to display the dropdowns with corresponding labels... the last dropdown
Select DropDown Default
Select DropDown Default Hi there, i have a program in JSP where i... of the record, in my jsp page i have a one dropdown menu where the user can choose, i.e if the user select PAGE 1 in the dropdown menu, it will display all
Select DropDown Default Hi there, i have a program in JSP where i... of the record, in my jsp page i have a one dropdown menu where the user can choose, i.e if the user select PAGE 1 in the dropdown menu, it will display all
jsp - JDBC
jsp -------------------------------------------------------------------------------- how to receive data into jsp from html for dropdown boxes
jsp -------------------------------------------------------------------------------- how to receive data into jsp from html for dropdown boxes
multiple dropdown issue
multiple dropdown issue This is Venkat from Hyderabad,India.Working... valuable suggestions.. Technologies I used are Java, J2ee, jsp,Servlets, Javascript... was not able to display the dropdowns with corresponding labels... the last dropdown
multiple dropdown issue This is Venkat from Hyderabad,India.Working... valuable suggestions.. Technologies I used are Java, J2ee, jsp,Servlets, Javascript... was not able to display the dropdowns with corresponding labels... the last dropdown
Multiple select dropdown with Ajax
Multiple select dropdown with Ajax This tutorial explains how to create multiple select dropdown with Ajax in JSP and Servlet . This example... database if not exists `multipleselect_dropdown`; USE `multipleselect
Multiple select dropdown with Ajax This tutorial explains how to create multiple select dropdown with Ajax in JSP and Servlet . This example... database if not exists `multipleselect_dropdown`; USE `multipleselect
Dropdown menus onchange atribute
Dropdown menus onchange atribute Can I know how do we get the drop... 11111 mini bus 64537 help me please!!! btw. im using jsp... from database and store it into dropdown list. On selecting the value from
Dropdown menus onchange atribute Can I know how do we get the drop... 11111 mini bus 64537 help me please!!! btw. im using jsp... from database and store it into dropdown list. On selecting the value from
Ads