QuestionAsk Questions?
View Answers
May 17, 2008 at 7:09 PM
Hi
<!DOCTYPE HTML PUBLIC ?-//W3C//DTD HTML 4.01 Transitional//EN?>
<html>
<head>
<title>AJAX and Servlet</title>
<script language="javascript">
var xmlHttp;
function checkUserExist(){
var username = document.getElementById("username").value;
var url = "AJAXCheckUserServlet?username=" + username;
if(window.XMLHttpRequest){
xmlHttp = new XMLHttpRequest();
}
else if(window.ActiveXObject){
xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
}
xmlHttp.open("Get",url,true);
xmlHttp.onreadystatechange = callback;
xmlHttp.send(null);
}
function callback() {
if( xmlHttp.readyState==4 ){
if( xmlHttp.status==200 ) {
document.getElementById('text').innerHTML = "<br/><b>"+xmlHttp.responseText+"</b>";
}
}
}
function focusIn(){
document.getElementById("username").focus( );
}
</script>
</head>
<body onload="focusIn();">
<form>
User Name <input type="text" id="username" name="username"/>
<input type="button" value="Check User Name Availability" onClick="checkUserExist()"/>
<div id="text"></div>
</form>
</body>
</html>
----------------------------------
<%@ page language="java" import="java.sql.*,java.util.*,java.text.*" %>
<%
Connection con = null;
String url = "jdbc:mysql://192.168.10.211:3306/";;
String db = "amar";
String driver = "com.mysql.jdbc.Driver";
String user ="amar";
String pass = "amar123";
boolean isExist= false;
try{
Class.forName(driver).newInstance();
con = DriverManager.getConnection(url+db, user, pass);
try{
Statement st = con.createStatement();
String username = request.getParameter("user_name");
ResultSet res = st.executeQuery("SELECT user_name FROM user");
while (res.next()) {
String un = res.getString("user_name");
if(username.equals(un)){
con.close();
isExist = true;
break;
}
}
con.close();
}
catch (SQLException s){
System.out.println("SQL code does not execute.");
}
}
catch (Exception e){
e.printStackTrace();
}
%>
------------------------------------------
Read for more information.
http://www.javajazzup.com/issue10/page21.shtml
<!DOCTYPE HTML PUBLIC ?-//W3C//DTD HTML 4.01 Transitional//EN?>
<html>
<head>
<title>AJAX and Servlet</title>
<script language="javascript">
var xmlHttp;
function checkUserExist(){
var username = document.getElementById("username").value;
var url = "AJAXCheckUserServlet?username=" + username;
if(window.XMLHttpRequest){
xmlHttp = new XMLHttpRequest();
}
else if(window.ActiveXObject){
xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
}
xmlHttp.open("Get",url,true);
xmlHttp.onreadystatechange = callback;
xmlHttp.send(null);
}
function callback() {
if( xmlHttp.readyState==4 ){
if( xmlHttp.status==200 ) {
document.getElementById('text').innerHTML = "<br/><b>"+xmlHttp.responseText+"</b>";
}
}
}
function focusIn(){
document.getElementById("username").focus( );
}
</script>
</head>
<body onload="focusIn();">
<form>
User Name <input type="text" id="username" name="username"/>
<input type="button" value="Check User Name Availability" onClick="checkUserExist()"/>
<div id="text"></div>
</form>
</body>
</html>
----------------------------------
<%@ page language="java" import="java.sql.*,java.util.*,java.text.*" %>
<%
Connection con = null;
String url = "jdbc:mysql://192.168.10.211:3306/";;
String db = "amar";
String driver = "com.mysql.jdbc.Driver";
String user ="amar";
String pass = "amar123";
boolean isExist= false;
try{
Class.forName(driver).newInstance();
con = DriverManager.getConnection(url+db, user, pass);
try{
Statement st = con.createStatement();
String username = request.getParameter("user_name");
ResultSet res = st.executeQuery("SELECT user_name FROM user");
while (res.next()) {
String un = res.getString("user_name");
if(username.equals(un)){
con.close();
isExist = true;
break;
}
}
con.close();
}
catch (SQLException s){
System.out.println("SQL code does not execute.");
}
}
catch (Exception e){
e.printStackTrace();
}
%>
------------------------------------------
Read for more information.
http://www.javajazzup.com/issue10/page21.shtml
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
