Dynamic select box
View Answers
December 18, 2009 at 12:25 PM
Hi Friend,
We have used the tables country(country_id(Number),countryname(Text)) and city(cityid(Number),country_id(Text),cityname(Text))
Try the following code:
<%@ page language="java" %>
<%@ page import="java.sql.*" %>
<%!
Connection conn = null;
ResultSet rs =null;
Statement st=null;
String query="";
int cid;
%>
<%
if(request.getParameter("cid")!=null){
cid=Integer.parseInt(request.getParameter("cid"));
}else {
cid=0;
}
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection("jdbc:odbc:access","","");
st = conn.createStatement();
rs = st.executeQuery("select * from country");
%>
<html>
<head>
<script type="text/javascript">
function selectCity(){
var cid=document.getElementById("country").selectedIndex;
window.location.replace("http://localhost:8080/examples/jsp/countrycombo.jsp?cid="+cid);
}
</script>
</head>
<body>
<select id="country" onchange="selectCity(this)">
<option value="0">--Please Select--</option>
<% while(rs.next()){ %>
<option value='<%=rs.getInt("country_id")%>'><%=rs.getString("countryname")%></option>
<%}%>
</select>
<%
rs = st.executeQuery("select * from city where country_id='"+cid+"'");
%>
<select>
<% while(rs.next()){ %>
<option value='<%=rs.getInt("country_id")%>'><%=rs.getString("cityname")%></option>
<%}%>
</select>
</body>
</html>
Thanks
We have used the tables country(country_id(Number),countryname(Text)) and city(cityid(Number),country_id(Text),cityname(Text))
Try the following code:
<%@ page language="java" %>
<%@ page import="java.sql.*" %>
<%!
Connection conn = null;
ResultSet rs =null;
Statement st=null;
String query="";
int cid;
%>
<%
if(request.getParameter("cid")!=null){
cid=Integer.parseInt(request.getParameter("cid"));
}else {
cid=0;
}
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection("jdbc:odbc:access","","");
st = conn.createStatement();
rs = st.executeQuery("select * from country");
%>
<html>
<head>
<script type="text/javascript">
function selectCity(){
var cid=document.getElementById("country").selectedIndex;
window.location.replace("http://localhost:8080/examples/jsp/countrycombo.jsp?cid="+cid);
}
</script>
</head>
<body>
<select id="country" onchange="selectCity(this)">
<option value="0">--Please Select--</option>
<% while(rs.next()){ %>
<option value='<%=rs.getInt("country_id")%>'><%=rs.getString("countryname")%></option>
<%}%>
</select>
<%
rs = st.executeQuery("select * from city where country_id='"+cid+"'");
%>
<select>
<% while(rs.next()){ %>
<option value='<%=rs.getInt("country_id")%>'><%=rs.getString("cityname")%></option>
<%}%>
</select>
</body>
</html>
Thanks
Ads
Related Tutorials/Questions & Answers:
dynamic select box
dynamic select box hello friends i created a form and details of city & locations have to be come from database. if city hyderabad chosen then locations of hyderabad only appear in location selectbox.plz send code it is more
dynamic select box hello friends i created a form and details of city & locations have to be come from database. if city hyderabad chosen then locations of hyderabad only appear in location selectbox.plz send code it is more
dynamic select box
dynamic select box thank u my dear friend.but i have a code like...> <select name="city"> <option>city</option>...) die("access failed"); $select=mysql_select_db("vtigercrm530"); if(!$select
dynamic select box thank u my dear friend.but i have a code like...> <select name="city"> <option>city</option>...) die("access failed"); $select=mysql_select_db("vtigercrm530"); if(!$select
Advertisements
select box and text box validations
select box and text box validations hi, any one please tell me how to set validations for select box and text boxes using bean classes? thank you Please visit the following link: http://www.roseindia.net/jsp/user
select box and text box validations hi, any one please tell me how to set validations for select box and text boxes using bean classes? thank you Please visit the following link: http://www.roseindia.net/jsp/user
Select Box question
Select Box question hello guys, i want to display data in a select box using foreign key,those data will come from other table which which is parent, that form will be in HTML(web ). i use oracle as database and i want using
Select Box question hello guys, i want to display data in a select box using foreign key,those data will come from other table which which is parent, that form will be in HTML(web ). i use oracle as database and i want using
Dynamic check box problem
Dynamic check box problem In my project i have used a dynamic table, in the each row of that table there is one check box [that i have created dynamically]. Now my problem is that i can't access those values from that dynamic
Dynamic check box problem In my project i have used a dynamic table, in the each row of that table there is one check box [that i have created dynamically]. Now my problem is that i can't access those values from that dynamic
Multiple select box
Multiple select box Hi, I need help in code for multiple select box. The multiple select box should be populated with the db values.The selection done in the multiple select box is to be moved to the text area provided a add
Multiple select box Hi, I need help in code for multiple select box. The multiple select box should be populated with the db values.The selection done in the multiple select box is to be moved to the text area provided a add
Drag a Text Box into dynamic positions
Drag a Text Box into dynamic positions Plz can anyone tell how can i drag a text box using mouse or arrow keys... Im doing a accounts projects and i need this feature for cheque configuration
Drag a Text Box into dynamic positions Plz can anyone tell how can i drag a text box using mouse or arrow keys... Im doing a accounts projects and i need this feature for cheque configuration
Select Box Validation in JavaScript
Select Box Validation in JavaScript In this section we will discuss about select box validation in JavaScript. Select box allows you to create drop down list... options. HTML select Box having same functionality as HTML Checkbox Fields
Select Box Validation in JavaScript In this section we will discuss about select box validation in JavaScript. Select box allows you to create drop down list... options. HTML select Box having same functionality as HTML Checkbox Fields
how to operate on select box using ajax in struts2?
how to operate on select box using ajax in struts2? I am doing a project on struts2 in which i have a jsp page which has two select boxes like Now i want to use ajax so that when i select a district value
how to operate on select box using ajax in struts2? I am doing a project on struts2 in which i have a jsp page which has two select boxes like Now i want to use ajax so that when i select a district value
how to operate on select box using ajax in struts2?
how to operate on select box using ajax in struts2? I am doing a project on struts2 in which i have a jsp page which has two select boxes like <... it by assigning to the block list select box. so please help me..its urgent
how to operate on select box using ajax in struts2? I am doing a project on struts2 in which i have a jsp page which has two select boxes like <... it by assigning to the block list select box. so please help me..its urgent
how to display(update) current date and month in select box on selecting the year.
how to display(update) current date and month in select box on selecting the year. how to display(update) current date and month in select box on selecting the year
how to display(update) current date and month in select box on selecting the year. how to display(update) current date and month in select box on selecting the year
How to implement ajax in struts2 to operate on select box in jsp
How to implement ajax in struts2 to operate on select box in jsp I am doing a project on struts2 in which i have a jsp page which has 2 select boxes... by assigning to block list select box... plz help me .. its urgent .. thanx in advance
How to implement ajax in struts2 to operate on select box in jsp I am doing a project on struts2 in which i have a jsp page which has 2 select boxes... by assigning to block list select box... plz help me .. its urgent .. thanx in advance
Insert value of dynamic generated text box in jsp using javascript
Insert value of dynamic generated text box in jsp using javascript hello sir , i want to generate dynamic text box at run time and i did that using... that dynamically generated text box value into database at a time without
Insert value of dynamic generated text box in jsp using javascript hello sir , i want to generate dynamic text box at run time and i did that using... that dynamically generated text box value into database at a time without
Use of Select Box to show the data from database
Use of Select Box to show the data from database Example program using Select Box to show retrieved data from database This example will describe you the use of Select Box in a JSP
Use of Select Box to show the data from database Example program using Select Box to show retrieved data from database This example will describe you the use of Select Box in a JSP
Passing Multi select list box values using ajax to get values to dependent list box
Passing Multi select list box values using ajax to get values to dependent list box Hi, I have a jsp page which has 3 dependent list boxes... the dependent values to the immediate next list box. Please help me
Passing Multi select list box values using ajax to get values to dependent list box Hi, I have a jsp page which has 3 dependent list boxes... the dependent values to the immediate next list box. Please help me
How to write a select box and id should be stored in database?
How to write a select box and id should be stored in database? Hi, How to write a select box and select the name(devi) regarding name id(like 60...); JLabel lab=new JLabel("Select Name:"); final JComboBox combo
How to write a select box and id should be stored in database? Hi, How to write a select box and select the name(devi) regarding name id(like 60...); JLabel lab=new JLabel("Select Name:"); final JComboBox combo
Not Able to select an Item in Spark Combo Box control (Adobe Flex Object) using QTP
Not Able to select an Item in Spark Combo Box control (Adobe Flex Object) using... Flex controls. But i am not able to select any item from Spark Combo Box. I tied using .Open (Its not opening the drop down list) , also i tried using Select
Not Able to select an Item in Spark Combo Box control (Adobe Flex Object) using... Flex controls. But i am not able to select any item from Spark Combo Box. I tied using .Open (Its not opening the drop down list) , also i tried using Select
add text box and select list dynamically and get its value to store it into database using jsp request parameter
add text box and select list dynamically and get its value to store it into database using jsp request parameter its very helpful when you have only... added select box also into next jsp page plz reply me as early as posssible
add text box and select list dynamically and get its value to store it into database using jsp request parameter its very helpful when you have only... added select box also into next jsp page plz reply me as early as posssible
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 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
select one item name throug combo box than other combobox show item price
select one item name throug combo box than other combobox show item price i have one table in database item master..if i select one item name through combo box than other combobox show item price only select item name... how i
select one item name throug combo box than other combobox show item price i have one table in database item master..if i select one item name through combo box than other combobox show item price only select item name... how i
sir plz help in design a jsp page whichis as follow username [_____] select [__>]password [_____] after selection then onlypassword text box is visible
sir plz help in design a jsp page sir plz help in design a jsp page which is as follow username [ _ ] select [ > ] password [ _ ] after selection then only password text box is visible
sir plz help in design a jsp page sir plz help in design a jsp page which is as follow username [ _ ] select [ > ] password [ _ ] after selection then only password text box is visible
JavaScript Combo Box Validation
JavaScript Combo Box Validation This application illustrates how to validate the combo box using JavaScript validation. In this example we create a combo box of different
JavaScript Combo Box Validation This application illustrates how to validate the combo box using JavaScript validation. In this example we create a combo box of different
jquery dependency dropdown box in spring hibernate my sql
jquery dependency dropdown box in spring hibernate my sql Hi Friends, Can you please provide me the code for dynamic drop down box using jquery in spring, hibernate and oracle/mysql database. Like if i select country
jquery dependency dropdown box in spring hibernate my sql Hi Friends, Can you please provide me the code for dynamic drop down box using jquery in spring, hibernate and oracle/mysql database. Like if i select country
dynamic form
dynamic form I need to make a dynamic form using php, for example, i will need a list of items which when we select one option another list... dependent dropdown lists using Ajax. when the user select country name from the first
dynamic form I need to make a dynamic form using php, for example, i will need a list of items which when we select one option another list... dependent dropdown lists using Ajax. when the user select country name from the first
how to select second combobox value .
how to select second combobox value . I requirement is , i have two combo box, i am selected first combo box value then automatically second combo box value show ,But this both combo box value i retrieves in database. please
how to select second combobox value . I requirement is , i have two combo box, i am selected first combo box value then automatically second combo box value show ,But this both combo box value i retrieves in database. please
Dynamic form
Dynamic form I need to make a dynamic form using jsp for example, i will need a list of items which when we select one option another list... list consisting of country names. When the user select any country name
Dynamic form I need to make a dynamic form using jsp for example, i will need a list of items which when we select one option another list... list consisting of country names. When the user select any country 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... to that user in left list.when we select module from left list and click INCLUDE button
combo box Hi, [_|] dropdown box... a screen like this using jsp-servlet(or DAO,DTO),in that drop down box i should get... to that user in left list.when we select module from left list and click INCLUDE button
ModuleNotFoundError: No module named 'box-box'
ModuleNotFoundError: No module named 'box-box' Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'box-box' How to remove the ModuleNotFoundError: No module named 'box-box
ModuleNotFoundError: No module named 'box-box' Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'box-box' How to remove the ModuleNotFoundError: No module named 'box-box
ModuleNotFoundError: No module named 'box-box'
ModuleNotFoundError: No module named 'box-box' Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'box-box' How to remove the ModuleNotFoundError: No module named 'box-box
ModuleNotFoundError: No module named 'box-box' Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'box-box' How to remove the ModuleNotFoundError: No module named 'box-box
dialog box
numeric choice to select answers hello. write an application that displays a series of at least four interview questions and each question should... of the interview, use a dialog box to ask whether the user wants to - enter another set
numeric choice to select answers hello. write an application that displays a series of at least four interview questions and each question should... of the interview, use a dialog box to ask whether the user wants to - enter another set
