게시판 - webstudy-board - 게시판 글쓰기

1. SQL

1) auto increment 값 받아오기

SELECT AUTO_INCREMENT FROM information_schema.tables WHERE table_name = 'table name' AND table_schema = DATABASE( ) ;

 

2. View

1)  WebContent - view - board- boardList.jsp 링크 수정

<a href="DispatcherServlet?command=createBoardPage">글쓰기</a>

2)  WebContent - view - board- createBoard.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"> <form action="DispatcherServlet" method="post"> <input type="hidden" name="command" value="createBoard"> <table> <tr> <td>작성자</td><td><input type="text" name ="clientName" value="${sessionScope.clientDTO.clientName}" readonly="readonly"></td> </tr> <tr> <td>글제목</td><td><input type="text" name="boardTitle"></td> </tr> <tr> <td>글쓰기</td><td><textarea name="boardContent" cols="50" rows="13"></textarea></td> </tr> <tr> <td colspan="2"><input type="submit" value="작성 완료"></td> </tr> </table> </form> </div>

 

3. Model

1) src - model.BoardDAO.java에 createBoard 메소드 추가

//3. 글쓰기 @SuppressWarnings("resource") public int createBoard(String boardTitle, String boardContent, String clientId) throws SQLException { Connection con=null; PreparedStatement pstmt=null; ResultSet rs=null; int boardNo=0; try { con=getConnection(); String sql="insert into board(boardTitle, boardContent, clientId) values (?,?,?)"; pstmt=con.prepareStatement(sql); pstmt.setString(1,boardTitle); pstmt.setString(2,boardContent); pstmt.setString(3,clientId); pstmt.execute(); pstmt.close(); pstmt=con.prepareStatement("SELECT AUTO_INCREMENT-1 FROM information_schema.tables WHERE table_name = 'board' AND table_schema = DATABASE()"); rs=pstmt.executeQuery(); while(rs.next()) boardNo=rs.getInt(1); }finally{ closeAll(rs, pstmt, con); } return boardNo; }

2) src - test.TestCreateBoard.java 추가

package test; import model.BoardDAO; public class TestCreateBoard { public static void main(String[] args) { int boardNo=0; try { boardNo=BoardDAO.getInstance().createBoard("안녕", "지금 테스트중", "do"); System.out.println(boardNo); } catch (Exception e) { e.printStackTrace(); } } }

 

4. Controller

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

else if(command.equals("createBoard")) // 글쓰기 처리 c=new CreateBoardController();

2) src - controller.CreateBoardController.java 추가

package controller; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import model.BoardDAO; import model.ClientDTO; public class CreateBoardController implements Controller { @Override public String execute(HttpServletRequest request, HttpServletResponse response) throws Exception { HttpSession session = request.getSession(false); if(session==null||session.getAttribute("clientDTO")==null){ return "redirect:index.jsp"; } ClientDTO clientDTO=(ClientDTO)session.getAttribute("clientDTO"); String boardTitle=request.getParameter("boardTitle"); String boardContent=request.getParameter("boardContent"); String clientId=clientDTO.getClientId(); int boardNo=BoardDAO.getInstance().createBoard(boardTitle,boardContent,clientId); return "redirect:DispatcherServlet?command=ViewBoard&boardNo="+boardNo; } }

 

[참고]

auto increment값 받아오기 https://wkdgusdn3.tistory.com/entry/%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%B2%A0%EC%9D%B4%EC%8A%A4-%EB%8B%A4%EC%9D%8C-autoincrement-%EA%B0%92-%EB%B0%9B%EC%95%84%EC%98%A4%EA%B8%B0