%
/*==============================================================================================
* Project Title : lovehb(ÇѸ¶À½¿¬¼ö¿ø)
* File Name : csnot03.jsp
* Include :
* Used DB Table : notice
* Used Class :
* Description : °Ô½ÃÆÇ µî·Ï
* Programmer : °ÁÖ¿ë
* First Write : 2010.04.29
* 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 spage = request.getParameter("spage");
String no = request.getParameter("no");
String menuId = request.getParameter("menuId");
if(menuId == null || menuId.equals("")) menuId = "41";
if (spage == null)
spage = "1";
if(no == null || no == "") no = "0";
int seq_no = Integer.parseInt(no);
int iPage = Integer.parseInt(spage);
String keytype = request.getParameter("keytype");
String keyword = request.getParameter("keyword");
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");
try {
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
String query = null;
String org_pwd = null;
String subject = "";
String contents = "";
String name = "";
conn = DriverManager.getConnection("jdbc:jdc:jdcpool");
query = "select * from notice where no = ? ";
pstmt = conn.prepareStatement(query);
pstmt.setInt(1, seq_no);
if(seq_no > 0) {
rs = pstmt.executeQuery();
}
if(rs != null) {
while(rs.next()) {
subject = rs.getString("subject");
contents = sutil.convertDBtoWEBComp(rs.getString("contents"));
name = rs.getString("name");
}
}
%>