How to 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.

Answer 2

We can retrieve column names from java.sql.ResultSet to retrieve this we have to use ResultSetMetaData interface because this interface provides some methods with the help of which we can retrieve metadata about the columns in a resultset which includes their names,type and some other properties as well. 

import java.sql.*;

public class Example {

    public static void main(String[] args) throws SQLException {

        // Assuming you have a valid ResultSet object called resultSet

        ResultSet resultSet = ...;

        ResultSetMetaData metaData = resultSet.getMetaData();

        int columnIndex = 1;  // Replace with your column index

        String columnName = metaData.getColumnName(columnIndex);

        System.out.println("Column name: " + columnName);

    }

}