Java, .NET, PHP, PYTHON, ANGULAR, ML, Data Science, Testing, CI Tutorials in Easy Languages.

"Best Software Training, Internship, Project Development center of Indore India, Helpline 780506-3968"

Ajax:-


...................................................................................................
Ajax means Asynchronous JavaScript and XML, it is used to partially update the content of the web page excluding complete web form.

Ajax improves the performance of web application and provide dynamic programming approach without reloading and submit the data.


for example, if we create a registration form and we want to check that email already exists when the user switches to the next text field then we can create ajax code to check email id.


when we select the country then the state list and when we select the state then the city list will be populated by AJAX.


when we search on Facebook or Google then the search box will populate when we press any key that will be managed by Ajax.




Role of JavaScript or Jquery:-

It is used to handle the event in Ajax Process, which means if we select a dropdown list and display data into another dropdown list, that will be managed by AJAX.


Role of XML:-

XML means Extensible markup language which is used to transfer data from client machine(Browser) to server machine (Apache Server) and server machine to the server machine.

XMLHttpRequest:-  this class is used to send data from browser to web server.

XMLHttpResponse:-  It is used to get web server response using XML form.



Create Search Box which will search the respective record from the database and show it into the browser?




Code of Index.JSP:-


<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>JSP Page</title>
        <script>
            function showdata(a)
            {
                xmlhttp = new XMLHttpRequest();
                xmlhttp.onreadystatechange=function()
                {
                document.getElementById("res").innerHTML= xmlhttp.responseText;       
                }
                xmlhttp.open("POST","showdata.jsp?q="+a,true);
                xmlhttp.send();
             
            }
         
        </script>
    </head>
    <body>
        <input type="text" placeholder="enter any data" id="txtsearch" onkeyup="showdata(this.value)" />
        <br>
        <br>
        <div id="res">
         
        </div>
    </body>
</html>



Code for ShowData.jsp

<%@page import="java.sql.*" %>
<%
                   
    String data = request.getParameter("q")+ "%";
    Class.forName("com.mysql.jdbc.Driver");
    Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/javadb","root","");
    Statement st = con.createStatement();
    ResultSet res = st.executeQuery("select * from reg where fullname like '"+data+"'");
    while(res.next())
    {
        out.print(res.getString(1)+" "+res.getString(2)+" "+res.getString(3)+" "+res.getString(4)+ " " + res.getString(5) +"<hr>");
    }
    
  %>
   

Another Example USer Already Exist:-


<%-- 
    Document   : RegisterForm
    Created on : Oct 14, 2019, 10:16:53 AM
    Author     : DELL
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>JSP Page</title>
        <script>
            function chkemail(a)
            {
                xmlhttp = new XMLHttpRequest();
                xmlhttp.onreadystatechange=function()
                {
                document.getElementById("res").innerHTML= xmlhttp.responseText;         
                }
                xmlhttp.open("POST","chkdata.jsp?q="+a,true);
                xmlhttp.send();
            }
        </script>
    </head>
    <body>
        <form action="RegSer" method="post">
            
            <p>Enter emailid</p>
            <p><input type="email" name="txtemail" required="" onblur="chkemail(this.value)"  /> </p>
           <div id="res">
           </div>
            <p>Enter password</p>
            <p><input type="password" name="txtpass" required=""  /> </p>
            <p>Enter mobileno</p>
            <p><input type="number" name="txtmobile"  required="" /> </p>
            <p>Enter fullname</p>
            <p><input type="text" name="txtfname" required="" /> </p>
            <p><input type="submit" name="btnsubmit" value="Click" /></p>
            
            
            
            
        </form>
    </body>
</html>


Ajax code:-

chkdata.jsp

<%@page import="java.sql.*" %>
<%
                   
    String data = request.getParameter("q");
    Class.forName("com.mysql.jdbc.Driver");
    Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/javadb","root","");
    Statement st = con.createStatement();
    ResultSet res = st.executeQuery("select * from reg where email = '"+data+"'");
    if(res.next())
    {
    out.print("emailid already exist"); 
    }
    
  %>
   


Post a Comment

If you have any doubt in programming or join online classes then you can contact us by comment .

Previous Post Next Post