Jsp doubt

In Employee.jsp form, When i click employee id value in combo box , how i get the related employee name will be displayed in text field?

i already stored combo box values from database.

View Answers

May 25, 2011 at 2:44 PM

1)ajax.jsp:

<%@page import="java.sql.*"%>
<html>
<head>
<script type="text/javascript">
function showData(id){ 

xmlHttp=GetXmlHttpObject()
var url="getdata.jsp";
url=url+"?id="+id;
xmlHttp.onreadystatechange=stateChanged 
xmlHttp.open("GET",url,true)
xmlHttp.send(null)
}
function stateChanged(){ 
if(xmlHttp.readyState==4 || xmlHttp.readyState=="complete"){ 
    var showdata = xmlHttp.responseText; 
    document.getElementById("name").value= showdata;
} 
}
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 >
<div id="mydiv"></div>
<tr><td><b>Select:</b></td><td><select name="id" onchange="showData(this.value);">
<option value="-1">--Select--</option>
   <%
   Class.forName("com.mysql.jdbc.Driver");
           Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
           Statement st=con.createStatement();
           ResultSet rs=st.executeQuery("select * from employee ");
           while(rs.next()){
               %>
               <option value="<%=rs.getInt("id")%>"><%=rs.getInt("id")%></option>
               <%
           }
               %>
               </select></td></tr>

<tr><td><b>Name:</b></td><td><input  type="text" name="name" id="name" ></td></tr>
</table>
</form>    
</body>
</html>

2)getdata.jsp:

<%@ page import="java.sql.*" %> 
<%
int id = Integer.parseInt(request.getParameter("id"));
String data ="";
try{
           Class.forName("com.mysql.jdbc.Driver");
           Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
           Statement st=con.createStatement();
           ResultSet rs=st.executeQuery("select * from employee where id="+id+"");
while(rs.next())
{
data =rs.getString("name");
}
out.println(data);
System.out.println(data);
}
catch (Exception e) {
System.out.println(e);
}
%>

Advertisements

Doubt regarding charts and jsp
Doubt regarding charts and jsp Hi, I successfully executed... in web application(jsp). So,please help me out in how to connect the normal java application output to an jsp page? thanks in advance Put the jar

Doubt regarding charts and jsp
Doubt regarding charts and jsp Hi in the http://www.roseindia.net/chartgraphs/barchart-jsppage.shtml of the code (new StandardEntityCollection()); final File file1 = new File("../webapps/jspchart/web/barchart.png

I have doubt in jsp file.
I have doubt in jsp file. I have doubt in jsp file. In a jsp file, there should be two buttons. One is start and other is stop. When we click on start then only stop should be enabled. Other wise it should be disabled. When

Doubt in servlets - JSP-Servlet
Doubt in servlets Good Evening sir/madam, I want to add data dynamically for that which methods i have to use to retrieve the dynamic data . Hi Friend, Try the following code: 1

JSP basic doubt
JSP basic doubt String user = request.getParameter("username"); in this "user" value is null or not how to validate? before going further action. Hi Friend,ADS_TO_REPLACE_1 Either you can do the following : 1

Clarify my doubt - JSP-Servlet
Clarify my doubt Hi All, Although i know the concept of Servlet & JSP, but I have never got a chance to work in EJB . So could u please tell me how... project in netbeans adding jsp/servlet in this web project and deploying

doubt this
doubt this what is the use of "this" and "super" keyword

DOUBT ?
DOUBT ? in c++ member function of a class must be public

Doubt
Doubt how to submit the details and how to go the next page after submitting.please clarify my doubt I don't know how to submit details

Doubt in using combination of JSP page and Java class. - JSP-Servlet
Doubt in using combination of JSP page and Java class. I've got... be disabled from clicking. How to go about doing this in a "JSP Page using... the data in form bean and used in jsp file. Well first of all thank

Doubt
User request form how to submit the details and how to go the next page after submitting.please clarify my doubt I don't know how to submit details. 1)page1.html: <html> <form type=get action="page2.html

Doubt
How to load page how to submit the details and how to go the next page after submitting.please clarify my doubt I don't know how to submit details. 1)page1.html: <html> <form type=get action="page2.html

Doubt
Submit and process form how to submit the details and how to go the next page after submitting.please clarify my doubt I don't know how to submit details. 1)page1.html: <html> <form type=get action

Doubt
load next page after submitting how to submit the details and how to go the next page after submitting.please clarify my doubt I don't know how to submit details. 1)page1.html: <html> <form type=get action

Validation doubt
Validation doubt hi..... thanks for the other validation code. I have got that and implemented in my code but i have a doubt in that. As we try... think i am able to tell u what i want to and u have got whats my doubt. plz give

doubt on DAO's
doubt on DAO's hai frnds.... can anyoneexplain about how to integrate struts with hibernate,any predifined plugin is available or we need to create our own plugin????? and please help me. how to use dao s while integrating

doubt

Doubt

DOUBT

doubt

Doubt in struts - Struts
Doubt in struts I am new to Struts, Can anybody say how to retrieve data from database and display it in jsp. Some said to use beans but i dont... : http://www.roseindia.net/jsp/paging.shtml Thanks

doubt about J2EE connetivity
doubt about J2EE connetivity steps to connect J2EE components with MYSQL

java beginners doubt!
java beginners doubt! How to write clone()in java strings

doubt in struts - Struts
doubt in struts i don't understand the concept on Resource bundle in struts can u please help me out

String doubt replace function
String doubt replace function What is the output and why of below : String s1 = "Hello"; if(s1.replace('H','H')== "Hello") System.out.println("yes"); else System.out.println("No"); if(s1.replace("H", "H")== "Hello

doubt regarding JSF
doubt regarding JSF Hi, pls explain what is difference between struts &JSF? pls explain what is difference between SPRING &JSF

doubt - Date Calendar
doubt about retrieve dates from Database Retrieve dates from... from the database with some condition in dates in jsp Retrieve data from Database using JSP JSP Example Code for retrieving Data from Database<

"Doubt on Swing" - Java Beginners
"Doubt on Swing" Hi Friend.... Thanks for ur goog Response.. i need to create a GUI Like... pic1.gif RadioButton pic2.gif RadioButton Pic3.gif RadioButton If we have select d appropriate radio

Doubt Regarding Charts
Doubt Regarding Charts Hi, Can you please help me out by answering "hoe to include charts in core java code and struts code" thanks in advance, Swaroop Eswara Please visit the following link: Jfreechart

I have a doubt regarding action - Struts
I have a doubt regarding action hi, I have doubt regarding struts,I got response through jsp and once again it redirecting to action. If anybody knows pls respond me. with regards, Teju Hi friend

Version of com.martiansoftware>hope-and-doubt dependency
List of Version of com.martiansoftware>hope-and-doubt dependency

Doubt on Segmentation - Java Beginners
Doubt on Segmentation Hi .. ImageProcessing.. How to segment the each and every characters from the bitmap image Consider for an example bitmap1.bmp: Visuallc++ text is on bitmap1.bmp..How to extract those from image

DOubt in Mysql connections
DOubt in Mysql connections i have some problem regarding data base connections, i have created a hostname, username and password in filezilla server but after i give those names also it is showing error like this: mysql

Doubt In Sql query
Doubt In Sql query Hi Have a glance @ http://img98.imageshack.us/img98/4348/tableo.png For a single country there may be n numbers of country_notes. I Need to fetch all the distinct records of countries with the latest country

doubt about JMS selector
doubt about JMS selector Hi! , i have a little problem with message selector in JMS api. I'am try develop a request and response with JMS queue, but I didnÃ?Â´t get success. I use this reference site like guide. in my

Doubt about Xstream Converter
Doubt about Xstream Converter Hi, I am using the Xstream freamwork to read a lot of files in a batch operation. I use a custom converter Xstream to read some properties of my Xml file, but when I changed my application

doubt on synchronized block in java
doubt on synchronized block in java Hi ! some people are feeling bore on my regular questions on threads. Do not feel bore on my regular questions.I.... I think you got my doubt. I request you to clarify my doubt based on below

doubt in combobox in flex - XML
doubt in combobox in flex hi, i have doudt in combobox in flex which is a combination of mxml and actioscript . In my project i has a combobox with 10 items when i select the particular item i has 2 display

doubt in ejb3 - EJB
doubt in ejb3 hi i am new to ejb3 .i have written simple code which look like these entitybean package EntityBean; import java.io.Serializable; import javax.persistence.Entity; import javax.persistence.Table; @Entity

doubt in inheritance program - Java Beginners
doubt in inheritance program how will we get the result 6 2 5 in the inheritance program in the given example i got 6 &2 but i am confused about 5

servlet doubt on online examination system
servlet doubt on online examination system hai. sir ,i am doing project in online examination system. taken back end as mysql database. and doing the programs using java servlet. MY PROBLEM and doubt is 1. how 2 skip

Hi Friend.. Doubt on + - Java Beginners
Hi Friend.. Doubt on + Hi friend... import java.io.*; class Plus { public static void main(String args[]) { int a=10; int b= 25; System.out.println("A = " + a + " B = " + b

Doubt on Data Types - Java Beginners
Doubt on Data Types Hi Friend doubt on DataTypes... How should i declare n Assign value to the Float variable; Can u Please COMPILE this Program...Explain in detail

Jsp doubt

Questions by Category