ajax jsp 登陆验证,ajax 验证用户名(以JSP中)

login.html :

Insert title here

function checkname(){

//alert("test") ;

  document.getElementById("msg").innerHTML="fwf3.JPG%5C%22" ;

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 + "") ;

%>

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值