/** * <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>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; }