Fetching all records Form Without Refreshing Page In Struts2

Database

CREATE TABLE `student` (                                    
          `id` bigint(255) NOT NULL auto_increment, 
          `name` varchar(255) default NULL,      
  `class` varchar(255) default NULL,                      
          PRIMARY KEY  (`id`)                                
        );

DBconnection

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DBconnection {
 public static Connection getConnection(){
  Connection con = null;
  try{
   //Class.forName("oracle.jdbc.driver.OracleDriver");
   //con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","ravi");
   Class.forName("com.mysql.jdbc.Driver");
       con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","ROOT");
  }catch(SQLException e){
   e.printStackTrace();
  }catch(Exception e){
   e.printStackTrace();
  }
  
  return con;
 }
}

StudentInfoBean

public class StudentInfoBean {
 private int id;
 private String name,level;
 public int getId() {
  return id;
 }
 public void setId(int id) {
  this.id = id;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public String getLevel() {
  return level;
 }
 public void setLevel(String level) {
  this.level = level;
 }
 

}

StudentInfo

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import java.io.InputStream;
import com.opensymphony.xwork2.ActionSupport;
import javax.servlet.http.HttpServletRequest;
import org.apache.struts2.interceptor.ServletRequestAware;
import connection.com.DBconnection;

public class StudentInfo extends ActionSupport implements ServletRequestAware{   
    private static final long serialVersionUID = 1L;
    private InputStream fileInputStream;
     
    public InputStream getFileInputStream() {
    return fileInputStream;
    }
     
    HttpServletRequest request;
   
   
    public String execute()
    {
   
    try{
    
        Connection con=DBconnection.getConnection();
      
        String id = request.getParameter("count");
    Statement st=con.createStatement();
    ResultSet rs = st.executeQuery("SELECT id,name,class FROM test.student where name='" + id + "' ;");
        List li = null;
         li = new ArrayList(); 
         StudentInfoBean StudentInfoBean = null;
        while(rs.next())
            {    
         StudentInfoBean = new StudentInfoBean();
            StudentInfoBean.setId(rs.getInt("id"));
         StudentInfoBean.setName(rs.getString("name"));
         StudentInfoBean.setLevel(rs.getString("class"));
             li.add(StudentInfoBean); 
            }
        request.setAttribute("studentinfo", li);
        rs.close();
         st.close();
        con.close();

            }
        catch(Exception e){
             e.printStackTrace();
         }
     
            return SUCCESS;
    }

    public void setServletRequest(HttpServletRequest request) {
        this.request = request;
    }

    public HttpServletRequest getServletRequest() {
        return request;
}
}

struts.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE struts PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 2.1//EN" "http://struts.apache.org/dtds/struts-2.1.dtd">
<struts>
<package name="java" extends="struts-default">
 <action name="student" class="student.com.StudentInfo">
<result name="success">studentinfo.jsp</result>
 </action>
 </package>
</struts>  

web.xml

<web-app id="WebApp_ID" version="3.0" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemalocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd">
  <display-name>Student</display-name>
  <welcome-file-list>
      <welcome-file>index.jsp</welcome-file>
       <welcome-file>default.jsp</welcome-file>
  </welcome-file-list>
  <filter>
    <filter-name>struts2</filter-name>
    <filter-class>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter</filter-class>
  </filter>
  <filter-mapping>
    <filter-name>struts2</filter-name>
    <url-pattern>/*</url-pattern>
  </filter-mapping>
</web-app>

index.jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Student Info</title>
    <script  type="text/javascript">  
      var xmlHttp;  
      var xmlHttp;
      function showStudent(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="student";
      url +="?count=" +str;
      xmlHttp.onreadystatechange = stateChange;
      xmlHttp.open("GET", url, true);
      xmlHttp.send(null);
      }

      function stateChange(){   
      if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete"){   
      document.getElementById("student").innerHTML=xmlHttp.responseText; 
      }   
      }

      </script>  
</head>
<body background="java9r.png">
<center><h1>Fetching all records Form Without Refreshing Page In Struts2</h1></center>
   <center>Search / Name<input type="text" name='sname' onchange="showStudent(this.value)">
      <br> <br><br><br> 
  
      <div id='student'>  
      
      </div> 
</center> 
</body>
</html>

studentinfo.jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
     <%@ page import="java.util.*;" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Student Info</title>
</head>
<body>
<form name="form" method="post">
<% 
List l=(List)request.getAttribute("studentinfo");
if(l!=null)
{
 Iterator it=l.iterator();
  while(it.hasNext())
 {
   student.com.StudentInfoBean b=(student.com.StudentInfoBean)it.next();
  int tempNum = b.getId();
  String tempname = b.getName();
  String tempcla = b.getLevel();

%>

<table border="2" width="500px"><tr><td width="100px"><%= tempNum %>
</td><td width="100px"><%= tempname %></td><td width="200px"> <%= tempcla %></td></tr></table>
 
<%   
    
 }
}

%>  

</form>

</body>
</html>