How to "Get data froom MySQL DB on giving a value in a tex-box in a JSP file."

Hi, How to get data from MYSQL Database tables on giving a "text" in a text-box in a JSP file. Ex:dept table; if we give dept_no in a text-box in JSP file,we have to retrieve the other fields from the dept table and display it in the same JSP file.

Help me plz;

View Answers

July 22, 2011 at 11:05 AM

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(":");
      if(strar.length>1){
        var strname = strar[1];
        document.getElementById("name").style.visibility= "visible";
        document.getElementById("address").style.visibility= "visible";
        document.getElementById("contactNo").style.visibility= "visible";
        document.getElementById("email").style.visibility= "visible";

        document.getElementById("lab1").style.visibility= "visible";
        document.getElementById("lab2").style.visibility= "visible";
        document.getElementById("lab3").style.visibility= "visible";
        document.getElementById("lab4").style.visibility= "visible";

        document.getElementById("name").value= strar[1];
        document.getElementById("address").value= strar[2];
        document.getElementById("contactNo").value= strar[3];
        document.getElementById("email").value= strar[4];
        }
       } 
     } 
    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>Enter Id:</td><td><input type="text" id="id" onkeyup="showData(this.value);"></td></tr>
<tr><td><label id="lab1" style="visibility:hidden">Name:</label></td><td><input type="text" id="name" style="visibility:hidden"></td></tr>
<tr><td><label id="lab2" style="visibility:hidden">Address:</label></td><td><input type="text" id="address" style="visibility:hidden"></td></tr>
<tr><td><label id="lab3" style="visibility:hidden">Contact No:</label></td><td><input type="text" id="contactNo" style="visibility:hidden"></td></tr>
<tr><td><label id="lab4" style="visibility:hidden">Email:</label></td><td><input type="text" id="email" style="visibility:hidden"></td></tr>
</table>
</body>
</html>

2)getdata.jsp:

<%@ page import="java.sql.*" %> 
<%
String emp_id = request.getParameter("id").toString();
 String buffer="";  
 try{
  Class.forName("com.mysql.jdbc.Driver");
  Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
 Statement stmt = con.createStatement();  
 ResultSet rs = stmt.executeQuery("Select * from employee where id='"+emp_id+"'");  
   while(rs.next()){
   buffer=":" +rs.getString("name") +":"+ rs.getString("address") +":"+rs.getString("contactNo")+":"+  rs.getString("email");
   }
 out.println(buffer);
 System.out.println(buffer);
 }
 catch(Exception e){
 System.out.println(e);
 }
 %>

How to "Get data froom MySQL DB on giving a value in a tex-box in a JSP file."

Questions by Category