게시물 등록

DAO

테스트

   @Test
    public void insertTest() throws ClassNotFoundException{
    	Class.forName(DRIVER);
    	
    	String sql = "INSERT INTO t_board(title, content, imgName, id, p_bno)"
    			+" VALUES(?,?,?,?,?)";
    	log.info(sql);
    	
    	try(
    		Connection conn = DriverManager.getConnection(URL,USER,PW);
    		PreparedStatement pstmt = conn.prepareStatement(sql);
    		) {
    		
    		log.info(conn.toString());
    		log.info(pstmt.toString());
    		
    		for (int i=1; i<=3; i++) {
    			pstmt.setString(1, "하이룽" + i);
    			pstmt.setString(2, "hello world " + i);
    			pstmt.setString(3, null);
    			pstmt.setString(4, "wooa");
    			
    			//0 : 자신이 원글.
    			//그 외 숫자 : 부모 글의 게시물 번호(bno)
    			//pstmt.setInt(5, 2); //2번 글의 답변글
    			pstmt.setInt(5, 0);
    			
    			//성공하면 1을 반환한다.
        		int result = pstmt.executeUpdate();
        		
        		//result가 1이 아니라면 테스트 실패
        		assertTrue(result == 1);
    		}
    	} catch(Exception e) {
    		e.printStackTrace();
    	}
    }

프로젝트

DAO

public class BoardDAO {
	private final static Logger log = Logger.getGlobal();
	DataSource ds;
    ...
    ...
	public int insert(BoardVO vo) {
    	String sql = "INSERT INTO t_board(title, content, imgName, id, p_bno)"
    			+" VALUES(?,?,?,?,?)";
		
    	log.info(sql);
    	
    	try(
			Connection conn = ds.getConnection();
			PreparedStatement pstmt = conn.prepareStatement(sql);
			){
			pstmt.setString(1, vo.getTitle());
			pstmt.setString(2, vo.getContent());
			pstmt.setString(3, vo.getImgName());
			pstmt.setString(4, vo.getId());
			pstmt.setInt(5, vo.getP_bno());
			
			return pstmt.executeUpdate();
			
		}catch(Exception e) {e.printStackTrace();}
		return -1;
	}
...
...
} // end - class

Service

public class BoardServiceImpl implements BoardService {

	private BoardDAO dao;
	
	public BoardServiceImpl() {
		//초기화
		dao = new BoardDAO();
	}
    
    ....
    	@Override
	public int register(BoardVO vo) {
		return dao.insert(vo);
	}
} // end - service

Controller

@WebServlet("/board/*")
public class BoardController extends HttpServlet {
	private final static Logger log = Logger.getGlobal();

	...
    
    	private void doHandle(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		BoardService boardService = new BoardServiceImpl();
		String nextPage = "";
		String action = request.getPathInfo();	//어떤 url을 요청했는가?
		List<BoardVO> list;
		log.info("action : " + action);
        
        else if (action.equals("/register")) {
			//등록한 게시물 데이터를 받아온다.
			String title = request.getParameter("title");
			String content = request.getParameter("content");
			String imgName = request.getParameter("imgName");
			String id = request.getParameter("id");
			int p_bno = Integer.parseInt(request.getParameter("p_bno"));
			
			//받아온 데이터로 VO객체를 생성한다.
			BoardVO vo = new BoardVO();
			
			vo.setTitle(title);
			vo.setContent(content);
			vo.setImgName(imgName);
			vo.setId(id);
			vo.setP_bno(p_bno);
			
			log.info("vo : " + vo);
			
			//데이터베이스에 저장하는 메서드에 vo를 전달한다.
			//결과가 1이라면 성공, 그 외는 실패..
			nextPage = boardService.register(vo) == 1
							? "/board/list" : "error";
		}
        
        RequestDispatcher dispatcher = request.getRequestDispatcher(nextPage);
		dispatcher.forward(request, response);
	}
}

view

...
<form name='action' method='post' action='/board/register'>
	<table>
		<tr>
			<td align="right"> 제목 </td>
			<td clspan='2'><input type='text' name='title' size='67' maxlength="50"></td>
		</tr>
		<tr>
			<td align="right" valign="top"><br> 내용 </td>
			<td colspan="2"><textarea rows="10" cols="65" name='content'></textarea></td>
		</tr>
		<tr>
			<td align="right"> 작성자 </td>
			<td clspan='2'><input type='text' name='id' maxlength="50"></td>
		</tr>
		<tr>
			<td align="right"> </td>
			<td colspan="2">
				<input type='submit' value='글쓰기'>
				<input type='button' id='list' value='목록'>
			</td>
		</tr>
	</table>
</form>
<script type="text/javascript">
	window.onload = () => {
		const list = document.getElementById('list')
		
		list.addEventListener("click", () => {
			location.replace('/board/list')
		})
	}
</script>
...

제대로 등록이 되는지 확인한다.