Skip to main content

Check user name available or already exists in database while creating Registration form in jsp using AJAX like gmail

First Create  login table in sql server
create table login
(
    name varchar(20),
    password varchar(20)
)
insert into login values('dilip','niit')
Now Create jsp page:
ajaxcheck.jsp




<%@page contentType="text/html" pageEncoding="UTF-8"%>








<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"








   "http://www.w3.org/TR/html4/loose.dtd">








<html>








    <head><title>welcome</title>








    <script language="javascript">




        reqObj=null;




        function varify(){




            document.getElementById("res").innerHTML="Checking";




            if(window.XMLHttpRequest){




                reqObj=new XMLHttpRequest();




            }else {




                reqObj=new ActiveXObject("Microsoft.XMLHTTP");




            }






            reqObj.onreadystatechange=process;




            reqObj.open("POST","usercheck.jsp?id="+document.getElementById("username").value,true);


            reqObj.send(null);



}

  function process(){

if(reqObj.readyState==4){

               document.getElementById("res").innerHTML=reqObj.responseText;




            }

}




        </script>




    </head>








    <body>








        <h1>welcome to this application</h1>








    <form>








        User Name<input type="text" name="t1" id="username" onblur="varify();"><span id="res"></span><br/>








        First Name<input type="text" name="t2" ><br/>








        Last Name<input type="text" name="t3"><br/>








        Email<input type="text" name="t4"><br/>








        Password<input type="password" name="t5"><br/>








        <input type ="submit" value="Press"/>








    </form>








    </body>








</html>











Now create usercheck.jsp










<%@page contentType="text/html" pageEncoding="UTF-8"%>








<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"








   "http://www.w3.org/TR/html4/loose.dtd">








<%@page import="java.util.*,java.sql.*,java.io.*" %>








<%@page import="javax.servlet.*" %>








<%! Connection con; %>








<%! Statement s; %>








<%! ResultSet rs; %>






<%






String user=request.getParameter("id");




try{




Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");




con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=j2ee","sa","niitbpl123");




s=con.createStatement();




rs=s.executeQuery("select name from login where name='"+user+"'");




if(rs.next())




    {




        Thread.sleep(1000);




        if(user.equals(rs.getString(1))




        {




%>




        <font color="red" ><strong>User already exists</strong></font>




        <%




        }


    }


else


    {


        Thread.sleep(1000);


    %>


<font color="green" ><strong>User  name available</strong></font>


    <%


    }


 }

catch(Exception e)

{ 

    e.printStackTrace();

}

%>





Output:



1



2



3



4







Technorati Tags: ,















Labels:






































Comments











Post a Comment



















Popular posts from this blog



















WAP to calculate the monthly telephone bills as per the following rule: Minimum Rs. 200 for upto 100 calls. Plus Rs. 0.60 per call for next 50 calls. Plus Rs. 0.50 per call for next 50 calls. Plus Rs. 0.40 per call for any call beyond 200 calls.




























  #include<iostream.h> #include<conio.h> void  main() { 	 int  calls; 	 float  bill; 	cout<<" Enter number of calls : "; 	cin>>calls; 	 if (calls<=100) 		bill=200; 	 else  if  (calls>100 && calls<=150)   	{      		calls=calls-100;      		bill=200+(0.60*calls); 	} 	 else  if  (calls>150 && calls<=200) 	{ 		calls=calls-150; 		bill=200+(0.60*50)+(0.50*calls);  	} 	 else 	{ 		calls=calls-200; 		bill=200+(0.60*50)+(0.50*50)+(0.40*calls); 	} 	cout<<"  Your bill is Rs. "<<bill; 	getch(); 	 }    Output: Enter number of calls : 190 Your bill is Rs.250   




















6 comments









Read more




























C++ Program to define a Class BOOK and accessing member function using its object.




























  #include<iostream.h> #include<stdio.h> #include<conio.h> class  BOOK { 	 int  BOOKNO; 	 char  BOOKTITLE[20]; 	 float  PRICE; 	 void  TOTAL_COST( int  N) 	{ 		 float  tcost; 		tcost=PRICE*N; 		cout<<tcost; 	} public : 	 void  INPUT() 	{ 		cout<<" Enter Book Number "; 		cin>>BOOKNO; 		cout<<" Enter Book Title "; 		gets(BOOKTITLE); 		cout<<" Enter price per copy "; 		cin>>PRICE; 	}  	 void  PURCHASE() 	{ 		 int  n; 		cout<<" Enter number of copies to purchase "; 		cin>>n; 		cout<<" Total cost is "; 		TOTAL_COST(n); 	} };  void  main() { 	BOOK obj; 	obj.INPUT(); 	obj.PURCHASE(); 	getch(); }     




















8 comments









Read more






























Addition of Two Number using servlet and jsp




























index.jsp      <%@page contentType="text/html" pageEncoding="UTF-8"%> <! 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=UTF-8" >         < title > JSP Page </ title >     </ head >     < body  bgcolor ="yellow" >         < center >< h1 > Addition of Two Number </ h1 ></ center >         < form  action =" additionservlet "  method ="post" >         < table  border ="0"  width ="100"  align ="center" >                 < tr >                     < td > First Number </ td >                     < td >< input  type ="text"  name ="txtnum1"  value =""  /></ td >       ...




















1 comment









Read more