How to get the table name of the current ResultSet using JDBC?

You can get the name of the table in the current ResultSet object using the getTableName() method of the ResultSetMetaData interface. This method accepts an integer value representing the index of a column and, returns a String value representing the name of the table that contains the given column.

Let us create a table with name MyPlayers in MySQL database using CREATE statement as shown below −

CREATE TABLE MyPlayers(
   ID INT,
   First_Name VARCHAR(255),
   Last_Name VARCHAR(255),
   Date_Of_Birth date,
   Place_Of_Birth VARCHAR(255),
   Country VARCHAR(255),
   PRIMARY KEY (ID)
);

Now, we will insert 7 records in MyPlayers table using INSERT statements −

insert into MyPlayers values(1, 'Shikhar', 'Dhawan', DATE('1981-12-05'), 'Delhi', 'India');
insert into MyPlayers values(2, 'Jonathan', 'Trott', DATE('1981-04-22'), 'CapeTown', 'SouthAfrica');
insert into MyPlayers values(3, 'Kumara', 'Sangakkara', DATE('1977-10-27'), 'Matale', 'Srilanka');
insert into MyPlayers values(4, 'Virat', 'Kohli', DATE('1988-11-05'), 'Delhi', 'India');
insert into MyPlayers values(5, 'Rohit', 'Sharma', DATE('1987-04-30'), 'Nagpur', 'India');
insert into MyPlayers values(6, 'Ravindra', 'Jadeja', DATE('1988-12-06'), 'Nagpur', 'India');
insert into MyPlayers values(7, 'James', 'Anderson', DATE('1982-06-30'), 'Burnley', 'England');

Following JDBC program establishes connection with MySQL database, retrieves and displays the name of the table.

Example

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
public class ResultSetMetaData_getTableName {
   public static void main(String args[]) throws SQLException {
      //Registering the Driver
      DriverManager.registerDriver(new com.mysql.jdbc.Driver());
      //Getting the connection
      String mysqlUrl = "jdbc:mysql://localhost/mydatabase";
      Connection con = DriverManager.getConnection(mysqlUrl, "root", "password");
      System.out.println("Connection established......");
      //Creating the Statement
      Statement stmt = con.createStatement();
      //Query to retrieve records
      String query = "Select * from MyPlayers";
      //Executing the query
      ResultSet rs = stmt.executeQuery(query);
      //retrieving the ResultSetMetaData object
      ResultSetMetaData resultSetMetaData = rs.getMetaData();
      //Retrieving the column name
      String tableName = resultSetMetaData.getTableName(4);
      System.out.println("Name of the table : "+ tableName);
   }
}

Output

Connection established......
Name of the table: myplayers

Arushi

Published on 16-May-2019 08:47:04

• Related Questions & Answers
• How to find the current row of a ResultSet object using JDBC?
• How to move the pointer of a ResultSet to the end of the table using JDBC?
• How to get all the column names from a ResultSet using JDBC
• How to get the row count from ResultSet in JDBC
• How to get the number of columns of a table using JDBC?
• How to get the number of records in a table using JDBC?
• How to get the name of the current executable in C#?
• How to get the datatype of a column of a table using JDBC?
• How to get the size of a column of a table using JDBC?
• How to move the pointer of a ResultSet to the default position using JDBC?
• How to update the contents of a ResultSet using a JDBC program?
• How to get the data type name from the java.sql.Type code using JDBC?
• How to get the current value of a particular row from a database using JDBC?
• How to get column count in a ResultSet in JDBC?
• How to get the list of all databases using JDBC?