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