If we give any text values,the another text box automatically processed and show the relevant values
in the textfield.
home.jsp
<html>
<head>
<script>
var request;
function sendInfo()
{
var v=document.frm.vno.value;
var url="ajax.jsp?val="+v;
alert(url);
if(window.XMLHttpRequest){
request=new XMLHttpRequest();
}
else if(window.ActiveXObject){
request=new ActiveXObject("Microsoft.XMLHTTP");
}
try{
request.onreadystatechange=getInfo;
request.open("POST",url,true);
request.send();
}catch(e){alert("Unable to connect to server");}
}
function getInfo(){
if(request.readyState==4){
var val=request.responseText;
//alert(val);
//document.getElementById('amit').innerHTML=val;
document.frm.eno.value=val;
}
}
</script>
</head>
<body>
<form name="frm" action="b22" method="post">
Enter vno:<input type="text" name="vno" onchange="sendInfo()">
Entry Toll no<input type="text" name="eno" readonly="">
<input type="submit" value="submit">
</form>
</body>
</html>
ajax.jsp
<%@ page import="java.sql.*"%>
<%
String s=request.getParameter("val");
System.out.println(":::::::::::::::::: "+s);
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/toll","root","root");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select entry from tollno where vno='"+s+"'");
System.out.println("select entry from tollno where vno='"+s+"'");
while(rs.next())
{
out.println(rs.getString("entry"));
}
}
catch(Exception e)
{
e.printStackTrace();
}
%>
No comments:
Post a Comment