Ajax校验text框内的内容（登录验证）

最新推荐文章于 2020-07-06 20:44:51 发布

xiaoshixiang

最新推荐文章于 2020-07-06 20:44:51 发布

阅读量463

点赞数 1

文章标签： ajax xmlhttprequest string sql null function

本文链接：https://blog.csdn.net/xiaoshixiang/article/details/3096196

版权

页面代码如下：

<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<script language="javascript">

var xmlHttp;

function CreateXmlHttp(){
if(xmlHttp==null){
  if(window.ActiveXObject){
   xmlHttp = new ActiveXObject("microsoft.XMLHTTP");
  }else if(window.XMLHttpRequest){
   xmlHttp = new XMLHttpRequest();
  }
}
}

function doRequest(url){
if(xmlHttp==null){
CreateXmlHttp();
}

if(xmlHttp){
  xmlHttp.open("GET",url,true);
  xmlHttp.onreadystatechange = callback;
  xmlHttp.send(null);
}

}

后台AjaxServelt代码：

package client.servlet;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.*;

import commonBean.DBConnectionOracleImpl;

public class AjaxServlet extends HttpServlet {

public AjaxServlet() {
super();
}

public void destroy() {
super.destroy();
}

public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

doProcess(request,response);
}

public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

  doProcess(request,response);
}

public void doProcess(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

  String user_id = request.getParameter("userid");
  String password = request.getParameter("pw");
  String check = request.getParameter("check");
  System.out.println("userid+password+check=="+user_id+password+check);
  PreparedStatement ps = null;
  ResultSet rs = null;
  Connection conn = null;
  PrintWriter out = response.getWriter();
  if("userid".equalsIgnoreCase(check)){
   conn = DBConnectionOracleImpl.getInstance().getConnection();
   String sql = "SELECT USERID FROM SYSTEM.USERINFO WHERE USERID='"+user_id+"'";
   System.out.println("sql=="+sql);
   try {
    ps = conn.prepareStatement(sql);
    rs = ps.executeQuery();
    if(rs.next()){
     out.println("1");
     System.out.println("1");
    }else{
     out.println("0");
     System.out.println("0");
    }
   } catch (SQLException e) {
    e.printStackTrace();
   }
  }else{
   conn = DBConnectionOracleImpl.getInstance().getConnection();
   String sql = "SELECT PASSWORD FROM SYSTEM.USERINFO WHERE PASSWORD='"+password+"'";
   System.out.println("sql=="+sql);
   try {
    ps = conn.prepareStatement(sql);
    rs = ps.executeQuery();
    if(rs.next()){
     out.println("3");
     System.out.println("3");
    }else{
     out.println("2");
     System.out.println("2");
    }
   } catch (SQLException e) {
    e.printStackTrace();
   }

  }

  DBConnectionOracleImpl.dbClose(conn);
  try{
   if(ps!=null) ps.close();
   if(rs!=null) rs.close();
  }catch(SQLException e){
   System.out.println("ps或rs关闭失败！");
   e.printStackTrace();
  }

}

public void init() throws ServletException {
}

}

xiaoshixiang

关注

1
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
Ajax校验text框内的内容（登录验证）

页面代码如下： var xmlHttp;function CreateXmlHttp(){ if(xmlHttp==null){ if(window.ActiveXObject){ xmlHttp = new ActiveXObject("microsoft.XMLHTTP"); }else if(window.XMLHttpRequest){ xmlHt
复制链接

扫一扫