<% /*============================================================================================== * Project Title : * File Name : csqa02.jsp * Include : * Used DB Table : notice, notice_rpl * Used Class : * Description : °Ô½ÃÆÇ ¸®½ºÆ® * Programmer : °­ÁÖ¿ë * First Write : 2010.04.28 * Last Update : ==============================================================================================*/ %> <%@ page contentType="text/html;charset=euc-kr" %> <%@ include file="/include/in_Import.jsp" %> <%@ include file="/include/in_Function.jsp" %> <% int PageAuth = 1; String menuId = request.getParameter("menuId"); if(menuId == null || menuId.equals("")) menuId = "42"; %> <%! static { try { new kr.co.slight.jinhae.pool.JDCConnectionDriver("org.postgresql.Driver","jdbc:postgresql:hanmaum","postgres",""); } catch(Exception e) { System.out.println("

JDCConnectionDriver Error : " + e.toString()); } } %> <% String spage = request.getParameter("spage"); int no = Integer.parseInt(request.getParameter("no")); if (spage == null) spage = "1"; int iPage = Integer.parseInt(spage); int totalCnt = 0; String keytype = request.getParameter("keytype"); String keyword = request.getParameter("keyword"); String password = request.getParameter("password"); String state = request.getParameter("state"); String query_insert = ""; if ( keytype == null || keytype.equals("") ) { keytype = "subject"; } if ( keyword == null || keyword.equals("") ) { keyword = ""; } else { keyword = sutil.toEucKr(keyword); } java.text.SimpleDateFormat tformat = new java.text.SimpleDateFormat("yyyyMMdd"); String cur_year = tformat.format(new java.util.Date()).substring(0,4); Connection conn = null; Statement stmt = null; ResultSet rs = null; PreparedStatement pstmt = null; try { StringBuffer query = new StringBuffer(); StringBuffer query_rpl = new StringBuffer(); query.append("select count(*)"); query.append(" from log_in "); query.append(" where password = '").append(password).append("'"); query.append(" and no = '0' "); conn = DriverManager.getConnection("jdbc:postgresql:hanmaum", "postgres", ""); stmt = conn.createStatement(); rs = stmt.executeQuery(query.toString()); while ( rs.next() ) { totalCnt = rs.getInt(1); } if (totalCnt==0){ query = new StringBuffer(); query.append("select count(*)"); query.append(" from log_in "); query.append(" where password = '").append(password).append("'"); query.append(" and no = '").append(Integer.toString(no)).append("'"); conn = DriverManager.getConnection("jdbc:postgresql:hanmaum", "postgres", ""); stmt = conn.createStatement(); rs = stmt.executeQuery(query.toString()); while ( rs.next() ) { totalCnt = rs.getInt(1); } } rs.close(); if(totalCnt>0){ query = new StringBuffer(); query.append("SELECT A.*, B.CONTENTS AS REPL, B.REG_DT AS REG_DT_REPL "); query.append(" FROM NOTICE AS A LEFT OUTER JOIN NOTICE_RPL AS B"); query.append(" ON (A.NO = B.NO)"); query.append(" WHERE A.NO = ").append(no); conn = DriverManager.getConnection("jdbc:postgresql:hanmaum", "postgres", ""); stmt = conn.createStatement(); rs = stmt.executeQuery(query.toString()); if(state.equals("2")){ query_insert = " UPDATE NOTICE SET VIEW_CNT = VIEW_CNT+1 WHERE NO = ? "; pstmt = conn.prepareStatement(query_insert); pstmt.setInt(1, no); pstmt.executeUpdate(); }else{ query_insert = " UPDATE NOTICE_RPL SET VIEW_CNT = VIEW_CNT+1 WHERE NO = ? "; pstmt = conn.prepareStatement(query_insert); pstmt.setInt(1, no); pstmt.executeUpdate(); } if (rs != null) { while ( rs.next() ) { String subject = rs.getString("subject"); String content = sutil.convertDBtoWEB(rs.getString("contents")); String name = rs.getString("name"); String reg_dt = rs.getString("reg_dt"); String reg_dt_repl = rs.getString("reg_dt_repl"); String repl = sutil.convertDBtoWEB(rs.getString("repl")); if(repl == null) repl = ""; String view_content = replace(content, " ", " "); String view_repl = replace(repl, " ", " "); view_content = replace(view_content, "\n", "
"); view_repl = replace(view_repl, "\n", "
"); %> ¹«Á¦ ¹®¼­ <%@ include file="/hanmaum/Cs/04_subimg.jsp" %>
<%@ include file="/hanmaum/Cs/left_menu.jsp" %>
Ȩ > °í°´¼¾ÅÍ > Áú¹®°ú´äº¯
 
<%if(state.equals("0")){%>[´äº¯]<%}%><%= subject %> <%if(state.equals("2")){%><%= name %><%}else{%>°ü¸®ÀÚ<%}%> <%if(state.equals("2")){%><%= reg_dt %><%}else{%><%=reg_dt_repl%><%}%>
<%if(state.equals("2")){%>
<%= view_content %>
<% } else {%>
<%= view_repl %>
<% } %>
<% if(view_repl != null && !view_repl.equals("")) {//´äº¯ %> <% } else {//´äº¯ ¼öÁ¤ %> <% } %> <% if(state.equals("2")&&password.equals("8125")){%> <% }%> <% if(password.equals("8125")){%> <% if(state.equals("2")){%> <%} else{%> <%}%> <% }else if(state.equals("2")&&!password.equals("8125")){%> <%}%>
<%@ include file="/hanmaum/bottom.jsp" %> <% } } }else{ %> <%} if ( rs != null ) rs.close(); if ( stmt != null ) stmt.close(); if ( conn != null ) conn.close(); } catch (Exception e) { // ¿¡·¯ÆäÀÌÁö·Î À̵¿............ out.println("JSP >> Slight Exception in /Cs/csnot02.jsp : " + e.toString()); } %>