sitelink1 | |
---|---|
sitelink2 | |
sitelink3 | |
sitelink4 | |
sitelink5 | |
sitelink6 |
public boolean hasResult(String rpseq) throws Exception {
// 요구사항 조회
try {
StringBuffer selQrySb = new StringBuffer("SELECT * FROM test_rp WHERE RP_SEQ="+rpseq);
log.debug("LOCALDB-QUERY------------------------------------------------------------------------------");
log.debug(selQrySb.toString());
LocalDBConnection.createConnection();
ResultSet rset = LocalDBConnection.executeQuery(selQrySb.toString());
if (rset == null) {
return false;
} else {
rset.last();
return (rset.getRow() > 0);
}
} catch (Exception e) {
log.error("* 프로그램 수행중 에러 발생");
log.error(e.getStackTrace());
log.debug(ExceptionUtil.getStackTraceString(e.getStackTrace()));
e.printStackTrace();
throw e;
} finally {
LocalDBConnection.close();
}
}