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...View Answers
July 28, 2010 at 12:35 PM
Hi Friend,
Try the following code:
<%@page import="java.sql.*"%>
<html>
<script>
function hello(){
var w = document.form.sel.selectedIndex;
var value = document.form.sel.options[w].text;
window.location.replace("select.jsp?st="+value);
}
</script>
<form name="form">
Select Employee Name:<select name="sel">
<option value="-1"><--Select--></option>
<option value="Angelina">Angelina</option>
<option value="Martina">Martina</option>
<option value="Julia">Julia</option>
<option value="Angel">Angel</option>
</select>
<input type="button" value="submit" onclick="hello();">
</form>
<%
String str=request.getParameter("st");
if(str!=null){
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test";, "root", "root");
Statement st = conn.createStatement();
ResultSet rs=st.executeQuery("Select * from employee where name='"+str+"'");
while(rs.next()){
out.println("Name= "+rs.getString("name")+"<br>");
out.println("Address= "+rs.getString("address")+"<br>");
out.println("Contact No= "+rs.getString("contactNo")+"<br>");
out.println("Email= "+rs.getString("email"));
}
}
catch(Exception e){}
}
%>
Thanks
Try the following code:
<%@page import="java.sql.*"%>
<html>
<script>
function hello(){
var w = document.form.sel.selectedIndex;
var value = document.form.sel.options[w].text;
window.location.replace("select.jsp?st="+value);
}
</script>
<form name="form">
Select Employee Name:<select name="sel">
<option value="-1"><--Select--></option>
<option value="Angelina">Angelina</option>
<option value="Martina">Martina</option>
<option value="Julia">Julia</option>
<option value="Angel">Angel</option>
</select>
<input type="button" value="submit" onclick="hello();">
</form>
<%
String str=request.getParameter("st");
if(str!=null){
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test";, "root", "root");
Statement st = conn.createStatement();
ResultSet rs=st.executeQuery("Select * from employee where name='"+str+"'");
while(rs.next()){
out.println("Name= "+rs.getString("name")+"<br>");
out.println("Address= "+rs.getString("address")+"<br>");
out.println("Contact No= "+rs.getString("contactNo")+"<br>");
out.println("Email= "+rs.getString("email"));
}
}
catch(Exception e){}
}
%>
Thanks
July 28, 2010 at 5:04 PM
thanks a lot... this code solve my problem...
Related Tutorials/Questions & Answers:
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
Advertisements
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
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 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
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
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.*"%>
Dependant Dropdown Lists
Dependant Dropdown Lists Hello, I'm trying to create 2 dropdown lists. When the visitor chooses one option from the 1st list it will automatically update the 2nd dropdown. Ive already found some code which i edited but still
Dependant Dropdown Lists Hello, I'm trying to create 2 dropdown lists. When the visitor chooses one option from the 1st list it will automatically update the 2nd dropdown. Ive already found some code which i edited but still
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
html dropdown not working firefox
html dropdown not working firefox I am writing a Dropdown code in HTML which is not working in firefox. What could be the reason as it's perfectly working in IE and Crome. Thanks
html dropdown not working firefox I am writing a Dropdown code in HTML which is not working in firefox. What could be the reason as it's perfectly working in IE and Crome. Thanks
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
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... item in dropdown menu is 10 then the second dropdown box should contain values
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... item in dropdown menu is 10 then the second dropdown box should contain values
ajax+dropdown+table format
ajax+dropdown+table format HI, i am looking for an ajax application which must contain two dropdown list.In first dropdown if i select a manager name from the first dropdown all the reporties under the selected manager should
ajax+dropdown+table format HI, i am looking for an ajax application which must contain two dropdown list.In first dropdown if i select a manager name from the first dropdown all the reporties under the selected manager should
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
parent and child dropdown
parent and child dropdown Hi, I have one scenario in spring,i need to populate child drop down,based on parent dropdown using spring mvc and ajax... know how to use it in child drop down.How to set that child dropdown in success
parent and child dropdown Hi, I have one scenario in spring,i need to populate child drop down,based on parent dropdown using spring mvc and ajax... know how to use it in child drop down.How to set that child dropdown in success
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
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
dropdown list in jsf
dropdown list in jsf I want to add a list box to display the country name from the lists on all countries.When I select for e.g India then in the second list box it will display the states related to India only and the flow
dropdown list in jsf I want to add a list box to display the country name from the lists on all countries.When I select for e.g India then in the second list box it will display the states related to India only and the flow
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
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
Label n Dropdown Issue
Label n Dropdown Issue Hi guys, Some how Iam able to receive the data for labels, dropdowns. I created one array with the size of label... with corresponding labels... the last dropdown is overriding the previous one... below
Label n Dropdown Issue Hi guys, Some how Iam able to receive the data for labels, dropdowns. I created one array with the size of label... with corresponding labels... the last dropdown is overriding the previous one... below
Dropdown and label issue
Dropdown and label issue This is Venkat from Hyderabad,India.Working as a JavaDeveloper herein. Could you please read the code n give your valuable... to display the dropdowns with corresponding labels... the last dropdown
Dropdown and label issue This is Venkat from Hyderabad,India.Working as a JavaDeveloper herein. Could you please read the code n give your valuable... to display the dropdowns with corresponding labels... the last dropdown
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 - 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 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
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
Dropdown menus onchange atribute
Dropdown menus onchange atribute Can I know how do we get the drop... from database and store it into dropdown list. On selecting the value from the first dropdown, the values will get stored into another dropdown from the database
Dropdown menus onchange atribute Can I know how do we get the drop... from database and store it into dropdown list. On selecting the value from the first dropdown, the values will get stored into another dropdown from the database
multiple dropdown issue
multiple dropdown issue This is Venkat from Hyderabad,India.Working... was not able to display the dropdowns with corresponding labels... the last dropdown... variables, and submit, then the last variable and its corresponding dropdown
multiple dropdown issue This is Venkat from Hyderabad,India.Working... was not able to display the dropdowns with corresponding labels... the last dropdown... variables, and submit, then the last variable and its corresponding dropdown
change navbar dropdown color in bootstrap
change navbar dropdown color in bootstrap How to change the color of navbar dropdown color in a bootstrap based menu in a website? Thanks ...-default .navbar-nav .open .dropdown-menu>li>a,.navbar-default .navbar-nav
change navbar dropdown color in bootstrap How to change the color of navbar dropdown color in a bootstrap based menu in a website? Thanks ...-default .navbar-nav .open .dropdown-menu>li>a,.navbar-default .navbar-nav
Retrieval of Dropdown list
Retrieval of Dropdown list Hi frnds... Am having problem... ... for eg, let A1,A2,A3,A4 be the values in dropdown.. if i click A1... dropdown.. Am not able to retrive the name for further process... Pls check
Retrieval of Dropdown list Hi frnds... Am having problem... ... for eg, let A1,A2,A3,A4 be the values in dropdown.. if i click A1... dropdown.. Am not able to retrive the name for further process... Pls check
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
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
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 - 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
DropDown Department Login
DropDown Department Login Hi all, I am doing a project using JSP. My Issue is..... I have two departments name Customs and Accounts in the database with different tables. I have designed the HTML page in such a way the I have
DropDown Department Login Hi all, I am doing a project using JSP. My Issue is..... I have two departments name Customs and Accounts in the database with different tables. I have designed the HTML page in such a way the I have
. Display JavaScript dropdown selected value
. Display JavaScript dropdown selected value How to get the selected value from dropdown box? I am using javascript. <html> <...("dropdown").value; alert("You selected : " + dropdownValue); } <
. Display JavaScript dropdown selected value How to get the selected value from dropdown box? I am using javascript. <html> <...("dropdown").value; alert("You selected : " + dropdownValue); } <
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
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
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
dropdown list and text fields in php
dropdown list and text fields in php How could I use php to populate text fields by selecting a name of a business from dropdown list? Those text fields that will be populated by information in regards its company name, suite
dropdown list and text fields in php How could I use php to populate text fields by selecting a name of a business from dropdown list? Those text fields that will be populated by information in regards its company name, suite
getting values from dropdown list
getting values from dropdown list I am having a dropdown list which has hardcoded values ( we need it hardcoded only and will not be populated from the database) My question is when i select a particular value it should be pass
getting values from dropdown list I am having a dropdown list which has hardcoded values ( we need it hardcoded only and will not be populated from the database) My question is when i select a particular value it should be pass
how to set value of dropdown list
how to set value of dropdown list Hello Sir, I'd solved the earlier problems somehow but now this time another problem arised when I want to pass the value from a link to a dropdown list. I want to set the dropdown list selected
how to set value of dropdown list Hello Sir, I'd solved the earlier problems somehow but now this time another problem arised when I want to pass the value from a link to a dropdown list. I want to set the dropdown list selected
how to set value of dropdown list
how to set value of dropdown list Hello Sir, I'd solved the earlier problems somehow but now this time another problem arised when I want to pass the value from a link to a dropdown list. I want to set the dropdown list selected
how to set value of dropdown list Hello Sir, I'd solved the earlier problems somehow but now this time another problem arised when I want to pass the value from a link to a dropdown list. I want to set the dropdown list selected
Version of com.mobileia>mc-dropdown-menu dependency
List of Version of com.mobileia>mc-dropdown-menu dependency
List of Version of com.mobileia>mc-dropdown-menu dependency
ModuleNotFoundError: No module named 'mkdocs-rtd-dropdown'
ModuleNotFoundError: No module named 'mkdocs-rtd-dropdown' Hi, My... named 'mkdocs-rtd-dropdown' How to remove the ModuleNotFoundError: No module named 'mkdocs-rtd-dropdown' error? Thanks Hi
ModuleNotFoundError: No module named 'mkdocs-rtd-dropdown' Hi, My... named 'mkdocs-rtd-dropdown' How to remove the ModuleNotFoundError: No module named 'mkdocs-rtd-dropdown' error? Thanks Hi
ModuleNotFoundError: No module named 'dash-dropdown-tree-select'
ModuleNotFoundError: No module named 'dash-dropdown-tree-select' Hi...: No module named 'dash-dropdown-tree-select' How to remove the ModuleNotFoundError: No module named 'dash-dropdown-tree-select' error? Thanks
ModuleNotFoundError: No module named 'dash-dropdown-tree-select' Hi...: No module named 'dash-dropdown-tree-select' How to remove the ModuleNotFoundError: No module named 'dash-dropdown-tree-select' error? Thanks
ModuleNotFoundError: No module named 'django-cascading-dropdown-widget'
ModuleNotFoundError: No module named 'django-cascading-dropdown-widget' ...: ModuleNotFoundError: No module named 'django-cascading-dropdown-widget' How to remove the ModuleNotFoundError: No module named 'django-cascading-dropdown-widget'
ModuleNotFoundError: No module named 'django-cascading-dropdown-widget' ...: ModuleNotFoundError: No module named 'django-cascading-dropdown-widget' How to remove the ModuleNotFoundError: No module named 'django-cascading-dropdown-widget'
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
dropdown to vert. scrollbar - Java Beginners
dropdown to vert. scrollbar can u please help me how to change a dropdown into scrollbar when we resize th window in java script Hi friend, drop down example var messages = new Array(6); messages[0
dropdown to vert. scrollbar can u please help me how to change a dropdown into scrollbar when we resize th window in java script Hi friend, drop down example var messages = new Array(6); messages[0
Ads