<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ page import="java.sql.*" %> <%@ include file="/common.inc" %> <% // POST 한글 파라미터 깨짐 처리 request.setCharacterEncoding("UTF-8"); // 사용할 객체 초기화 Connection conn = null; PreparedStatement pstmt = null; PreparedStatement pstmt_contents = null; ResultSet rs = null; ResultSet rs_contents = null; if(main_seq.equals("")&&sub_seq.equals("")){ response.sendRedirect("/"); return; } String contentsSeq = sub_sub_seq.equals("") ? sub_seq : sub_sub_seq; String seq = request.getParameter("seq"); if(seq == null) response.sendRedirect("notice_list.jsp?main_seq="+main_seq+"&sub_seq="+sub_seq+"&sub_sub_seq="+sub_sub_seq); try { // 데이터베이스 객체 생성 Class.forName("com.mysql.jdbc.Driver"); conn = DriverManager.getConnection( "jdbc:mysql://127.0.0.1:3306/ys", "srpinfotec", "srpinfotec1@#"); pstmt = conn.prepareStatement("UPDATE NOTICE SET cnt = cnt+1 where seq = ?"); pstmt.setInt(1, Integer.parseInt(seq)); pstmt.executeUpdate(); pstmt = conn.prepareStatement("SELECT ADMIN_ONLY FROM MENU WHERE SEQ = ?"); pstmt.setInt(1, Integer.parseInt(contentsSeq)); rs = pstmt.executeQuery(); rs.next(); String isAdminOnly = rs.getString(1); pstmt_contents = conn.prepareStatement("SELECT * FROM NOTICE WHERE seq = ?"); pstmt_contents.setInt(1, Integer.parseInt(seq)); rs_contents = pstmt_contents.executeQuery(); rs_contents.next(); %>


	제목	<%=rs_contents.getString("title")%>

	첨부파일	"><%=rs_contents.getString("FILE_NM")%>

<%=rs_contents.getString("contents")%>

<%if(isAdminOnly.equals("Y")){%> <%if(session_isadimn.equals("Y")){%>

목록 &main_seq=<%=main_seq%>&sub_seq=<%=sub_seq%>&sub_sub_seq=<%=sub_sub_seq%>" class="button white medium">삭제 &main_seq=<%=main_seq%>&sub_seq=<%=sub_seq%>&sub_sub_seq=<%=sub_sub_seq%>" class="button white medium">수정

<%}%> <%}else if(isAdminOnly.equals("N")){%> <%if(session_isadimn.equals("Y")||session_user_id.equals(rs_contents.getString("reg_user_id"))){%>

<%}%> <%}%> <%@include file="/foot.inc"%> <% } catch (Exception e) { // System.out.println(); e.printStackTrace(); } finally { System.out.println(pstmt_contents.toString()); if (pstmt != null) pstmt.close(); if (conn != null) conn.close(); if (rs != null) rs.close(); if (pstmt_contents != null) pstmt_contents.close(); if (rs_contents != null) rs_contents.close();//pstmt_contents } %>