Ajax Call onkeyup Event in jsp

// ----------  Save as index.jsp --------------------- //

<%@ page import="java.util.*" %>

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

<%@ page import="java.io.*" %>

<%@ page import="java.text.*"  %>

<% 

  Connection con = null;

  ResultSet rs = null;

  Statement stmt = null;

  

  Class.forName("net.sourceforge.jtds.jdbc.Driver");

  con = DriverManager.getConnection("jdbc:jtds:sqlserver://192.168.7.128:1433/amantrn","sa","abcd");

  stmt = con.createStatement();

%>

<%-- <% --%>

<!--   String Query1="SELECT [id],[username],[password],[email],[profile] FROM [admin]"; -->

<!--   stmt = con.createStatement(); -->

<!--   ResultSet rs1 = stmt.executeQuery(Query1); -->

  

<!-- %> -->

<script language="javascript" type="text/javascript">

var xmlHttp;

function modifyData(Str) {

var versionIds = [ "Msxml2.XMLHTTP", "Microsoft.XMLHTTP",

"Microsoft.XMLDOM", "Msxml2.XMLHTTP.6.0", "Msxml2.XMLHTTP.5.0",

"Msxml2.XMLHTTP.4.0", "Msxml2.XMLHTTP.3.0",

"Msxml2.XMLHTTP.2.6", "Microsoft.XMLHTTP.1.0",

"Microsoft.XMLHTTP.1" ];

if (typeof XMLHttpRequest != "undefined") {

xmlHttp = new XMLHttpRequest();

} else if (window.ActiveXObject) {

for ( var i = 0; i < versionIds.length; i++) {

try {

return new ActiveXObject(versionIds[i]);

} catch (e) {

alert("Browser does not support XMLHTTP Request");

}

}

new XDomainRequest();

}

if (xmlHttp == null) {

alert("Browser does not support XMLHTTP Request");

return;

}

var url = "modify.jsp?";

url += "id=" + Str;

url += "&sid=" + Math.random();

xmlHttp.onreadystatechange = stateChange;

xmlHttp.open("POST", url, true);

xmlHttp.send(null);

function stateChange() {

if (xmlHttp.readyState == 4 || xmlHttp.readyState == "complete") {

var abc = xmlHttp.responseText.split("~");

//alert(abc);

document.getElementById('id').value = abc[0];//id

document.getElementById('name').value = abc[1];//Username

document.getElementById('pass').value = abc[2];//Password

document.getElementById('email').value = abc[3];//Email

//document.getElementById("id").value = abc[4];//Profile

}

}

}

</script>

<table>

  <tr>

   <td>Id:</td>

     <td><input type="text" name="id" id="id" value="" onblur='modifyData(this.value);'/></td>

  </tr>

    <tr>

   <td>Name:</td> 

    <td><input type="text" name="name" id="name" value=""/></td>

  </tr>

   <tr>

   <td>Password:</td>

   <td><input type="password" name="pass" id="pass" value="" /></td>

  </tr>

   <tr>

   <td>Email:</td>

   <td><input type="text" name="email" id="email" value="" /></td>

  </tr>

  <tr>

  <td><input type="reset" value="Clear"></td>

  <td></td>

  </tr>

</table>

// ---------------- Save as  modify.jsp ----------------- //

<%@ page import="java.util.*" %>

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

<%@ page import="java.io.*" %>

<%@ page import="java.text.*"  %>

<% 

  Connection con = null;

  ResultSet rs = null;

  Statement stmt = null;

  

  Class.forName("net.sourceforge.jtds.jdbc.Driver");

  con = DriverManager.getConnection("jdbc:jtds:sqlserver://192.168.7.128:1433/amantrn","sa","abcd");

  stmt = con.createStatement();

%>

<%

  String id = request.getParameter("id").trim();

  String Query1="SELECT [id],[username],[password],[email],[profile] FROM [admin] where id like '"+id+"%' ";

  stmt = con.createStatement();

  ResultSet rs1 = stmt.executeQuery(Query1);

  while(rs1.next()){

%>

<%=rs1.getString("id").trim()%>~<%=rs1.getString("username")%>~<%=rs1.getString("password")%>~<%=rs1.getString("email")%>~

<% }%>