jsp drop down-- select Option
how to get drop down populated dynamically
View Answers
October 21, 2010 at 4:26 PM
Hi Friend,
Create table country(country_id,country) in database and try the following code:
<%@page import="java.sql.*"%>
<html>
<form name="form" method="post" >
<b>Select a country:</b> </td>
<select name="sel"><option value=""><---Select---></option>
<%
Class.forName("com.mysql.jdbc.Driver").newInstance();
String connectionURL = "jdbc:mysql://localhost:3306/test";
Connection connection= DriverManager.getConnection(connectionURL, "root", "root");
PreparedStatement psmnt = connection.prepareStatement("select * from country ");
ResultSet results = psmnt.executeQuery();
while(results.next()){
String name = results.getString(2);
String id = results.getString(1);
%><option value="<%= name %>"><%=name%></option>
<%} results.close(); psmnt.close(); %>
</select><br>
</form>
Thanks
October 21, 2010 at 4:49 PM
Hi Friend,
If you want the code in ajax then try the following code:
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= "city.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)city.jsp:
<%@page language="java" import ="java.sql.*" %>
<%
String country=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/test","root","root");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("Select * from city where countryid='"+country+"' ");
while(rs.next()){
buffer=buffer+"<option value='"+rs.getString(2)+"'>"+rs.getString(3)+"</option>";
}
buffer=buffer+"</select>";
response.getWriter().println(buffer);
%>
We have used following database tables:
1)country
CREATE TABLE country (
countryid bigint(30) NOT NULL auto_increment,
countryname varchar(40) default NULL,
PRIMARY KEY (countryid)
)
2)city
CREATE TABLE city (
id bigint(40) NOT NULL auto_increment,
countryid int(100) default NULL,
city varchar(40) default NULL,
PRIMARY KEY (id)
)
The above code populate the second dropdown on selecting the value from the first dropdown.
Thanks
Ads
Related Tutorials/Questions & Answers:
jsp drop down-- select Option
jsp drop down-- select Option how to get drop down populated...;nbsp;</td> <select name="sel"><option value=""><---Select..."); String buffer="<select name='state'><option value='-1'>Select<
jsp drop down-- select Option how to get drop down populated...;nbsp;</td> <select name="sel"><option value=""><---Select..."); String buffer="<select name='state'><option value='-1'>Select<
Add values of drop down menu( select option) to mysql table
Add values of drop down menu( select option) to mysql table Here...['valveId'].'<td>'; echo '<select name="onoff">'; echo '<option value="ON">ON'; echo '</option>'; echo '<option
Add values of drop down menu( select option) to mysql table Here...['valveId'].'<td>'; echo '<select name="onoff">'; echo '<option value="ON">ON'; echo '</option>'; echo '<option
Advertisements
Select functionality of drop down list - Struts
Select functionality of drop down list Hi, I have to write a code(in struts application) in which if user select HIDE from the drop down list... for entering Age,Now if user select "HIDE" from drop-down list the below text
Select functionality of drop down list Hi, I have to write a code(in struts application) in which if user select HIDE from the drop down list... for entering Age,Now if user select "HIDE" from drop-down list the below text
select option with text facility - JSP-Servlet
select option with text facility Hello. My doubt is regarding how to provide facility to add text in a drop down box ie(select tag in html )in a jsp page. Consider we have a drop down list which is dynamically displayed using
select option with text facility Hello. My doubt is regarding how to provide facility to add text in a drop down box ie(select tag in html )in a jsp page. Consider we have a drop down list which is dynamically displayed using
jsp drop down without refresh - JSP-Servlet
jsp drop down without refresh Sir I have tried two depenedent jsp dropdown in jsp page,But the probleam is when i select first drop down its... jsp same probleam also arise. Please tell me how to use the drop down without
jsp drop down without refresh Sir I have tried two depenedent jsp dropdown in jsp page,But the probleam is when i select first drop down its... jsp same probleam also arise. Please tell me how to use the drop down without
JSP Dependent Drop Down Menu
JSP Dependent Drop Down Menu Hey Guy/Gals! I need someone help to guide me in creating a drop down menu, where the first menu affects the second... buffer="<select name='state' ><option value='-1'>Select</option>
JSP Dependent Drop Down Menu Hey Guy/Gals! I need someone help to guide me in creating a drop down menu, where the first menu affects the second... buffer="<select name='state' ><option value='-1'>Select</option>
drop down box - JSP-Servlet
drop down box when i enter some letter in the input box,the corresponding words of that particular letter must be displayed below as a list from the data base in the same input box as drop down. Thanks&Regards, VijayaBabu.M
drop down box when i enter some letter in the input box,the corresponding words of that particular letter must be displayed below as a list from the data base in the same input box as drop down. Thanks&Regards, VijayaBabu.M
Select from drop down and load the appropriate application resource.properties in struts2
Select from drop down and load the appropriate application resource.properties in struts2 I would like to use a dropdown for selecting a language in my application .On selecting a language the appropriate
Select from drop down and load the appropriate application resource.properties in struts2 I would like to use a dropdown for selecting a language in my application .On selecting a language the appropriate
Drop-down text selection in jsp/html
Drop-down text selection in jsp/html Hi, I am trying to create JSP page where I have two drop-downs. There are two-sets of data - First set.... Now the first dropdown will have all the values. The second drop-down depends upon
Drop-down text selection in jsp/html Hi, I am trying to create JSP page where I have two drop-downs. There are two-sets of data - First set.... Now the first dropdown will have all the values. The second drop-down depends upon
dependent drop down box - JSP-Servlet
dependent drop down box haloo sir Please give me the solution how to extract data from dependent drop down box with page refresh...; window.location.replace("http://localhost:8080/examples/jsp/dependentDropdown.jsp?id="+cid+"&&value
dependent drop down box haloo sir Please give me the solution how to extract data from dependent drop down box with page refresh...; window.location.replace("http://localhost:8080/examples/jsp/dependentDropdown.jsp?id="+cid+"&&value
select option value
select option value if i select a value of any drop down then that value should be used in a select query of the next dropdown in jsp???? ...("Select * from country"); while(rs.next()){ %> <option value
select option value if i select a value of any drop down then that value should be used in a select query of the next dropdown in jsp???? ...("Select * from country"); while(rs.next()){ %> <option value
select option value
select option value if i select a value of any drop down then that value should be used in a select query of the next dropdown in jsp on same page... buffer="<select name='state' ><option value='-1'>Select</option>
select option value if i select a value of any drop down then that value should be used in a select query of the next dropdown in jsp on same page... buffer="<select name='state' ><option value='-1'>Select</option>
displaying section in the jsp based on the sected value in drop down - Java Beginners
on the jsp based on the selected value in the drop down list using java script code...displaying section in the jsp based on the sected value in drop down ...; } Drop Dwon list Select
on the jsp based on the selected value in the drop down list using java script code...displaying section in the jsp based on the sected value in drop down ...; } Drop Dwon list Select
select option - JDBC
select option how to dynamically generate the select option values from database
select option how to dynamically generate the select option values from database
jsp login code ... when username , drop down box and password is correct
jsp login code ... when username , drop down box and password is correct i need a jsp code for login.... when username password and dropdown box value is correct.... the drop down box values should be retrieved from database
jsp login code ... when username , drop down box and password is correct i need a jsp code for login.... when username password and dropdown box value is correct.... the drop down box values should be retrieved from database
jsp code for a drop down box to retrive value from database
jsp code for a drop down box to retrive value from database my project needs to get the value from database in to the drop down box..... pls give me code for that ..... tan q 1)login.jsp: <html> <script>
jsp code for a drop down box to retrive value from database my project needs to get the value from database in to the drop down box..... pls give me code for that ..... tan q 1)login.jsp: <html> <script>
how to retrieve the id value itself from the access database to drop down listbox in jsp
access database to drop down list box in jsp...plz send the code for that.....plz <%@page import="java.sql.*"%> <select> <option value...how to retrieve the id value itself from the access database to drop down
access database to drop down list box in jsp...plz send the code for that.....plz <%@page import="java.sql.*"%> <select> <option value...how to retrieve the id value itself from the access database to drop down
dynamic drop down
into the designation drop down (use jsp+javascript+servlet) reply soon 1...dynamic drop down I have created 2 drop downs in jsp.1...; <select onchange="showDesig(this.value)"> <option value="none
into the designation drop down (use jsp+javascript+servlet) reply soon 1...dynamic drop down I have created 2 drop downs in jsp.1...; <select onchange="showDesig(this.value)"> <option value="none
dynamic drop down list
dynamic drop down list I want to create 2 drop down list, where it takes value from database and the two list are dependent..means if I select... on the value chosen from the previous. want code in javascript and jsp, Can you help
dynamic drop down list I want to create 2 drop down list, where it takes value from database and the two list are dependent..means if I select... on the value chosen from the previous. want code in javascript and jsp, Can you help
Login With Drop Down
Login With Drop Down Hi all, I am doing a project using JSP. My... a drop down list consisting of Customs and Accounts. I have user accounts of both the departments. Now, my intention is to select the department from the drop down
Login With Drop Down Hi all, I am doing a project using JSP. My... a drop down list consisting of Customs and Accounts. I have user accounts of both the departments. Now, my intention is to select the department from the drop down
how to set a value of dynamic number of drop down lists on a jsp page and access it value on another jsp page
how to set a value of dynamic number of drop down lists on a jsp page... number of drop down lists(depending upon number of books in that category) on jsp... one setting values of drop down lists and other one accessing it in this jsp
how to set a value of dynamic number of drop down lists on a jsp page... number of drop down lists(depending upon number of books in that category) on jsp... one setting values of drop down lists and other one accessing it in this jsp
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
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
Drop Down reload in IE
Drop Down reload in IE Hi i was using two drop down box..One for Displaying date followed by another for Dispalying Month..If i Select/Change Month from the 2nd drop down then the 1st drop down ( which is date) automatically
Drop Down reload in IE Hi i was using two drop down box..One for Displaying date followed by another for Dispalying Month..If i Select/Change Month from the 2nd drop down then the 1st drop down ( which is date) automatically
Drop down combos
Drop down combos Hi.. How to write a javascript for linked combo...="combo1" onchange="change(this);"> <option value="0">-Select-</option>... language="javascript"> var arr = new Array(); arr[0] = new Array("-select
Drop down combos Hi.. How to write a javascript for linked combo...="combo1" onchange="change(this);"> <option value="0">-Select-</option>... language="javascript"> var arr = new Array(); arr[0] = new Array("-select
How to add another option to the select tag using struts2 tag - Struts
How to add another option to the select tag using struts2 tag Hi, How to add another option to select tag using tag. My scenario is : If the logged in user is admin then drop down should contain the normal list
How to add another option to the select tag using struts2 tag Hi, How to add another option to select tag using tag. My scenario is : If the logged in user is admin then drop down should contain the normal list
How to pass parameter through drop down list using session management in jsp??
How to pass parameter through drop down list using session management in jsp?? How to pass parameter through drop down list in the URL and access it on same jsp page using session management
How to pass parameter through drop down list using session management in jsp?? How to pass parameter through drop down list in the URL and access it on same jsp page using session management
