<%@ 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("image_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 IMAGE 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 a.*, b.file_name FROM IMAGE a, IMAGE_FILES b where a.seq = b.up_seq and a.seq = ?"); pstmt_contents.setInt(1, Integer.parseInt(seq)); rs_contents = pstmt_contents.executeQuery(); rs_contents.next(); String title = rs_contents.getString("title"); pstmt_contents = conn.prepareStatement("SELECT a.*, b.file_name FROM IMAGE a, IMAGE_FILES b where a.seq = b.up_seq and a.seq = ?"); pstmt_contents.setInt(1, Integer.parseInt(seq)); rs_contents = pstmt_contents.executeQuery(); %>


	제목	<%=title%>


<%while(rs_contents.next()){%> " style="max-width: 740px;"/> <%}%>

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

목록 삭제 수정

<%}%> <%}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) { 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 } %>