forked from halnigalni/DB_Team3_Phase4
-
Notifications
You must be signed in to change notification settings - Fork 0
/
idchecking.jsp
63 lines (58 loc) · 1.54 KB
/
idchecking.jsp
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page language = "java" import ="java.text.*, java.sql.*,java.util.ArrayList"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>id중복확인</title>
</head>
<body>
<form action="Join.jsp" method = "POST">
<%
String id= request.getParameter("id");
String serverIP = "localhost";
String strSID = "orcl";
String portNum = "1521";
String user = "university";
String pass = "comp322";
String url = "jdbc:oracle:thin:@"+serverIP+":"+portNum+":"+strSID;
String idcheck = "false";
Connection conn = null; // Connection object
Statement stmt = null; // Statement object
ResultSet rs;
Class.forName("oracle.jdbc.driver.OracleDriver");
conn=DriverManager.getConnection(url,user,pass);
String sql ="";
try {
conn.setAutoCommit(false);
stmt = conn.createStatement();
sql = "SELECT * FROM ACCOUNT WHERE Account_id = '"+id+"'";
rs = stmt.executeQuery(sql);
if(id.compareTo("")==0) { //idfield에 아무입력 없을 때
out.println("please input id");
id="";
}
else
{
if(rs.next()) //이미 있는 id일 때
{
out.println("That id is already exists.");
id = "";
}
//사용가능한 id일 때
else {
out.print("That id is available.");
idcheck = "true";
}
}
}catch(SQLException ex2) {
System.exit(1);
}
session.setAttribute("key",idcheck);
session.setAttribute("id",id);
%>
<input type = "submit" value = "Go Join">
</form>
</body>
</html>