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
}
function process(){
if(reqObj.readyState==4){
document.getElementById("res").innerHTML=reqObj.responseText;
Now create usercheck.jsp
{
e.printStackTrace();
}
%>
Output:
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();
}
%>
Technorati Tags: ajax & java script,jsp
Comments
Post a Comment