- CSS는 구현하지 않았습니다.
- DB는 MariaDB에서 생성하였습니다.
SelectOne
body>
<h1>::: 검색 :::</h1>
<%
BoardDAO bdao = new BoardDAO();
List<BoardDTO> list = bdao.selectAll();
for(BoardDTO dto : list){
out.print("<p>"+dto+"</p>");
}
%>
<form action="board_selectone_proc.jsp" method="POST">
책 번호 <input type="text" name="bno"/><br>
<input type="submit" value="SAVE"/>
</form>
</body>SelectOne_proc
<body>
<%
String bno = request.getParameter("bno");
BoardDAO bdao = new BoardDAO();
out.println(bdao.selectOne(new BoardDTO(Integer.parseInt(bno),"","","","")));
%>
</body>
board_form
<body>
<h1> :::도서 등록::: </h1>
<form action="board_form_proc.jsp">
제목 <input type="text" name="title"/><br>
내용 <input type="text" name="content" /><br>
작가 <input type="text" name="author" /><br>
발행일 <input type="text" name="write_day"/><br>
<input type="submit" value="SAVE" />
</form>
</body>board_form_proc
<h1>DB</h1>
<!-- 쿼리스트링으로 전달 받은 파라미터를 확인하고 DB에 저장하기 -->
<%
//int bno, String title, String content, String author, String writeday
String title = request.getParameter("title");
String content = request.getParameter("content");
String author = request.getParameter("author");
String write_day = request.getParameter("write_day");
out.print(title+","+content+","+author+","+write_day);
BoardDAO bdao = new BoardDAO();
BoardDTO dto = new BoardDTO(0,title,content,author,write_day);
bdao.insert(dto);
response.sendRedirect("Menu.jsp");
%>
</body>
bno가 18인 이유는 test로 17을 삭제했고, bno가 increment 속성이기 때문
board_update
<body>
<h1> :::등록 수정::: </h1>
<%
BoardDAO bdao = new BoardDAO();
List<BoardDTO> list = bdao.selectAll();
for(BoardDTO dto : list){
out.print("<p>"+dto+"</p>");
}
%>
<form action="board_update_proc.jsp">
번호 <input type="text" name="bno"/><br>
제목 <input type="text" name="title"/><br>
내용 <input type="text" name="content" /><br>
작가 <input type="text" name="author" /><br>
발행일 <input type="text" name="write_day"/><br>
<input type="submit" value="SAVE" />
</form>
</body>board_update_proc
<body>
<%
String bno = request.getParameter("bno");
String title = request.getParameter("title");
String content = request.getParameter("content");
String author = request.getParameter("author");
String write_day = request.getParameter("write_day");
BoardDAO bdao = new BoardDAO();
bdao.update(new BoardDTO(Integer.parseInt(bno),title,content,author,write_day));
response.sendRedirect("Menu.jsp");
%>
</body>
board_delete
<body>
<h1> ::: 삭제 :::</h1>
<%
BoardDAO bdao = new BoardDAO();
List<BoardDTO> list = bdao.selectAll();
for(BoardDTO dto : list){
out.print("<p>"+dto+"</p>");
}
%>
<form action="board_delete_proc.jsp" method="POST">
책 번호 <input type="text" name="bno"/><br>
<input type="submit" value="SAVE"/>
</form>
</body>board_delete_proc
<body>
<%
String bno = request.getParameter("bno");
BoardDAO bdao = new BoardDAO();
bdao.delete(new BoardDTO(Integer.parseInt(bno),"","","",""));
response.sendRedirect("Menu.jsp");
%>
</body>
👨Education Computer Engineering 🎓Expected Graduation: February 2023 📞Contact info thstjddn77@gmail.com