Java ResultSetMetaData Interface
The metadata means data about data i.e. we can get further information from the data.
If you have to get metadata of a table like total number of column, column name, column type etc. , ResultSetMetaData interface is useful because it provides methods to get metadata from the ResultSet object.
Commonly used methods of ResultSetMetaData interface
| Method | Description |
|---|
| public int getColumnCount()throws SQLException | it returns the total number of columns in the ResultSet object. |
| public String getColumnName(int index)throws SQLException | it returns the column name of the specified column index. |
| public String getColumnTypeName(int index)throws SQLException | it returns the column type name for the specified index. |
| public String getTableName(int index)throws SQLException | it returns the table name for the specified column index. |
How to get the object of ResultSetMetaData:
| The getMetaData() method of ResultSet interface returns the object of ResultSetMetaData. Syntax: |
Example of ResultSetMetaData interface :
Output:Total columns: 2
Column Name of 1st column: ID
Column Type Name of 1st column: NUMBER
| 
Home
Java
Programs
OOPs
String
Exception
Multithreading
Collections
JavaFX
JSP
Spring
Spring Boot
Projects
Interview Questions
For Videos Join Our Youtube Channel: Join Now
