%@ 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();
%>
<%
while(!empty && rs_contents.next()){
if(first){
first = false;
sb.append(" \n");
sb.append(" \n");
sb.append(" \n");
sb.append(rs_contents.getString("year"));
sb.append("\n");
sb.append("\n");
sb.append(" \n");
sb.append(" \n");
sb.append(" \n");
sb.append(" \n");
sb.append(" \n");
sb.append("\n");
sb.append(rs_contents.getString("month"));
sb.append("\n");
sb.append("\n");
sb.append("\n");
sb.append(" \n");
sb.append(" \n");
sb.append("- \n");
sb.append(rs_contents.getString("contents"));
sb.append("
\n");
sb.append(" \n");
sb.append(" \n");
sb.append(" \n");
}else{
if(rs_contents.getString("year").equals(prev_year)){
sb.append(" \n");
sb.append(" \n");
sb.append(" \n");
sb.append("\n");
sb.append(rs_contents.getString("month"));
sb.append("\n");
sb.append("\n");
sb.append("\n");
sb.append(" \n");
sb.append(" \n");
sb.append("- \n");
sb.append(rs_contents.getString("contents"));
sb.append("
\n");
sb.append(" \n");
sb.append(" \n");
sb.append(" \n");
}else{
sb.append(" ");
sb.append(" ");
sb.append(" ");
sb.append(" \n");
sb.append(" \n");
sb.append(" \n");
sb.append(rs_contents.getString("year"));
sb.append("\n");
sb.append("\n");
sb.append(" \n");
sb.append(" \n");
sb.append(" \n");
sb.append(" \n");
sb.append(" \n");
sb.append("\n");
sb.append(rs_contents.getString("month"));
sb.append("\n");
sb.append("\n");
sb.append("\n");
sb.append(" \n");
sb.append(" \n");
sb.append("- \n");
sb.append(rs_contents.getString("contents"));
sb.append("
\n");
sb.append(" \n");
sb.append(" \n");
sb.append(" \n");
}
}
prev_year = rs_contents.getString("year");
}
sb.append(" ");
sb.append(" ");
sb.append(" ");
// System.out.println(sb);
%>
<%=sb.toString()%>
|
<%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"%>