<% /*============================================================================================== * Project Title : lovehb(ÇѸ¶À½¿¬¼ö¿ø) * File Name : csnot03_ok.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" %> <% 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()); } } %> <% myUpload.initialize(pageContext); myUpload.upload(); String spage = request.getParameter("spage"); String keytype = request.getParameter("keytype"); String keyword = request.getParameter("keyword"); String file_gubun = request.getParameter("file_gubun1"); if (spage == null) spage = "1"; int iPage = Integer.parseInt(spage); if ( keytype == null || keytype.equals("") ) { keytype = "subject"; } if ( keyword == null || keyword.equals("") ) { keyword = ""; } String no = sutil.toNullStr(request.getParameter("no")); String subject = sutil.toNullStr(request.getParameter("subject")); String name = sutil.toNullStr(request.getParameter("wr_name")); String content = sutil.convertWEBtoDB(sutil.toNullStr(request.getParameter("contents"))); String file_nm = ""; subject = sutil.toEucKr(subject); name = sutil.toEucKr(name); content = sutil.toEucKr(content); Connection conn = null; PreparedStatement pstmt = null; ResultSet rs = null; String query = null; int i_rtn = 0; int seq_no = Integer.parseInt(no); try { conn = DriverManager.getConnection("jdbc:postgresql:hanmaum", "postgres", ""); if(file_gubun.equals("1")) { com.jspsmart.upload.File myFile = myUpload.getFiles().getFile(0); System.out.println("file_nm : " + file_nm); if (!myFile.isMissing()) { String file_name = myFile.getFileName(); int last_idx = file_name.lastIndexOf("."); String f_name = file_name.substring (0,last_idx); int i = 0; File file = null; while(true) { file = new File("/project/love_hanbill/hanmaum/file/" + file_name); if (file.exists()) { i++; file_name = f_name +"_"+ i + "." + myFile.getFileExt(); } else { break; } } file_nm = file_name; myFile.saveAs("/project/slight_jinhae/bbs/file/" + file_nm); System.out.println("!myFile.isMissing() >> file_nm : " + file_nm); } } if(seq_no > 0) { String query_insert = "update notice set subject = ?, name = ?, contents = ? where no = ?"; pstmt = conn.prepareStatement(query_insert); pstmt.setString(1, subject); pstmt.setString(2, name); pstmt.setString(3, content); pstmt.setInt(4, seq_no); } else { String query_insert = "insert into notice (subject, name, contents, reg_dt, file_name, state, view_cnt) values (?, ?, ?, now(), ?, '1', 0)"; pstmt = conn.prepareStatement(query_insert); pstmt.setString(1, subject); pstmt.setString(2, name); pstmt.setString(3, content); pstmt.setString(4, file_nm); } i_rtn = pstmt.executeUpdate(); pstmt.close(); conn.close(); if ( i_rtn > 0) { %> <% } else { %> <% } } catch (Exception e) { out.println("JSP >> Slight Exception in /CS/csnot03_ok.jsp : " + e.toString()); %> <% } finally { if (pstmt != null) pstmt.close(); if (conn != null) conn.close(); } %>