Java Utililty Methods SQL ResultSet Read

int value = rs.getInt(index);
for (T t : type.getEnumConstants()) {
    if (t.ordinal() == value)
        return t;
return null;

return getEnumFromResultSet(rset, field.name(), enumValues);

Class expectedType;
ResultSetMetaData metaData = resultSet.getMetaData();
int sqlType = metaData.getColumnType(columnIndex);
int decimalDigits = metaData.getScale(columnIndex);
expectedType = getClassByJdbcType(sqlType, decimalDigits);
return expectedType;

StringBuilder buf = new StringBuilder();
while (rs.next()) {
    buf.append(rs.getString(1));
    buf.append('\n');
if (buf.length() > 0) {
    buf.setLength(buf.length() - 1);
return buf.toString();

if (rs == null)
    return null;
ResultSetMetaData metaData = rs.getMetaData();
int col_num = metaData.getColumnCount();
String[] col_names = new String[col_num];
for (int i = 0; i < col_num; i++)
    col_names[i] = metaData.getColumnName(i + 1);
return col_names;
...

List<String> fieldsPresentInResultSet = new ArrayList<String>();
ResultSetMetaData metaData = rs.getMetaData();
for (int index = 1; index <= metaData.getColumnCount(); index++) {
    fieldsPresentInResultSet.add(metaData.getColumnLabel(index).toLowerCase());
return fieldsPresentInResultSet;

ResultSetMetaData meta = resultSet.getMetaData();
int columnCount = meta.getColumnCount();
for (int i = 1; i <= columnCount; i++) {
    if (meta.getColumnTypeName(i).equalsIgnoreCase("geometry")) {
        return i;
return -1;
...

if (resultSet.next() == true) {
    return resultSet.getInt(1);
return -1;

Flags flags = new Flags();
for (int i = 0; i < attrArray.length; i++) {
    if ("Y".equals(rs.getString(attrArray[i]))) {
        flags.add(flagArray[i]);
return flags;

long orderId = -1;
while (resultSet != null && resultSet.next()) {
    orderId = resultSet.getLong(1);
return orderId;