%
/*==============================================================================================
* Project Title :
* File Name : csnot04_ok.jsp
* Include :
* Used DB Table : log_in
* Used Class :
* Description : °Ô½ÃÆÇ µî·Ï ºñ¹Ð¹øÈ£ ó¸®
* Programmer : °ÁÖ¿ë
* First Write : 2010.04.24
* 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:hanmaum","postgres","");
} catch(Exception e) {
System.out.println("
JDCConnectionDriver Error : " + e.toString());
}
}
%>
<%
String passkey = request.getParameter("passkey");
String no = request.getParameter("no");
String cmd = request.getParameter("cmd");
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:postgresql:hanmaum", "postgres", "");
stmt = conn.createStatement();
rs = stmt.executeQuery(query.toString());
while ( rs.next() ) {
totalCnt = rs.getInt(1);
}
if (totalCnt==0){
query = new StringBuffer();
query.append("select count(*)");
query.append(" from log_in ");
query.append(" where password = '").append(passkey).append("'");
query.append(" and no = '").append(no).append("'");
conn = DriverManager.getConnection("jdbc:postgresql:hanmaum", "postgres", "");
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 >> Slight Exception in /Cs/csqa03_ok.jsp : " + e.toString());
%>
<%
} finally {
if (stmt != null) stmt.close();
if (conn != null) conn.close();
}
%>