login.html :
Insert title herefunction checkname(){
//alert("test") ;
document.getElementById("msg").innerHTML="" ;
var url = "checklogin.jsp?username=" + document.forms[0].username.value ;
//alert(url) ;
if(window.XMLHttpRequest){
xhr = new XMLHttpRequest() ;
}else{
if(window.ActiveXObject){
try{
xhr = new ActiveXObject("Microsoft.XMLHttpRequest") ;
}catch(e){}
}
}
if(xhr){
xhr.onreadystatechange = showContents ;
xhr.open("GET", url, true) ;
xhr.send(null) ;
}else{
document.getElementById("msg").innerHTML = "sorry ! but your pc coundn't create a xhr object !" ;
}
}
function showContents(){
if(xhr.readyState == 4){
if(xhr.status == 200){
//alert(xhr.responseXML.contentType) ;
//var outMsg = xhr.responseText ;
//if(xhr.responseXML && xhr.responseXML.contentType == "text/xml"){
var outMsg = xhr.responseXML.getElementsByTagName("msg")[0].childNodes[0].nodeValue ;
//}else{
//var outMsg = xhr.responseText ;
//}
//alert(outMsg) ;
if(outMsg == "validate"){
document.getElementById("msg").innerHTML = "用户名正确 " ;
}else{
document.getElementById("msg").innerHTML = "用户名不正确 " ;
}
}else{
var outMsg = "there was a problem on your server : status = " + status ;
}
}
}
username :
password :
checklogin.jsp
response.setContentType("text/xml") ;
response.setCharacterEncoding("GB18030") ;
response.setHeader("catch-control", "no-store") ;
response.setDateHeader("Expires", 0) ;
String username = request.getParameter("username") ;
Connection conn = null ;
String login = "" ;
try{
Class.forName("com.mysql.jdbc.Driver") ;
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/testuser?user=root&password=110110") ;
Statement stmt = conn.createStatement() ;
String sql = "select count(*) from ruser where username = '" + username + "'" ;
System.out.println(sql) ;
ResultSet rs = stmt.executeQuery(sql) ;
rs.next() ;
int count = rs.getInt(1) ;
if(count > 0){
login = "validate" ;
}else{
login="novalidate" ;
}
}catch(ClassNotFoundException ex){
ex.printStackTrace() ;
}catch(SQLException ex){
ex.printStackTrace() ;
}
//System.out.println(request.getParameter("username")) ;
response.getWriter().write("" + login + "") ;
%>