%@ 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();
}
%>