/** * <p>Geter for database ID.</p> * @return ID database **/ @Override public final synchronized int getIdDatabase() { if (this.idDatabase == 0) { try { String query = "select count(*) as TOTALROWS from " + DatabaseInfo.class .getSimpleName().toUpperCase() + ";"; Integer rowCount = evalIntegerResult(query, "TOTALROWS"); if (rowCount != 1) { throw new ExceptionWithCode(ExceptionWithCode.CONFIGURATION_MISTAKE, "database_info_config_error"); } query = "select DATABASEID from " + DatabaseInfo.class .getSimpleName().toUpperCase() + ";"; Integer databaseId = evalIntegerResult(query, "DATABASEID"); if (databaseId == null) { throw new ExceptionWithCode(ExceptionWithCode.CONFIGURATION_MISTAKE, "database_info_config_error"); } this.idDatabase = databaseId; } catch (Exception e) { throw new RuntimeException(e); } } return this.idDatabase; }
/** * <p>Evaluate single Long result.</p> * @param pQuery Query * @param pColumnName Column Name * @return Long result e.g 11231 or NULL * @throws Exception - an exception */ @Override public final Long evalLongResult( final String pQuery, final String pColumnName) throws Exception { Long result = null; IRecordSet<RS> recordSet = null; try { recordSet = retrieveRecords(pQuery); if (recordSet.moveToFirst()) { result = getSrvRecordRetriever().getLong(recordSet.getRecordSet(), pColumnName); } } finally { if (recordSet != null) { recordSet.close(); } } return result; }
/** * <p>Evaluate single Double result.</p> * @param pQuery Query * @param pColumnName Column Name * @return Double result e.g 1.1231 or NULL * @throws Exception - an exception */ @Override public final Double evalDoubleResult( final String pQuery, final String pColumnName) throws Exception { Double result = null; IRecordSet<RS> recordSet = null; try { recordSet = retrieveRecords(pQuery); if (recordSet.moveToFirst()) { result = getSrvRecordRetriever().getDouble(recordSet.getRecordSet(), pColumnName); } } finally { if (recordSet != null) { recordSet.close(); } } return result; }
/** * <p>Evaluate single Float result.</p> * @param pQuery Query * @param pColumnName Column Name * @return Float result e.g 1.1231 or NULL * @throws Exception - an exception */ @Override public final Float evalFloatResult( final String pQuery, final String pColumnName) throws Exception { Float result = null; IRecordSet<RS> recordSet = null; try { recordSet = retrieveRecords(pQuery); if (recordSet.moveToFirst()) { result = getSrvRecordRetriever().getFloat(recordSet.getRecordSet(), pColumnName); } } finally { if (recordSet != null) { recordSet.close(); } } return result; }
/** * <p>Geter for database version.</p> * @return database version **/ @Override public final int getVersionDatabase() { try { String query = "select count(*) as TOTALROWS from " + DatabaseInfo.class .getSimpleName().toUpperCase() + ";"; Integer rowCount = evalIntegerResult(query, "TOTALROWS"); if (rowCount != 1) { throw new ExceptionWithCode(ExceptionWithCode.CONFIGURATION_MISTAKE, "database_info_config_error"); } query = "select DATABASEVERSION from " + DatabaseInfo.class .getSimpleName().toUpperCase() + ";"; Integer databaseVersion = evalIntegerResult(query, "DATABASEVERSION"); if (databaseVersion == null) { throw new ExceptionWithCode(ExceptionWithCode.CONFIGURATION_MISTAKE, "database_info_config_error"); } return databaseVersion; } catch (Exception e) { throw new RuntimeException(e); } }
/** * <p>Evaluate single Integer result.</p> * @param pQuery Query * @param pColumnName Column Name * @return Integer result e.g 11231 or NULL * @throws Exception - an exception */ @Override public final Integer evalIntegerResult( final String pQuery, final String pColumnName) throws Exception { Integer result = null; IRecordSet<RS> recordSet = null; try { recordSet = retrieveRecords(pQuery); if (recordSet.moveToFirst()) { result = getSrvRecordRetriever().getInteger(recordSet.getRecordSet(), pColumnName); } } finally { if (recordSet != null) { recordSet.close(); } } return result; }
/** * <p>Evaluate Double results.</p> * @param pQuery Query * @param pColumnNames Column Names * @return Double[] result e.g. [2.14, NULL, 111.456] * @throws Exception - an exception */ @Override public final Double[] evalDoubleResults( final String pQuery, final String[] pColumnNames) throws Exception { Double[] result = new Double[pColumnNames.length]; IRecordSet<RS> recordSet = null; try { recordSet = retrieveRecords(pQuery); if (recordSet.moveToFirst()) { for (int i = 0; i < pColumnNames.length; i++) { result[i] = getSrvRecordRetriever() .getDouble(recordSet.getRecordSet(), pColumnNames[i]); } } } finally { if (recordSet != null) { recordSet.close(); } } return result; }