Java ResultSetMetaData

The data about another data is called Metadata. The ResultSetMetaData is used to store the data about ResultSet. The ResultSet Contains the columns, rows, names of table, datatypes etc. these data are stored in the ResultSetMetaData.

Methods:

1. getColumnCount():
   It is used to give the number of columns present in the ResultSet object.
2. getColumnLabel():
   It is used to give the suggested column name.
3. getColumnName():
   It is used to give the Name of the Column.
4. getTableName():
   It is used to give the Name of the Table.

Example:

// example program for resultsetmetadata
import java.sql.Connection;
import java.sql.Drivermanager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
public class ResMD
{
public static void main(String args[])
{
// Driver Registering
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
//Creating Connection
String url = “jdbc:mysql://localhost//DB”;
Connection con = DriverManager.getConnection(url,”root”,”password”)
Statement st = con.createStatement();
// retrieving data
ResultSet rs = st.executeQuery(“select * from Dataset”);
ResultSetMetaData rsmd = rs.getMetaData();
// to print the no of the column
System.out.print(“Number of Columns:”+rsMetaData.getColumnCount());
// to print column label
System.out.println(“Column Label:”+ rsMetaData.getColumnLabel(1));
//to print column name
System.out.println(“Column Name:”+ rsMetaData.getColumnName(1));
// to print table name
System.out.println(“Table Name:”+ rsMetaData.getTableName(1));



}
}

Output:

Number of Columns: 3
Column Label: name
Column Name: name
Table Name: Dataset

Summary:

The ResultSetMetaData is used to store the data of the ResultSet i.e., the number of columns, name of column, Table name etc. The ResultSetMetaData has the Four methods i.e. ColumnCount , ColumnLabel, ColumnName, TableName.