개발자로가는길

1. Template

1) WebContent - view - template - sidebar.jsp 수정

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <c:choose> <c:when test="${sessionScope.clientDTO==null}"> <!-- 로그인 부분 --> <div class="card"> <h3>로그인</h3> <form method="post" action="${pageContext.request.contextPath}/DispatcherServlet"> <input type="hidden" name="command" value="login"> <p>아이디 <input type="text" name="clientId" placeholder="아이디" size="12"></p> <p>패스워드 <input type="password" name="clientPassword" placeholder="비밀번호" size="12"></p> <input type="submit" value="로그인"> <a href="${pageContext.request.contextPath}/DispatcherServlet?command=registerPage">회원가입</a></p> </form> </div> </c:when> <c:otherwise> <div class="card"> <p>${sessionScope.clientDTO.clientName}님    반갑습니다.</p> <p><a href="${pageContext.request.contextPath}/DispatcherServlet?command=logout">로그아웃</a></p> <p><a href="#">회원수정</a></p> <p><a href="#">회원탈퇴</a></p> <p><a href="${pageContext.request.contextPath}/index.jsp">홈으로</a>  </p> </div> <!-- 메뉴부분 --> <div class="card"> <h3>게시판</h3> <a href="#">게시판 보기</a> </div> </c:otherwise> </c:choose>

2. View

1) WebContent - view - member - login_result.jsp 추가

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <!-- 로그인 실패 : 세션 없음 --> <c:if test="${sessionScope.clientDTO==null}"> <script lang="javascript"> alert('아이디가 없거나 패스워드가 맞지 않아 로그인에 실패하셨습니다.'); location.href='http://localhost:8080/webstudy-board/'; </script> </c:if> <!-- 로그인 성공 : 세션 있음 --> <c:if test="${sessionScope.clientDTO!=null}"> <script lang="javascript"> var name='${sessionScope.clientDTO.clientName}'; alert(name+'님 안녕하세요'); location.href='http://localhost:8080/webstudy-board/'; </script> </c:if>

3. Model 

1) src - model.ClientDAO.java에 login 로그인 메소드 추가

public ClientDTO login(ClientDTO clientDTO) throws SQLException { ClientDTO resultDTO=null; Connection con=null; PreparedStatement pstmt=null; ResultSet rs=null; try { con=getConnection(); String sql="select clientId,clientName from client where clientId=? and clientPassword=?"; pstmt=con.prepareStatement(sql); pstmt.setString(1, clientDTO.getClientId()); pstmt.setString(2, clientDTO.getClientPassword()); rs=pstmt.executeQuery(); if(rs.next()) resultDTO=new ClientDTO(rs.getString(1), null, rs.getString(2), null, null, null); }finally { closeAll(rs, pstmt, con); } return resultDTO; }

2) src - test.TestLogin.java 추가(login 메소드 테스트)

package test; import model.ClientDAO; import model.ClientDTO; public class TestLogin { public static void main(String[] args) { String clientId="xiumin"; String clientPassword="exo1234"; try { ClientDTO clientDTO=ClientDAO.getInstance().login(new ClientDTO(clientId,clientPassword,null,null,null,null)); System.out.println(clientDTO); } catch (Exception e) { e.printStackTrace(); } } }

4. Controller

1) src - controller.HandlerMapping.java에 login, logout command 추가;

else if(command.equals("login")) //로그인 c=new LoginController(); else if(command.equals("logout")) //로그아웃 c=new LogoutController();

2) src - controller.LoginController.java 추가

package controller; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import model.ClientDAO; import model.ClientDTO; public class LoginController implements Controller { @Override public String execute(HttpServletRequest request, HttpServletResponse response) throws Exception { String clientId=request.getParameter("clientId"); String clientPassword=request.getParameter("clientPassword"); ClientDTO clientDTO=ClientDAO.getInstance().login(new ClientDTO(clientId,clientPassword,null,null,null,null)); HttpSession session=request.getSession(); session.setAttribute("clientDTO", clientDTO); return "redirect:view/member/login_result.jsp"; } }

3) src - controller.LogoutController.java 추가

package controller; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; public class LogoutController implements Controller { @Override public String execute(HttpServletRequest request, HttpServletResponse response) throws Exception { HttpSession session = request.getSession(false); if(session!=null) session.invalidate(); return "redirect:index.jsp"; } }

1. Template

1) WebContent - view - template - sidebar.jsp 에 회원가입 링크 추가

<p><a href="${pageContext.request.contextPath}/DispatcherServlet?command=registerPage">회원가입</a></p>

2. View

1) WebContent - view -  member - register.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <div class="card"> <div class="registerClient"> <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> </div> </div>

2) WebContent - view -  member - register_result.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <script> alert("등록이 완료되었습니다."); location.href="http://localhost:8080/webstudy-board/"; </script>

3. Model

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

//1. 회원등록 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); } }

2) src - test.TestRegister.java (register 메소드를 테스트)

package test; import java.sql.SQLException; import model.ClientDAO; import model.ClientDTO; public class TestRegister { public static void main(String[] args) { ClientDTO newClient=new ClientDTO("test", "test1234", "테스트", "test@test.com", "010-0000-0000", "서울시 종로구"); try { ClientDAO.getInstance().register(newClient); System.out.println("추가완료"); } catch (SQLException e) { e.printStackTrace(); } } }

4. Controller

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

else if(command.equals("registerPage")) //회원가입 페이지 이동 c=new RegisterPageController(); else if(command.equals("register")) //회원가입 처리 c=new RegisterController();

2) src - controller.RegisterPageController.java 추가

package controller; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; public class RegisterPageController implements Controller { @Override public String execute(HttpServletRequest request, HttpServletResponse response) throws Exception { request.setAttribute("url", "/view/member/register.jsp"); return "/view/template/home.jsp"; } }

3) src - controller.ResgisterController.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:view/member/register_result.jsp"; } }

5.CSS

1. webstudy-board 폴더 구조

1. index 페이지와  error 페이지

1) WebContent-index.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <jsp:forward page="DispatcherServlet"> <jsp:param name="command" value="mainPage"/> </jsp:forward>

2) WebContent-error.jsp

에러페이지 이동하기

3) WebContent - view - template - home.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>회원관리 & 게시판</title> <link rel="stylesheet" href="${pageContext.request.contextPath}/css/style.css"> </head> <body> <div class="header"> <c:import url="/view/template/header.jsp"></c:import> </div> <div class="row"> <div class="leftcolumn"> <c:import url="/view/template/sidebar.jsp"></c:import> </div> <div class="rightcolumn"> <c:import url="${url}"></c:import> </div> </div> <div class="footer"> <c:import url="/view/template/footer.jsp"></c:import> </div> </body> </html>

4) WebContent - view - template - header.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <h1>게시판 테스트</h1> <p>게시판 테스트 중입니다. 나중에 페이징빈도 할 것 입니다.</p>

5) WebContent - view - template - sidebar.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <!-- 회원 --> <div class="card"> 회원부분 </div> <!-- 메뉴부분 --> <div class="card"> 메뉴부분 </div>

6) WebContent - view - template - footer.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <h2>푸터임</h2>

7) WebContent - view - template - mainPage.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <div class="card"> <img src="./mainPage_Img.jpg"/> </div>

- mainPage 이미지

2. Controller

1) src - controller.HandlerMapping.java

package controller; public class HandlerMapping { private static HandlerMapping instance=new HandlerMapping(); private HandlerMapping() {} public static HandlerMapping getInstance() { return instance; } public Controller create(String command) { Controller c=null; //메인 if(command.equals("mainPage")) c=new MainPageController(); //회원관리 //게시판 return c; } }

2) src - controller.MainPageController.java

package controller; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; public class MainPageController implements Controller { @Override public String execute(HttpServletRequest request, HttpServletResponse response) throws Exception { request.setAttribute("url", "/view/template/mainPage.jsp"); return "/view/template/home.jsp"; } }

3.CSS

1) WebContent - css - style.css

** 표현 언어(EL:Expression Language) **
- 데이터를 웹 페이지에 표시하는데 사용하는 태그
- JSP 출력에 대한 부분을 쉽게 하기 위해 개발한 태그
- 등장배경 : 자바코드로 내장 객체(request, session 등)에 저장된 속성 값에 접근하면 코드가 길어지고 지저분해짐
ex) ${ expr }

* 요청 파마리터 처리
request.getParamter()--->param 객체
- param : request.getParameter()와 동일한 역할로, 파라미터 값을 알려준다
- paramValues : request.getParamterValues()와 동일한 역할로, 동일한 이름으로 전달되는 파라미터 값들(라디오버튼, 체크박스 등)을 배열형태로 얻어온다.

ex)
request.getParameter("id") ---> ${param.id}
request.getParameter("pw") ---> ${param.pw}


* 내장객체 접근
- pageScope : 내장객체 pageContext
- requestScope : 내장객체 request
- sessionScope : 내장객체 session
- applicationScope : 내장객체 application




** JSTL (JSP Standard Tag Library) **

- JSP 표준 태크 라이브러리
- 일관성 없던 커스텀 태그(JSP를 작성할 때 자주 사용되는 자바 코드를 웹에서 사용할 수 있는 태크 형태로 만드는 기술)들을 표준화 한 것

* 태그 라이브러리 사용하기
- JSTL 제공 기능 중 core를 사용하기 위한 taglib
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
- uri : 사용할 태그 라이브러리 식별자
- prefix : 태그에서 사용할 접두어

* JSTL core 태그

1. model

1) src - model.DataSource.java

package model; import javax.sql.DataSource; import org.apache.tomcat.dbcp.dbcp2.BasicDataSource; /* * javax.sql.DataSource Interface는 다양한 DBCP 구현체를 표준화 하는 인터페이스 * DataSource Interface 타입으로 DAO에서 사용하면 DBCP 구현체가 변경되도 별도 코드 수정 필요 없음 */ public class DataSourceManager { private static DataSourceManager instance=new DataSourceManager(); private DataSource dataSource; private DataSourceManager() { BasicDataSource dbcp=new BasicDataSource(); dbcp.setDriverClassName("org.mariadb.jdbc.Driver"); dbcp.setUrl("jdbc:mysql://localhost:3306/study_db"); dbcp.setUsername("study_user"); dbcp.setPassword("user"); //동시에 사용될 수 있는 커넥션 수 설정, 기본은 8 dbcp.setMaxTotal(20); dataSource=dbcp; } public static DataSourceManager getInstance() { return instance; } public DataSource getDataSource() { return dataSource; } }

2) src - model.ClientDTO

3) src - model.ClientDAO

4)src - model.BoardDTO

package model; public class BoardDTO { private int boardNo; private String boardTitle; private String boardContent; private String clientId; private String boardDate; private int boardCount; public BoardDTO() { super(); } public BoardDTO(int boardNo, String boardTitle, String boardContent, String clientId, String boardDate, int boardCount) { super(); this.boardNo = boardNo; this.boardTitle = boardTitle; this.boardContent = boardContent; this.clientId = clientId; this.boardDate = boardDate; this.boardCount = boardCount; } public int getBoardNo() { return boardNo; } public void setBoardNo(int boardNo) { this.boardNo = boardNo; } public String getBoardTitle() { return boardTitle; } public void setBoardTitle(String boardTitle) { this.boardTitle = boardTitle; } public String getBoardContent() { return boardContent; } public void setBoardContent(String boardContent) { this.boardContent = boardContent; } public String getClientId() { return clientId; } public void setClientId(String clientId) { this.clientId = clientId; } public String getBoardDate() { return boardDate; } public void setBoardDate(String boardDate) { this.boardDate = boardDate; } public int getBoardCount() { return boardCount; } public void setBoardCount(int boardCount) { this.boardCount = boardCount; } @Override public String toString() { return "BoardDTO [boardNo=" + boardNo + ", boardTitle=" + boardTitle + ", boardContent=" + boardContent + ", clientId=" + clientId + ", boardDate=" + boardDate + ", boardCount=" + boardCount + "]"; } }

5) src - mordel.BoardDAO

package model; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import javax.sql.DataSource; public class BoardDAO { private static BoardDAO instance=new BoardDAO(); private DataSource dataSource; private BoardDAO(){ dataSource=DataSourceManager.getInstance().getDataSource(); } public static BoardDAO getInstance() throws ClassNotFoundException{ return instance; } public void closeAll(PreparedStatement pstmt,Connection con) throws SQLException{ if(pstmt!=null) pstmt.close(); if(con!=null) con.close(); } public void closeAll(ResultSet rs,PreparedStatement pstmt,Connection con) throws SQLException{ closeAll(pstmt,con); if(rs!=null) rs.close(); } public Connection getConnection() throws SQLException{ return dataSource.getConnection(); } //여기서부터 코딩 }

※ DB connection 테스트

1) src - mordel.BoardDAO 에 checkDbconnect 추가

//DB Connection Test public void checkDbconnect()throws SQLException{ Connection con=null; PreparedStatement pstmt=null; ResultSet rs=null; ArrayList<ClientDTO> list=new ArrayList<ClientDTO>(); try { con=dataSource.getConnection(); String sql="select * from client"; pstmt=con.prepareStatement(sql); rs=pstmt.executeQuery(); while(rs.next()) { ClientDTO resultDTO=new ClientDTO(rs.getString(1),rs.getString(2),rs.getString(3),rs.getString(4),rs.getString(5),rs.getString(6)); list.add(resultDTO); } for(int i=0;i<list.size();i++) System.out.println(list.get(i)); }finally { closeAll(rs, pstmt, con); } }

2) src - test.TestDBConnection.java 

package test; import java.sql.SQLException; import model.BoardDAO; public class TestDBConnection { public static void main(String[] args) throws ClassNotFoundException, SQLException { BoardDAO.getInstance().checkDbconnect(); } }

[참고] Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/juli/logging/LogFactory 에러발생 시

- tomcat-juli.jar파일 다운로드(톰캣버전에 맞게) : https://mvnrepository.com/artifact/org.apache.tomcat/tomcat-juli

- Java\jdk1.8.0_211\jre\lib\ext 안에 tomcat-juli.jar 파일을 넣는다.

2. controller

1) src - controller.DispatcherServelt.java

package controller; import java.io.IOException; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; @WebServlet("/DispatcherServlet") public class DispatcherServlet extends HttpServlet { private static final long serialVersionUID = 1L; public DispatcherServlet() { super(); } protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { handleRequest(request, response); } protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); handleRequest(request, response); } private void handleRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{ try { String command=request.getParameter("command"); String url=HandlerMapping.getInstance().create(command).execute(request,response); if(url.trim().startsWith("redirect:")) response.sendRedirect(url.trim().substring(9)); else request.getRequestDispatcher(url).forward(request, response); } catch (Exception e) { e.printStackTrace(); response.sendRedirect("error.jsp"); } } }

2) src - controller.HandlerMapping.java

package controller; public class HandlerMapping { private static HandlerMapping instance=new HandlerMapping(); private HandlerMapping() {} public static HandlerMapping getInstance() { return instance; } public Controller create(String command) { Controller c=null; //메인 //회원관리 //게시판 return c; } }

3) src - controller.Controller.java(인터페이스)

package controller; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; public interface Controller { public String execute(HttpServletRequest request, HttpServletResponse response) throws Exception; }

* 기능 명세서

1. ERD

2. Class Diagram