Search code examples
javaresultset

getColumnLabel vs. getColumnName

What is the difference between ResultSetMetaData.getColumnLabel and ResultSetMetaData.getColumnName?

Label: Gets the designated column's suggested title for use in printouts and displays.

Name: Get the designated column's name.

Does anyone know how Label is determined?

Solution 
  • String getColumnLabel(int column) throws SQLException;

    If a SQL AS is not specified, the value returned from getColumnLabel will be the same as the value returned by the getColumnName method.

    Example:

    select id as user_no from users
    • getColumnLabel would return 'user_no'
    • getColumnName would return 'id'