Retrieve column names from java.sql.ResultSet

Question

With java.sql.ResultSet is there a way to get a column's name as a String by using the column's index? I had a look through the API doc but I can't find anything.

Answer 1

You can get the aforementioned info from the ResultSet metadata. Descry ResultSetMetaData

e.g.

 ResultSet rs = stmt.executeQuery("SELECT a, b, c FROM TABLE2");

 ResultSetMetaData rsmd = rs.getMetaData();

 String name = rsmd.getColumnName(1);

and you can notice the column name from there. If you do

choose x as y from table

then rsmd.getColumnLabel() will get you the retrieved label name also.