Select from select list + display

i have a select list containing elements, say EmpCode. there are 2 fields below it EmpName and DeptName.

As i select EmpCode from the select list, the corresponding EmpName and DeptName should be displayed automatically in empty text fields.

I am using struts 1.2 framework for the application.

Kindly reply asap.

Thanks & regards.

View Answers

April 18, 2011 at 3:55 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; 
    var strar = showdata.split(":");
    document.getElementById("name").value= strar[1];
    document.getElementById("dept").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 >
<div id="mydiv"></div>
<tr><td><b>Select:</b></td><td><select onchange="showData(this.value);">
   <%
   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 emp ");
           while(rs.next()){
               %>
               <option value="<%=rs.getInt("EMP_NO")%>"><%=rs.getInt("EMP_NO")%></option>
               <%
           }
               %>
               </select></td></tr>

<tr><td><b>EMP Name:</b></td><td><input  type="text" id="name" ></td></tr>
<tr><td ><b>DEPT Name:</b></td><td><input  type="text" id="dept" ></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 emp where EMP_NO="+id+"");
while(rs.next())
{
data =":"+rs.getString("EMP_NAME")+":"+rs.getString("DEPT_NAME");
}
out.println(data);
System.out.println(data);
}
catch (Exception e) {
System.out.println(e);
}
%>

Struts2 Ajax

Ads

Advertisements

select Query result display problem
select Query result display problem Hi, String SQL_QUERY ="from Cc"; Query query = session.createQuery(SQL_QUERY); for(Iterator it=query.iterate... Hibernate: select cc0.id as col00 from cc cc0_ Cc$$EnhancerByCGLIB$$2235676a cannot

How to display all the Select values from the MySQL database table in where condition= In JSP?
How to display all the Select values from the MySQL database table in where... to display all the select values from MySQL DB** only first value is displayed in the jsp file. @select * from table dept where dept_no=10;" jsp code i have used

JSP:select image for db and display in image tag
JSP:select image for db and display in image tag Hi, i am new to this forum. My query is that, i am trying to display image in tag but i am...); response.getOutputStream().flush(); } i think, this code will display image

JSP:select image for db and display in image tag
JSP:select image for db and display in image tag Hi, i am new to this forum. My query is that, i am trying to display image in image tag but i am...); response.getOutputStream().flush(); } i think, this code will display

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 all the rows in JSP ,MySQL select condition statement IN dept_table
How to display all the rows in JSP ,MySQL select condition statement IN dept_table I iam unable to display all the rows in JSP select statement from... is [email protected]select * from department where dept_no=10;My display code in JSP

How to Display Duplicate elements from more than one List in java?
How to Display Duplicate elements from more than one List in java? How to Display Duplicate elements from more than one List in java? //I mean common elements from two List? Ex: List a1=new ArrayList(); a1.add(50

displaying List of records from database in a jsp using ajax, onclick it should display the results ?? its urgent can u help me
displaying List of records from database in a jsp using ajax, onclick it should display the results ?? its urgent can u help me displaying List of records from database in a jsp using ajax, onclick it should display the results

jfreechart display from access database data.
jfreechart display from access database data. I have made a database... to retrieve the data from the access database using prepared statement and then display...="org.jfree.data.jdbc.JDBCCategoryDataset"%> <% String query="SELECT * from chart

how to display records from database
how to display records from database I want to display records from database in tables, the database is having 2000 records and i want to display 20 records at a time and to use next and previous link buttons to show

How to display content in same page while selecting fron dropdown list
dropdownlist in jsp page.If i select any value in that list(for eg-rollno),then it want to display all records from table specific to that rollno in that same...How to display content in same page while selecting fron dropdown list

display date to jsp from database
display date to jsp from database display date to jsp from database to calender if the start date and end date is available than calender date will disappeared or non-clickable and its show in red color. those date

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

How to Display values from databse into table
How to Display values from databse into table I want to display values from database into table based on condition in query, how to display... = request.getParameter("name"); String query = "select * from books where authorname

Display Data from Database in JSP
; <html> <head> <title>display data from...;To display all the data from the table click here...</h2></TD>...;title>display data from the table using jsp</title> </head> <

display multiple images from postgres database in jframe
display multiple images from postgres database in jframe i just want to display multiple images on jframe by firing a query on postgres database

I want to display the quantity of the selected item of a drop down list in a textbox. The data is stored in database.
I want to display the quantity of the selected item of a drop down list... from database into Drop Down List. <% DataSource data = new... = con.prepareStatement("select * from library.booklist"); ResultSet result

Fetch the data from mysql and display it on php form
Fetch the data from mysql and display it on php form when i press on login button, after succesful login the related data of that person should be display in other textbox

get and display blob from mysql on jsf
get and display blob from mysql on jsf i want to get blob from mysql, and display on jsf page. your examples with jsp. i dont find an example with jsf. plese help me about this. thanks.. Have a look at the following

Display Data from Database in JSP
Display Data from Database in JSP ... and execute query to display data from the specified table. Before...;title>display data from the table using jsp</title> </head> <

How to retrieve and display image from database in Java?
How to retrieve and display image from database in Java? Hi, I am writing a web application for reading the data from database and displaying on the web page. My application is in Java/JSP. How to retrieve and display image

ModuleNotFoundError: No module named 'mult_list_display'
ModuleNotFoundError: No module named 'mult_list_display' Hi, My... named 'mult_list_display' How to remove the ModuleNotFoundError: No module named 'mult_list_display' error? Thanks Hi, In your

How to read and display data from a .properties file from a jsp page
How to read and display data from a .properties file from a jsp page I have a .properties file. I have to create a jsp page such that it reads the data from this .properties file and display it in table format. Ex:by using

Dynamic retrieval od data from database and display it in the table at jsp
Dynamic retrieval od data from database and display it in the table at jsp ...; Here is a jsp code that retrieves the data from the database and display...:3306/test", "root", "root"); String query = "select * from employee"; Statement

Ads