%
/*==============================================================================================
* 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();
}
%>