Java, .NET, PHP, PYTHON, ANGULAR, .NET, ML, Data Scince, 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 web page excluding complete web form.

Ajax improves 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 user switch to next text field then we can create ajax code to check email id.


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


when we search from facebook or google search box then data will be populated 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, means if we select dropdown list and display data into another dropdown list 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 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 respective record from database and show into browser?




Code of Index.JSP:-

<%--
    Document   : index
    Created on : Oct 18, 2019, 10:32:56 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 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