By dropdownlist retrive data from database and show in textbox in jsp.

Hello Sir, I am doing project in jsp.I have to retrive data from database, when I select value from dropdownlist, and that data I want to show in textbox. Please suggest some ajax code that will work. your suggestion will be helpful for me .And thanks in advance.

View Answers

December 20, 2010 at 5:58 PM

Hi Friend,

Try the following code:

1)selectname.jsp:

<html>
<head>
<script type="text/javascript">
function showEmp(emp_value){ 
 if(document.getElementById("address").value!="-1"){
 xmlHttp=GetXmlHttpObject()
if (xmlHttp==null){
 alert ("Browser does not support HTTP Request")
 return
 }
var url="getvalue.jsp"
url=url+"?name="+emp_value
xmlHttp.onreadystatechange=stateChanged 
xmlHttp.open("GET",url,true)
xmlHttp.send(null)
}
else{
 alert("Please Select Employee Id");
}
}
function stateChanged(){ 
document.getElementById("email").value ="";
document.getElementById("address").value ="";
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete") { 
var showdata = xmlHttp.responseText; 
    var strar = showdata.split(":");
if(strar.length==1){
  document.getElementById("address").focus();
  alert("Please Select Employee Id");
  document.getElementById("email").value =" ";
document.getElementById("address").value =" ";
 }
 else if(strar.length>1) {
var strname = strar[1];
document.getElementById("address").value= strar[1];
document.getElementById("email").value= strar[2];
 }
 } 
}

function GetXmlHttpObject(){
var xmlHttp=null;
try{
 xmlHttp=new XMLHttpRequest();
 }
catch (e) {
 try {
  xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
  }
 catch (e)  {
  xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
 }
return xmlHttp;
}
</script>
</head>
<body>
<form name="employee">
<br><br>
<table border="0" width="400px" align="center" bgcolor="#CDFFFF">
<div id="mydiv"></div>
   <tr><td><b>Select Employee Name</b></td><td> 
   <select name="name" onchange="showEmp(this.value);">
   <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>
</td></tr>
<tr><td ><b>Employee Address:</b></td><td>
<input  type="text" name="address" id="address" value=""></td></tr>
<tr><td><b>Employee Email:</b></td><td>
<input  type="text" name="email" id="email" value=""></td></tr>

</table>
</form>    
<table border="0" width="100%" align="center">
<br>
<br>
</table>
</body>
</html>

2)getvalue.jsp:

<%@page import="java.sql.*"%>
<%
String emp_id = request.getParameter("name").toString();
String data="";
Connection conn = null;
String url = "jdbc:mysql://localhost:3306/";
String dbName = "test";
String driver = "com.mysql.jdbc.Driver";
String userName = "root"; 
String password = "root";

int sumcount=0; 
Statement st;
try {
Class.forName(driver).newInstance();

conn = DriverManager.getConnection(url+dbName,userName,password);
String query = "select * from employee where name='"+emp_id+"'";

st = conn.createStatement();
ResultSet rs = st.executeQuery(query);
while(rs.next())
{
data = ":" + rs.getString("address") +":"+  rs.getString("email");
}
out.println(data);
}
catch (Exception e) {
e.printStackTrace();
}
%>

3)For the above code, we have created following table:

CREATE TABLE `employee` (               
            `id` bigint(255) default NULL,        
            `name` varchar(255) default NULL,     
            `address` varchar(255) default NULL,  
            `contactNo` int(255) default NULL,    
            `email` varchar(255) default NULL     
          )

Thanks

January 20, 2012 at 12:27 PM

sorry this code is not working, i can't select an employ id...? can u help me.. ?

Advertisements

how to get data from database into dropdownlist in jsp
how to get data from database into dropdownlist in jsp //Customer Name: <select name="name"> <% try{ Class.forName...="select * from staff"; ResultSet rs=st.executeQuery(sql); while(rs.next

how to get data from database into dropdownlist in jsp
how to get data from database into dropdownlist in jsp Can anybody tell me what is the problem in this code as i am not able to fetch the data from... tutorial go through the link JSP Get Data Into Dropdown list From Database �

how to get data from database into dropdownlist in jsp
how to get data from database into dropdownlist in jsp Customer Name:<select name="name"> <% try{ Class.forName...=con.createStatement(); String sql="select * from staff"; ResultSet rs

retrive data from database?
retrive data from database? hellow i have a database sheet name..... now i want retrive sn,roll no and name and textbox like....,rllno,and name retrive

retrive data from database using jsp in struts?
retrive data from database using jsp in struts? *search.jsp* <%@taglib uri="http://struts.apache.org/tags-html" prefix="html"%> <... searchProduct(SearchDTO sdto) { String query="select * from product

dynamic retrival of data from mysql database to dropdownlist in jsp
dynamic retrival of data from mysql database to dropdownlist in jsp Hello, Am having problem in my project... i want to retrive the data from mysql database to the dropdownlist in jsp. Example: 1st i want to display the list

To retrive data from database - Struts
To retrive data from database How to get values ,when i select a select box in jsp and has to get values in textbox automatically from database? eg... come to jsp page automatically from database

how to get data using dropdownlist, textbox and search button in jsp
how to get data using dropdownlist, textbox and search button in jsp Hi, I want to display data using jsp,javascript and mysql. My Q. is If i select an entry suppose 'title' from dropdownlist and give a title name 'partial dif

retrive data from database
retrive data from database hi.. i made a application form. it's have attribute s.no,name,roll no and i enter a few records. now i want to view all record not in database access sheet i want to view it at any another

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

url parameter using retrive data from database in jsp
url parameter using retrive data from database in jsp The user can... clicks the Preview button, you have to create a dynamic jsp which should read the contents from the db based on the event id. But this jsp url should be a public url

url parameter using retrive data from database in jsp
url parameter using retrive data from database in jsp the user can... clicks the Preview button, you have to create a dynamic jsp which should read the contents from the db based on the event id. But this jsp url should be a public

GWT -- retrive the data from Database
GWT -- retrive the data from Database the user can create an event... button, you have to create a dynamic jsp which should read the contents from the db based on the event id. But this jsp url should be a public url. Means anyone

retrieving data from database to the textbox depending upon the id in jsp
retrieving data from database to the textbox depending upon the id in jsp Hi, our project involves fetching of data from database into textbox depending upon another textbox value which is productid.First the id entered by us

display data from database on selecting option of dropdownlist
display data from database on selecting option of dropdownlist Sir I want to display data from database by just selecting option of dropdown list... is that to display image from database in a grid format or in a fixed column and row

display data from database in textbox when id entered in textbox
display data from database in textbox when id entered in textbox i wanted to enter data in textbox .depending on entered data in textbox data from database should be displayed dynamically in textbox

Getting Textbox data from database
Getting Textbox data from database When i m trying to get data in textbox as readonly from database i m getting following error.and my code is shown... data from database and display it on the textboxes. <%@page language="java

Retrive data from database and perform binary tree operations on that data in jsp or java
Retrive data from database and perform binary tree operations on that data in jsp or java To develop code for MLM project. I want to retrieve data from database dynamically and perform operations on that. Just like calculate

Getting Textbox data from database
;Here is a jsp code that retrieves data from database and display...Getting Textbox data from database When i m trying to get data in textbox as readonly from database i m getting following error.and my code is shown

retrive data from oracle to jsp
retrive data from oracle to jsp i am a beginer in jsp so please help... cost and manager name and storing it in the data base. in search proj fiel...(); psmt= conn.prepareStatement("select * from CR_EMPLOYEE_DETAILS

how to retrive data grom database in jsp pages.
how to retrive data grom database in jsp pages. sir, i have problem to retrieve data from table of the database on the html web pages , so would... immediately. i want sample code of jsp to retrieving data from table of database to html

retrive the employee details with image from mysql database using jsp servlet
retrive the employee details with image from mysql database using jsp servlet im doing the web project to retrive the employee profile which i stored in the database using jsp servlet then want to show the result in the next jsp

retrive image from database using jsp without stream
retrive image from database using jsp without stream How to retrive image from database using jsp without stream like (inputStream

insert and retrive image from sql server database in jsp
insert and retrive image from sql server database in jsp what is the code to insert and retrive an image from sql server database in jsp

how to insert data into database using jsp & retrive
how to insert data into database using jsp & retrive Hello, I have created 1 html page which contain username, password & submit button. in my oracle10G database already contain table name admin which has name, password

select value from autocomplete textbox using jquery in jsp from database.
select value from autocomplete textbox using jquery in jsp from database. Hii Sir, Lots of thnx to ur reply .I went through both... of selecting value from autocomplete textbox using jquery in jsp from mysql database

select value from autocomplete textbox using jquery in jsp from database.
select value from autocomplete textbox using jquery in jsp from database.�... but was unable to find out exact way to fullfill the solution of selecting value from autocomplete textbox using jquery in jsp from mysql database. Kindly send me

Use of Select Box to show the data from database
Use of Select Box to show the data from database �... from database This example will describe you the use of Select Box in a JSP page to show the data fetched from the database. We are using Servlet to get data

how to show data in database ?
how to show data in database ? how to show the data in the database to the user in the textbox so that user can modify it and save it again

How to insert data from a combobox and textbox values into DB using JSP?
How to insert data from a combobox and textbox values into DB using JSP? hi, How to insert a comb-box and a text box values in to DB using JSP? @DB:student; @table:stu_info; Combobox values:(class1,class2,class3); textbox1

how to retrive the particular data from database in php with mysql?
how to retrive the particular data from database in php with mysql? �..._db("samp", $con); $Name=$_POST['unames']; $data=mysql_query("SELECT * FROM tbl_sample where Name='$Name'"); /*$info=mysql_fetch_array($data);*/ while

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>

dynamic retrivel of data from mysql database in table format at jsp
the data from database and display it as table format in jsp... For example, i have...dynamic retrivel of data from mysql database in table format at jsp �... of A1 should be retrived from database and display it in the respective textbox

how to display data from database in jsp
how to display data from database in jsp how to display data from database in jsp

data are not display in JSP from database - JSP-Servlet
data are not display in JSP from database i want to finding some data through a SQL query from SQL server database to a JSP page based on some... of this jsp page. like.. School Result and three request parameters 'class', 'from

store and retrive image from the database
store and retrive image from the database please provide me... to store and retreive images from sql database using sql commands -how to store and retreive images from sql database using asp.net/c# thanks in advance

Dynamically Update textbox from database
Dynamically Update textbox from database I have a database as shown below.(database created using SQL Server 2005) name : george,simon address... to that typed value from database has to be displayed in another text box

Display Data from Database in JSP
, to show data from the database click on the link that calls another .jsp file named... page,that calls this jsp page and show all data from the table. ADS...; <font size="4" color="blue">show data from table<

retrive article from sql databse and show using php
retrive article from sql databse and show using php hello sir i have sql database which i store articles.i want to show these article... code only for show these content

How to Autogenerate of ID from database and show on JSP page?
How to Autogenerate of ID from database and show on JSP page? problem in web application : I have a database names tasks in SQL server 2005 having tasks id as primay key, I am using JSP and struts for database connectivity,Now I

How to Autogenerate of ID from database and show on JSP page?
How to Autogenerate of ID from database and show on JSP page? �... tasks id as primay key, I am using JSP and struts for database connectivity,Now I can update my database but i want to autogenerate tasks id in numbers on JSP

populating textbox value from the database using onchange function,
populating textbox value from the database using onchange function, �... selecting from dropdownlist. i have a form in jsp n I created the dropdown list.... but the next textbox value is populated from database. plz help me guys

how to retreive values from MS Access Database based on the values entered in textbox values in jsp file
Solution field from database and display in the textbox of the jsp. 1...how to retreive values from MS Access Database based on the values entered in textbox values in jsp file Hi am new to java. i need to create

Ads