%
/*==============================================================================================
* 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" %>
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");
}
}
%>