- 회원가입 페이지
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-1BmE4kWBq78iYhFldvKuhfTAU6auU8tT94WrHftjDbrCEXSU1oBoqyl2QvZ6jIW3" crossorigin="anonymous">
<title>JSP 게시판 웹 사이트</title>
</head>
<body>
<nav class="navbar navbar-expand-lg navbar-light bg-light">
<a class="navbar-brand" href="login.jsp">JSP 게시판</a>
<button class="navbar-toggler" type="button" data-toggle="collapse"
data-target="#navbarNav" aria-controls="navbarNav"
aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarNav">
<ul class="navbar-nav">
<li class="nav-item active">
<a class="nav-link" href="main.jsp">메인</a>
</li>
<li class="nav-item">
<a class="nav-link" href="bbs.jsp">게시판</a>
</li>
</ul>
<ul class="navbar-nav">
<li class="nav-item dropdown">
<a class="nav-link dropdown-toggle" href="#" id="navbarDropdownMenuLink" role="button" data-bs-toggle="dropdown"
aria-expanded="false"> 접속하기 </a>
<div class="dropdown-menu" aria-labelledby="navbarDropdownMenuLink">
<a class="dropdown-item" href="login.jsp">로그인</a>
<a class="dropdown-item" href="join.jsp">가입하기</a>
</div>
</li>
</ul>
</div>
</nav>
<div class="container">
<div class="row"> <!-- ? -->
<div class="col-lg-5 col-md-7 mx-auto"> <!-- 가로 길이 줄임 -->
<div class="bg-light p-5 mt-5"> <!-- 폼 전체 이동 -->
<form action="joinAction.jsp" method="post">
<h3 class="text-center mb-3">회원가입 화면</h3>
<input type="text" class="form-control mb-3" name="userID" placeholder="아이디" maxlength="20" required>
<input type="password" class="form-control mb-3" name="userPassword" placeholder="패스워드" maxlength="20" required>
<input type="text" class="form-control mb-3" name="userName" placeholder="이름" maxlength="20" required>
<input class="form-check-input" type="radio" name="userGender" value="남자" checked>
<label class="form-check-label" for="flexRadioDefault1">남자</label>
<input class="form-check-input" type="radio" name="userGender" value="여자">
<label class="form-check-label" for="flexRadioDefault2">여자</label>
<input type="email" class="form-control mt-3 mb-3" name="userEmail" placeholder="이메일" maxlength="20" required>
<input type="submit" class="btn btn-primary form-control mb-3" value="회원가입">
</form>
</div>
</div>
</div>
</div>
<script src="https://code.jquery.com/jquery-3.1.1.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js" integrity="sha384-ka7Sk0Gln4gmtz2MlQnikT1wXgYsOg+OMhuP+IlRH9sENBO0LRn5q+8nbTov4+1p" crossorigin="anonymous"></script>
</body>
</html>- UserDAO 클래스에 join 메서드 추가
public int join(User user) {
String SQL = "INSERT INTO USER VALUES (?, ?, ?, ?, ?)";
try {
pstmt = conn.prepareStatement(SQL);
pstmt.setString(1, user.getUserID());
pstmt.setString(2, user.getUserPassword());
pstmt.setString(3, user.getUserName());
pstmt.setString(4, user.getUserGender());
pstmt.setString(5, user.getUserEmail());
return pstmt.executeUpdate();
} catch (Exception e) {
e.getStackTrace();
}
return -1; //데이터베이스 오류
}- 회원가입 기능 구현
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ page import="user.UserDAO" %> <% request.setCharacterEncoding("UTF-8"); %> <jsp:useBean id="user" class="user.User" scope="page" /> <jsp:setProperty name="user" property="userID" /> <jsp:setProperty name="user" property="userPassword" /> <jsp:setProperty name="user" property="userName" /> <jsp:setProperty name="user" property="userGender" /> <jsp:setProperty name="user" property="userEmail" /> <!DOCTYPE html> <html> <head> <meta http-equiv="Content-Type" content="text/html" charset="UTF-8"> <title>JSP 게시판 웹 사이트</title> </head> <body> <% if(user.getUserID() == null || user.getUserPassword() == null || user.getUserName() == null || user.getUserGender() == null || user.getUserEmail() == null) { out.println("<script>"); out.println("alert('입력이 안된 사항이 있습니다.');"); out.println("history.back()"); out.println("</script>"); } else { UserDAO userDao = new UserDAO(); int result = userDao.join(user); if(result == -1) { out.println("<script>"); out.println("alert('이미 존재하는 아이디입니다.');"); out.println("history.back()"); out.println("</script>"); } else { out.println("<script>"); out.println("location.href = 'main.jsp'"); out.println("</script>"); } } %> </body> </html>
*pstmt.executeUpdate() :
*userDAO.join(user) : user는
*result == -1, 데이터베이스 오류가 나는 이유 : userID가 PRIMARY KEY 이기 때문에 아이디가 중복될 경우 데이터베이스 오류가 남
코딩주니어