
HI i have developed a simple ajax application contains two drop down lists and and one search button when i seleted a mangername from the popuated dropdwon list its dispalyed all the employee names on selection of the employee name and i kept search it should dispalay me the employee details when i click on search button its saying options is null or not an Obejct..
here im sending my code
select.jsp
<%@page import="java.sql.*"%>
<html>
<head>
<script language="javascript" type="text/javascript">
var xmlHttp
var xmlHttp
function showEmp(str){
if (typeof XMLHttpRequest != "undefined"){
xmlHttp= new XMLHttpRequest();
}
else if (window.ActiveXObject){
xmlHttp= new ActiveXObject("Microsoft.XMLHTTP");
}
if (xmlHttp==null){
alert("Browser does not support XMLHTTP Request")
return;
}
var url="getemp.jsp";
url +="?managername="+str;
alert(url);
xmlHttp.onreadystatechange = stateChange;
xmlHttp.open("GET", url, true);
xmlHttp.send(null);
}
function stateChange(){
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete"){
document.getElementById("empname").innerHTML=xmlHttp.responseText
}
}
function searchDetails(){
var combo = document.getElementsByName("empname");
//alert(combo.options[combo.selectedIndex].text);
var str = combo.options[combo.selectedIndex].value;
alert("val of str is "+str);
if (typeof XMLHttpRequest != "undefined"){
xmlHttp= new XMLHttpRequest();
}
else if (window.ActiveXObject){
xmlHttp= new ActiveXObject("Microsoft.XMLHTTP");
}
if (xmlHttp==null){
alert("Browser does not support XMLHTTP Request")
return;
}
var url="check.jsp";
url +="?count="+str;
alert(str);
xmlHttp.onreadystatechange = stateChange1;
xmlHttp.open("GET", url, true);
xmlHttp.send(null);
}
function stateChange1(){
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete"){
document.getElementById("data").innerHTML=xmlHttp.responseText
}
}
</script>
</head>
<body>
Select ManagerName:<select name='managername' onchange="showEmp(this.value)">
<option value="none">SelectManagername</option>
<%
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","hr","hr");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("Select * from employee_table1");
while(rs.next()){
%>
<option value="<%=rs.getString(3)%>"><%=rs.getString(3)%></option>
<%
}
%>
</select>
<br>
<div id='empname'>
<select name='empname' >
<option value='-1'></option>
</select>
</div>
<input type='button' value= 'SearchforempDetails' onclick='searchDetails();' >
<div id='data'>
<table name='data' >
</table>
</div>
</body>
</html>
getemp.jsp
<%@page import="java.sql.*"%>
<%
String managername=request.getParameter("managername");
String buffer="<select name='empname'><option value='-1'>SelectEmployeeName</option>";
try{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","hr","hr");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("Select * from employee_table1 where managername='"+managername+"' ");
while(rs.next()){
buffer=buffer+"<option value='"+rs.getString(2)+"'>"+rs.getString(2)+"</option>";
}
buffer=buffer+"</select>";
response.getWriter().println(buffer);
}
catch(Exception e){
System.out.println(e);
}
%>
check.jsp
<%@page import="java.sql.*"%>
<%
String empname=request.getParameter("count");
String buffer="<table name='data'>";
try{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","hr","hr");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("Select * from employee_table1 where empname='"+empname+"' ");
while(rs.next()){
buffer=buffer+"<tr><td>"+rs.getString("empcode")+"</td><td>"+rs.getString("org")+"</td></tr>";
}
buffer=buffer+"</table>";
response.getWriter().println(buffer);
}
catch(Exception e){
System.out.println(e);
}
%>
<%=empname%>
Database table table name employee_table1;
and empcode, empname, managername, org are columns
Pls help me
Thanks in Adavace


hi Thanks,
I figured out the solution