%@ 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"%>