아이디 중복 체크하기 예제

WEB/Ajax Json

아이디 중복 체크하기 예제

choi121xx 2015. 2. 26. 15:34

< DBConnection.java >

package test.db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DBConnection {
public static Connection getCon() throws SQLException{
  Connection con=null;
  try{
   Class.forName("oracle.jdbc.OracleDriver");
   String url="jdbc:oracle:thin:@localhost:1521:XE";
   con= DriverManager.getConnection(url,"SCOTT","TIGER");
   return con;
  }catch(ClassNotFoundException ce){
   System.out.println(ce.getMessage());
   return null;
  }
}
}

1. 초기화면

2. 1을 등록하면 바로 옆에 검증 후 메시지 보여줌.

3. 2을 등록하면 가능하다고 보여줌.

4. 관련 테이블 데이터

; 데이터로 ID 1이 들어가 있음.

< insert.html >

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=EUC-KR">
<title>Insert title here</title>
<style type="text/css">
#idcheck{
  color:red;
  font-size:10pt;
}
</style>
<script type="text/javascript">
var xhr=null;

function getXHR(){
  if(window.XMLHttpRequest){
   //IE 7.0이상,Chrome,Firefox,Safari,....
   return new XMLHttpRequest();
  }else{
   //IE 하위버젼(6.0이하)
   return new ActiveXObject("Microsoft.XMLHTTP");
  }
}

function idCheck(){
  xhr=getXHR();
  xhr.onreadystatechange=getResult;
  var id=document.getElementById("id").value;
  xhr.open("get","idcheck.jsp?id="+id,true);
  xhr.send(null);
}

function getResult(){
  if(xhr.readyState==4 && xhr.status==200){
   var xml=xhr.responseXML;
   var re=xml.getElementsByTagName("result")[0].firstChild.nodeValue;

   if(re=='true'){
    //span에 결과 출력하기
    document.getElementById("idcheck").innerHTML="이미 사용중인 아이디 입니다.";
   }else{
    document.getElementById("idcheck").innerHTML="사용가능한 아이디 입니다.";
   }
  }
}
</script>
</head>
<body>
<h3>회원가입</h3>
<form method="post" action="insert.jsp">
아이디 <input type="text" name="id" id="id" onkeyup="idCheck()"/>

<span id="idcheck"></span>
<br/>
비밀번호 <input type="password" name="pwd"/><br/>
이메일<input type="text" name="email"/><br/>
<input type="submit" value="회원가입"/>
</form>
</body>
</html>

< idcheck.jsp >

<%@page import="java.io.PrintWriter"%>
<%@page import="java.sql.SQLException"%>
<%@page import="test.db.DBConnection"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=EUC-KR"
    pageEncoding="EUC-KR"%>
<%
//1.사용자가 입력한 아이디 얻어오기
String id=request.getParameter("id");
//2.해당아이디가 존재하는지 검사
Connection con=null;
PreparedStatement pstmt=null;
ResultSet rs=null;
boolean result=false;
try{
  con=DBConnection.getCon();
  String sql="select * from members where id=?";
  pstmt=con.prepareStatement(sql);
  pstmt.setString(1, id);
  rs=pstmt.executeQuery();
  if(rs.next()){
   result=true;
  }
}catch(SQLException se){
  System.out.println(se.getMessage());

}finally{
  rs.close();
  pstmt.close();
  con.close();
}

////////// 3.xml로 결과 응답하기 ///////////
response.setContentType("text/xml;charset=euc-kr");
PrintWriter pw=response.getWriter();
pw.println("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
pw.println("<data>");
pw.println("<result>" + result + "</result>");
pw.println("</data>");
pw.close();

%>

저작자표시