[Nerddette]

I have been given the following snippet of code, which is part of a ResultSetModel.java file which is used by a file which uses JDBC/SQL data.

public String getColumnName (int columnIndex) {
        ResultSetMetaData  resultSetMetaData = resultSet.getMetaData();
        //Put some program code here. (They put this in, not me :))
    }

It then tells me to "use one of its methods, so that the above function returns an appropriate heading for each column. "

The GUI columns currently show as the defaults (a-e) and instead I want them to show ComNum, FirstName, Surname, Gender, CountryCode.

Any ideas???

Nerddette

[stdunbar]

If I understand your question correctly I think you want to use the getColumnName() method on ResultSetMetaData (see http://java.sun.com/j2se/1.4.2/docs/...tMetaData.html for more information)

Your comment line below would be replaced by:

return( resultSetMetaData.getColumnName( columnIndex ) );

Originally Posted by Nerddette

I have been given the following snippet of code, which is part of a ResultSetModel.java file which is used by a file which uses JDBC/SQL data.

public String getColumnName (int columnIndex) {
        ResultSetMetaData  resultSetMetaData = resultSet.getMetaData();
        //Put some program code here. (They put this in, not me :))
    }

It then tells me to "use one of its methods, so that the above function returns an appropriate heading for each column. "

The GUI columns currently show as the defaults (a-e) and instead I want them to show ComNum, FirstName, Surname, Gender, CountryCode.

Any ideas???

Nerddette

[oh_maan]

ResultSetMetaData class has a method called getColumn Name...u se that to get the name of the column with which u are workin...resultSet intially points to a empty column..u'll have to do resultSet.next to make it point to the first row.

Originally Posted by Nerddette

I have been given the following snippet of code, which is part of a ResultSetModel.java file which is used by a file which uses JDBC/SQL data.

public String getColumnName (int columnIndex) {
        ResultSetMetaData  resultSetMetaData = resultSet.getMetaData();
        //Put some program code here. (They put this in, not me :))
    }

It then tells me to "use one of its methods, so that the above function returns an appropriate heading for each column. "

The GUI columns currently show as the defaults (a-e) and instead I want them to show ComNum, FirstName, Surname, Gender, CountryCode.

Any ideas???

Nerddette