무제 문서

<% /*============================================================================================== * Project Title : lovehb(한마음연수원) * File Name : csnot03.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" %> <%! static { try { new kr.co.slight.jinhae.pool.JDCConnectionDriver("org.postgresql.Driver","jdbc:postgresql:jinhae","postgres",""); } catch(Exception e) { System.out.println("

JDCConnectionDriver Error : " + e.toString()); } } %> <% String no = request.getParameter("no"); String cmd = request.getParameter("cmd"); String spage = request.getParameter("spage"); String menuId = request.getParameter("menuId"); String keytype = request.getParameter("keytype"); String keyword = request.getParameter("keyword"); String password = request.getParameter("password"); if(spage == null) spage = "1"; if(no == null || no == "") no = "0"; if(cmd == null || cmd.equals("")) cmd = "I"; if(menuId == null || menuId.equals("")) menuId = "42"; if(keytype == null || keytype.equals("")) keytype = "subject"; if(keyword == null || keyword.equals("")) { keyword = ""; } else { keyword = sutil.toEucKr(keyword); } int seq_no = Integer.parseInt(no); int iPage = Integer.parseInt(spage); java.text.SimpleDateFormat tformat = new java.text.SimpleDateFormat("yyyyMMdd"); try { Connection conn = null; PreparedStatement pstmt = null; ResultSet rs = null; String query = null; String org_pwd = null; String subject = ""; String contents = ""; String rplContents = ""; String name = ""; conn = DriverManager.getConnection("jdbc:jdc:jdcpool"); query = " SELECT * FROM NOTICE WHERE NO = ? "; pstmt = conn.prepareStatement(query); pstmt.setInt(1, seq_no); if(seq_no > 0) { rs = pstmt.executeQuery(); } if(rs != null) { while(rs.next()) { subject = rs.getString("subject"); contents = sutil.convertDBtoWEBComp(rs.getString("contents")); name = rs.getString("name"); } } if(cmd.equals("R") || cmd.equals("RU")) { rs = null; query = " SELECT * FROM NOTICE_RPL WHERE NO = ? "; pstmt = conn.prepareStatement(query); pstmt.setInt(1, seq_no); if(seq_no > 0) { rs = pstmt.executeQuery(); } if(rs != null) { while(rs.next()) { rplContents = sutil.convertDBtoWEBComp(rs.getString("contents")); } } } %> 무제 문서 <%@ include file="/hanmaum/Cs/04_subimg.jsp" %> <%@ include file="/hanmaum/bottom.jsp" %> <% if(rs != null) rs.close(); if(pstmt != null) pstmt.close(); if(conn != null) conn.close(); } catch (Exception e) { // 에러페이지로 이동............ out.println("JSP >> Slight Exception in /Cs/csnot03.jsp : " + e.toString()); } %>