Thursday 31 March 2016

Search Example


Search Example using AJAX in Java:

  • In this example, we are creating a form to search employee by name using ajax in java. Here, we have written the two-tier application code, to make the application easy to understand. You can write the database code, according to your standard.

Steps to create search example using AJAX in Java:

  • You need to follow following steps:
  • Create table in database
  • load the org.json.jar file
  • Create input form
  • Create server side page to search employee using name
  • Create table in database

In this example, we are using oracle 10g database. Here, we have created a table "emp911" which has following data.


  • Load the org.json.jar file
  • In this page, we have created a form that gets input from the user to search employee by name. When user releases the key after pressing through keyboard, searchInfo() function is called. The ajax code is written inside searchInfo() function.

index.html:

  1. <!DOCTYPE html> 
  2. <html> 
  3. <head> 
  4. <script> 
  5. var request=new XMLHttpRequest(); 
  6. function searchInfo(){ 
  7. var name=document.vinform.name.value; 
  8. var url="index.jsp?val="+name; 

  10. try{ 
  11. request.onreadystatechange=function(){ 
  12. if(request.readyState==4){ 
  13. var val=request.responseText; 
  14. document.getElementById('mylocation').innerHTML=val; 
  15. } 
  16. }//end of function 
  17. request.open("GET",url,true); 
  18. request.send(); 
  19. }catch(e){alert("Unable to connect to server");} 
  20. } 
  21. </script> 
  22. </head> 
  23. <body> 
  24. <h1>Search Employee</h1> 
  25. <form name="vinform"> 
  26. <input type="text" name="name" onkeyup="searchInfo()"> 
  27. </form> 

  29. <span id="mylocation"></span> 
  30. </body> 
  31. </html> 
  • Create server side page to process the request
  • In this jsp page, we are writing the database code to search employee starting with given name.

index.jsp:

  1. <%@ page import="java.sql.*" %> 
  2. <% 
  3. String name=request.getParameter("val"); 
  4. if(name==null||name.trim().equals("")){ 
  5. out.print("<p>Please enter name!</p>"); 
  6. }else{ 
  7. try{ 
  8. Class.forName("oracle.jdbc.driver.OracleDriver"); 
  9. Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","oracle"); 
  10. PreparedStatement ps=con.prepareStatement("select * from emp911 where name like '"+name+"%'"); 
  11. ResultSet rs=ps.executeQuery(); 

  13. if(!rs.isBeforeFirst()) { 
  14. out.println("<p>No Record Found!</p>"); 
  15. }else{ 
  16. out.print("<table border='1' cellpadding='2' width='100%'>"); 
  17. out.print("<tr><th>Id</th><th>Name</th><th>Email</th> 
  18. <th>Address</th><th>City</th><th>State</th><th>Country</th></tr>"); 
  19. while(rs.next()){ 
  20. out.print("<tr><td>"+rs.getString(1)+"</td><td>"+rs.getString(2)+"</td><td>"+rs.getString(3)+"</td> 
  21. <td>"+rs.getString(4)+"</td><td>"+rs.getString(5)+"</td><td>"+rs.getString(6)+"</td> 
  22. <td>"+rs.getString(7)+"</td></tr>"); 
  23. } 
  24. out.print("</table>"); 
  25. }//end of else for rs.isBeforeFirst 
  26. con.close(); 
  27. }catch(Exception e){out.print(e);} 
  28. }//end of else 
  29. %> 

Output:


See the search form.



Now enter employee name. If employee name is not found, it will display "No record found!" message.



Now enter employee name that exists in the table. Now it will display all records starting with given name.