<% /*============================================================================================== * Project Title : * File Name : * Include : * Used DB Table : notice * Used Class : * Description : À̽´ ¸®½ºÆ® * Programmer : °­ÁÖ¿ë * First Write : 2011.02.24 * 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 = "41"; %> <%! 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 no = request.getParameter("no"); String cmd = request.getParameter("cmd"); String password = request.getParameter("password"); String subject = ""; String contents = ""; String passKey = ""; if(cmd == null || cmd.equals("")) cmd = "I"; Connection conn = null; Statement stmt = null; ResultSet rs = null; try { StringBuffer query = new StringBuffer(); if(no != null && !no.equals("")) { query.append(" SELECT A.NO, A.SUBJECT, A.CONTENTS, A.REG_DT, A.NAME, "); query.append(" A.FILE_NAME, A.COM_IDS, A.VIEW_CNT, B.PASSWORD "); query.append(" FROM NOTICE A, LOG_IN B "); query.append(" WHERE A.NO = '"+no+"' "); query.append(" AND A.NO = B.NO "); conn = DriverManager.getConnection("jdbc:jdc:jdcpool"); stmt = conn.createStatement(); rs = stmt.executeQuery(query.toString()); if(rs.next()) { subject = rs.getString("SUBJECT"); contents = sutil.convertDBtoWEBComp(rs.getString("CONTENTS")); passKey = rs.getString("PASSWORD"); } } %> ÇѸ¶À½ ¿¬¼ö¿ø
³»¿ë ºñ°í
 
ºñ¹Ð¹øÈ£ : <% if(cmd.equals("I")) { %> <% } else { %> <% } %>
<% } catch(Exception e) { out.println("JSP >> Slight Exception in /issue/issuePopup.jsp : " + e.toString()); %> <% } finally { if (stmt != null) stmt.close(); if (conn != null) conn.close(); } %>