index.jsp// 首页,在这里输入用户名查询<!doctype html>
<html lang="en">
<head>
<meta charset="gbk">
<title>Document</title>
</head>
<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("GET","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( text=="true"){
flag=false;
document.getElementById("msg").innerHTML="用户ID重复";
}else{
flag=true;
document.getElementById("msg").innerHTML="此用户ID可以注册";
}
}
}
}
</script>
<form action="index.jsp" method="GET" ">
用户ID: <input type="text" id="userid" name="userid">
<span id="msg"></span>
<br>
姓名 <input type="text" name="name" >
</form>
</body>
</html>package org.lxh.ajaxdemo;
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?characterEncoding=gbk";
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");
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.getInt(1)>0){
out.println("true");
}else{
out.println("false");
}
}
out.close();
}catch(Exception e){
e.printStackTrace();
}finally{
try{
conn.close();
}catch(SQLException e){
e.printStackTrace();
}
}
}
}
<html lang="en">
<head>
<meta charset="gbk">
<title>Document</title>
</head>
<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("GET","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( text=="true"){
flag=false;
document.getElementById("msg").innerHTML="用户ID重复";
}else{
flag=true;
document.getElementById("msg").innerHTML="此用户ID可以注册";
}
}
}
}
</script>
<form action="index.jsp" method="GET" ">
用户ID: <input type="text" id="userid" name="userid">
<span id="msg"></span>
<br>
姓名 <input type="text" name="name" >
</form>
</body>
</html>package org.lxh.ajaxdemo;
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?characterEncoding=gbk";
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");
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.getInt(1)>0){
out.println("true");
}else{
out.println("false");
}
}
out.close();
}catch(Exception e){
e.printStackTrace();
}finally{
try{
conn.close();
}catch(SQLException e){
e.printStackTrace();
}
}
}
}
解决方案 »
- hibernate 执行hql报错:org.springframework.orm.hibernate3.HibernateQueryException
- 关联关系映射,如此简化方法是否可行
- java heap space(在线等)
- 让createElement创建的div层,始终在屏幕的中央,位置怎么控制啊!
- 在struts技术开发中关于下拉框事件的问题
- 新年要找工作了,大家谈谈找工作的体会吧,谈些面试上的技术上的东西也行,不限话题
- web.xml重新部署时出错,有懂的兄弟快帮我看一下
- new ClassPathXmlApplicationContext("applicationContext.xml")报错
- 有趣的问题:请问我扔出了什么类型的异常?
- JSP与MYSQL网站出现的情况
- Java调用NET编写的WebService问题
- JSP用javabean链接SQLServer
改为如下:<servlet>
<description></description>
<display-name>CheckServlet</display-name>
<servlet-name>CheckServlet</servlet-name>
<servlet-class>org.lxh.ajaxdemo.CheckServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>CheckServlet</servlet-name>
<url-pattern>/CheckServlet</url-pattern>
</servlet-mapping>
问题大概解决了,的确是数据库链接的问题,谢谢你的回答好人一生平安。不过还有一个剩余的问题就是 String sql=" select * from name where username=?";
pstmt=conn.prepareStatement(sql);
pstmt.setString(1,userid);
rs=pstmt.executeQuery();
if(rs.next()){
if(rs.getInt(1)>0){ //这里验证方法应该是错的,怎么改呢?
out.println("true");//如果有该用户名则返回true信息
}else{
out.println("false");
}
这里永远都是out.println("false"),不管用户名存不存在。为什么呢?导致
if(request.readyState==4){
if(request.status==200){
if( request.responseText=="true"){
document.getElementById("msg").innerHTML="用户ID重复"; //这段话永远执行不到
}else{
document.getElementById("msg").innerHTML="此用户ID可以注册"; }
}
}
password也要传进来
我这里没有弄密码验证。只单纯验证用户名是否存在。
数据库只有一个表,name
里面有三个人名如下图
当我输入jack的时候,它仍旧是判定为false的,所以还是可以注册。
我改成这样
if(rs.next()){
if(rs.getString("username")==userid){
out.println("true");
}else{
out.println("false");
}
还是不行啊