<%@ page contentType="text/html;charset=euc-kr" %>
<%@ include file="/include/in_Import.jsp" %>
<%@ include file="/include/in_Function.jsp" %>
<%
int PageAuth = 1;
%>
<%!
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");
String keytype = request.getParameter("keytype");
String keyword = request.getParameter("keyword");
String file_gubun = request.getParameter("file_gubun1");
String cmd = request.getParameter("cmd");
String no = sutil.toNullStr(request.getParameter("no"));
String subject = sutil.toNullStr(request.getParameter("bigo"));
String name = sutil.toNullStr(request.getParameter("wr_name"));
String passkey = sutil.toNullStr(request.getParameter("passkey"));
String content = sutil.convertWEBtoDB(sutil.toNullStr(request.getParameter("context")));
String file_nm = "";
String query = "";
if(spage == null || spage.equals("")) spage = "1";
if(keytype == null || keytype.equals("")) keytype = "subject";
if(keyword == null || keyword.equals("")) keyword = "";
if(no == null || no.equals("")) no = "0";
subject = sutil.toEucKr(subject);
content = sutil.toEucKr(content);
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
int i_rtn = 0;
int seq_no = Integer.parseInt(no);
int iPage = Integer.parseInt(spage);
try {
conn = DriverManager.getConnection("jdbc:jdc:jdcpool");
String query_insert = "";
if(cmd != null && cmd.equals("U")) {
query_insert = " UPDATE NOTICE SET SUBJECT = ?, CONTENTS = ? WHERE NO = ? ";
pstmt = conn.prepareStatement(query_insert);
pstmt.setString(1, subject);
pstmt.setString(2, content);
pstmt.setInt(3, seq_no);
} else if(cmd != null && cmd.equals("I")) {
pstmt = conn.prepareStatement("SELECT NEXTVAL('PUBLIC.NITICE_NO_SEQ')");
rs = pstmt.executeQuery();
int seqNO = 0;//등록에만 쓰는 변수
while(rs.next()) {
seqNO = rs.getInt(1);
}
query_insert = " INSERT INTO NOTICE ( ";
query_insert += " NO, SUBJECT, NAME, CONTENTS, REG_DT, FILE_NAME, STATE, VIEW_CNT";
query_insert += " ) VALUES ( ";
query_insert += " ?, ?, ?, ?, NOW(), ?, '3', 0) ";
pstmt = conn.prepareStatement(query_insert);
pstmt.setInt(1, seqNO);
pstmt.setString(2, subject);
pstmt.setString(3, "");
pstmt.setString(4, content);
pstmt.setString(5, "");
i_rtn = pstmt.executeUpdate();
query_insert = " INSERT INTO LOG_IN (NO, PASSWORD) VALUES (?, ?) ";
pstmt = conn.prepareStatement(query_insert);
pstmt.setInt(1, seqNO);
pstmt.setString(2, passkey);
} else if(cmd != null && cmd.equals("D")) {
query_insert += " DELETE FROM NOTICE WHERE NO = ? ";
pstmt = conn.prepareStatement(query_insert);
pstmt.setInt(1, seq_no);
} else {
}
i_rtn = pstmt.executeUpdate();
pstmt.close();
conn.close();
if ( i_rtn > 0) {
%>
<%
} else {
%>
<%
}
} catch (Exception e) {
out.println("JSP >> Slight Exception in /issue/issueOk.jsp : " + e.toString());
%>
<%
} finally {
if (pstmt != null) pstmt.close();
if (conn != null) conn.close();
}
%>