<div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"> 원래 프로그래밍이라는 것이 혼자서 문제를 해결해나가야 실력이 는다고 하지만, 지금 도저히 찾아봐도 문제점을 찾을 수 없어 이렇게 글을 올려봅니다.</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"><br></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"> 4개 1팀중 여자 2명이 탈주해버리는 바람에 정신이없네요.</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"><br></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"> <span style="line-height:22.1px;">밑은 소스입니다.</span></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"><br style="margin:0px;padding:0px;"></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"> a.jsp 파일에 b.jsp파일로 id값을 넘겨와 (예시 : <span style="line-height:22.1px;"><a target="_blank" href="http://localhost:8080/jdbc/b.jsp?id=5" target="_blank">http://localhost:8080/jdbc/b.jsp?id=5</a>) </span></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"><br style="margin:0px;padding:0px;"></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"> id값을 mysql에서 검색, 테이블로 출력하는 소스입니다.</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"><br style="margin:0px;padding:0px;"></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"> 값을 넘겨와서 출력을 하려고 하는데 화면 구성 자체가 안되어지네요. </div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"> (jsp 소스 전부 빼고 테이블만 넣었을 때 출력이 되었습니다.) </div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"><br></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">/* 여기서부터 b.jpg시작 */</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"><%@ page language="java" contentType="text/html; charset=euc-kr" pageEncoding="euc-kr" %></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"><%@ page import="java.sql.*" %></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"><br style="margin:0px;padding:0px;"></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"><html></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"><head></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"><title></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">게시판</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"></title></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"></head></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"><body></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"><%</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">int id;</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"><br style="margin:0px;padding:0px;"></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">//mysql DB 연결 </div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">Connection conn = null;</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">Statement stmt = null;</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">String sql= "";</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">ResultSet rs = null;</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">try{</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">Class.forName("com.mysql.jdbc.Driver");</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">String url="jdbc:mysql://localhost:3306/board_db";</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">conn=DriverManager.getConnection(url,"root","jspbook");</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">stmt=conn.createStatement();</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">sql="select * from board_tbl";</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">rs=stmt.executeQuery(sql);</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">} catch(Exception e) {</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">out.println("DB 연동 오류입니다. : " + e.getMessage());</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">}</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">// ID 받아와서 검색</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">id=Integer.parseInt(request.getParameter("id")); </div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">rs = stmt.executeQuery("SELECT * FROM member_tbl WHERE id=" + id);</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">String name, e_mail, title, content;</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">while(rs.next()){</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">name=rs.getString("name");</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">e_mail=rs.getString("e_mail");</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">title=rs.getString("title");</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">content=rs.getString("content");</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">%></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"><table border="1" align="center" width="603"></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"><tr> </div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"><td align="center" bgcolor="silver" width="75"> 글쓴이 </td> </div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"><td align="center" width="75"> <%= name %> </td> </div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"></tr></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"><tr> </div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"><td align="center" bgcolor="silver" width="75"> 메일주소 </td> </div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"><td align="center" width="75"> <%= e_mail %> </td> </div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"></tr></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"><tr> </div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"><td align="center" bgcolor="silver" width="75"> 글 제목 </td> </div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"><td align="center" width="75"> <%= title %> </td> </div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"></tr></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"><tr> </div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"><td align="center" bgcolor="silver" width="75"> 글 내용 </td> </div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"><td align="center" width="75"> <%= content %> </td> </div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"></tr></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"></table></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"><% </div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">}</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">//닫기</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">rs.close();</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">stmt.close();</div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;">%></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"></body></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"></html></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"><br></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"> /* 종료 */ </div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"><br></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"><br></div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"> 문제는 이렇게 입력시 화면이 </div> <div style="margin:0px;padding:0px;color:#404040;font-family:gulim, sans-serif;font-size:13px;line-height:22.1px;"> <div style="text-align:left;"><img src="http://thimg.todayhumor.co.kr/upfile/201512/1449305580D63d85F4JAgJkiU6YLmJr1HCHhfFZPN.jpg" width="746" height="899" alt="캡처.JPG" style="border:none;"></div> <div style="text-align:left;"><br></div> <div style="text-align:left;"><br></div> <div style="text-align:left;"> 이렇게 아무것도 안뜹니다 (...) </div> <div style="text-align:left;"><br></div> <div style="text-align:left;"> 차라리 오류라도 뜨면 찾아서 해결하지 왜 이렇게 뜨는지 모르겠네요. </div> <div style="text-align:left;"> </div> <div style="text-align:left;"> 왜 이렇게 뜨는걸까요..? ㅠㅠㅠㅠㅠㅠㅠㅠ </div><br></div>
<img src="http://thimg.todayhumor.co.kr/upfile/201208/7253200ea2705c660893ce4f05caf1fc.jpg" alt="7253200ea2705c660893ce4f05caf1fc.jpg">
댓글 분란 또는 분쟁 때문에 전체 댓글이 블라인드 처리되었습니다.
