<%@ 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"); if(main_seq.equals("")&&sub_seq.equals("")){ response.sendRedirect("/"); return; } if(main_seq.equals("")&&sub_seq.equals("")){ response.sendRedirect("/"); return; } String contentsSeq = sub_sub_seq.equals("") ? sub_seq : sub_sub_seq; System.out.println("contentsSeq = "+contentsSeq ); boolean empty = false; // 사용할 객체 초기화 Connection conn = null; PreparedStatement pstmt = null; PreparedStatement pstmt_contents = null; ResultSet rs = null; ResultSet rs_contents = null; StringBuffer sb = new StringBuffer(); String prev_year=""; boolean first = true; String menu_id = request.getParameter("menu_id"); if(menu_id==null)menu_id="1"; try { // 데이터베이스 객체 생성 Class.forName("com.mysql.jdbc.Driver"); conn = DriverManager.getConnection( "jdbc:mysql://127.0.0.1:3306/ys", "srpinfotec", "srpinfotec1@#"); 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 HISTORY where contents_seq = ? order by year desc, month desc, seq"); pstmt_contents.setString(1,contentsSeq); rs_contents = pstmt_contents.executeQuery(); System.out.println(pstmt_contents.toString()); if(!rs_contents.next()) empty = true; pstmt_contents.setString(1,contentsSeq); rs_contents = pstmt_contents.executeQuery(); %>  
 
<%if(isAdminOnly.equals("Y") && session_isadimn.equals("Y")){%>
<%if(empty){%> 글쓰기 <%}else{%> 수정 <%}%>
<%}else if(isAdminOnly.equals("N")&&!session_user_id.equals("")){%>
<%if(empty){%> 글쓰기 <%}else{%> 수정 <%}%>
<%}%>   <%@include file="/foot.inc"%> <% } catch (Exception e) { e.printStackTrace(); } finally { 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 } %>