<%@ 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:hanmaum","postgres",""); } catch(Exception e) { System.out.println("

JDCConnectionDriver Error : " + e.toString()); } } %> <% String menuId = request.getParameter("menuId"); String code = ""; if(menuId == null || menuId.equals("")) menuId = "34"; Connection conn = null; Statement stmt = null; ResultSet rs = null; try { StringBuffer query = new StringBuffer(); query.append(" SELECT * FROM COMMON_CODE WHERE USE_YN = 'Y' AND GROUP_ID = '001' "); conn = DriverManager.getConnection("jdbc:jdc:jdcpool"); stmt = conn.createStatement(); rs = stmt.executeQuery(query.toString()); while(rs.next()) { code = rs.getString(5); } %> <%@ page contentType="text/html;charset=euc-kr" %>

<%@ include file="/hanmaum/Accou/03_subimg.jsp" %>

<%@ include file="/hanmaum/Accou/left_menu.jsp" %>

Ȩ > ÀÌ¿ë¾È³» > ÀÌ¿ë¿ä±Ý   µî·ÏÇÏ½Ç Æ¯½Ä±Ý¾×À» ÀÔ·ÂÇØÁÖ¼¼¿ä. Ư½Ä ±Ý¾× ¿ø

<%@ include file="/hanmaum/bottom.jsp" %> <% if ( rs != null ) rs.close(); if ( stmt != null ) stmt.close(); if ( conn != null ) conn.close(); } catch (Exception e) { if ( rs != null ) rs.close(); if ( stmt != null ) stmt.close(); if ( conn != null ) conn.close(); // ¿¡·¯ÆäÀÌÁö·Î À̵¿............ out.println("JSP >> Slight Exception in /Cs/csnot01.jsp : " + e.toString()); } %>