Model2 Architecture - (1) 회원가입

1.JAVA Web Programming/[3주차]JSP+model2

Model2 Architecture - (1) 회원가입

서나브로 2019. 8. 1. 16:14

[회원가입 폼]

[실행화면]

1. 회원가입 폼

1) WebContent - index.jsp에 가입 url 기입

2) WebContent - register.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>회원가입</title> <style> table { border-collapse: collapse; width: 100%; } th, td { text-align: left; padding: 8px; } tr:nth-child(even) {background-color: #f2f2f2;} input[type=submit] { width: 20%; background-color: #4CAF50; color: white; padding: 14px 20px; margin: 8px 0; border: none; border-radius: 4px; cursor: pointer; } input[type=submit]:hover { background-color: #45a049; } </style> </head> <body> <h3>회원가입</h3> <form method="post" action="DispatcherServlet"> <input type="hidden" name="command" value="register"> <table> <tr> <td>아이디</td><td><input type="text" name="clientId"></td> </tr> <tr> <td>패스워드</td><td><input type="password" name="clientPassword"></td> </tr> <tr> <td>이름</td><td><input type="text" name="clientName"></td> </tr> <tr> <td>이메일</td><td><input type="email" name="clientEmail"></td> </tr> <tr> <td>휴대폰</td><td><input type="tel" name="clientPhone"></td> </tr> <tr> <td>주소</td><td><input type="text" name="clientAddress"></td> </tr> <tr> <td colspan="2" ><input type="submit" value="등록"></td> </tr> </table> </form> </body> </html>

3) WebContent - register_result.jsp (회원가입 성공시 등록 확인 페이지)

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>회원등록 성공</title> </head> <body> <script> alert("등록이 완료되었습니다."); location.href="http://localhost:8080/webstudy5-model2/"; </script> </body> </html>

2. controller 변경

1) src - controller.HandlerMapping.java에 register 추가

if(command.equals("register")) c=new RegisterController();

2) src - controller.RegisterController.java 생성

package controller; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import model.ClientDAO; import model.ClientDTO; public class RegisterController implements Controller { @Override public String execute(HttpServletRequest request, HttpServletResponse response) throws Exception { String clientId=request.getParameter("clientId"); String clientPassword=request.getParameter("clientPassword"); String clientName=request.getParameter("clientName"); String clientEmail=request.getParameter("clientEmail"); String clientPhone=request.getParameter("clientPhone"); String clientAddress=request.getParameter("clientAddress"); ClientDAO.getInstance().register(new ClientDTO(clientId, clientPassword, clientName, clientEmail, clientPhone, clientAddress)); return "redirect:register_result.jsp"; } }

3. model 변경

1) src - model.ClientDAO.java에 register 메소드 추가

public void register(ClientDTO clientDTO) throws SQLException{ Connection con=null; PreparedStatement pstmt=null; try { con=getConnection(); String sql="insert into client(clientId, clientPassword, clientName, clientEmail, clientPhone, clientAddress) values(?,?,?,?,?,?)"; pstmt=con.prepareStatement(sql); pstmt.setString(1,clientDTO.getClientId()); pstmt.setString(2,clientDTO.getClientPassword()); pstmt.setString(3,clientDTO.getClientName()); pstmt.setString(4,clientDTO.getClientEmail()); pstmt.setString(5,clientDTO.getClientPhone()); pstmt.setString(6,clientDTO.getClientAddress()); pstmt.execute(); }finally { closeAll(pstmt,con); } }