Java: How to retrieve SQL resultSet data through column name?

Question

I wanted to retrieve the data stored in resultSet through the column names and the index of the row. Is there any way to do that? I tried through arraylist but I was not able to do that.

Example: There is table called Employee which has around 20 records with several columns such as ID, Name, Account, Project, Shift and Role. I want to access the data from the column 'Name' and 'Role' from the 5th row of resultSet i.e., something like (Name, 5) and (Row, 5). The column name will be taken from the user input. So I want to retrieve the data through column name. Is there any way to do that?

Stavr00 · Accepted Answer · 2020-02-14T13:26:52.210

1

Interface java.sql.ResultSet has a collection of getter functions. The pattern is

getXxx(int columnIndex)
getXxx(String columnLabel)

Where Xxx is the data type to be fetched. The second variant fetches a value using the column header label.

To adust the cursor to a specific row, the function is

absolute(int rownum)

If the call returns false it means there are no rows at that number. Caveat, not all drivers and queries allow navigation to any row number like that.

edited Feb 14 '20 at 13:26

answered Feb 13 '20 at 18:40

Stavr00

3,219
1
16
28

Thank you for your answer.I assume by this way whole column will retrieve. But u need the record from a particular row using column name. For example (Name, 5) where Name is the column name and 5 is the index of the row. – Manjunath Chinnanagoudar Feb 13 '20 at 18:52
@ManjunathChinnanagoudar If you need row `5`, then just add a `WHERE` clause to your SQL statement. – The Impaler Feb 13 '20 at 19:41
It's just an example. I want to retrieve the value based on column name and row number. – Manjunath Chinnanagoudar Feb 14 '20 at 03:09

Java: How to retrieve SQL resultSet data through column name?

1 Answers1