CheckServlet
-----------------------------------------
package servlets;
import java.io.*;
import java.sql.*;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpServlet;
public class CheckServlet extends HttpServlet{
public static final String DBDRIVER="com.mysql.jdbc.Driver";
public static final String DBURL="jdbc:mysql://localhost:8889/username";
public static final String DBUSER="root";
public static final String DBPASS="root";
public void doGet(HttpServletRequest request,HttpServletResponse response)
throws ServletException,IOException{
this.doPost(request, response);
}
public void doPost(HttpServletRequest request,HttpServletResponse response)
throws ServletException,IOException{
request.setCharacterEncoding("gbk");
response.setContentType("text/html");
Connection conn=null;
PreparedStatement pstmt=null;
ResultSet rs=null;
PrintWriter out=response.getWriter();
String userid=request.getParameter("userid");//接受验证的用户名
out.println(userid);
try{
Class.forName(DBDRIVER);
conn=DriverManager.getConnection(DBURL,DBUSER,DBPASS);
String sql=" select * from name where username=?";
pstmt=conn.prepareStatement(sql);
pstmt.setString(1,userid);
rs=pstmt.executeQuery();
if(rs.next()){ if(rs.getString("username")==userid){
out.println("true");
}else{
out.println("false");
}
}
out.close();
}catch(Exception e){
e.printStackTrace();
}finally{
try{
conn.close();
}catch(SQLException e){
e.printStackTrace();
}
}
}
}
----------------------------check.jsp
<%@ page language="java" pageEncoding="utf-8"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<!doctype html>
<html lang="en">
<body>
<script>
window.onload = initPage;
function initPage() {
document.getElementById("userid").onblur = checkUserid;//引用函数方法。
} //创建请求对象
function createRequest() {
try {
request = new XMLHttpRequest();
} catch (tryMS) {
try {
request = new ActiveXObject("Msxml2.XMLHTTP");
} catch (otherMS) {
try {
request = new ActiveXObject("Microsoft.XMLHTTP");
} catch (failed) {
request = null;
}
}
}
return request;
}
//检查用户名是否重复
function checkUserid(){
request=createRequest();
var theName = document.getElementById("userid").value;
request.open("POST","CheckServlet?userid="+theName,true);
request.onreadystatechange=checkUseridCallback;
request.send(null);
document.getElementById("msg").innerHTML="正在验证..."; }
//回调函数
function checkUseridCallback(){
if(request.readyState==4){
if(request.status==200){
if( request.responseText=="true"){
document.getElementById("msg").innerHTML="用户ID重复";
}else{
document.getElementById("msg").innerHTML="此用户ID可以注册"; }
}
}
}
</script>
<form action="check.jsp" method="POST" >
用户ID: <input type="text" id="userid" name="userid">
<span id="msg"></span>
<br>
姓名 <input type="text" name="name" >
</form>
</body>
</html>
Ajax数据库
-----------------------------------------
package servlets;
import java.io.*;
import java.sql.*;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpServlet;
public class CheckServlet extends HttpServlet{
public static final String DBDRIVER="com.mysql.jdbc.Driver";
public static final String DBURL="jdbc:mysql://localhost:8889/username";
public static final String DBUSER="root";
public static final String DBPASS="root";
public void doGet(HttpServletRequest request,HttpServletResponse response)
throws ServletException,IOException{
this.doPost(request, response);
}
public void doPost(HttpServletRequest request,HttpServletResponse response)
throws ServletException,IOException{
request.setCharacterEncoding("gbk");
response.setContentType("text/html");
Connection conn=null;
PreparedStatement pstmt=null;
ResultSet rs=null;
PrintWriter out=response.getWriter();
String userid=request.getParameter("userid");//接受验证的用户名
out.println(userid);
try{
Class.forName(DBDRIVER);
conn=DriverManager.getConnection(DBURL,DBUSER,DBPASS);
String sql=" select * from name where username=?";
pstmt=conn.prepareStatement(sql);
pstmt.setString(1,userid);
rs=pstmt.executeQuery();
if(rs.next()){ if(rs.getString("username")==userid){
out.println("true");
}else{
out.println("false");
}
}
out.close();
}catch(Exception e){
e.printStackTrace();
}finally{
try{
conn.close();
}catch(SQLException e){
e.printStackTrace();
}
}
}
}
----------------------------check.jsp
<%@ page language="java" pageEncoding="utf-8"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<!doctype html>
<html lang="en">
<body>
<script>
window.onload = initPage;
function initPage() {
document.getElementById("userid").onblur = checkUserid;//引用函数方法。
} //创建请求对象
function createRequest() {
try {
request = new XMLHttpRequest();
} catch (tryMS) {
try {
request = new ActiveXObject("Msxml2.XMLHTTP");
} catch (otherMS) {
try {
request = new ActiveXObject("Microsoft.XMLHTTP");
} catch (failed) {
request = null;
}
}
}
return request;
}
//检查用户名是否重复
function checkUserid(){
request=createRequest();
var theName = document.getElementById("userid").value;
request.open("POST","CheckServlet?userid="+theName,true);
request.onreadystatechange=checkUseridCallback;
request.send(null);
document.getElementById("msg").innerHTML="正在验证..."; }
//回调函数
function checkUseridCallback(){
if(request.readyState==4){
if(request.status==200){
if( request.responseText=="true"){
document.getElementById("msg").innerHTML="用户ID重复";
}else{
document.getElementById("msg").innerHTML="此用户ID可以注册"; }
}
}
}
</script>
<form action="check.jsp" method="POST" >
用户ID: <input type="text" id="userid" name="userid">
<span id="msg"></span>
<br>
姓名 <input type="text" name="name" >
</form>
</body>
</html>
Ajax数据库
-----------------------------------------
package servlets;
import java.io.*;
import java.sql.*;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpServlet;
public class CheckServlet extends HttpServlet{
public static final String DBDRIVER="com.mysql.jdbc.Driver";
public static final String DBURL="jdbc:mysql://localhost:8889/username";
public static final String DBUSER="root";
public static final String DBPASS="root";
public void doGet(HttpServletRequest request,HttpServletResponse response)
throws ServletException,IOException{
this.doPost(request, response);
}
public void doPost(HttpServletRequest request,HttpServletResponse response)
throws ServletException,IOException{
request.setCharacterEncoding("gbk");
response.setContentType("text/html");
Connection conn=null;
PreparedStatement pstmt=null;
ResultSet rs=null;
PrintWriter out=response.getWriter();
String userid=request.getParameter("userid");//接受验证的用户名
out.println(userid); //这里可以输出
try{
Class.forName(DBDRIVER);
conn=DriverManager.getConnection(DBURL,DBUSER,DBPASS);
String sql=" select * from name where username=?";
pstmt=conn.prepareStatement(sql);
pstmt.setString(1,userid);
rs=pstmt.executeQuery();
out.println(userid); //这段语句是可以输出的
//下面这段可能有错误请大神看看
if(rs.next()){
out.println(userid);//这里就没有输出了。
if(rs.getString("username")==userid){
out.println("true");
}else{
out.println("false");
}
}
out.close();
}catch(Exception e){
e.printStackTrace();
}finally{
try{
conn.close();
}catch(SQLException e){
e.printStackTrace();
}
}
}
}
在浏览器直接访问如下地址的时候http://localhost:8080/ajaxtest/CheckServlet?userid=jack
页面输出2个jack ,doPost方法里面设置了3个输出userid的语句,有一个语句没有输出。
----------------------------check.jsp
<%@ page language="java" pageEncoding="utf-8"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<!doctype html>
<html lang="en">
<body>
<script>
window.onload = initPage;
function initPage() {
document.getElementById("userid").onblur = checkUserid;//引用函数方法。
} //创建请求对象
function createRequest() {
try {
request = new XMLHttpRequest();
} catch (tryMS) {
try {
request = new ActiveXObject("Msxml2.XMLHTTP");
} catch (otherMS) {
try {
request = new ActiveXObject("Microsoft.XMLHTTP");
} catch (failed) {
request = null;
}
}
}
return request;
}
//检查用户名是否重复
function checkUserid(){
request=createRequest();
var theName = document.getElementById("userid").value;
request.open("POST","CheckServlet?userid="+theName,true);
request.onreadystatechange=checkUseridCallback;
request.send(null);
document.getElementById("msg").innerHTML="正在验证..."; }
//回调函数
function checkUseridCallback(){
if(request.readyState==4){
if(request.status==200){
if( request.responseText=="true"){
document.getElementById("msg").innerHTML="用户ID重复";
}else{
document.getElementById("msg").innerHTML="此用户ID可以注册"; }
}
}
}
</script>
<form action="check.jsp" method="POST" >
用户ID: <input type="text" id="userid" name="userid">
<span id="msg"></span>
<br>
姓名 <input type="text" name="name" >
</form>
</body>
</html>这是数据库的信息在check.jsp 里面输入jack的时候显示可注册!!!实际应该提示不能注册的
while(rs.next()){
String username = rs.getString("username");
}
你的数据库可以连接吗?建议你把数据库连接单独做成一个Util工具包,然后先测试下
String类型的可以用==来比较是否相等么?另外楼主对象的起名要对应,不要把userid和usernmae混起来用。这样很容易让其他人看不懂的。
userid理论上应该是自动生成的主键才对。
查找的应该是username
浏览器直接访问http://localhost:8080/ajaxtest/CheckServlet?userid=admin //admin是数据库已经有的人名
已经可以直接输出true了,但是在check.jsp上还是说可以注册。为什么request.responseText既不是true也不是false呢?
自增。
check.jsp说还可以注册的那说明返回的就不是String类型的true或者false。
你是不是返回了boolean型的呢?
这东西好久没接触,只是觉得某些地方很怪,但是说不上来。
你想知道返回的是什么的话,那么你干嘛不在页面打出来看看呢?
嗯谢谢你提醒了我,我打印出request.responseText的时候都是输出false的
function checkUseridCallback(){
if(request.readyState==4){
if(request.status==200){
var text=request.responseText;
alert(text); //这里输出的都是false
if( text=="true"){
document.getElementById("msg").innerHTML="用户ID重复";
}if(text=="false"){
document.getElementById("msg").innerHTML="此用户ID可以注册"; }
}
}
}
如果判定语句是下面这样的话,它都是输出此用户ID可以注册
if( text=="true"){
document.getElementById("msg").innerHTML="用户ID重复";
}else{
document.getElementById("msg").innerHTML="此用户ID可以注册";
}
但是如果判定语句改成
if( text=="true"){
document.getElementById("msg").innerHTML="用户ID重复";
}if(text=="false"){
document.getElementById("msg").innerHTML="此用户ID可以注册"; }
}页面就永远停止在“正在验证...”这一段了。
function checkUserid(userid){
createRequest();
request.open("POST","CheckServlet?userid="+userid);
request.onreadystatechange=checkUseridCallback;
request.send(null);
document.getElementById("msg").innerHTML="正在验证...";
}
好奇怪啊