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

You can use ResultSetMetaData to iterate through 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 2

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