Java Utililty Methods SQL ResultSet Double Read

Double getDouble(ResultSet res, String name)
Returns the values of the specified column as a Double.

double v = res.getDouble(name);
return res.wasNull() ? null : v;

Double getDouble(ResultSet resultSet, int columnIndex)
get Double

double value = resultSet.getDouble(columnIndex);
return resultSet.wasNull() ? null : value;

Double getDouble(ResultSet resultSet, String columnName)
Returns a double value using a given SQL result set and column name.

Double value = null;
if (resultSet != null && columnName != null) {
 double columnValue = resultSet.getDouble(columnName);
 if (!resultSet.wasNull()) {
 value = new Double(columnValue);
return value;
...

double getDouble(ResultSet rs, int index)
get Double

if (rs.getObject(index) != null) {
 return rs.getDouble(index);
throw new RuntimeException("Null value in non-Nullable column");

Double getDouble(ResultSet rs, String colName)
get Double

double res = rs.getDouble(colName);
return rs.wasNull() ? null : new Double(res);

double getDouble(ResultSet rs, String column)
get a double from ResultSet rs with name 'column' /** get a short from ResultSet rs with name 'column'

double i = rs.getDouble(column);
if (rs.wasNull())
 i = 0;
return i;

Double getDouble(ResultSet rs, String columnName)
get a Double from a result set column with given name

double val = rs.getDouble(columnName);
if (rs.wasNull()) {
 return null;
return val;

double getDouble2(ResultSet rs, int index)
get Double

Double result = rs.getDouble(index);
if (result == 0 && rs.getObject(index) == null) {
 throw new RuntimeException("Null value in non-Nullable column");
return result;

List getDoubleList(ResultSet resultSet, String columnName)
Returns a list of double values using a given SQL result set and column name.

List<Double> values = null;
if (resultSet != null && columnName != null) {
 values = new ArrayList<Double>();
 while (resultSet.next()) {
 values.add(getDouble(resultSet, columnName));
return values;
...

Double getDoubleNotZero(ResultSet rs, String columnLabel)
get Double Not Zero

return nullIfZero(getDouble(rs, columnLabel));