DropDown and text boxes with AJAX, JSP

Hi,

we are using one drop down and two text boxes. Drop down values needs to be retrive from one table.we should provide a text box through which users can input the emp number and emp rev number for textboxes in the Add employee Form. when the user entered values in the text boxes onblur it needs to validate whether the inserted values are already present in another table.The Validations need to verify that emp no should be unique and it can?t be duplicated, if the emp number is duplicate mean that emp number already exists, in that case it should not allow the user to add a new employee details with same emp number.it needs to alert emp no is already present.

we are already using jsp's and java technology. can we integrate ajax in jsp's to achieve the same? if so could you please guide me to achive the same with sample code

Thanks in advance for ur help.

regards
sona

View Answers

August 27, 2010 at 4:21 PM

Hi Friend,

Try the following code:

1)checkEmployee.jsp:

<html>
<head>
<script>
var xmlHttp;
function showState(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= "emp.jsp";
url += "?val=" +str;
xmlHttp.onreadystatechange = stateChange;
xmlHttp.open("GET", url, true);
xmlHttp.send(null);
}
function stateChange(){
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete"){
var v=xmlHttp.responseText;
alert(v);
}
}
</script>
</head>
<body>

<table>
<tr><td>Enter EMP ID:</td><td><input type="text" id="txt" onkeyup="showState(this.value)"> </td></tr>
<tr><td>Enter Name:</td><td><input type="text" id="txt1"></td></tr>
</table>
</body>
</html>

2)emp.jsp:

<%@page language="java" import ="java.sql.*" %>
<%

String val = request.getParameter("val").toString();
String data="";
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root";);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery( "SELECT * FROM employee WHERE empid='"+val+"'");
String id="";
while(rs.next()){
id=rs.getString(1);
}
if(id.equals(val)){
data="Emp No is already present!";
response.getWriter().println(data);
}
else{
data="This is valid id";
response.getWriter().println(data);

}

%>

Hope that it will be helpful for you.
Thanks