<%@ 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(); } %>