getColumnLabel vs. getColumnName

java resultset
sova picture sova · Nov 24, 2010 · Viewed 11.8k times · Source

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?

Answer

stacker picture stacker · Nov 24, 2010 
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'

Related questions

How do I get the size of a java.sql.ResultSet?

Shouldn't this be a pretty straightforward operation? However, I see there's neither a size() nor length() method.

Read More
How to get row count using ResultSet in Java?

I'm trying to create a simple method that receives a ResultSet as a parameter and returns an int that contains the row count of the ResultSet. Is this a valid way of doing this or not so much? int size = 0; …

Read More
Checking for a null int value from a Java ResultSet

In Java I'm trying to test for a null value, from a ResultSet, where the column is being cast to a primitive int type. int iVal; ResultSet rs = magicallyAppearingStmt.executeQuery(query); if (rs.next()) { if (rs.getObject("ID_PARENT") != null &…

Read More