forked from estanie/dbproject
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathupdate_verify.jsp
55 lines (50 loc) · 1.69 KB
/
update_verify.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
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
<%@ page import="java.sql.*" %>
<%@ include file="top.jsp" %>
<%@ include file="dbconfig.jsp" %>
<!DOCTYPE html>
<html>
<head><title> 수강신청 사용자 정보 수정 </title></head>
<body>
<%
String sMessage = null;
try {
String formPass = request.getParameter("userpw");
String formName = request.getParameter("username");
String formAddr = request.getParameter("useraddr");
String formEmail = request.getParameter("useremail");
PreparedStatement pstmt = null;
if (session_identity == "student") {
String sql = "UPDATE students set s_pwd=?,s_addr=?,s_email=? where s_id =?";
pstmt = myConn.prepareStatement(sql);
pstmt.setString(1, formPass);
pstmt.setString(2, formAddr);
pstmt.setString(3, formEmail);
pstmt.setInt(4, session_id);
pstmt.executeUpdate();
} else if (session_identity == "professor") {
String sql = "UPDATE professor set p_pwd=?,p_email=? where p_id =?";
pstmt = myConn.prepareStatement(sql);
pstmt.setString(1, formPass);
pstmt.setString(2, formEmail);
pstmt.setInt(3, session_id);
pstmt.executeUpdate();
}
} catch (SQLException ex) {
if (ex.getErrorCode() == 20002) sMessage = "암호는 4자리 이상이어야 합니다";
else if (ex.getErrorCode() == 20003) sMessage = "암호에 공란은 입력되지 않습니다.";
else sMessage = "잠시 후 다시 시도하십시오";
%>
<script>
alert("<%= sMessage %> ");
location.href = "update.jsp";
</script>
<%
}
%>
<script>
alert("변경이 완료되었습니다.");
location.href = "main.jsp";
</script>
</body>
</html>