<%@ 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 textfield2 = request.getParameter("textfield2"); String passkey = request.getParameter("passkey"); int totalCnt = 0; Connection conn = null; Statement stmt = null; ResultSet rs = null; try { StringBuffer query = new StringBuffer(); query.append(" update common_code "); query.append(" set value = '" + textfield2 + "' "); query.append(" where group_id = '001' "); query.append(" and rank = '001' "); query.append(" and code = '001' "); query.append(" and use_yn = 'Y' "); conn = DriverManager.getConnection("jdbc:jdc:jdcpool"); stmt = conn.createStatement(); totalCnt = stmt.executeUpdate(query.toString()); if(totalCnt > 0) { %> <% } else { %> <% } } catch (Exception e) { out.println("JSP >> Exception : " + e.toString()); %> <% if(rs != null) rs.close(); if(stmt != null) stmt.close(); if(conn != null) conn.close(); } finally { if(rs != null) rs.close(); if(stmt != null) stmt.close(); if(conn != null) conn.close(); } %>