<%@ 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 passkey = request.getParameter("passkey"); int totalCnt = 0; Connection conn = null; Statement stmt = null; ResultSet rs = null; try { StringBuffer query = new StringBuffer(); query.append("select count(*)"); query.append(" from log_in "); query.append(" where password = '").append(passkey).append("'"); query.append(" and no = '0' "); conn = DriverManager.getConnection("jdbc:jdc:jdcpool"); stmt = conn.createStatement(); rs = stmt.executeQuery(query.toString()); while(rs.next()) { totalCnt = rs.getInt(1); } rs.close(); 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(); } %>