DoR@Hee의 끄적끄적

VIEW - board_content_view.jsp와 동일 MODEL123456789101112131415161718192021 public void board_delete(String bId) { Connection con = null; PreparedStatement pstmt = null; try { String query = "delete from board where bId = ?"; Class.forName(driver); con=DriverManager.getConnection(url, user, password); pstmt = con.prepareStatement(query); pstmt.setInt(1, Integer.parseInt(bId)); pstmt.executeUpdate()..

VIEW - member_modify.jsp1234567891011121314151617181920212223242526 정보수정 페이지 비밀번호: 비밀번호 확인: 변경 Colored by Color ScriptercsModel - UDao.java123456789101112131415161718192021222324 public void ModifyMember(String uId, String uPassword) { //정보 수정을 위함 Connection con = null; PreparedStatement pstmt = null; try { String query = "update members set pw = ? where id = ?"; Class.forName(driver); con = Dri..

VIEW - board_list.jsp 와 동일 Command - x Model12345678910111213141516171819202122 public void Hit(String bId) { Connection con = null; PreparedStatement pstmt = null; try { String query = "update board set bHit = bHit + 1 where bId = ?"; Class.forName(driver); con=DriverManager.getConnection(url, user, password); pstmt = con.prepareStatement(query); pstmt.setInt(1, Integer.parseInt(bId)); pstmt.ex..

VIEW - board_modify_view.jsp12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758 글 수정하기 제 목 작성자 ${content.bNickname} 내용 ${content.bContent} 글 수정 Colored by Color ScriptercsMODEL - BDao.java123456789101112131415161718192021222324252627 public void board_modify(String bId, String bTitle, String bContent) { Connection con = null; PreparedStatem..

View + Controller -loginout.jsp12345678910111213141516Insert title here Colored by Color Scriptercs

VIEW - board_content_view.jsp12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879 function deleteOk(){ if (confirm("정말 삭제하시겠습니까??") == true){ //확인 location.href="board_delete.do?bId=${content.bId}" }else{ //취소 return; } } 글 보기 제목 ${content.bTitle} 글쓴이 ${content.bNickname} 내용 ${content.bContent} 목록 삭제..

VIEW - board_list.jsp1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677 게시글 목록 번호 제목 작성자 날짜 조회수 글쓰기 Colored by Color ScriptercsMODEL - BDao.java 12345678910111213141516171819202122232425262728293031323334353637383940 public ArrayList board_list(){ ArrayList dtos = new ArrayList(); Connection con = null..

ViEW - board_write.jsp 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152 글 쓰기 제 목 작성자 내용 글쓰기 Colored by Color Scriptercs MODEL - BDao.java123456789101112131415161718192021222324 public void board_write(String bNickname, String bTitle, String bContent) { Connection con = null; PreparedStatement pstmt = null; String query = "insert into board (bId, bNi..