%
/*==============================================================================================
* 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"));
String password = request.getParameter("password");
if (spage == null) spage = "1";
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");
String cur_year = tformat.format(new java.util.Date()).substring(0,4);
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
PreparedStatement pstmt = null;
String passkey = "";
String query1 = "";
int chk = 0;
try {
conn = DriverManager.getConnection("jdbc:jdc:jdcpool");
query1="select password from log_in where no = '0'";
stmt = conn.createStatement();
rs = stmt.executeQuery(query1);
if (rs != null) {
while ( rs.next() ) {
passkey=rs.getString("password");
}
}
if (passkey.equals(password)){
chk = 1;
}
if(chk==0){
query1="select password from log_in where no = "+no+"";
stmt = conn.createStatement();
rs = stmt.executeQuery(query1);
if (rs != null) {
while ( rs.next() ) {
passkey=rs.getString("password");
}
}
}
if (passkey.equals(password)){
chk = 1;
}
StringBuffer query = new StringBuffer();
StringBuffer query_rpl = new StringBuffer();
if(chk==1){
query.append("SELECT A.*, B.CONTENTS AS 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:jdc:jdcpool");
stmt = conn.createStatement();
rs = stmt.executeQuery(query.toString());
String query_insert = " UPDATE NOTICE 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 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" %>
|
Ȩ > °í°´¼¾ÅÍ > Áú¹®°ú´äº¯
|
 |
|
 |
|
<%= subject %> |
<%= name %> |
<%= reg_dt %> |
 |
<% if(view_repl != null && !view_repl.equals("")) {//´äº¯ %>
<% } else { %>
<% } %>
|
<%@ include file="/hanmaum/bottom.jsp" %>
<%
}
}
if ( rs != null ) rs.close();
if ( stmt != null ) stmt.close();
if ( conn != null ) conn.close();
} else{
%>
<%
}
} catch (Exception e) {
// ¿¡·¯ÆäÀÌÁö·Î À̵¿............
out.println("JSP >> Slight Exception in /Cs/csnot02.jsp : " + e.toString());
}
%>