How to check that a ResultSet contains a specifically named field?

Question

Having rs, an instance of java.sql.ResultSet, how to check that it contains a column named "theColumn"?

Answer 1

Try using the method ResultSet#findColumn(String)

private boolean isThere(ResultSet rs, String column)
{
  try
  {
    rs.findColumn(column);
    return true;
  } catch (SQLException sqlex)
  {
    logger.debug("column doesn't exist {}", column);
  }
  return false;
}

Answer 2

You can do:

rs.findColumn("theColum")

and check for SQLException

Answer 3

You can use ResultSetMetaData to iterate throw the ResultSet columns and see if the column name matches your specified column name.

Example:

ResultSetMetaData rsMetaData = rs.getMetaData();
int numberOfColumns = rsMetaData.getColumnCount();

// get the column names; column indexes start from 1
for (int i = 1; i < numberOfColumns + 1; i++) {
    String columnName = rsMetaData.getColumnName(i);
    // Get the name of the column's table name
    if ("theColumn".equals(columnName)) {
        System.out.println("Bingo!");
    }
}

Answer 4

Use the ResultSetMetaData object provided by the ResultSet object via rs.getMetaData()